public Int32 SaveDrug(Entities.Drug drug)
{
var drugId = 0;
var db = DBConnect.getDBConnection();
using (DbConnection conn = db.CreateConnection())
{
conn.Open();
using (DbTransaction transaction = conn.BeginTransaction())
{
try
{
var drugRouteLinkId = 0;
if (drug != null)
{
if (drug.DrugId == null || drug.DrugId == 0)
{
drugId = AddDrug(drug, transaction);
}
else
{
if (drug.IsDeleted == true)
{
var result = DeleteDrug(drug, transaction);
drugId = Convert.ToInt32(drug.DrugId);
}
else
{
if (drug.ModifiedBy > 0 || drug.ModifiedBy != null)
{
drugId = UpdateDrug(drug, transaction);
// If records failed to save
if (drugId < 0)
{
drugId = -1;
}
}
}
}
if (drugId > 0)
{
if (drug.IsDeleted == true)
{
DrugsLinkWithDrugRoute dal = new DrugsLinkWithDrugRoute();
var result = dal.DeleteDrugRoutesLinkByDrugId(drugId, (int)drug.DeletedBy, drug.DeletedByIP, transaction);
if (result == true)
{
drugId = 1;
}
}
// Save Drugs Link with Drug Route
if (drug.DrugLinkWithDrugRoutes != null)
{
if (drug.DrugLinkWithDrugRoutes.Count > 0)
{
foreach (Entities.DrugLinkWithDrugRoutes drugLinkRoute in drug.DrugLinkWithDrugRoutes)
{
drugLinkRoute.DrugId = drugId;
DrugsLinkWithDrugRoute dal = new DrugsLinkWithDrugRoute();
drugRouteLinkId = dal.SaveDrugLinkWithDrugRoute(drugLinkRoute, transaction);
// If records failed to save
if (drugRouteLinkId < 0)
{
drugId = -1;
}
}
}
}
}
}
if (drugId > 0)
{
transaction.Commit();
}
else
{
transaction.Rollback();
}
}
catch (Exception ex)
{
drugId = -1;
transaction.Rollback();
throw ex;
}
finally
{
db = null;
}
}
}
return(drugId);
}
public Int32 SaveXRayIssueDetails(Entities.XRayIssue xrayIssue)
{
var XRayIssueId = 0;
var db = DBConnect.getDBConnection();
using (DbConnection conn = db.CreateConnection())
{
conn.Open();
using (DbTransaction dbTransaction = conn.BeginTransaction())
{
try
{
var xrayFilmUsedId = 0;
if (xrayIssue != null)
{
if (xrayIssue.XRayIssueId == null || xrayIssue.XRayIssueId == 0)
{
XRayIssueId = AddXRayIssueDetails(xrayIssue, dbTransaction);
}
else if (xrayIssue.ModifiedBy != null || xrayIssue.ModifiedBy > 0)
{
XRayIssueId = UpdateXRayIssueDetails(xrayIssue, dbTransaction);
}
else if (xrayIssue.IsDeleted == true)
{
var result = DeleteXRayIssueDetails(xrayIssue, dbTransaction);
if (result)
{
XRayIssueId = (int)xrayIssue.XRayIssueId;
}
else
{
XRayIssueId = -1;
}
}
if (XRayIssueId > 0)
{
if (xrayIssue.IsDeleted == true)
{
XRayFilmUsed xRayFilmUsed = new XRayFilmUsed();
var result = xRayFilmUsed.DeleteXRayFilmUsedDetailsByXRayIssueId((int)xrayIssue.XRayIssueId, (int)xrayIssue.DeletedBy, xrayIssue.DeletedByIP, dbTransaction);
if (result)
{
XRayIssueId = (int)xrayIssue.XRayIssueId;
}
}
if (xrayIssue.XRayFilmsUsed != null)
{
if (xrayIssue.XRayFilmsUsed.Count > 0)
{
foreach (Entities.XRayFilmUsed xrayFilmUsed in xrayIssue.XRayFilmsUsed)
{
XRayFilmUsed xRayFilmUsedDB = new XRayFilmUsed();
xrayFilmUsed.XRayIssueId = XRayIssueId;
xrayFilmUsedId = xRayFilmUsedDB.SaveXRayFilmUsed(xrayFilmUsed, dbTransaction);
if (xrayFilmUsedId < 0)
{
XRayIssueId = -1;
}
}
}
}
}
}
if (XRayIssueId > 0)
{
dbTransaction.Commit();
}
else
{
dbTransaction.Rollback();
}
}
catch (Exception ex)
{
XRayIssueId = -1;
dbTransaction.Rollback();
throw ex;
}
}
return(XRayIssueId);
}
}
public Drug()
{
database = DBConnect.getDBConnection();
}
public Company()
{
database = DBConnect.getDBConnection();
}
public DataSearchField()
{
database = DBConnect.getDBConnection();
}
public AddressType()
{
database = DBConnect.getDBConnection();
}
public Role()
{
database = DBConnect.getDBConnection();
}
public Employer()
{
database = DBConnect.getDBConnection();
}
public WorkingPeriod()
{
database = DBConnect.getDBConnection();
}
public Int32 SaveDrugDispenseDetails(Entities.DrugDispense drugDispense)
{
var drugDispenseId = 0;
var db = DBConnect.getDBConnection();
using (DbConnection conn = db.CreateConnection())
{
conn.Open();
using (DbTransaction dbTransaction = conn.BeginTransaction())
{
try
{
var drugDispenseDrugUtilisationId = 0;
if (drugDispense != null)
{
if (drugDispense.DrugDispenseId == null || drugDispense.DrugDispenseId == 0)
{
drugDispenseId = AddDrugDispenseDetails(drugDispense, dbTransaction);
}
else if (drugDispense.ModifiedBy != null || drugDispense.ModifiedBy > 0)
{
drugDispenseId = UpdateDrugDispenseDetails(drugDispense, dbTransaction);
}
else if (drugDispense.IsDeleted == true)
{
var result = DeleteDrugDispenseDetails(drugDispense, dbTransaction);
if (result)
{
drugDispenseId = (int)drugDispense.DrugDispenseId;
}
else
{
drugDispenseId = -1;
}
}
if (drugDispenseId > 0)
{
if (drugDispense.IsDeleted == true)
{
DrugDispenseDrugUtilisation drugUtilisationDB = new DrugDispenseDrugUtilisation();
var result = drugUtilisationDB.DeleteDrugDispenseDrugUtilisationDetailsByDrugDispenseId((int)drugDispense.DrugDispenseId, (int)drugDispense.DeletedBy, drugDispense.DeletedByIP, dbTransaction);
if (result)
{
drugDispenseDrugUtilisationId = (int)drugDispense.DrugDispenseId;
}
}
if (drugDispense.DrugDispenseDrugUtilisations != null)
{
if (drugDispense.DrugDispenseDrugUtilisations.Count > 0)
{
foreach (Entities.DrugDispenseDrugUtilisation drugUtilisation in drugDispense.DrugDispenseDrugUtilisations)
{
DrugDispenseDrugUtilisation drugUtilisationDB = new DrugDispenseDrugUtilisation();
drugUtilisation.DrugDispenseId = drugDispenseId;
drugDispenseDrugUtilisationId = drugUtilisationDB.SaveDrugDispenseDrugUtilisation(drugUtilisation, dbTransaction);
if (drugDispenseDrugUtilisationId < 0)
{
drugDispenseId = -1;
}
}
}
}
}
}
if (drugDispenseId > 0)
{
dbTransaction.Commit();
}
else
{
dbTransaction.Rollback();
}
}
catch (Exception ex)
{
drugDispenseId = -1;
dbTransaction.Rollback();
throw ex;
}
}
return(drugDispenseId);
}
}
public ClientAddressContact()
{
database = DBConnect.getDBConnection();
}
public DrugDispense()
{
database = DBConnect.getDBConnection();
}
public Precautions()
{
database = DBConnect.getDBConnection();
}
public AccountHead()
{
database = DBConnect.getDBConnection();
}
public ModeOfPayment()
{
database = DBConnect.getDBConnection();
}
public PurchaseBillReturnItem()
{
database = DBConnect.getDBConnection();
}
public Menu()
{
database = DBConnect.getDBConnection();
}
public Client()
{
database = DBConnect.getDBConnection();
}
public RolePermission()
{
database = DBConnect.getDBConnection();
}
public Int32 SaveClient(List <Entities.Client> client)
{
var clientId = 0;
var db = DBConnect.getDBConnection();
using (DbConnection conn = db.CreateConnection())
{
conn.Open();
using (DbTransaction transaction = conn.BeginTransaction())
{
try
{
var clientAddressId = 0;
if (client.Count > 0)
{
foreach (Entities.Client c in client)
{
if (c.ClientId == null || c.ClientId == 0)
{
var result = IsClientNameExists(c.ClientName);
if (result == false)
{
clientId = AddClient(c, transaction);
}
else
{
clientId = -2;
}
}
else if (c.ModifiedBy == null || c.ModifiedBy == 0)
{
clientId = UpdateClient(c, transaction);
}
else if (c.IsDeleted == true)
{
var result = DeleteClient(c, transaction);
if (result)
{
clientId = (int)c.ClientId;
}
}
if (clientId > 0)
{
foreach (Entities.ClientAddress ca in c.ClientAddressess)
{
ca.ClientId = clientId;
ClientAddress clientAddress = new ClientAddress();
clientAddressId = clientAddress.SaveClientAddress(ca, transaction);
}
}
}
}
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
finally
{
db = null;
}
}
}
return(clientId);
}
public BloodGroup()
{
database = DBConnect.getDBConnection();
}
public XRayIssue()
{
database = DBConnect.getDBConnection();
}
public Brand()
{
database = DBConnect.getDBConnection();
}
public State()
{
database = DBConnect.getDBConnection();
}