public int InsertOPDPatientTreatmentDetail(List <EntityOPDPatient> lstentOPDMaster, EntityOPDPatient entOPDMaster) { int cnt = 0; List <string> lstspNames = new List <string>(); List <List <SqlParameter> > lstParamVals = new List <List <SqlParameter> >(); List <SqlParameter> lstParam; try { foreach (EntityOPDPatient entOPD in lstentOPDMaster) { lstspNames.Add("sp_InsertOPDPatient"); lstParamVals.Add(CreateParameterOPDPatient(entOPD)); } lstspNames.Add("sp_InsertOPDPatientDiagnosis"); lstParam = new List <SqlParameter>(); Commons.ADDParameter(ref lstParam, "@PatientCode", DbType.String, entOPDMaster.PatientCode); Commons.ADDParameter(ref lstParam, "@PatientName", DbType.String, entOPDMaster.PatientName); Commons.ADDParameter(ref lstParam, "@Injections", DbType.Int32, entOPDMaster.TotalInjections); Commons.ADDParameter(ref lstParam, "@InjectionCharge", DbType.Decimal, entOPDMaster.InjectionCharge); Commons.ADDParameter(ref lstParam, "@DressingCharge", DbType.Decimal, entOPDMaster.DressingCharge); Commons.ADDParameter(ref lstParam, "@RevisitCharge", DbType.Decimal, entOPDMaster.RevisitCharge); Commons.ADDParameter(ref lstParam, "@ConsultantCharge", DbType.Decimal, entOPDMaster.ConsultantCharge); Commons.ADDParameter(ref lstParam, "@TotalOPDBill", DbType.Decimal, entOPDMaster.TotalOPDBill); Commons.ADDParameter(ref lstParam, "@PatientVisitType", DbType.String, entOPDMaster.PatientVisitType); Commons.ADDParameter(ref lstParam, "@ConsultedBy", DbType.Int32, entOPDMaster.ConsultedBy); Commons.ADDParameter(ref lstParam, "@EntryBy", DbType.String, entOPDMaster.EntryBy); Commons.ADDParameter(ref lstParam, "@DiagnosisNo", DbType.String, entOPDMaster.DiagnosisCode); Commons.ADDParameter(ref lstParam, "@Symptoms", DbType.String, entOPDMaster.Symptoms); Commons.ADDParameter(ref lstParam, "@Diagnosis", DbType.String, entOPDMaster.Diagnosis); Commons.ADDParameter(ref lstParam, "@XRays", DbType.String, entOPDMaster.XRay); Commons.ADDParameter(ref lstParam, "@BloodTests", DbType.String, entOPDMaster.BloodTest); lstParamVals.Add(lstParam); lstspNames.Add("sp_CloseOPDPatient"); lstParam = new List <SqlParameter>(); Commons.ADDParameter(ref lstParam, "@PatientCode", DbType.String, entOPDMaster.PatientCode); Commons.ADDParameter(ref lstParam, "@AppointNo", DbType.Int32, entOPDMaster.AppointNO); lstParamVals.Add(lstParam); cnt = mobjDataAcces.ExecuteTransaction(lstspNames, lstParamVals); } catch (Exception ex) { throw ex; } return(cnt); }
public int InsertMaterialInward(List <EntityMatrialInword> lstentInward, EntityMatrialInword entMaterialInward) { int cnt = 0; List <string> lstspName = new List <string>(); List <List <SqlParameter> > lstParamVals = new List <List <SqlParameter> >(); List <SqlParameter> lstParam; try { foreach (EntityMatrialInword entInward in lstentInward) { lstspName.Add("sp_InsertInwardDT"); lstParamVals.Add(CreateParameterMaterialInward(entInward)); lstParam = new List <SqlParameter>(); lstspName.Add("sp_UpdateItemByInwardDetails"); Commons.ADDParameter(ref lstParam, "@ItemCode", DbType.String, entInward.ItemCode); Commons.ADDParameter(ref lstParam, "@Quantity", DbType.Decimal, entInward.Quantity); lstParamVals.Add(lstParam); } if (!Commons.IsRecordExists("tblMaterialInwardMT", "InwardNo", entMaterialInward.InwardNo)) { lstspName.Add("sp_InsertInwardMT"); lstParam = new List <SqlParameter>(); Commons.ADDParameter(ref lstParam, "@InwardNo", DbType.String, entMaterialInward.InwardNo); Commons.ADDParameter(ref lstParam, "@InwardDate", DbType.DateTime, entMaterialInward.InwardDate); Commons.ADDParameter(ref lstParam, "@SupplierCode", DbType.String, entMaterialInward.SupplierCode); Commons.ADDParameter(ref lstParam, "@SupplierName", DbType.String, entMaterialInward.SupplierName); Commons.ADDParameter(ref lstParam, "@TotalInwardAmount", DbType.Decimal, entMaterialInward.TotalInwardAmount); Commons.ADDParameter(ref lstParam, "@EntryBy", DbType.String, entMaterialInward.EntryBy); lstParamVals.Add(lstParam); } lstParam = new List <SqlParameter>(); lstspName.Add("sp_UpdateSupplierMasterOnInward"); Commons.ADDParameter(ref lstParam, "@SupplierCode", DbType.String, entMaterialInward.SupplierCode); Commons.ADDParameter(ref lstParam, "@InwardAmnt", DbType.Decimal, entMaterialInward.TotalInwardAmount); lstParamVals.Add(lstParam); cnt = mobjDataAcces.ExecuteTransaction(lstspName, lstParamVals); } catch (Exception ex) { Commons.FileLog("MterialInwardBLL - insertMaterialInward(EntityMatrialInward entMaterialInward)", ex); } return(cnt); }
public int UpdateRequisition(List <EntityMaterialRequisition> pstentMaterialReq, EntityMaterialRequisition entRequisition) { int cnt = 0; List <string> lstspName = new List <string>(); List <List <SqlParameter> > lstParamVals = new List <List <SqlParameter> >(); List <SqlParameter> lstParam; try { foreach (EntityMaterialRequisition entMaterialReq in pstentMaterialReq) { lstspName.Add("sp_UpdateRerquisitonDT"); lstParamVals.Add(createParameterList(entMaterialReq)); lstParam = new List <SqlParameter>(); lstspName.Add("sp_UpdateItemByReqDetails"); Commons.ADDParameter(ref lstParam, "@ItemCode", DbType.String, entRequisition.ItemCode); Commons.ADDParameter(ref lstParam, "@Quantity", DbType.Decimal, entRequisition.Qty); lstParamVals.Add(lstParam); } lstspName.Add("sp_UpdateRerquisitonMT"); lstParam = new List <SqlParameter>(); Commons.ADDParameter(ref lstParam, "@RequisitionCode", DbType.String, entRequisition.RequisitionCode); Commons.ADDParameter(ref lstParam, "@RequisitionStatus", DbType.String, entRequisition.RequisitionStatus); lstParamVals.Add(lstParam); cnt = mobjDataAcces.ExecuteTransaction(lstspName, lstParamVals); } catch (Exception ex) { Commons.FileLog("RequisitionDetailsBLL - InsertRequisition(EntityRequisition entRequisition)", ex); } return(cnt); }
public int GetRegister(EntityRegistration ent) { int lintcnt = 0; List <string> lstspNames = new List <string>(); List <List <SqlParameter> > lstParamVals = new List <List <SqlParameter> >(); List <SqlParameter> lstParam; try { lstParam = new List <SqlParameter>(); Commons.ADDParameter(ref lstParam, "@UserName", DbType.String, ent.UserName); Commons.ADDParameter(ref lstParam, "@ConfirmPass", DbType.String, ent.ConfirmPassword); Commons.ADDParameter(ref lstParam, "@UserType", DbType.String, ent.UserType); lstspNames.Add("sp_InsertPassInLoginTable"); lstParamVals.Add(lstParam); lstParam = new List <SqlParameter>(); Commons.ADDParameter(ref lstParam, "@UserCode", DbType.String, ent.UserName); Commons.ADDParameter(ref lstParam, "@ConfirmPass", DbType.String, ent.ConfirmPassword); Commons.ADDParameter(ref lstParam, "@UserType", DbType.String, ent.UserType); lstspNames.Add("sp_UpdatePassInEmpMaster"); lstParamVals.Add(lstParam); lintcnt = mobjDataAccess.ExecuteTransaction(lstspNames, lstParamVals); } catch (Exception ex) { Commons.FileLog("RegistrationBLL - GetRegister(EntityRegistration ent)", ex); } return(lintcnt); }
public int DeleteEmployee(List <EntityEmployee> lstEntEmployee) { int cnt = 0; List <string> lstspNames = new List <string>(); List <List <SqlParameter> > lstParamVals = new List <List <SqlParameter> >(); try { foreach (EntityEmployee entEmployee in lstEntEmployee) { lstspNames.Add("sp_DeleteEmployee"); lstParamVals.Add(CreateParameterDeleteEmp(entEmployee)); lstspNames.Add("sp_DeleteEmployeeLogin"); List <SqlParameter> lstParam = new List <SqlParameter>(); Commons.ADDParameter(ref lstParam, "@EmpCode", DbType.String, entEmployee.EmpCode); Commons.ADDParameter(ref lstParam, "@Discontinued", DbType.Boolean, entEmployee.DisContinued); lstParamVals.Add(lstParam); } cnt = mobjDataAcces.ExecuteTransaction(lstspNames, lstParamVals); } catch (Exception ex) { Commons.FileLog("EmployeeBLL - DeleteEmployee(List<EntityEmployee> lstEntEmployee) ", ex); } return(cnt); }
public int InsertRequisition(List <EntityMaterialRequisition> lstentRequisition, EntityMaterialRequisition entRequisition) { int cnt = 0; List <string> lstspNames = new List <string>(); List <List <SqlParameter> > lstParamVals = new List <List <SqlParameter> >(); try { foreach (EntityMaterialRequisition entMaterialReq in lstentRequisition) { lstspNames.Add("sp_InsertRequisitionDT"); lstParamVals.Add(CreateParameterMaterialReceipt(entMaterialReq)); } if (!Commons.IsRecordExists("tblMaterialRequisitionMT", "RequisitionCode", entRequisition.RequisitionCode)) { lstspNames.Add("sp_InsertRequisitionMT"); List <SqlParameter> lstParam = new List <SqlParameter>(); Commons.ADDParameter(ref lstParam, "@RequisitionCode", DbType.String, entRequisition.RequisitionCode); Commons.ADDParameter(ref lstParam, "@RequisitionBy", DbType.String, entRequisition.RequisitionBy); Commons.ADDParameter(ref lstParam, "@RequisitionStatus", DbType.String, entRequisition.RequisitionStatus); Commons.ADDParameter(ref lstParam, "@GroupId", DbType.Int32, entRequisition.Group); Commons.ADDParameter(ref lstParam, "@EntryBy", DbType.String, entRequisition.EntryBy); lstParamVals.Add(lstParam); } cnt = mobjDataAcces.ExecuteTransaction(lstspNames, lstParamVals); } catch (Exception ex) { Commons.FileLog("CustomerReceiptBLL - InsertRequisitionDT(List<EntityMaterialRequisition> lstentRequisition, EntityMaterialRequisition entRequisition)", ex); } return(cnt); }
public int DeleteConsultant(List <EntityConsultant> lstEntConsultant) { int cnt = 0; List <string> lstspNames = new List <string>(); List <List <SqlParameter> > lstParamVals = new List <List <SqlParameter> >(); try { foreach (EntityConsultant entConsultant in lstEntConsultant) { lstspNames.Add("sp_DeleteConsultant"); lstParamVals.Add(CreateParameterDeleteCons(entConsultant)); lstspNames.Add("sp_DeleteConsultantLogin"); List <SqlParameter> lstParam = new List <SqlParameter>(); Commons.ADDParameter(ref lstParam, "@ConsCode", DbType.String, entConsultant.ConsultantCode); Commons.ADDParameter(ref lstParam, "@Discontinued", DbType.Boolean, entConsultant.DisContinued); lstParamVals.Add(lstParam); } cnt = mobjDataAcces.ExecuteTransaction(lstspNames, lstParamVals); } catch (Exception ex) { Commons.FileLog("ConsultantBLL - DeleteConsultant(List<EntityConsultant> lstEntConsultant) ", ex); } return(cnt); }
public int DeletePatient(List <EntityPatientMaster> lstentPatientMaster) { int cnt = 0; List <string> lstspNames = new List <string>(); List <List <SqlParameter> > lstParamVals = new List <List <SqlParameter> >(); try { foreach (EntityPatientMaster entPatient in lstentPatientMaster) { lstspNames.Add("sp_DeletePatientMaster"); lstParamVals.Add(CreateParameterDeletePatient(entPatient)); } cnt = mobjDataAcces.ExecuteTransaction(lstspNames, lstParamVals); } catch (Exception ex) { throw ex; } return(cnt); }
public int DeleteItem(List <EntityItem> lstentItem) { int cnt = 0; List <string> lstspNames = new List <string>(); List <List <SqlParameter> > lstParamVals = new List <List <SqlParameter> >(); try { foreach (EntityItem entItem in lstentItem) { lstspNames.Add("sp_DeleteItem"); lstParamVals.Add(CreateParameterDeleteItem(entItem)); } cnt = mobjDataAcces.ExecuteTransaction(lstspNames, lstParamVals); } catch (Exception ex) { Commons.FileLog("ItemBLL - DeleteItem(List<EntityItem> lstEntItem) ", ex); } return(cnt); }