public PharmaBusinessObjects.Transaction.PurchaseSaleBookHeader GetPurchaseSaleBookHeaderForModify(long purchaseSaleBookHeaderID) { try { PharmaBusinessObjects.Transaction.PurchaseSaleBookHeader header = new PharmaBusinessObjects.Transaction.PurchaseSaleBookHeader(); string ConnString = ConfigurationManager.ConnectionStrings["PharmaDBConn"].ConnectionString; using (SqlConnection connection = new SqlConnection(ConnString)) { SqlCommand cmd = new SqlCommand("GetPurchaseSaleBookHeaderForModify", connection); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter() { ParameterName = "@PurchaseSaleBookHeaderID", Value = purchaseSaleBookHeaderID }); SqlDataAdapter sda = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); sda.Fill(dt); if (dt != null && dt.Rows.Count > 0) { header.PurchaseSaleBookHeaderID = Convert.ToInt64(dt.Rows[0]["PurchaseSaleBookHeaderID"]); header.VoucherTypeCode = Convert.ToString(dt.Rows[0]["VoucherTypeCode"]); header.VoucherDate = Convert.ToDateTime(dt.Rows[0]["VoucherDate"]); header.PurchaseBillNo = Convert.ToString(dt.Rows[0]["PurchaseBillNo"]); header.LedgerType = Convert.ToString(dt.Rows[0]["LedgerType"]); header.LedgerTypeCode = Convert.ToString(dt.Rows[0]["LedgerTypeCode"]); header.LocalCentral = Convert.ToString(dt.Rows[0]["LocalCentral"]); header.OldPurchaseSaleBookHeaderID = Convert.ToInt64(dt.Rows[0]["OldPurchaseSaleBookHeaderID"]); header.PurchaseEntryFormID = Convert.ToInt32(dt.Rows[0]["PurchaseEntryFormID"]); } } return(header); } catch (DbEntityValidationException ex) { throw ex; } }
public long InsertUpdateTempPurchaseBookHeader(PharmaBusinessObjects.Transaction.PurchaseSaleBookHeader header) { try { long PurchaseSaleBookHeaderID = 0; string ConnString = ConfigurationManager.ConnectionStrings["PharmaDBConn"].ConnectionString; using (SqlConnection connection = new SqlConnection(ConnString)) { SqlCommand cmd = new SqlCommand("InsertUpdateInvetoryHeadersInTempTable", connection); cmd.CommandType = System.Data.CommandType.StoredProcedure; List <PharmaBusinessObjects.Transaction.PurchaseSaleBookHeader> list = new List <PharmaBusinessObjects.Transaction.PurchaseSaleBookHeader>(); list.Add(header); SqlParameter parameter = new SqlParameter(); parameter.SqlDbType = SqlDbType.Structured; parameter.TypeName = "dbo.TableTypePurchaseSaleBookHeader"; parameter.ParameterName = "@TableTypePurchaseSaleBookHeader"; parameter.Value = CommonDaoMethods.CreateDataTable <PharmaBusinessObjects.Transaction.PurchaseSaleBookHeader>(list); cmd.Parameters.Add(parameter); SqlDataAdapter sda = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); sda.Fill(dt); if (dt != null && dt.Rows.Count > 0) { PurchaseSaleBookHeaderID = Convert.ToInt64(dt.Rows[0]["PurchaseSaleBookHeaderID"]); } } return(PurchaseSaleBookHeaderID); } catch (Exception ex) { throw ex; } }