public Menu() { database = DBConnect.getDBConnection(); }
public DrugRoutes() { database = DBConnect.getDBConnection(); }
public DrugDispenseDrugUtilisation() { database = DBConnect.getDBConnection(); }
public DrugGroup() { database = DBConnect.getDBConnection(); }
public Int32 SaveDrugDispenseReturnDetails(Entities.DrugDispenseReturn drugDispenseReturn) { var drugDispenseReturnId = 0; var db = DBConnect.getDBConnection(); using (DbConnection conn = db.CreateConnection()) { conn.Open(); using (DbTransaction dbTransaction = conn.BeginTransaction()) { try { var drugDispenseDrugReturnId = 0; if (drugDispenseReturn != null) { if (drugDispenseReturn.DrugDispenseReturnId == null || drugDispenseReturn.DrugDispenseReturnId == 0) { drugDispenseReturnId = AddDrugDispenseReturnDetails(drugDispenseReturn, dbTransaction); } else if (drugDispenseReturn.ModifiedBy != null || drugDispenseReturn.ModifiedBy > 0) { drugDispenseReturnId = UpdateDrugDispenseReturnDetails(drugDispenseReturn, dbTransaction); } else if (drugDispenseReturn.IsDeleted == true) { var result = DeleteDrugDispenseReturnDetails(drugDispenseReturn, dbTransaction); if (result) { drugDispenseReturnId = (int)drugDispenseReturn.DrugDispenseReturnId; } else { drugDispenseReturnId = -1; } } if (drugDispenseReturnId > 0) { if (drugDispenseReturn.IsDeleted == true) { DrugDispenseDrugReturn drugReturnDB = new DrugDispenseDrugReturn(); var result = drugReturnDB.DeleteDrugDispenseDrugReturnDetailsByDrugDispenseReturnId((int)drugDispenseReturn.DrugDispenseReturnId, (int)drugDispenseReturn.DeletedBy, drugDispenseReturn.DeletedByIP, dbTransaction); if (result) { drugDispenseDrugReturnId = (int)drugDispenseReturn.DrugDispenseReturnId; } } if (drugDispenseReturn.DrugDispenseDrugReturns != null) { if (drugDispenseReturn.DrugDispenseDrugReturns.Count > 0) { foreach (Entities.DrugDispenseDrugReturn drugReturn in drugDispenseReturn.DrugDispenseDrugReturns) { DrugDispenseDrugReturn drugReturnDB = new DrugDispenseDrugReturn(); drugReturn.DrugDispenseReturnId = drugDispenseReturnId; drugDispenseDrugReturnId = drugReturnDB.SaveDrugDispenseDrugReturn(drugReturn, dbTransaction); if (drugDispenseDrugReturnId < 0) { drugDispenseReturnId = -1; } } } } } } if (drugDispenseReturnId > 0) { dbTransaction.Commit(); } else { dbTransaction.Rollback(); } } catch (Exception ex) { drugDispenseReturnId = -1; dbTransaction.Rollback(); throw ex; } } return(drugDispenseReturnId); } }
public Pettycash() { database = DBConnect.getDBConnection(); }
public User() { database = DBConnect.getDBConnection(); }
public Company() { database = DBConnect.getDBConnection(); }
public Brand() { database = DBConnect.getDBConnection(); }
public Role() { database = DBConnect.getDBConnection(); }
public BloodGroup() { database = DBConnect.getDBConnection(); }
public UnitsOfMeasurement() { database = DBConnect.getDBConnection(); }
public RolePermission() { database = DBConnect.getDBConnection(); }
public AddressType() { database = DBConnect.getDBConnection(); }
public PurchaseBillCharges() { database = DBConnect.getDBConnection(); }
public DrugsLinkWithDrugRoute() { database = DBConnect.getDBConnection(); }
public PreEmploymentTestDetails() { database = DBConnect.getDBConnection(); }
public ClientType() { database = DBConnect.getDBConnection(); }
public DrugFormulation() { database = DBConnect.getDBConnection(); }
public PurchaseBillReturn() { database = DBConnect.getDBConnection(); }
public ClientAddress() { database = DBConnect.getDBConnection(); }
public Int32 SavePreEmploymentDetails(Entities.PreEmploymentDetails preEmploymentDetails) { var preEmploymentId = 0; var db = DBConnect.getDBConnection(); using (DbConnection conn = db.CreateConnection()) { conn.Open(); using (DbTransaction dbTransaction = conn.BeginTransaction()) { try { var preEmploymentTestId = 0; if (preEmploymentDetails != null) { if (preEmploymentDetails.PreEmploymentId == null || preEmploymentDetails.PreEmploymentId == 0) { preEmploymentId = AddPreEmploymentDetails(preEmploymentDetails, dbTransaction); } else if (preEmploymentDetails.ModifiedBy != null || preEmploymentDetails.ModifiedBy > 0) { preEmploymentId = UpdatePreEmploymentDetails(preEmploymentDetails, dbTransaction); } else if (preEmploymentDetails.IsDeleted == true) { var result = DeletePreEmploymentDetails(preEmploymentDetails, dbTransaction); if (result) { preEmploymentId = (int)preEmploymentDetails.PreEmploymentId; } else { preEmploymentId = -1; } } if (preEmploymentId > 0) { if (preEmploymentDetails.IsDeleted == true) { PreEmploymentTestDetails preEmploymentTestDetailsDB = new PreEmploymentTestDetails(); var result = preEmploymentTestDetailsDB.DeletePreEmploymentTestDetails((int)preEmploymentDetails.PreEmploymentId, (int)preEmploymentDetails.DeletedBy, preEmploymentDetails.DeletedByIP, dbTransaction); if (result) { preEmploymentTestId = (int)preEmploymentDetails.PreEmploymentId; } } if (preEmploymentDetails.PreEmploymentTestDetails != null) { if (preEmploymentDetails.PreEmploymentTestDetails.Count > 0) { foreach (Entities.PreEmploymentTestDetails preEmploymentTestDetails in preEmploymentDetails.PreEmploymentTestDetails) { PreEmploymentTestDetails preEmploymentTestDetailsDB = new PreEmploymentTestDetails(); preEmploymentTestDetails.PreEmploymentId = preEmploymentId; preEmploymentTestId = preEmploymentTestDetailsDB.SavePreEmploymentDetails(preEmploymentTestDetails, dbTransaction); if (preEmploymentTestId < 0) { preEmploymentTestId = -1; } } } } } } if (preEmploymentTestId > 0) { dbTransaction.Commit(); } else { dbTransaction.Rollback(); } } catch (Exception ex) { preEmploymentId = -1; dbTransaction.Rollback(); throw ex; } } return(preEmploymentId); } }
public DrugDispenseReturn() { database = DBConnect.getDBConnection(); }
public Employee() { database = DBConnect.getDBConnection(); }
public MedicalTestParameters() { database = DBConnect.getDBConnection(); }
public Int32 SavePurchaseBill(Entities.PurchaseBill purchaseBill) { var purchaseBillId = 0; var db = DBConnect.getDBConnection(); using (DbConnection conn = db.CreateConnection()) { conn.Open(); using (DbTransaction transaction = conn.BeginTransaction()) { try { var purchaseBillItemId = 0; var purchaseBillChargeId = 0; if (purchaseBill != null) { if (purchaseBill.PurchaseBillId == null || purchaseBill.PurchaseBillId == 0) { purchaseBillId = AddPurchaseBill(purchaseBill, transaction); } else { if (purchaseBill.IsDeleted == true) { var result = DeletePurchaseBill(purchaseBill, transaction); purchaseBillId = Convert.ToInt32(purchaseBill.PurchaseBillId); } else { if (purchaseBill.ModifiedBy > 0 || purchaseBill.ModifiedBy != null) { purchaseBillId = UpdatePurchaseBill(purchaseBill, transaction); // If records failed to save if (purchaseBillId < 0) { purchaseBillId = -1; } } } } if (purchaseBillId > 0) { if (purchaseBill.IsDeleted == true) { PurchaseBillItem dal = new PurchaseBillItem(); var result = dal.DeletePurchaseBillItemByPurchaseBillId(purchaseBillId, (int)purchaseBill.DeletedBy, purchaseBill.DeletedByIP, transaction); if (result) { purchaseBillId = 1; } } // Save Purchase Bill Items if (purchaseBill.PurchaseBillItems != null) { if (purchaseBill.PurchaseBillItems.Count > 0) { foreach (Entities.PurchaseBillItem purchaseBillItem in purchaseBill.PurchaseBillItems) { purchaseBillItem.PurchaseBillId = purchaseBillId; PurchaseBillItem dal = new PurchaseBillItem(); purchaseBillItemId = dal.SavePurchaseBillItem(purchaseBillItem, transaction); // If records failed to save if (purchaseBillItemId < 0) { purchaseBillId = -1; } } } } if (purchaseBill.IsDeleted == true) { PurchaseBillCharges dal = new PurchaseBillCharges(); var result = dal.DeletePurchaseBillChargeByPurchaseBillId(purchaseBillId, (int)purchaseBill.DeletedBy, purchaseBill.DeletedByIP, transaction); if (result == true) { purchaseBillId = (int)purchaseBill.PurchaseBillId; } } // Save Purchase Bill Charges if (purchaseBill.PurchaseBillCharges != null) { if (purchaseBill.PurchaseBillCharges.Count > 0) { foreach (Entities.PurchaseBillCharge purchaseBillCharge in purchaseBill.PurchaseBillCharges) { purchaseBillCharge.PurchaseBillId = purchaseBillId; PurchaseBillCharges dal = new PurchaseBillCharges(); purchaseBillChargeId = dal.SavePurchaseBillCharge(purchaseBillCharge, transaction); // If records failed to save if (purchaseBillChargeId < 0) { purchaseBillId = -1; } } } } } } if (purchaseBillId > 0) { transaction.Commit(); } else { transaction.Rollback(); } } catch (Exception ex) { purchaseBillId = -1; transaction.Rollback(); throw ex; } finally { db = null; } } } return(purchaseBillId); }
public Location() { database = DBConnect.getDBConnection(); }
public City() { database = DBConnect.getDBConnection(); }
public Country() { database = DBConnect.getDBConnection(); }
public ModeOfPayment() { database = DBConnect.getDBConnection(); }