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();
}
