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);
}
}
