public bool Save(ServicesPackage objModel, ServicesPackage_ServicesCharges objServicepkg, ServicePackage_OPDCharges objserPkgOPD) { Services ServicesMod = new Services(); ServicesCharges servicesCharges = new ServicesCharges(); // ServicesPackage_ServicesCharges servicepkg_servicecharge = new ServicesPackage_ServicesCharges(); // ServicesCharges servicesCharges = new ServicesCharges(); bool flag = true; Connect(); con.Open(); SqlCommand cmd; if (objModel.serviceID1 > 0) { ServicesMod.Mode = "Edit"; } else { ServicesMod.Mode = "Add"; } try { #region ----------------------Add Services-------------------------------- cmd = new SqlCommand("IUServices", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@HospitalID", HospitalID); cmd.Parameters.AddWithValue("@LocationID", LocationID); if (ServicesMod.Mode == "Add") { cmd.Parameters.AddWithValue("@ServiceID", 0); cmd.Parameters["@ServiceID"].Direction = ParameterDirection.Output; } else { cmd.Parameters.AddWithValue("@ServiceID", objModel.serviceID1); } if (objModel.ServiceGroupID == null) { cmd.Parameters.AddWithValue("@ServiceGroupID", 0); } else { cmd.Parameters.AddWithValue("@ServiceGroupID", objModel.ServiceGroupID); } cmd.Parameters.AddWithValue("@ReferenceCode", 1); cmd.Parameters.AddWithValue("@ServiceName", objModel.ServiceName); if (objModel.UnitID == null) { cmd.Parameters.AddWithValue("@UnitID", 0); } else { cmd.Parameters.AddWithValue("@UnitID", objModel.UnitID); } cmd.Parameters.AddWithValue("@GeneralCharges", objModel.GeneralCharges); cmd.Parameters.AddWithValue("@EmergencyCharges", objModel.EmergencyCharges); cmd.Parameters.AddWithValue("@ServiceType", objModel.ServiceType); if (ServicesMod.TPAHSNCode == "") { cmd.Parameters.AddWithValue("@TPAHSNCode", ""); } else { cmd.Parameters.AddWithValue("@TPAHSNCode", ServicesMod.TPAHSNCode); } if (ServicesMod.HospitalHSNCode != "") { cmd.Parameters.AddWithValue("@HospitalHSNCode", ""); } else { cmd.Parameters.AddWithValue("@HospitalHSNCode", ServicesMod.HospitalHSNCode); } if (ServicesMod.HSNCode == "") { cmd.Parameters.AddWithValue("@HSNCode", ""); } else { cmd.Parameters.AddWithValue("@HSNCode", ServicesMod.HSNCode); } cmd.Parameters.AddWithValue("@RecommendedByDoctor", ServicesMod.RecommendedByDoctor); cmd.Parameters.AddWithValue("@HideInBilling", ServicesMod.RecommendedByDoctor); cmd.Parameters.AddWithValue("@CreationID", UserID); cmd.Parameters.AddWithValue("@Mode", ServicesMod.Mode); int RowNo = cmd.ExecuteNonQuery(); #endregion if ("Both Package" == objModel.ServiceType || "IPD Package" == objModel.ServiceType) { #region IPD Package #region -------------------Add ServiceCharges------------------- if ("Both Package" == objModel.ServiceType || "IPD Package" == objModel.ServiceType) { if (RowNo > 0) { ServicesMod.Mode = "Add"; int ServiceChargesID = 0; objModel.ServiceID = Convert.ToInt32(cmd.Parameters["@ServiceID"].Value.ToString()); ServiceID = objModel.ServiceID; // DataSet dsServiceCharge = new DataSet(); // dsServiceCharge = SelectServiceChargesbyID(ServiceID); for (int i = 0; i < objServicepkg.WardID.Length; i++) { cmd = new SqlCommand("IUServiceCharges", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@HospitalID", HospitalID); cmd.Parameters.AddWithValue("@LocationID", LocationID); if (ServicesMod.Mode == "Add") { cmd.Parameters.AddWithValue("@ServiceChargesID", 0); cmd.Parameters["@ServiceChargesID"].Direction = ParameterDirection.Output; } else { cmd.Parameters.AddWithValue("@ServiceChargesID", 0); } cmd.Parameters.AddWithValue("@ServiceID", ServiceID); cmd.Parameters.AddWithValue("@WardID", Convert.ToInt32(objServicepkg.WardID[i].ToString())); if (objModel.GeneralCharges == null) { cmd.Parameters.AddWithValue("@GeneralCharges", 0.00); } else { cmd.Parameters.AddWithValue("@GeneralCharges", Convert.ToDecimal(objServicepkg.GeneralCharges1[i].ToString())); } if (objModel.EmergencyCharges == null) { cmd.Parameters.AddWithValue("@EmergencyCharges", 0.00); } else { cmd.Parameters.AddWithValue("@EmergencyCharges", Convert.ToDecimal(objServicepkg.EmergencyCharges1[i].ToString())); } cmd.Parameters.AddWithValue("@CreationID", UserID); cmd.Parameters.AddWithValue("@Mode", ServicesMod.Mode); ServiceChargesID = cmd.ExecuteNonQuery(); } #endregion -------------------------------------- #region ServiceDetailsPackage objModel.ServiceID = Convert.ToInt32(cmd.Parameters["@ServiceID"].Value.ToString()); ServiceID = objModel.ServiceID; for (int i = 0; i < objServicepkg.ServiceOrTestID.Length; i++) { int servicedetailpkgID = 0; cmd = new SqlCommand("IUServiceDetailsPackage", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@HospitalID", HospitalID); cmd.Parameters.AddWithValue("@LocationID", LocationID); if (ServicesMod.Mode == "Add") { cmd.Parameters.AddWithValue("@ServiceDetailsPackagelID", 0); cmd.Parameters["@ServiceDetailsPackagelID"].Direction = ParameterDirection.Output; } else { // cmd.Parameters.AddWithValue("@ServiceChargesID", dsServiceCharge.Tables[0].Rows[i]["ServiceChargesID"].ToString()); } cmd.Parameters.AddWithValue("@ServiceID", ServiceID); cmd.Parameters.AddWithValue("@ServiceOrTestID", objServicepkg.ServiceOrTestID[i].ToString()); int servicetestid = Convert.ToInt32(objServicepkg.ServiceOrTestID[i].ToString()); cmd.Parameters.AddWithValue("@ServiceOrTestName", objServicepkg.ServiceNTestName[i].ToString()); cmd.Parameters.AddWithValue("@ServiceType", "Service"); cmd.Parameters.AddWithValue("@Quantity", objServicepkg.Quantity[i].ToString()); int quantity = Convert.ToInt32(objServicepkg.Quantity[i].ToString()); cmd.Parameters.AddWithValue("@Rechange", objModel.chkrechange); cmd.Parameters.AddWithValue("@CreationID", UserID); cmd.Parameters.AddWithValue("@Mode", ServicesMod.Mode); servicedetailpkgID = cmd.ExecuteNonQuery(); } #endregion #region IUServicePackageForWardCharges DataSet dsword = new DataSet(); dsword = GetWardName(ServiceID); for (int j = 0; j < dsword.Tables[0].Rows.Count; j++) { int ServicePackageForWardCharges = 0; cmd = new SqlCommand("IUServicePackageForWardCharges", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@HospitalID", HospitalID); cmd.Parameters.AddWithValue("@LocationID", LocationID); if (ServicesMod.Mode == "Add") { cmd.Parameters.AddWithValue("@SPWchargeID", 0); cmd.Parameters["@SPWchargeID"].Direction = ParameterDirection.Output; } else { // cmd.Parameters.AddWithValue("@ServiceChargesID", dsServiceCharge.Tables[0].Rows[i]["ServiceChargesID"].ToString()); } cmd.Parameters.AddWithValue("@ServicePackageID", dsword.Tables[0].Rows[j]["ServiceDetailsPackagelID"].ToString()); cmd.Parameters.AddWithValue("@ServiceOrTestID", dsword.Tables[0].Rows[j]["ServiceOrTestID"].ToString()); cmd.Parameters.AddWithValue("@ServiceType", "Service"); cmd.Parameters.AddWithValue("@WardID", dsword.Tables[0].Rows[j]["WardID"].ToString()); cmd.Parameters.AddWithValue("@WardName", dsword.Tables[0].Rows[j]["WardName"].ToString()); // cmd.Parameters.AddWithValue("@Quantity", quantity); if (objModel.GeneralCharges == null) { cmd.Parameters.AddWithValue("@GeneralCharges", 0.00); } else { cmd.Parameters.AddWithValue("@GeneralCharges", Convert.ToDecimal(objServicepkg.GenralCharges[j].ToString())); } cmd.Parameters.AddWithValue("@CreationID", UserID); cmd.Parameters.AddWithValue("@Mode", ServicesMod.Mode); ServicePackageForWardCharges = cmd.ExecuteNonQuery(); } #endregion #region Add ServiceTPAWise String Mode = ""; Mode = cmd.Parameters["@Mode"].Value.ToString(); if (Mode == "Add") { DataSet dsTPAWise = new DataSet(); dsTPAWise = GetServicesTPAWiseForOrganizationID(); for (int i = 0; i < dsTPAWise.Tables[0].Rows.Count; i++) { cmd = new SqlCommand("IUServicesTPAWise", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@HospitalID", HospitalID); cmd.Parameters.AddWithValue("@LocationID", LocationID); cmd.Parameters.AddWithValue("@ServicesTPAWiseID", 0); cmd.Parameters["@ServicesTPAWiseID"].Direction = ParameterDirection.Output; cmd.Parameters.AddWithValue("@ServiceID", ServiceID); cmd.Parameters.AddWithValue("@ReferenceCode", 1); if (objModel.UnitID == null) { cmd.Parameters.AddWithValue("@UnitID", 0); } else { cmd.Parameters.AddWithValue("@UnitID", objModel.UnitID); } cmd.Parameters.AddWithValue("@OrganizationID", Convert.ToInt32(dsTPAWise.Tables[0].Rows[i]["OrganizationID"].ToString())); cmd.Parameters.AddWithValue("@GeneralCharges", objModel.GeneralCharges); cmd.Parameters.AddWithValue("@EmergencyCharges", objModel.EmergencyCharges); cmd.Parameters.AddWithValue("@ServiceType", objModel.ServiceType); cmd.Parameters.AddWithValue("@RecommendedByDoctor", ServicesMod.RecommendedByDoctor); cmd.Parameters.AddWithValue("@CreationID", UserID); cmd.Parameters.AddWithValue("@Mode", "Add"); int ServicesTPAWiseID = cmd.ExecuteNonQuery(); //if (ServicesTPAWiseID > 0) //{ // flag = true; //} //else //{ // flag = false; //} } #endregion #region Add ServicesTPAWiseDetailForOrganization objModel.ServiceID = Convert.ToInt32(cmd.Parameters["@ServiceID"].Value.ToString()); ServiceID = Convert.ToInt32(cmd.Parameters["@ServiceID"].Value.ToString()); DataSet dsWardDetailsTPAWise = new DataSet(); dsWardDetailsTPAWise = GetServicesTPAWiseDetailForOrganizationID(); for (int i = 0; i < dsWardDetailsTPAWise.Tables[0].Rows.Count; i++) { cmd = new SqlCommand("IUServicesDetailsTPAWise", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@HospitalID", HospitalID); cmd.Parameters.AddWithValue("@LocationID", LocationID); cmd.Parameters.AddWithValue("@ServicesDetailsTPAWiseID", 0); cmd.Parameters["@ServicesDetailsTPAWiseID"].Direction = ParameterDirection.Output; cmd.Parameters.AddWithValue("@ServicesTPAWiseID", Convert.ToInt32(dsWardDetailsTPAWise.Tables[0].Rows[i]["ServicesTPAWiseID"].ToString())); if (servicesCharges.WardID == null) { cmd.Parameters.AddWithValue("@WardID", 0); } else { cmd.Parameters.AddWithValue("@WardID", Convert.ToInt32(dsWardDetailsTPAWise.Tables[0].Rows[i]["WardID"].ToString())); } // cmd.Parameters.AddWithValue("@WardName", Convert.ToString(ServicesMod.dsServicesCharges.Tables[0].Rows[0]["WardName"].ToString())); cmd.Parameters.AddWithValue("@GeneralCharges", Convert.ToDecimal(dsWardDetailsTPAWise.Tables[0].Rows[i]["GeneralCharges"].ToString())); cmd.Parameters.AddWithValue("@EmergencyCharges", Convert.ToDecimal(dsWardDetailsTPAWise.Tables[0].Rows[i]["GeneralCharges"].ToString())); cmd.Parameters.AddWithValue("@CreationID", UserID); cmd.Parameters.AddWithValue("@Mode", "Add"); int Row2 = cmd.ExecuteNonQuery(); if (Row2 > 0) { flag = true; } else { flag = false; } } } } } #endregion #endregion } else if ("OPD Package" == objModel.ServiceType) { #region ServiceDetailsPackage for opd ServicesMod.Mode = "Add"; objModel.ServiceID = Convert.ToInt32(cmd.Parameters["@ServiceID"].Value.ToString()); ServiceID = objModel.ServiceID; for (int i = 0; i < objserPkgOPD.ServiceOrTestIDOPD.Length; i++) { int servicedetailpkgOPDID = 0; cmd = new SqlCommand("IUServiceDetailsPackageOPD", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@HospitalID", HospitalID); cmd.Parameters.AddWithValue("@LocationID", LocationID); if (ServicesMod.Mode == "Add") { cmd.Parameters.AddWithValue("@ServiceDetailsPackageOPDID", 0); cmd.Parameters["@ServiceDetailsPackageOPDID"].Direction = ParameterDirection.Output; } else { //cmd.Parameters.AddWithValue("@ServiceDetailsPackageOPDID", objserPkgOPD.ServiceOrTestIDOPD[i].ToString()); } cmd.Parameters.AddWithValue("@ServiceID", ServiceID); cmd.Parameters.AddWithValue("@ServiceOrTestID", objserPkgOPD.ServiceOrTestIDOPD[i].ToString()); // int servicetestid = Convert.ToInt32(objServicepkg.ServiceOrTestID[i].ToString()); cmd.Parameters.AddWithValue("@ServiceOrTestName", objserPkgOPD.ServiceNTestNameOPD[i].ToString()); cmd.Parameters.AddWithValue("@ServiceType", "Service"); cmd.Parameters.AddWithValue("@Quantity", objserPkgOPD.QuantityOPD[i].ToString()); cmd.Parameters.AddWithValue("@GeneralCharges", objserPkgOPD.OPDGenralCharges[i].ToString()); cmd.Parameters.AddWithValue("@EmergencyCharges", objserPkgOPD.OPDEmergencyCharges[i].ToString()); cmd.Parameters.AddWithValue("@Rechange", objModel.chkrechange); cmd.Parameters.AddWithValue("@CreationID", UserID); cmd.Parameters.AddWithValue("@Mode", ServicesMod.Mode); servicedetailpkgOPDID = cmd.ExecuteNonQuery(); } #endregion } if (flag == true) { return(true); } else { return(false); } } #pragma warning disable CS0168 // The variable 'ex' is declared but never used catch (Exception ex) #pragma warning restore CS0168 // The variable 'ex' is declared but never used { flag = false; } con.Close(); return(flag); }
public bool Save(Services ServicesMod, ServicesCharges servicesCharges) { // ServicesCharges servicesCharges = new ServicesCharges(); bool flag = true; Connect(); con.Open(); SqlCommand cmd; if (ServicesMod.ServiceID > 0) { ServicesMod.Mode = "Edit"; } #region ----------------------Add Services-------------------------------- cmd = new SqlCommand("IUServices", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@HospitalID", HospitalID); cmd.Parameters.AddWithValue("@LocationID", LocationID); if (ServicesMod.Mode == "Add") { cmd.Parameters.AddWithValue("@ServiceID", 0); cmd.Parameters["@ServiceID"].Direction = ParameterDirection.Output; } else { cmd.Parameters.AddWithValue("@ServiceID", ServicesMod.ServiceID); } if (ServicesMod.ServiceGroupID == null) { cmd.Parameters.AddWithValue("@ServiceGroupID", 0); } else { cmd.Parameters.AddWithValue("@ServiceGroupID", ServicesMod.ServiceGroupID); } cmd.Parameters.AddWithValue("@ReferenceCode", 1); cmd.Parameters.AddWithValue("@ServiceName", ServicesMod.ServiceName); cmd.Parameters.AddWithValue("@BillCharges", ServicesMod.BillCharges); cmd.Parameters.AddWithValue("@BillAutoOne", ServicesMod.BillChargesOne); cmd.Parameters.AddWithValue("@CheckedOneDay", ServicesMod.CheckedOneDay); cmd.Parameters.AddWithValue("@CheckedOutTime", ServicesMod.CheckedOutTime); cmd.Parameters.AddWithValue("@CheckOneDayTime", ServicesMod.CheckOneDayTime); cmd.Parameters.AddWithValue("@CheckOutTime", ServicesMod.CheckOutTime); if (ServicesMod.UnitID == null) { cmd.Parameters.AddWithValue("@UnitID", 0); } else { cmd.Parameters.AddWithValue("@UnitID", ServicesMod.UnitID); } cmd.Parameters.AddWithValue("@GeneralCharges", ServicesMod.GeneralCharges); cmd.Parameters.AddWithValue("@EmergencyCharges", ServicesMod.EmergencyCharges); cmd.Parameters.AddWithValue("@ServiceType", ServicesMod.ServiceType); if (ServicesMod.TPAHSNCode == "") { cmd.Parameters.AddWithValue("@TPAHSNCode", ""); } else { cmd.Parameters.AddWithValue("@TPAHSNCode", ServicesMod.TPAHSNCode); } if (ServicesMod.HospitalHSNCode == null) { cmd.Parameters.AddWithValue("@HospitalHSNCode", ""); } else { cmd.Parameters.AddWithValue("@HospitalHSNCode", ServicesMod.HospitalHSNCode); } if (ServicesMod.HSNCode == "") { cmd.Parameters.AddWithValue("@HSNCode", ""); } else { cmd.Parameters.AddWithValue("@HSNCode", ServicesMod.HSNCode); } cmd.Parameters.AddWithValue("@RecommendedByDoctor", ""); if (ServicesMod.HideInBilling == null || ServicesMod.HideInBilling == "No") { cmd.Parameters.AddWithValue("@HideInBilling", "No"); } else { cmd.Parameters.AddWithValue("@HideInBilling", ServicesMod.HideInBilling); } cmd.Parameters.AddWithValue("@CreationID", UserID); cmd.Parameters.AddWithValue("@Mode", ServicesMod.Mode); int RowNo = cmd.ExecuteNonQuery(); #endregion #region -------------------Add ServiceCharges------------------- if ("Both" == ServicesMod.ServiceType || "IPD" == ServicesMod.ServiceType) { if (RowNo > 0) { int ServiceChargesID = 0; ServicesMod.ServiceID = Convert.ToInt32(cmd.Parameters["@ServiceID"].Value.ToString()); ServiceID = ServicesMod.ServiceID; DataSet dsServiceCharge = new DataSet(); dsServiceCharge = SelectServiceChargesbyID(ServiceID); con.Open(); for (int i = 0; i < servicesCharges.WardID.Length; i++) { cmd = new SqlCommand("IUServiceCharges", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@HospitalID", HospitalID); cmd.Parameters.AddWithValue("@LocationID", LocationID); // if (ServicesMod.Mode == "Add") // { cmd.Parameters.AddWithValue("@ServiceChargesID", 0); cmd.Parameters["@ServiceChargesID"].Direction = ParameterDirection.Output; // } //else //{ // cmd.Parameters.AddWithValue("@ServiceChargesID", dsServiceCharge.Tables[0].Rows[i]["ServiceChargesID"].ToString()); //} cmd.Parameters.AddWithValue("@ServiceID", ServicesMod.ServiceID); cmd.Parameters.AddWithValue("@WardID", Convert.ToInt32(servicesCharges.WardID[i].ToString())); if (ServicesMod.GeneralCharges == null) { cmd.Parameters.AddWithValue("@GeneralCharges", 0.00); } else { cmd.Parameters.AddWithValue("@GeneralCharges", Convert.ToDecimal(servicesCharges.GeneralCharges1[i].ToString())); } if (ServicesMod.EmergencyCharges == null) { cmd.Parameters.AddWithValue("@EmergencyCharges", 0.00); } else { cmd.Parameters.AddWithValue("@EmergencyCharges", Convert.ToDecimal(servicesCharges.EmergencyCharges1[i].ToString())); } cmd.Parameters.AddWithValue("@CreationID", UserID); cmd.Parameters.AddWithValue("@Mode", "Add"); ServiceChargesID = cmd.ExecuteNonQuery(); } #endregion -------------------------------------- #region Add ServiceTPAWise if (ServicesMod.HideInBilling == "Yes") { String Mode = ""; Mode = cmd.Parameters["@Mode"].Value.ToString(); if (Mode == "Add") { DataSet dsTPAWise = new DataSet(); dsTPAWise = GetServicesTPAWiseForOrganizationID(); for (int i = 0; i < dsTPAWise.Tables[0].Rows.Count; i++) { cmd = new SqlCommand("IUServicesTPAWise", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@HospitalID", HospitalID); cmd.Parameters.AddWithValue("@LocationID", LocationID); cmd.Parameters.AddWithValue("@ServicesTPAWiseID", 0); cmd.Parameters["@ServicesTPAWiseID"].Direction = ParameterDirection.Output; // cmd.Parameters.AddWithValue("@HideInBilling", ServicesMod.RecommendedByDoctor); cmd.Parameters.AddWithValue("@ServiceID", ServicesMod.ServiceID); cmd.Parameters.AddWithValue("@ReferenceCode", 1); cmd.Parameters.AddWithValue("@HideInBilling", ServicesMod.HideInBilling); if (ServicesMod.UnitID == null) { cmd.Parameters.AddWithValue("@UnitID", 0); } else { cmd.Parameters.AddWithValue("@UnitID", ServicesMod.UnitID); } cmd.Parameters.AddWithValue("@OrganizationID", dsTPAWise.Tables[0].Rows[i]["OrganizationID"].ToString()); cmd.Parameters.AddWithValue("@GeneralCharges", ServicesMod.GeneralCharges); cmd.Parameters.AddWithValue("@EmergencyCharges", ServicesMod.EmergencyCharges); cmd.Parameters.AddWithValue("@ServiceType", ServicesMod.ServiceType); cmd.Parameters.AddWithValue("@RecommendedByDoctor", ""); cmd.Parameters.AddWithValue("@CreationID", UserID); cmd.Parameters.AddWithValue("@Mode", "Add"); int ServicesTPAWiseID = cmd.ExecuteNonQuery(); //if (ServicesTPAWiseID > 0) //{ // flag = true; //} //else //{ // flag = false; //} } #endregion #region Add ServicesTPAWiseDetailForOrganization ServicesMod.ServiceID = Convert.ToInt32(cmd.Parameters["@ServiceID"].Value.ToString()); ServiceID = Convert.ToInt32(cmd.Parameters["@ServiceID"].Value.ToString()); DataSet dsWardDetailsTPAWise = new DataSet(); dsWardDetailsTPAWise = GetServicesTPAWiseDetailForOrganizationID(); for (int i = 0; i < dsWardDetailsTPAWise.Tables[0].Rows.Count; i++) { cmd = new SqlCommand("IUServicesDetailsTPAWise", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@HospitalID", HospitalID); cmd.Parameters.AddWithValue("@LocationID", LocationID); cmd.Parameters.AddWithValue("@ServicesDetailsTPAWiseID", 0); cmd.Parameters["@ServicesDetailsTPAWiseID"].Direction = ParameterDirection.Output; cmd.Parameters.AddWithValue("@ServicesTPAWiseID", Convert.ToInt32(dsWardDetailsTPAWise.Tables[0].Rows[i]["ServicesTPAWiseID"].ToString())); if (servicesCharges.WardID == null) { cmd.Parameters.AddWithValue("@WardID", 0); } else { cmd.Parameters.AddWithValue("@WardID", Convert.ToInt32(dsWardDetailsTPAWise.Tables[0].Rows[i]["WardID"].ToString())); } cmd.Parameters.AddWithValue("@WardName", Convert.ToString(dsWardDetailsTPAWise.Tables[0].Rows[i]["WardName"].ToString())); cmd.Parameters.AddWithValue("@GeneralCharges", Convert.ToDecimal(dsWardDetailsTPAWise.Tables[0].Rows[i]["GeneralCharges"].ToString())); cmd.Parameters.AddWithValue("@EmergencyCharges", Convert.ToDecimal(dsWardDetailsTPAWise.Tables[0].Rows[i]["GeneralCharges"].ToString())); cmd.Parameters.AddWithValue("@CreationID", UserID); cmd.Parameters.AddWithValue("@Mode", "Add"); int Row2 = cmd.ExecuteNonQuery(); if (Row2 > 0) { flag = true; } else { flag = false; } } } } } } #endregion if (flag == true) { return(true); } else { return(false); } con.Close(); return(flag); }
public ActionResult Services(Services AddServiceMod, ServicesCharges obj1) { try { FormCollection formCollection = new FormCollection(); KeystoneProject.Buisness_Logic.Master.Bl_Services Bl_obj = new Buisness_Logic.Master.Bl_Services(); if (Request.Form["BillCharges"] == null) { AddServiceMod.BillChargesOne = false; AddServiceMod.BillCharges = false; } else { string nm = Request.Form["BillCharges"].ToString(); if (nm == "Auto") { AddServiceMod.BillCharges = true; } if (nm == "OneTime") { AddServiceMod.BillChargesOne = true; } } if (Request.Form["CheckedOutTime"] == "on") { AddServiceMod.CheckedOutTime = "true"; } else { AddServiceMod.CheckedOutTime = "false"; } if (Request.Form["CheckedOneDay"] == "on") { AddServiceMod.CheckedOneDay = "true"; } else { AddServiceMod.CheckedOneDay = "false"; } AddServiceMod.Mode = "Add"; // if (Bl_obj.CheckServices(AddServiceMod.ServiceID, AddServiceMod.ServiceName, AddServiceMod.ServiceGroupID, AddServiceMod.UnitID, AddServiceMod.ServiceType)) // { //if (Bl_obj.Save(AddServiceMod, obj1)) //{ // // ViewBag.Message = "Services Added Successfully"; // ModelState.Clear(); // TempData["Msg"] = "Services Save Successfully"; // // } //} if (Convert.ToString(AddServiceMod.ServiceID) == "") { AddServiceMod.ServiceID = 0; } var id = AddServiceMod.ServiceID; if (Bl_obj.Save(AddServiceMod, obj1)) { if (id > 0) { TempData["Msg"] = "Services Updated Successfully"; return(RedirectToAction("Services", "Services")); } else { TempData["Msg"] = "Services Saved Successfully"; return(RedirectToAction("Services", "Services")); } //if (id == 0) //{ // TempData["Msg"] = "Services Save Successfully"; // return RedirectToAction("Services", "Services"); //} //else //{ // TempData["Msg"] = "Services Updated Successfully"; // return RedirectToAction("Services", "Services"); //} } else { TempData["Msg"] = "Error"; } AddServiceMod.dsServicesCharges = Bl_obj.AllWardCharges(); // return View(AddServiceMod); return(RedirectToAction("Services", "Services")); } catch (Exception ex) { TempData["Msg"] = ex.Message; return(RedirectToAction("Services", "Services")); } }