public static void AcknowledgePurchaseOrder(PurchaseOrderHeader header,Collection<PurchaseOrderItemSchedule> schedules) { try { EpTransaction tran = DataManager.BeginTransaction(); try { PurchaseOrderHeaderDAO.Update(tran, header); foreach (PurchaseOrderItemSchedule schedule in schedules) { PurchaseOrderItemScheduleDAO.Update(tran, schedule); } tran.Commit(); } catch (Exception ex) { tran.Rollback(); throw (ex); } finally { tran.Dispose(); } } catch (Exception ex) { Utility.ExceptionLog(ex); throw (ex); } }
public static void Delete(EpTransaction epTran, PurchaseOrderHeader entity) { SqlCommand cm = new SqlCommand(); cm.CommandType = CommandType.Text; //set connection SqlConnection connection; if (epTran == null) { connection = DataManager.GetConnection(); } else { connection = epTran.GetSqlConnection(); } if (connection.State != System.Data.ConnectionState.Open) { connection.Open(); } cm.Connection = connection; //set transaction if (epTran != null) { cm.Transaction = epTran.GetSqlTransaction(); } //Check whether record exists PurchaseOrderHeader checkEntity = RetrieveByKey(epTran, entity.OrderNumber); if (checkEntity == null) { throw new Exception("Record doesn't exist."); } //Update cm.CommandText = "DELETE FROM purhdr WHERE EBELN=@EBELN"; SqlParameter p1 = new SqlParameter("@EBELN", SqlDbType.Char, 10); cm.Parameters.Add(p1); p1.Value = entity.OrderNumber; cm.ExecuteNonQuery(); if (epTran == null) { if (connection.State != System.Data.ConnectionState.Closed) { connection.Close(); } } }
public static PurchaseOrderHeader RetrieveByKey(EpTransaction epTran, string orderNumber) { PurchaseOrderHeader entity = null; string whereClause = " EBELN='" + DataManager.EscapeSQL(orderNumber) + "' "; Collection <PurchaseOrderHeader> entities = Retrieve(epTran, whereClause, ""); if (entities.Count > 0) { entity = entities[0]; } return(entity); }
public static void Insert(EpTransaction epTran, PurchaseOrderHeader entity) { SqlCommand cm = new SqlCommand(); cm.CommandType = CommandType.Text; //set connection SqlConnection connection; if (epTran == null) connection = DataManager.GetConnection(); else connection = epTran.GetSqlConnection(); if (connection.State != System.Data.ConnectionState.Open) connection.Open(); cm.Connection = connection; //set transaction if (epTran != null) cm.Transaction = epTran.GetSqlTransaction(); //Check whether record exists PurchaseOrderHeader checkEntity = RetrieveByKey(epTran, entity.OrderNumber); if (checkEntity != null) { throw new Exception("Record already exists."); } //Insert cm.CommandText = "INSERT INTO purhdr ([EBELN],[LIFNR],[BEDAT],[AMTPR],[GSTPR],[WAERS],[ZTERM],[BUYER],[AD_TLNMBR],[VERKF],[ADRNR_TXT],[REMARK],[STAT],[RECSTS],[ACKSTS]) VALUES(@EBELN,@LIFNR,@BEDAT,@AMTPR,@GSTPR,@WAERS,@ZTERM,@BUYER,@AD_TLNMBR,@VERKF,@ADRNR_TXT,@REMARK,@STAT,@RECSTS,@ACKSTS)"; SqlParameter p1 = new SqlParameter("@EBELN", SqlDbType.Char, 10); cm.Parameters.Add(p1); p1.Value = entity.OrderNumber; SqlParameter p2 = new SqlParameter("@LIFNR", SqlDbType.Char, 10); cm.Parameters.Add(p2); p2.Value = entity.SupplierID; SqlParameter p3 = new SqlParameter("@BEDAT", SqlDbType.BigInt, 8); cm.Parameters.Add(p3); if (entity.OrderDate.HasValue) p3.Value = entity.OrderDate; else p3.Value = DBNull.Value; SqlParameter p4 = new SqlParameter("@AMTPR", SqlDbType.Decimal, 11); cm.Parameters.Add(p4); if (entity.OrderAmount.HasValue) p4.Value = entity.OrderAmount; else p4.Value = DBNull.Value; SqlParameter p5 = new SqlParameter("@GSTPR", SqlDbType.Decimal, 11); cm.Parameters.Add(p5); if (entity.GstAmount.HasValue) p5.Value = entity.GstAmount; else p5.Value = DBNull.Value; SqlParameter p6 = new SqlParameter("@WAERS", SqlDbType.Char, 5); cm.Parameters.Add(p6); p6.Value = entity.CurrencyCode; SqlParameter p7 = new SqlParameter("@ZTERM", SqlDbType.Char, 4); cm.Parameters.Add(p7); p7.Value = entity.PaymentTerms; SqlParameter p8 = new SqlParameter("@BUYER", SqlDbType.VarChar, 31); cm.Parameters.Add(p8); p8.Value = entity.BuyerName; SqlParameter p9 = new SqlParameter("@AD_TLNMBR", SqlDbType.VarChar, 30); cm.Parameters.Add(p9); p9.Value = entity.AddressNumber; SqlParameter p10 = new SqlParameter("@VERKF", SqlDbType.VarChar, 30); cm.Parameters.Add(p10); p10.Value = entity.SalesPerson; SqlParameter p11 = new SqlParameter("@ADRNR_TXT", SqlDbType.VarChar, 80); cm.Parameters.Add(p11); p11.Value = entity.ShipmentAddress; SqlParameter p12 = new SqlParameter("@REMARK", SqlDbType.VarChar, 60); cm.Parameters.Add(p12); p12.Value = entity.Remarks; SqlParameter p13 = new SqlParameter("@STAT", SqlDbType.Char, 3); cm.Parameters.Add(p13); p13.Value = entity.OrderStatus; SqlParameter p14 = new SqlParameter("@RECSTS", SqlDbType.Char, 1); cm.Parameters.Add(p14); p14.Value = entity.RecordStatus; SqlParameter p15 = new SqlParameter("@ACKSTS", SqlDbType.Char, 1); cm.Parameters.Add(p15); p15.Value = entity.AcknowledgeStatus; cm.ExecuteNonQuery(); if (epTran == null) if (connection.State != System.Data.ConnectionState.Closed) connection.Close(); }
public static void Insert(PurchaseOrderHeader entity) { Insert(null, entity); }
private static Collection<PurchaseOrderHeader> Retrieve(EpTransaction epTran, string whereClause, string sortClaues) { Collection<PurchaseOrderHeader> entities = new Collection<PurchaseOrderHeader>(); SqlCommand cm = new SqlCommand(); cm.CommandType = CommandType.Text; //set connection SqlConnection connection; if (epTran == null) connection = DataManager.GetConnection(); else connection = epTran.GetSqlConnection(); if (connection.State != System.Data.ConnectionState.Open) connection.Open(); cm.Connection = connection; //set transaction if (epTran != null) cm.Transaction = epTran.GetSqlTransaction(); //Retrieve Data string selectCommand = "SELECT [EBELN],[LIFNR],[BEDAT],[AMTPR],[GSTPR],[WAERS],[ZTERM],[BUYER],[AD_TLNMBR],[VERKF],[ADRNR_TXT],[REMARK],[STAT],[RECSTS],[ACKSTS] FROM purhdr"; if (!string.IsNullOrEmpty(whereClause)) selectCommand += " where " + whereClause; if (!string.IsNullOrEmpty(sortClaues)) selectCommand += " order by " + sortClaues; cm.CommandText = selectCommand; SqlDataReader rd = cm.ExecuteReader(); while (rd.Read()) { PurchaseOrderHeader entity = new PurchaseOrderHeader(); entity.OrderNumber = rd["EBELN"].ToString(); entity.SupplierID = rd["LIFNR"].ToString(); if (rd.IsDBNull(2)) entity.OrderDate = null; else entity.OrderDate = Convert.ToInt64(rd["BEDAT"]); if (rd.IsDBNull(3)) entity.OrderAmount = null; else entity.OrderAmount = Convert.ToInt64(rd["AMTPR"]); if (rd.IsDBNull(3)) entity.GstAmount = null; else entity.GstAmount = Convert.ToInt64(rd["GSTPR"]); entity.CurrencyCode = rd["WAERS"].ToString(); entity.PaymentTerms = rd["ZTERM"].ToString(); entity.BuyerName = rd["BUYER"].ToString(); entity.AddressNumber = rd["AD_TLNMBR"].ToString(); entity.SalesPerson = rd["VERKF"].ToString(); entity.ShipmentAddress = rd["ADRNR_TXT"].ToString(); entity.Remarks = rd["REMARK"].ToString(); entity.OrderStatus = rd["STAT"].ToString(); entity.RecordStatus = rd["RECSTS"].ToString(); entity.AcknowledgeStatus = rd["ACKSTS"].ToString(); entities.Add(entity); } // close reader rd.Close(); if (epTran == null) if (connection.State != System.Data.ConnectionState.Closed) connection.Close(); return entities; }
public static void Delete(EpTransaction epTran, PurchaseOrderHeader entity) { SqlCommand cm = new SqlCommand(); cm.CommandType = CommandType.Text; //set connection SqlConnection connection; if (epTran == null) connection = DataManager.GetConnection(); else connection = epTran.GetSqlConnection(); if (connection.State != System.Data.ConnectionState.Open) connection.Open(); cm.Connection = connection; //set transaction if (epTran != null) cm.Transaction = epTran.GetSqlTransaction(); //Check whether record exists PurchaseOrderHeader checkEntity = RetrieveByKey(epTran, entity.OrderNumber); if (checkEntity == null) { throw new Exception("Record doesn't exist."); } //Update cm.CommandText = "DELETE FROM purhdr WHERE EBELN=@EBELN"; SqlParameter p1 = new SqlParameter("@EBELN", SqlDbType.Char, 10); cm.Parameters.Add(p1); p1.Value = entity.OrderNumber; cm.ExecuteNonQuery(); if (epTran == null) if (connection.State != System.Data.ConnectionState.Closed) connection.Close(); }
public static void Delete(PurchaseOrderHeader entity) { Delete(null, entity); }
public static void Update(EpTransaction epTran, PurchaseOrderHeader entity) { SqlCommand cm = new SqlCommand(); cm.CommandType = CommandType.Text; //set connection SqlConnection connection; if (epTran == null) connection = DataManager.GetConnection(); else connection = epTran.GetSqlConnection(); if (connection.State != System.Data.ConnectionState.Open) connection.Open(); cm.Connection = connection; //set transaction if (epTran != null) cm.Transaction = epTran.GetSqlTransaction(); //Check whether record exists PurchaseOrderHeader checkEntity = RetrieveByKey(epTran, entity.OrderNumber); if (checkEntity == null) { throw new Exception("Record doesn't exist."); } //Update cm.CommandText = "UPDATE purhdr SET LIFNR=@LIFNR,BEDAT=@BEDAT,AMTPR=@AMTPR,GSTPR=@GSTPR,WAERS=@WAERS,ZTERM=@ZTERM,BUYER=@BUYER,AD_TLNMBR=@AD_TLNMBR,VERKF=@VERKF,ADRNR_TXT=@ADRNR_TXT,REMARK=@REMARK,STAT=@STAT,RECSTS=@RECSTS,ACKSTS=@ACKSTS WHERE EBELN=@EBELN"; SqlParameter p1 = new SqlParameter("@EBELN", SqlDbType.Char, 10); cm.Parameters.Add(p1); p1.Value = entity.OrderNumber; SqlParameter p2 = new SqlParameter("@LIFNR", SqlDbType.Char, 10); cm.Parameters.Add(p2); p2.Value = entity.SupplierID; SqlParameter p3 = new SqlParameter("@BEDAT", SqlDbType.BigInt, 8); cm.Parameters.Add(p3); if (entity.OrderDate.HasValue) p3.Value = entity.OrderDate; else p3.Value = DBNull.Value; SqlParameter p4 = new SqlParameter("@AMTPR", SqlDbType.Decimal, 11); cm.Parameters.Add(p4); if (entity.OrderAmount.HasValue) p4.Value = entity.OrderAmount; else p4.Value = DBNull.Value; SqlParameter p5 = new SqlParameter("@GSTPR", SqlDbType.Decimal, 11); cm.Parameters.Add(p5); if (entity.GstAmount.HasValue) p5.Value = entity.GstAmount; else p5.Value = DBNull.Value; SqlParameter p6 = new SqlParameter("@WAERS", SqlDbType.Char, 5); cm.Parameters.Add(p6); p6.Value = entity.CurrencyCode; SqlParameter p7 = new SqlParameter("@ZTERM", SqlDbType.Char, 4); cm.Parameters.Add(p7); p7.Value = entity.PaymentTerms; SqlParameter p8 = new SqlParameter("@BUYER", SqlDbType.VarChar, 31); cm.Parameters.Add(p8); p8.Value = entity.BuyerName; SqlParameter p9 = new SqlParameter("@AD_TLNMBR", SqlDbType.VarChar, 30); cm.Parameters.Add(p9); p9.Value = entity.AddressNumber; SqlParameter p10 = new SqlParameter("@VERKF", SqlDbType.VarChar, 30); cm.Parameters.Add(p10); p10.Value = entity.SalesPerson; SqlParameter p11 = new SqlParameter("@ADRNR_TXT", SqlDbType.VarChar, 80); cm.Parameters.Add(p11); p11.Value = entity.ShipmentAddress; SqlParameter p12 = new SqlParameter("@REMARK", SqlDbType.VarChar, 60); cm.Parameters.Add(p12); p12.Value = entity.Remarks; SqlParameter p13 = new SqlParameter("@STAT", SqlDbType.Char, 3); cm.Parameters.Add(p13); p13.Value = entity.OrderStatus; SqlParameter p14 = new SqlParameter("@RECSTS", SqlDbType.Char, 1); cm.Parameters.Add(p14); p14.Value = entity.RecordStatus; SqlParameter p15 = new SqlParameter("@ACKSTS", SqlDbType.Char, 1); cm.Parameters.Add(p15); p15.Value = entity.AcknowledgeStatus; cm.ExecuteNonQuery(); if (epTran == null) if (connection.State != System.Data.ConnectionState.Closed) connection.Close(); }
public static void Update(PurchaseOrderHeader entity) { Update(null, entity); }
public static void Insert(EpTransaction epTran, PurchaseOrderHeader entity) { SqlCommand cm = new SqlCommand(); cm.CommandType = CommandType.Text; //set connection SqlConnection connection; if (epTran == null) { connection = DataManager.GetConnection(); } else { connection = epTran.GetSqlConnection(); } if (connection.State != System.Data.ConnectionState.Open) { connection.Open(); } cm.Connection = connection; //set transaction if (epTran != null) { cm.Transaction = epTran.GetSqlTransaction(); } //Check whether record exists PurchaseOrderHeader checkEntity = RetrieveByKey(epTran, entity.OrderNumber); if (checkEntity != null) { throw new Exception("Record already exists."); } //Insert cm.CommandText = "INSERT INTO purhdr ([EBELN],[LIFNR],[BEDAT],[AMTPR],[GSTPR],[WAERS],[ZTERM],[BUYER],[AD_TLNMBR],[VERKF],[ADRNR_TXT],[REMARK],[STAT],[RECSTS],[ACKSTS]) VALUES(@EBELN,@LIFNR,@BEDAT,@AMTPR,@GSTPR,@WAERS,@ZTERM,@BUYER,@AD_TLNMBR,@VERKF,@ADRNR_TXT,@REMARK,@STAT,@RECSTS,@ACKSTS)"; SqlParameter p1 = new SqlParameter("@EBELN", SqlDbType.Char, 10); cm.Parameters.Add(p1); p1.Value = entity.OrderNumber; SqlParameter p2 = new SqlParameter("@LIFNR", SqlDbType.Char, 10); cm.Parameters.Add(p2); p2.Value = entity.SupplierID; SqlParameter p3 = new SqlParameter("@BEDAT", SqlDbType.BigInt, 8); cm.Parameters.Add(p3); if (entity.OrderDate.HasValue) { p3.Value = entity.OrderDate; } else { p3.Value = DBNull.Value; } SqlParameter p4 = new SqlParameter("@AMTPR", SqlDbType.Decimal, 11); cm.Parameters.Add(p4); if (entity.OrderAmount.HasValue) { p4.Value = entity.OrderAmount; } else { p4.Value = DBNull.Value; } SqlParameter p5 = new SqlParameter("@GSTPR", SqlDbType.Decimal, 11); cm.Parameters.Add(p5); if (entity.GstAmount.HasValue) { p5.Value = entity.GstAmount; } else { p5.Value = DBNull.Value; } SqlParameter p6 = new SqlParameter("@WAERS", SqlDbType.Char, 5); cm.Parameters.Add(p6); p6.Value = entity.CurrencyCode; SqlParameter p7 = new SqlParameter("@ZTERM", SqlDbType.Char, 4); cm.Parameters.Add(p7); p7.Value = entity.PaymentTerms; SqlParameter p8 = new SqlParameter("@BUYER", SqlDbType.VarChar, 31); cm.Parameters.Add(p8); p8.Value = entity.BuyerName; SqlParameter p9 = new SqlParameter("@AD_TLNMBR", SqlDbType.VarChar, 30); cm.Parameters.Add(p9); p9.Value = entity.AddressNumber; SqlParameter p10 = new SqlParameter("@VERKF", SqlDbType.VarChar, 30); cm.Parameters.Add(p10); p10.Value = entity.SalesPerson; SqlParameter p11 = new SqlParameter("@ADRNR_TXT", SqlDbType.VarChar, 80); cm.Parameters.Add(p11); p11.Value = entity.ShipmentAddress; SqlParameter p12 = new SqlParameter("@REMARK", SqlDbType.VarChar, 60); cm.Parameters.Add(p12); p12.Value = entity.Remarks; SqlParameter p13 = new SqlParameter("@STAT", SqlDbType.Char, 3); cm.Parameters.Add(p13); p13.Value = entity.OrderStatus; SqlParameter p14 = new SqlParameter("@RECSTS", SqlDbType.Char, 1); cm.Parameters.Add(p14); p14.Value = entity.RecordStatus; SqlParameter p15 = new SqlParameter("@ACKSTS", SqlDbType.Char, 1); cm.Parameters.Add(p15); p15.Value = entity.AcknowledgeStatus; cm.ExecuteNonQuery(); if (epTran == null) { if (connection.State != System.Data.ConnectionState.Closed) { connection.Close(); } } }
private static Collection <PurchaseOrderHeader> Retrieve(EpTransaction epTran, string whereClause, string sortClaues) { Collection <PurchaseOrderHeader> entities = new Collection <PurchaseOrderHeader>(); SqlCommand cm = new SqlCommand(); cm.CommandType = CommandType.Text; //set connection SqlConnection connection; if (epTran == null) { connection = DataManager.GetConnection(); } else { connection = epTran.GetSqlConnection(); } if (connection.State != System.Data.ConnectionState.Open) { connection.Open(); } cm.Connection = connection; //set transaction if (epTran != null) { cm.Transaction = epTran.GetSqlTransaction(); } //Retrieve Data string selectCommand = "SELECT [EBELN],[LIFNR],[BEDAT],[AMTPR],[GSTPR],[WAERS],[ZTERM],[BUYER],[AD_TLNMBR],[VERKF],[ADRNR_TXT],[REMARK],[STAT],[RECSTS],[ACKSTS] FROM purhdr"; if (!string.IsNullOrEmpty(whereClause)) { selectCommand += " where " + whereClause; } if (!string.IsNullOrEmpty(sortClaues)) { selectCommand += " order by " + sortClaues; } cm.CommandText = selectCommand; SqlDataReader rd = cm.ExecuteReader(); while (rd.Read()) { PurchaseOrderHeader entity = new PurchaseOrderHeader(); entity.OrderNumber = rd["EBELN"].ToString(); entity.SupplierID = rd["LIFNR"].ToString(); if (rd.IsDBNull(2)) { entity.OrderDate = null; } else { entity.OrderDate = Convert.ToInt64(rd["BEDAT"]); } if (rd.IsDBNull(3)) { entity.OrderAmount = null; } else { entity.OrderAmount = Convert.ToInt64(rd["AMTPR"]); } if (rd.IsDBNull(3)) { entity.GstAmount = null; } else { entity.GstAmount = Convert.ToInt64(rd["GSTPR"]); } entity.CurrencyCode = rd["WAERS"].ToString(); entity.PaymentTerms = rd["ZTERM"].ToString(); entity.BuyerName = rd["BUYER"].ToString(); entity.AddressNumber = rd["AD_TLNMBR"].ToString(); entity.SalesPerson = rd["VERKF"].ToString(); entity.ShipmentAddress = rd["ADRNR_TXT"].ToString(); entity.Remarks = rd["REMARK"].ToString(); entity.OrderStatus = rd["STAT"].ToString(); entity.RecordStatus = rd["RECSTS"].ToString(); entity.AcknowledgeStatus = rd["ACKSTS"].ToString(); entities.Add(entity); } // close reader rd.Close(); if (epTran == null) { if (connection.State != System.Data.ConnectionState.Closed) { connection.Close(); } } return(entities); }
public static void Update(EpTransaction epTran, PurchaseOrderHeader entity) { SqlCommand cm = new SqlCommand(); cm.CommandType = CommandType.Text; //set connection SqlConnection connection; if (epTran == null) { connection = DataManager.GetConnection(); } else { connection = epTran.GetSqlConnection(); } if (connection.State != System.Data.ConnectionState.Open) { connection.Open(); } cm.Connection = connection; //set transaction if (epTran != null) { cm.Transaction = epTran.GetSqlTransaction(); } //Check whether record exists PurchaseOrderHeader checkEntity = RetrieveByKey(epTran, entity.OrderNumber); if (checkEntity == null) { throw new Exception("Record doesn't exist."); } //Update cm.CommandText = "UPDATE purhdr SET LIFNR=@LIFNR,BEDAT=@BEDAT,AMTPR=@AMTPR,GSTPR=@GSTPR,WAERS=@WAERS,ZTERM=@ZTERM,BUYER=@BUYER,AD_TLNMBR=@AD_TLNMBR,VERKF=@VERKF,ADRNR_TXT=@ADRNR_TXT,REMARK=@REMARK,STAT=@STAT,RECSTS=@RECSTS,ACKSTS=@ACKSTS WHERE EBELN=@EBELN"; SqlParameter p1 = new SqlParameter("@EBELN", SqlDbType.Char, 10); cm.Parameters.Add(p1); p1.Value = entity.OrderNumber; SqlParameter p2 = new SqlParameter("@LIFNR", SqlDbType.Char, 10); cm.Parameters.Add(p2); p2.Value = entity.SupplierID; SqlParameter p3 = new SqlParameter("@BEDAT", SqlDbType.BigInt, 8); cm.Parameters.Add(p3); if (entity.OrderDate.HasValue) { p3.Value = entity.OrderDate; } else { p3.Value = DBNull.Value; } SqlParameter p4 = new SqlParameter("@AMTPR", SqlDbType.Decimal, 11); cm.Parameters.Add(p4); if (entity.OrderAmount.HasValue) { p4.Value = entity.OrderAmount; } else { p4.Value = DBNull.Value; } SqlParameter p5 = new SqlParameter("@GSTPR", SqlDbType.Decimal, 11); cm.Parameters.Add(p5); if (entity.GstAmount.HasValue) { p5.Value = entity.GstAmount; } else { p5.Value = DBNull.Value; } SqlParameter p6 = new SqlParameter("@WAERS", SqlDbType.Char, 5); cm.Parameters.Add(p6); p6.Value = entity.CurrencyCode; SqlParameter p7 = new SqlParameter("@ZTERM", SqlDbType.Char, 4); cm.Parameters.Add(p7); p7.Value = entity.PaymentTerms; SqlParameter p8 = new SqlParameter("@BUYER", SqlDbType.VarChar, 31); cm.Parameters.Add(p8); p8.Value = entity.BuyerName; SqlParameter p9 = new SqlParameter("@AD_TLNMBR", SqlDbType.VarChar, 30); cm.Parameters.Add(p9); p9.Value = entity.AddressNumber; SqlParameter p10 = new SqlParameter("@VERKF", SqlDbType.VarChar, 30); cm.Parameters.Add(p10); p10.Value = entity.SalesPerson; SqlParameter p11 = new SqlParameter("@ADRNR_TXT", SqlDbType.VarChar, 80); cm.Parameters.Add(p11); p11.Value = entity.ShipmentAddress; SqlParameter p12 = new SqlParameter("@REMARK", SqlDbType.VarChar, 60); cm.Parameters.Add(p12); p12.Value = entity.Remarks; SqlParameter p13 = new SqlParameter("@STAT", SqlDbType.Char, 3); cm.Parameters.Add(p13); p13.Value = entity.OrderStatus; SqlParameter p14 = new SqlParameter("@RECSTS", SqlDbType.Char, 1); cm.Parameters.Add(p14); p14.Value = entity.RecordStatus; SqlParameter p15 = new SqlParameter("@ACKSTS", SqlDbType.Char, 1); cm.Parameters.Add(p15); p15.Value = entity.AcknowledgeStatus; cm.ExecuteNonQuery(); if (epTran == null) { if (connection.State != System.Data.ConnectionState.Closed) { connection.Close(); } } }