public JsonResult SelectAllTestTPAWise() { BL_TestMasterTPAWise Blobj1 = new BL_TestMasterTPAWise(); TestMasterTPAWise AddServiceMod1 = new TestMasterTPAWise(); AddServiceMod1.dsgrid = Blobj1.GetAllTestMasterTPAWise(); List <TestMasterTPAWise> searchList = new List <TestMasterTPAWise>(); foreach (DataRow dr in AddServiceMod1.dsgrid.Tables[0].Rows) { searchList.Add(new TestMasterTPAWise { OrganisationName = dr["OrganizationName"].ToString(), TestName = dr["TestName"].ToString(), TestTPAWiseID = dr["TestTPAWiseID"].ToString(), TestID = dr["TestID"].ToString(), }); } return(new JsonResult { Data = searchList, JsonRequestBehavior = JsonRequestBehavior.AllowGet, MaxJsonLength = 86753090 }); }
public JsonResult GetAllWard() { BL_TestMasterTPAWise Blobj = new BL_TestMasterTPAWise(); TestMasterTPAWise AddServiceMod = new TestMasterTPAWise(); AddServiceMod.dsgrid = Blobj.GetAllWardName(); List <WardDetail_class> search = new List <WardDetail_class>(); foreach (DataRow dr in AddServiceMod.dsgrid.Tables[0].Rows) { dr["GeneralCharges"] = 0; dr["EmergencyCharges"] = 0; search.Add(new WardDetail_class { WardId = Convert.ToInt16(dr["WardId"]), WardName = dr["WardName"].ToString(), GeneralCharges = dr["GeneralCharges"].ToString(), EmergencyCharges = dr["EmergencyCharges"].ToString(), }); } return(new JsonResult { Data = search, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public ActionResult TestMasterTPAWise(TestMasterTPAWise objmodel, FormCollection form) { string TestDetailsTPAWiseID = form["TestDetailsTPAWiseID"]; string WardID = form["WardID"].ToString(); string GeneralChargess = form["GeneralCharges1"].ToString(); string EmergencyCharge = form["EmergencyCharges1"].ToString(); string[] TestDetailsTPAWise_ID = TestDetailsTPAWiseID.Split(','); string[] Ward_ID = WardID.Split(','); string[] General_Chargess = GeneralChargess.Split(','); string[] Emergency_Charge = EmergencyCharge.Split(','); WardDetail_class[] ward = new WardDetail_class[Ward_ID.Length]; for (int i = 0; i < Ward_ID.Length; i++) { ward[i] = new WardDetail_class(); ward[i].TestDetailsTPAWiseID = Convert.ToInt32(TestDetailsTPAWise_ID[i]); ward[i].WardId = Convert.ToInt32(Ward_ID[i]); ward[i].GeneralCharges = General_Chargess[i].ToString(); ward[i].EmergencyCharges = Emergency_Charge[i].ToString(); } try { objmodel.ward = ward; if (Blobj.Edit(objmodel)) { if (Convert.ToInt32(objmodel.TestTPAWiseID) > 0) { ModelState.Clear(); TempData["Msg"] = "TestMasterTPAWise Updated Successfully "; return(RedirectToAction("TestMasterTPAWise", "TestMasterTPAWise")); } else { ModelState.Clear(); TempData["Msg"] = "TestMasterTPAWise Saved Successfully "; return(RedirectToAction("TestMasterTPAWise", "TestMasterTPAWise")); } } else { ViewData["flag"] = "Error"; } return(View()); } catch (Exception) { return(View()); } }
public ActionResult TestMasterTPAWise(TestMasterTPAWise objmodel) { //DataSet ds = Blobj.GetTestMasterTPAWise(TestTPAWiseID); //objmodel.TPAName = ds.Tables[0].Rows[0]["OrganizationName"].ToString(); //objmodel.TestName = ds.Tables[0].Rows[0]["TestName"].ToString(); //objmodel.GeneralCharges = ds.Tables[0].Rows[0]["GeneralCharges"].ToString(); //objmodel.EmergencyCharges = ds.Tables[0].Rows[0]["EmergencyCharges"].ToString(); //objmodel.NonBillable = ds.Tables[0].Rows[0]["RecommendedByDoctor"].ToString(); //objmodel.dsgrid = Blobj.GetTestMasterDetailsTPAWise(TestTPAWiseID); //GetTestMasterDetailsTPAWise return(View()); }
public JsonResult GetTestMasterTPAWise(string TPAID) { BL_TestMasterTPAWise Blobj2 = new BL_TestMasterTPAWise(); TestMasterTPAWise AddServiceMod2 = new TestMasterTPAWise(); AddServiceMod2.dsgrid = new DataSet(); AddServiceMod2.dsgrid = Blobj2.GetTestMasterTPAWiseDetails(TPAID); List <TestMasterTPAWise> search = new List <TestMasterTPAWise>(); foreach (DataRow dr in AddServiceMod2.dsgrid.Tables[0].Rows) { search.Add(new TestMasterTPAWise { GeneralCharges = dr["GeneralCharges"].ToString(), EmergencyCharges = dr["EmergencyCharges"].ToString(), }); } return(new JsonResult { Data = search, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public JsonResult EditServiceTPAWise(int TestTPAWiseID) { BL_TestMasterTPAWise Blobj1 = new BL_TestMasterTPAWise(); List <TestMasterTPAWise> searchList = new List <TestMasterTPAWise>(); DataSet ds = Blobj1.GetTPAWiseID(TestTPAWiseID); TestMasterTPAWise AddServiceTPAWise = new TestMasterTPAWise(); AddServiceTPAWise.TPAName = ds.Tables[0].Rows[0]["OrganizationName"].ToString(); AddServiceTPAWise.TPAId = ds.Tables[0].Rows[0]["OrganizationID"].ToString(); AddServiceTPAWise.TestName = ds.Tables[0].Rows[0]["TestName"].ToString(); AddServiceTPAWise.TestID = ds.Tables[0].Rows[0]["TestID"].ToString(); AddServiceTPAWise.GeneralCharges = ds.Tables[0].Rows[0]["GeneralCharges"].ToString(); AddServiceTPAWise.EmergencyCharges = ds.Tables[0].Rows[0]["EmergencyCharges"].ToString(); AddServiceTPAWise.RecommendedByDoctor = ds.Tables[0].Rows[0]["RecommendedByDoctor"].ToString(); AddServiceTPAWise.TestTPAWiseID = Convert.ToInt32(TestTPAWiseID).ToString(); ds = Blobj1.GetTestDetailsTPAWiseID(TestTPAWiseID); searchList.Add(AddServiceTPAWise); foreach (DataRow dr in ds.Tables[0].Rows) { searchList.Add(new TestMasterTPAWise { WardName = dr["WardName"].ToString(), GeneralCharges = dr["GeneralCharges"].ToString(), EmergencyCharges = dr["EmergencyCharges"].ToString(), WardId = Convert.ToInt32(dr["WardID"]), TestDetailsTPAWiseID = Convert.ToInt32(dr["TestDetailsTPAWiseID"]), }); } return(new JsonResult { Data = searchList, JsonRequestBehavior = JsonRequestBehavior.AllowGet, MaxJsonLength = 86753090 }); }
public bool Edit(TestMasterTPAWise objmodel) { connect(); con.Open(); try { SqlCommand cmd = new SqlCommand("IUTestMasterTPAWise", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@HospitalID", HospitalID); cmd.Parameters.AddWithValue("@LocationID", LocationID); cmd.Parameters.AddWithValue("@TestTPAWiseID", objmodel.TestTPAWiseID); cmd.Parameters.AddWithValue("@OrganizationID", ""); cmd.Parameters.AddWithValue("@TestID", ""); cmd.Parameters.AddWithValue("@GeneralCharges", objmodel.GeneralCharges); cmd.Parameters.AddWithValue("@EmergencyCharges", objmodel.EmergencyCharges); cmd.Parameters.AddWithValue("@RecommendedByDoctor", objmodel.RecommendedByDoctor); cmd.Parameters.AddWithValue("@CreationID", UserID); cmd.Parameters.AddWithValue("@Mode", "Edit"); int i = cmd.ExecuteNonQuery(); con.Close(); if (i > 0) { try { int k = 0; WardDetail_class[] ward123 = objmodel.ward; for (int j = 0; j < ward123.Length; j++) { SqlCommand cmd1 = new SqlCommand("IUTestMasterDetailsTPAWise", con); cmd1.CommandType = CommandType.StoredProcedure; cmd1.Parameters.AddWithValue("@HospitalID", HospitalID); cmd1.Parameters.AddWithValue("@LocationID", LocationID); cmd1.Parameters.AddWithValue("@TestDetailsTPAWiseID", ward123[j].TestDetailsTPAWiseID); //cmd1.Parameters["@TestDetailsTPAWiseID"].Direction = ParameterDirection.Output; cmd1.Parameters.AddWithValue("@TestTPAWiseID", objmodel.TestTPAWiseID); cmd1.Parameters.AddWithValue("@WardID", ward123[j].WardId); cmd1.Parameters.AddWithValue("@GeneralCharges", ward123[j].GeneralCharges); cmd1.Parameters.AddWithValue("@EmergencyCharges", ward123[j].EmergencyCharges); cmd1.Parameters.AddWithValue("@CreationID", UserID); cmd1.Parameters.AddWithValue("@Mode", "Edit"); con.Open(); k = cmd1.ExecuteNonQuery(); con.Close(); } } catch (Exception ex) { } return(true); } else { return(false); } } catch (Exception ex) { return(false); } }