public int InsertCompany(EntityCompany entCompany)
{
int cnt = 0;
try
{
List <SqlParameter> lstParam = new List <SqlParameter>();
Commons.ADDParameter(ref lstParam, "@CompanyCode", DbType.String, entCompany.CompanyCode);
Commons.ADDParameter(ref lstParam, "@CompanyName", DbType.String, entCompany.CompanyName);
Commons.ADDParameter(ref lstParam, "@Address", DbType.String, entCompany.Address);
Commons.ADDParameter(ref lstParam, "@PhoneNo", DbType.String, entCompany.PhoneNo);
Commons.ADDParameter(ref lstParam, "@MobileNo", DbType.String, entCompany.MobileNo);
Commons.ADDParameter(ref lstParam, "@VATCSTNo", DbType.String, entCompany.VATCSTNo);
Commons.ADDParameter(ref lstParam, "@ExciseNo", DbType.String, entCompany.ExciseNo);
Commons.ADDParameter(ref lstParam, "@Email", DbType.String, entCompany.Email);
Commons.ADDParameter(ref lstParam, "@ServiceTaxNo", DbType.String, entCompany.ServiceTaxNo);
Commons.ADDParameter(ref lstParam, "@EntryBy", DbType.String, entCompany.EntryBy);
cnt = mobjDataAcces.ExecuteQuery("sp_InsertCompany ", lstParam);
}
catch (Exception ex)
{
Commons.FileLog("CompanyBLL - InsertCompany(EntityCompany entCompany)", ex);
}
return(cnt);
}
public int UpdateEmployee(EntityEmployee entEmployee)
{
int cnt = 0;
try
{
List <SqlParameter> lstParam = new List <SqlParameter>();
Commons.ADDParameter(ref lstParam, "@EmpCode", DbType.String, entEmployee.EmpCode);
Commons.ADDParameter(ref lstParam, "@EmpFirstName", DbType.String, entEmployee.EmpFirstName);
Commons.ADDParameter(ref lstParam, "@EmpMiddleName", DbType.String, entEmployee.EmpMiddleName);
Commons.ADDParameter(ref lstParam, "@EmpLastName", DbType.String, entEmployee.EmpLastName);
Commons.ADDParameter(ref lstParam, "@EmpAddress", DbType.String, entEmployee.EmpAddress);
Commons.ADDParameter(ref lstParam, "@EmpDOB", DbType.DateTime, entEmployee.EmpDOB);
Commons.ADDParameter(ref lstParam, "@EmpDOJ", DbType.DateTime, entEmployee.EmpDOJ);
Commons.ADDParameter(ref lstParam, "@DeptId", DbType.String, entEmployee.DeptId);
Commons.ADDParameter(ref lstParam, "@ChangeBy", DbType.String, entEmployee.ChangeBy);
Commons.ADDParameter(ref lstParam, "@DesigId", DbType.Int32, entEmployee.DesignationId);
Commons.ADDParameter(ref lstParam, "@BankName", DbType.String, entEmployee.BankName);
Commons.ADDParameter(ref lstParam, "@BankACNo", DbType.String, entEmployee.BankACNo);
Commons.ADDParameter(ref lstParam, "@PFNo", DbType.String, entEmployee.PFNo);
Commons.ADDParameter(ref lstParam, "@PanNo", DbType.String, entEmployee.PanNo);
Commons.ADDParameter(ref lstParam, "@BasicSalary", DbType.Decimal, entEmployee.BasicSal);
cnt = mobjDataAcces.ExecuteQuery("sp_UpdateEmployee", lstParam);
}
catch (Exception ex)
{
Commons.FileLog("EmployeeBLL - CreateParameterUpdateEmp(EntityEmployee entEmployee)", ex);
}
return(cnt);
}
public int InsertInsurance(EntityInsuranceCom entInsurance)
{
int cnt = 0;
try
{
List <SqlParameter> lstParam = new List <SqlParameter>();
Commons.ADDParameter(ref lstParam, "@InsuranceCode", DbType.String, entInsurance.InsuranceCode);
Commons.ADDParameter(ref lstParam, "@InsuranceDesc", DbType.String, entInsurance.InsuranceDesc);
Commons.ADDParameter(ref lstParam, "@Address", DbType.String, entInsurance.Address);
Commons.ADDParameter(ref lstParam, "@Country", DbType.String, entInsurance.Country);
Commons.ADDParameter(ref lstParam, "@State", DbType.String, entInsurance.State);
Commons.ADDParameter(ref lstParam, "@City", DbType.String, entInsurance.City);
Commons.ADDParameter(ref lstParam, "@EmailID", DbType.String, entInsurance.EmailID);
Commons.ADDParameter(ref lstParam, "@ContactNo", DbType.String, entInsurance.ContactNo);
Commons.ADDParameter(ref lstParam, "@PostalCode", DbType.String, entInsurance.PostalCode);
Commons.ADDParameter(ref lstParam, "@FaxNumber", DbType.String, entInsurance.FaxNumber);
Commons.ADDParameter(ref lstParam, "@ContactPerson", DbType.String, entInsurance.ContactPerson);
Commons.ADDParameter(ref lstParam, "@ContactPhNo", DbType.String, entInsurance.ContactPhNo);
Commons.ADDParameter(ref lstParam, "@MobileNo", DbType.String, entInsurance.MobileNo);
Commons.ADDParameter(ref lstParam, "@ContactEmailID", DbType.String, entInsurance.ContactEmail);
Commons.ADDParameter(ref lstParam, "@Notes", DbType.String, entInsurance.Notes);
Commons.ADDParameter(ref lstParam, "@EntryBy", DbType.String, entInsurance.EntryBy);
cnt = mobjDataAcces.ExecuteQuery("sp_InsertInsurance", lstParam);
}
catch (Exception ex)
{
throw ex;
}
return(cnt);
}
public int UpdateConsultant(EntityConsultant entConsultant)
{
int cnt = 0;
try
{
List <SqlParameter> lstParam = new List <SqlParameter>();
Commons.ADDParameter(ref lstParam, "@ConsCode", DbType.String, entConsultant.ConsultantCode);
Commons.ADDParameter(ref lstParam, "@ConsFirstName", DbType.String, entConsultant.FirstName);
Commons.ADDParameter(ref lstParam, "@ConsMiddleName", DbType.String, entConsultant.MiddleName);
Commons.ADDParameter(ref lstParam, "@ConsLastName", DbType.String, entConsultant.LastName);
Commons.ADDParameter(ref lstParam, "@ConsAddress", DbType.String, entConsultant.Address);
Commons.ADDParameter(ref lstParam, "@ConsDOB", DbType.DateTime, entConsultant.DOB);
Commons.ADDParameter(ref lstParam, "@ConsDOJ", DbType.DateTime, entConsultant.DOJ);
Commons.ADDParameter(ref lstParam, "@ChangeBy", DbType.String, entConsultant.ChaneBy);
Commons.ADDParameter(ref lstParam, "@WardNo", DbType.String, entConsultant.WardNo);
Commons.ADDParameter(ref lstParam, "@Fees", DbType.String, entConsultant.Fees);
cnt = mobjDataAcces.ExecuteQuery("sp_UpdateConsultant", lstParam);
}
catch (Exception ex)
{
Commons.FileLog("ConsultantBLL - UpdateConsultant(EntityConsultant entConsultant)", ex);
}
return(cnt);
}
public int InsertSupplier(EntitySupplier entSupplier)
{
int cnt = 0;
try
{
List <SqlParameter> lstParam = new List <SqlParameter>();
Commons.ADDParameter(ref lstParam, "@SupplierCode", DbType.String, entSupplier.SupplierCode);
Commons.ADDParameter(ref lstParam, "@SupplierName", DbType.String, entSupplier.SupplierName);
Commons.ADDParameter(ref lstParam, "@Address", DbType.String, entSupplier.Address);
Commons.ADDParameter(ref lstParam, "@PhoneNo", DbType.String, entSupplier.PhoneNo);
Commons.ADDParameter(ref lstParam, "@MobileNo", DbType.String, entSupplier.MobileNo);
Commons.ADDParameter(ref lstParam, "@VATCSTNo", DbType.String, entSupplier.VATCSTNo);
Commons.ADDParameter(ref lstParam, "@ExciseNo", DbType.String, entSupplier.ExciseNo);
Commons.ADDParameter(ref lstParam, "@Email", DbType.String, entSupplier.Email);
Commons.ADDParameter(ref lstParam, "@ServiceTaxNo", DbType.String, entSupplier.ServiceTaxNo);
Commons.ADDParameter(ref lstParam, "@EntryBy", DbType.String, entSupplier.EntryBy);
cnt = mobjDataAcces.ExecuteQuery("sp_InsertSupplier ", lstParam);
}
catch (Exception ex)
{
throw ex;
}
return(cnt);
}
public int InsertOPD(EntityOPD entOPD)
{
int cnt = 0;
try
{
List <SqlParameter> lstParam = new List <SqlParameter>();
Commons.ADDParameter(ref lstParam, "@OPDDesc", DbType.String, entOPD.OPDDesc);
cnt = mobjDataAcces.ExecuteQuery("sp_InsertOPD ", lstParam);
}
catch (Exception ex)
{
Commons.FileLog("OPDBLL - InsertOPD(EntityOPD entOPD)", ex);
}
return(cnt);
}
public int InsertReligion(EntitySurgeryMaster entReligion)
{
int cnt = 0;
try
{
List <SqlParameter> lstParam = new List <SqlParameter>();
Commons.ADDParameter(ref lstParam, "@NameOfSurgery", DbType.String, entReligion.NameOfSurgery);
Commons.ADDParameter(ref lstParam, "@OperationalProcedure", DbType.String, entReligion.OperationalProcedure);
cnt = mobjDataAcces.ExecuteQuery("sp_InsertSurgeryMaster ", lstParam);
}
catch (Exception ex)
{
Commons.FileLog("TabletMasterBLL - InsertReligion(EntityReligion entReligion)", ex);
}
return(cnt);
}
public int InsertOccupation(EntityOccupation entOccupation)
{
int cnt = 0;
try
{
List <SqlParameter> lstParam = new List <SqlParameter>();
Commons.ADDParameter(ref lstParam, "@OccupationDesc", DbType.String, entOccupation.OccupationDesc);
Commons.ADDParameter(ref lstParam, "@EntryBy", DbType.String, entOccupation.EntryBy);
cnt = mobjDataAcces.ExecuteQuery("sp_InsertOccupation ", lstParam);
}
catch (Exception ex)
{
Commons.FileLog("OccupationBLL - InsertOccupation(EntityOccupation entOccupation)", ex);
}
return(cnt);
}
public int InsertReligion(EntityOperationCategory entReligion)
{
int cnt = 0;
try
{
List <SqlParameter> lstParam = new List <SqlParameter>();
Commons.ADDParameter(ref lstParam, "@CategoryCode", DbType.String, entReligion.CategoryCode);
Commons.ADDParameter(ref lstParam, "@CategoryName", DbType.String, entReligion.CategoryName);
cnt = mobjDataAcces.ExecuteQuery("sp_InsertOperationCat", lstParam);
}
catch (Exception ex)
{
Commons.FileLog("OperationCategoryBLL - InsertOperationCat(EntityOperationCategory entReligion)", ex);
}
return(cnt);
}
public int InsertGroup(EntityGroup entGroup)
{
int cnt = 0;
try
{
List <SqlParameter> lstParam = new List <SqlParameter>();
Commons.ADDParameter(ref lstParam, "@GroupDesc", DbType.String, entGroup.GroupDesc);
Commons.ADDParameter(ref lstParam, "@EntryBy", DbType.String, entGroup.EntryBy);
cnt = mobjDataAcces.ExecuteQuery("sp_InsertGroup ", lstParam);
}
catch (Exception ex)
{
Commons.FileLog("GroupBLL - InsertGroup(EntityGroup entGroup)", ex);
}
return(cnt);
}
public int InsertReligion(EntityTabletMaster entReligion)
{
int cnt = 0;
try
{
List <SqlParameter> lstParam = new List <SqlParameter>();
Commons.ADDParameter(ref lstParam, "@TabletCode", DbType.String, entReligion.TabletCode);
Commons.ADDParameter(ref lstParam, "@MedicineName", DbType.String, entReligion.MedicineName);
cnt = mobjDataAcces.ExecuteQuery("sp_InsertTablet ", lstParam);
}
catch (Exception ex)
{
Commons.FileLog("TabletMasterBLL - InsertReligion(EntityReligion entReligion)", ex);
}
return(cnt);
}
public int InsertItem(EntityItem entItem)
{
int cnt = 0;
try
{
if (entItem.IsCheked == 0)
{
List <SqlParameter> lstParam = new List <SqlParameter>();
Commons.ADDParameter(ref lstParam, "@ItemCode", DbType.String, entItem.ItemCode);
Commons.ADDParameter(ref lstParam, "@ItemDesc", DbType.String, entItem.ItemDesc);
Commons.ADDParameter(ref lstParam, "@ReorderLevel", DbType.Int32, entItem.ReorderLevel);
Commons.ADDParameter(ref lstParam, "@ReorderMaxLevel", DbType.Int32, entItem.ReorderMaxLevel);
Commons.ADDParameter(ref lstParam, "@UnitCode", DbType.String, entItem.UnitCode);
Commons.ADDParameter(ref lstParam, "@SupplierCode", DbType.String, entItem.SupplierCode);
Commons.ADDParameter(ref lstParam, "@OpenningBalance", DbType.Decimal, entItem.OpeningBalance);
Commons.ADDParameter(ref lstParam, "@Rate", DbType.Decimal, entItem.Rate);
Commons.ADDParameter(ref lstParam, "@GroupId", DbType.Int32, entItem.GroupId);
Commons.ADDParameter(ref lstParam, "@EntryBy", DbType.String, entItem.EntryBy);
cnt = mobjDataAcces.ExecuteQuery("sp_InsertItem ", lstParam);
}
else
{
List <SqlParameter> lstParam = new List <SqlParameter>();
Commons.ADDParameter(ref lstParam, "@ItemCode", DbType.String, entItem.ItemCode);
Commons.ADDParameter(ref lstParam, "@ItemDesc", DbType.String, entItem.ItemDesc);
Commons.ADDParameter(ref lstParam, "@ReorderLevel", DbType.Int32, entItem.ReorderLevel);
Commons.ADDParameter(ref lstParam, "@ReorderMaxLevel", DbType.Int32, entItem.ReorderMaxLevel);
Commons.ADDParameter(ref lstParam, "@UnitCode", DbType.String, entItem.UnitCode);
Commons.ADDParameter(ref lstParam, "@SupplierCode", DbType.String, entItem.SupplierCode);
Commons.ADDParameter(ref lstParam, "@OpenningBalance", DbType.Decimal, entItem.OpeningBalance);
Commons.ADDParameter(ref lstParam, "@Rate", DbType.Decimal, entItem.Rate);
Commons.ADDParameter(ref lstParam, "@GroupId", DbType.Int32, entItem.GroupId);
Commons.ADDParameter(ref lstParam, "@ManifacturingDate", DbType.DateTime, entItem.ManifacturingDate);
Commons.ADDParameter(ref lstParam, "@ExpiryDate", DbType.DateTime, entItem.ExpiryDate);
Commons.ADDParameter(ref lstParam, "@EntryBy", DbType.String, entItem.EntryBy);
cnt = mobjDataAcces.ExecuteQuery("sp_InsertItem ", lstParam);
}
}
catch (Exception ex)
{
Commons.FileLog("ItemBLL - InsertItem(EntityItem entItem)", ex);
}
return(cnt);
}
public int InsertUnit(EntityUnit entUnit)
{
int cnt = 0;
try
{
List <SqlParameter> lstParam = new List <SqlParameter>();
Commons.ADDParameter(ref lstParam, "@UnitCode", DbType.String, entUnit.UnitCode);
Commons.ADDParameter(ref lstParam, "@UnitDesc", DbType.String, entUnit.UnitDesc);
cnt = mobjDataAcces.ExecuteQuery("sp_InsertUnit ", lstParam);
}
catch (Exception ex)
{
Commons.FileLog("UnitBLL - InsertUnit(EntityUnit entUnit)", ex);
}
return(cnt);
}
public int InsertGender(EntityGender entGender)
{
int cnt = 0;
try
{
List <SqlParameter> lstParam = new List <SqlParameter>();
Commons.ADDParameter(ref lstParam, "@GenderCode", DbType.String, entGender.GenderCode);
Commons.ADDParameter(ref lstParam, "@GenderDesc", DbType.String, entGender.GenderDesc);
Commons.ADDParameter(ref lstParam, "@EntryBy", DbType.String, entGender.EntryBy);
cnt = mobjDataAcces.ExecuteQuery("sp_InsertGender ", lstParam);
}
catch (Exception ex)
{
Commons.FileLog("GenderBLL - InsertGender(EntityGender entGender)", ex);
}
return(cnt);
}
public int InsertDignosis(EntityDignosis entDignosis)
{
int cnt = 0;
try
{
List <SqlParameter> lstParam = new List <SqlParameter>();
Commons.ADDParameter(ref lstParam, "@DignosisCode", DbType.String, entDignosis.DignosisCode);
Commons.ADDParameter(ref lstParam, "@DignosisDesc", DbType.String, entDignosis.DignosisDesc);
Commons.ADDParameter(ref lstParam, "@EntryBy", DbType.String, entDignosis.EntryBy);
cnt = mobjDataAcces.ExecuteQuery("sp_InsertDignosis ", lstParam);
}
catch (Exception ex)
{
Commons.FileLog("DignosisBLL - InsertDignosis(EntityDignosis entDignosis)", ex);
}
return(cnt);
}
public int InsertCurrency(EntityCurrency entCurrency)
{
int cnt = 0;
try
{
List <SqlParameter> lstParam = new List <SqlParameter>();
Commons.ADDParameter(ref lstParam, "@CurrencyCode", DbType.String, entCurrency.CurrencyCode);
Commons.ADDParameter(ref lstParam, "@CurrencyDesc", DbType.String, entCurrency.CurrencyDesc);
Commons.ADDParameter(ref lstParam, "@EntryBy", DbType.String, entCurrency.EntryBy);
cnt = mobjDataAcces.ExecuteQuery("sp_InsertCurrency", lstParam);
}
catch (Exception ex)
{
Commons.FileLog("CurrencyBLL - InsertCurrency(EntityCurrency entCurrency)", ex);
}
return(cnt);
}
public int UpdateTestMethod(EntityTestMethod entTest)
{
int cnt = 0;
try
{
List<SqlParameter> lstParam = new List<SqlParameter>();
Commons.ADDParameter(ref lstParam, "@TestMethodId", DbType.String, entTest.TestMethodId);
Commons.ADDParameter(ref lstParam, "@TestMethodDesc", DbType.String, entTest.TestMethodDesc);
cnt = mobjDataAcces.ExecuteQuery("sp_UpdateTestMethod", lstParam);
}
catch (Exception ex)
{
Commons.FileLog("TestMethodBLL - UpdateTestMethod(EntityTestMethod entTest)", ex);
}
return cnt;
}
public int InsertCity(EntityCity entCity)
{
int cnt = 0;
try
{
List <SqlParameter> lstParam = new List <SqlParameter>();
Commons.ADDParameter(ref lstParam, "@StateId", DbType.Int32, entCity.State);
Commons.ADDParameter(ref lstParam, "@CityDesc", DbType.String, entCity.CityDesc);
Commons.ADDParameter(ref lstParam, "@EntryBy", DbType.String, entCity.EntryBy);
cnt = mobjDataAcces.ExecuteQuery("sp_InsertCity ", lstParam);
}
catch (Exception ex)
{
Commons.FileLog("CityBLL - InsertCity(EntityCity entCity)", ex);
}
return(cnt);
}
public int InsertPatient(EntityPatientType entPatient)
{
int cnt = 0;
try
{
List <SqlParameter> lstParam = new List <SqlParameter>();
Commons.ADDParameter(ref lstParam, "@PatientCode", DbType.String, entPatient.PatientCode);
Commons.ADDParameter(ref lstParam, "@PatientDesc", DbType.String, entPatient.PatientDesc);
Commons.ADDParameter(ref lstParam, "@EntryBy", DbType.String, entPatient.EntryBy);
cnt = mobjDataAcces.ExecuteQuery("sp_InsertPatient ", lstParam);
}
catch (Exception ex)
{
Commons.FileLog("PatientTypeBLL -InsertPatient(EntityPatientType entPatient)", ex);
}
return(cnt);
}
public int InsertReligion(EntityNurse entReligion)
{
int cnt = 0;
try
{
List <SqlParameter> lstParam = new List <SqlParameter>();
Commons.ADDParameter(ref lstParam, "@NurseCode", DbType.String, entReligion.NurseCode);
Commons.ADDParameter(ref lstParam, "@NurseName", DbType.String, entReligion.NurseName);
Commons.ADDParameter(ref lstParam, "@DeptId", DbType.Int32, entReligion.DeptId);
Commons.ADDParameter(ref lstParam, "@DepartmentName", DbType.String, entReligion.DepartmentName);
cnt = mobjDataAcces.ExecuteQuery("sp_InsertNurse ", lstParam);
}
catch (Exception ex)
{
Commons.FileLog("NurseBLL - InsertReligion(EntityReligion entReligion)", ex);
}
return(cnt);
}
public int InsertConsultantCharges(EntityConsultantChargeMaster entChargeMaster)
{
int cnt = 0;
try
{
List <SqlParameter> lstParam = new List <SqlParameter>();
Commons.ADDParameter(ref lstParam, "@ConsultantId", DbType.Int32, entChargeMaster.ConsultantId);
Commons.ADDParameter(ref lstParam, "@Ward", DbType.Int32, entChargeMaster.WardNo);
Commons.ADDParameter(ref lstParam, "@Charge", DbType.Decimal, entChargeMaster.Charge);
Commons.ADDParameter(ref lstParam, "@EntryBy", DbType.String, entChargeMaster.UserName);
cnt = mobjDataAcces.ExecuteQuery("sp_InsertConsultantCharge", lstParam);
}
catch (Exception ex)
{
Commons.FileLog("ConsultantChargeBLL - InsertConsultantCharges(EntityConsultantChargeMaster entChargeMaster)", ex);
}
return(cnt);
}
public int InsertInitial(EntityInitials entInitial)
{
int cnt = 0;
try
{
List <SqlParameter> lstParam = new List <SqlParameter>();
Commons.ADDParameter(ref lstParam, "@InitialCode", DbType.String, entInitial.InitialCode);
Commons.ADDParameter(ref lstParam, "@InitialDesc", DbType.String, entInitial.InitialDesc);
Commons.ADDParameter(ref lstParam, "@EntryBy", DbType.String, entInitial.EntryBy);
cnt = mobjDataAcces.ExecuteQuery("sp_InsertInitial", lstParam);
}
catch (Exception ex)
{
Commons.FileLog("InitialsBLL - InsertInitial(EntityInitials entInitial)", ex);
}
return(cnt);
}
public int InsertState(EntityState entState)
{
int cnt = 0;
try
{
List <SqlParameter> lstParam = new List <SqlParameter>();
Commons.ADDParameter(ref lstParam, "@StateCode", DbType.String, entState.StateCode);
Commons.ADDParameter(ref lstParam, "@CountryId", DbType.Int32, entState.Country);
Commons.ADDParameter(ref lstParam, "@StateDesc", DbType.String, entState.StateDesc);
Commons.ADDParameter(ref lstParam, "@EntryBy", DbType.String, entState.EntryBy);
cnt = mobjDataAcces.ExecuteQuery("sp_InsertState ", lstParam);
}
catch (Exception ex)
{
Commons.FileLog("StateBLL - InsertState(EntityState entState)", ex);
}
return(cnt);
}
public int InsertBedMaster(EntityBedMaster entBedMaster)
{
int cnt = 0;
try
{
List <SqlParameter> lstParam = new List <SqlParameter>();
Commons.ADDParameter(ref lstParam, "@BedNo", DbType.String, entBedMaster.BedNo);
Commons.ADDParameter(ref lstParam, "@RoomId", DbType.Int32, entBedMaster.RoomId);
Commons.ADDParameter(ref lstParam, "@FloorNo", DbType.Int32, entBedMaster.FloorNo);
Commons.ADDParameter(ref lstParam, "@CategoryId", DbType.Int32, entBedMaster.CategoryId);
cnt = mobjDataAcces.ExecuteQuery("sp_InsertBedMaster", lstParam);
}
catch (Exception ex)
{
throw ex;
}
return(cnt);
}
public int UpdateRooms(EnitiyRoomMaster entRoom)
{
int cnt = 0;
try
{
List <SqlParameter> lstParam = new List <SqlParameter>();
//Commons.ADDParameter(ref lstParam, "@RoomId", DbType.String, entRoom.RoomId);
Commons.ADDParameter(ref lstParam, "@RoomNo", DbType.String, entRoom.RoomNo);
Commons.ADDParameter(ref lstParam, "@FloorNo", DbType.Int32, entRoom.FloorNo);
Commons.ADDParameter(ref lstParam, "@CategoryId", DbType.String, entRoom.CategoryId);
cnt = mobjDataAcces.ExecuteQuery("sp_UpdateRoom", lstParam);
}
catch (Exception ex)
{
Commons.FileLog("RoomMasterBLL - UpdateRooms(EnitiyRoomMaster entRoom)", ex);
}
return(cnt);
}
public int UpdateProduct(EntityProduct entProduct)
{
int cnt = 0;
try
{
List <SqlParameter> lstParam = new List <SqlParameter>();
Commons.ADDParameter(ref lstParam, "@ProductId", DbType.String, entProduct.ProductId);
Commons.ADDParameter(ref lstParam, "@ProductName", DbType.String, entProduct.ProductName);
Commons.ADDParameter(ref lstParam, "@UOM", DbType.String, entProduct.UOM);
Commons.ADDParameter(ref lstParam, "@SubUOM", DbType.String, entProduct.SubUOM);
Commons.ADDParameter(ref lstParam, "@Price", DbType.String, entProduct.Price);
cnt = mobjDataAcces.ExecuteQuery("sp_UpdateProduct", lstParam);
}
catch (Exception ex)
{
Commons.FileLog("ProductBLL - UpdateProductEntityProduct entProduct)", ex);
}
return(cnt);
}
public int InsertAppoinment(EntityBookAppoinment entAppoinment)
{
int cnt = 0;
try
{
List <SqlParameter> lstParam = new List <SqlParameter>();
Commons.ADDParameter(ref lstParam, "@PatientCode", DbType.String, entAppoinment.PatientCode);
Commons.ADDParameter(ref lstParam, "@FullName", DbType.String, entAppoinment.FullName);
Commons.ADDParameter(ref lstParam, "@DeptId", DbType.Int32, entAppoinment.DepartmentId);
Commons.ADDParameter(ref lstParam, "@OPD", DbType.Int32, entAppoinment.OPDRoom);
Commons.ADDParameter(ref lstParam, "@ConsutingDr", DbType.Int32, entAppoinment.ConsultingDr);
Commons.ADDParameter(ref lstParam, "@VisitType", DbType.String, entAppoinment.VisitType);
Commons.ADDParameter(ref lstParam, "@Shift", DbType.String, entAppoinment.Shift);
cnt = mobjDataAcces.ExecuteQuery("sp_InsertAppoinment ", lstParam);
}
catch (Exception ex)
{
Commons.FileLog("BookAppoinmentBLL - int InsertAppoinment(EntityBookAppoinment entAppoinment)", ex);
}
return(cnt);
}
public int InsertCategory(EntityRoomCategory entRoomCat)
{
int cnt = 0;
try
{
List <SqlParameter> lstParam = new List <SqlParameter>();
Commons.ADDParameter(ref lstParam, "@CategoryCode", DbType.String, entRoomCat.CategoryCode);
Commons.ADDParameter(ref lstParam, "@CategoryDesc", DbType.String, entRoomCat.CategoryDesc);
Commons.ADDParameter(ref lstParam, "@Rate", DbType.Decimal, entRoomCat.Rate);
Commons.ADDParameter(ref lstParam, "@EntryBy", DbType.String, entRoomCat.EntryBy);
Commons.ADDParameter(ref lstParam, "@IsICU", DbType.Boolean, entRoomCat.IsICU);
Commons.ADDParameter(ref lstParam, "@IsOT", DbType.Boolean, entRoomCat.IsOT);
cnt = mobjDataAcces.ExecuteQuery("sp_InsertCategory", lstParam);
}
catch (Exception ex)
{
Commons.FileLog("RoomCategoryBLL - InsertCategory(EntityRoomCategory entRoomCat)", ex);
}
return(cnt);
}
public int InsertReligion(EntityAnaesthetist entReligion)
{
int cnt = 0;
try
{
List <SqlParameter> lstParam = new List <SqlParameter>();
Commons.ADDParameter(ref lstParam, "@AnaesthetistCode", DbType.String, entReligion.AnaesthetistCode);
Commons.ADDParameter(ref lstParam, "@AnaesthetistName", DbType.String, entReligion.AnaesthetistName);
Commons.ADDParameter(ref lstParam, "@TypeOfAnaesthetist", DbType.String, entReligion.TypeOfAnaesthetist);
Commons.ADDParameter(ref lstParam, "@CategoryName", DbType.String, entReligion.CategoryName);
Commons.ADDParameter(ref lstParam, "@CategoryId", DbType.Int32, entReligion.CategoryId);
Commons.ADDParameter(ref lstParam, "@ConsultCharges", DbType.Decimal, entReligion.ConsultCharges);
cnt = mobjDataAcces.ExecuteQuery("sp_InsertAnaesthetist ", lstParam);
}
catch (Exception ex)
{
Commons.FileLog("AnaesthetistBLL - InsertAnaesthetist(EntityAnaesthetist entReligion)", ex);
}
return(cnt);
}
public int DeleteRequisition(EntityMaterialRequisition entRequisition)
{
int cnt = 0;
try
{
List <SqlParameter> lstParam = new List <SqlParameter>();
Commons.ADDParameter(ref lstParam, "@RequisitionCode", DbType.String, entRequisition.RequisitionCode);
cnt = mobjDataAcces.ExecuteQuery("sp_DeleteRequisitionDT", lstParam);
}
catch (Exception ex)
{
Commons.FileLog("RequisitionBLL - DeleteRequisition(EntityRequisition entRequisition)", ex);
}
return(cnt);
}