Hi,
In my project I need to update edited values. I have created an sp for that tha works fine. I got all the edited values on data layer, business layer and presentation layer as well. But the values are not updated in my db table.
Here is my datalayer code:
public object Update(object ObjEditItem)
{
try
{
BusinessObjects.Common.TransactionDetail objEditTransactionDetail = new BusinessObjects.Common.TransactionDetail();
string spName = "spUpdateItemHeader";
Database db = DatabaseFactory.CreateDatabase(ConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand(spName);
db.AddInParameter(dbCommand, "@ItemID", DbType.String, ((BusinessObjects.Tables.aItem)ObjEditItem).ItemID);
db.AddInParameter(dbCommand, "@ItemCode", DbType.String, ((BusinessObjects.Tables.aItem)ObjEditItem).ItemCode);
db.AddInParameter(dbCommand, "@ItemDescription", DbType.String, ((BusinessObjects.Tables.aItem)ObjEditItem).ItemDescription);
db.AddOutParameter(dbCommand, "@TransactionId", DbType.Int32, 100);
db.AddOutParameter(dbCommand, "@TransactionNo", DbType.String, 100);
db.ExecuteScalar(dbCommand);
if (db.GetParameterValue(dbCommand, "@TransactionId") != DBNull.Value)
{
objEditTransactionDetail.TrnsactionId = Convert.ToInt32(db.GetParameterValue(dbCommand, "TransactionId"));
}
if (db.GetParameterValue(dbCommand, "@TransactionNo") != DBNull.Value)
{
objEditTransactionDetail.TrnsactionNo = Convert.ToString(db.GetParameterValue(dbCommand, "TransactionNo"));
}
return objEditTransactionDetail;
}