public ActionResult ServicesTPAWise(ServicesTPAWise location, ArrayWordDetailTpa TpaDetail)
{
Buisness_Logic.Master.BL_ServiceTPAWise ServiceEditTPAWise = new Buisness_Logic.Master.BL_ServiceTPAWise();
string Save = ServiceEditTPAWise.Save(location, TpaDetail);
if (location.ServicesTPAWiseID > 0)
{
if (Save == "Save")
{
TempData["Msg"] = "ServiceTPAWise Updated Successfully";
return(RedirectToAction("ServicesTPAWise", "ServicesTPAWise"));
}
}
else
{
if (Save == "Save")
{
TempData["msg"] = "Privilege Card Saved Successfully";
return(RedirectToAction("ServicesTPAWise", "ServicesTPAWise"));
}
}
//if (Save == "Save") // passing Value to DBClass from model
//{
// TempData["Msg"] = "ServiceTPAWise Save Sussefully";
//}
return(RedirectToAction("ServicesTPAWise", "ServicesTPAWise"));
}
public JsonResult EditServiceTPAWise(int ServicesTPAWiseID)
{
Buisness_Logic.Master.BL_ServiceTPAWise ServiceEditTPAWise = new Buisness_Logic.Master.BL_ServiceTPAWise();
List <ServicesTPAWise> searchList = new List <ServicesTPAWise>();
DataSet ds = ServiceEditTPAWise.GetServicesTPAWise(ServicesTPAWiseID);
ServicesTPAWise AddServiceTPAWise = new ServicesTPAWise();
AddServiceTPAWise.OrganizationName = ds.Tables[0].Rows[0]["OrganizationName"].ToString();
AddServiceTPAWise.OrganizationID = ds.Tables[0].Rows[0]["OrganizationID"].ToString();
AddServiceTPAWise.ServiceName = ds.Tables[0].Rows[0]["ServiceName"].ToString();
AddServiceTPAWise.ServiceID = ds.Tables[0].Rows[0]["ServiceID"].ToString();
AddServiceTPAWise.UnitName = ds.Tables[0].Rows[0]["UnitName"].ToString();
AddServiceTPAWise.UnitID = ds.Tables[0].Rows[0]["UnitID"].ToString();
AddServiceTPAWise.GeneralCharges = Convert.ToDecimal(ds.Tables[0].Rows[0]["GeneralCharges"].ToString());
AddServiceTPAWise.EmergencyCharges = Convert.ToDecimal(ds.Tables[0].Rows[0]["EmergencyCharges"].ToString());
AddServiceTPAWise.ServiceType = ds.Tables[0].Rows[0]["ServiceType"].ToString();
AddServiceTPAWise.RecommendedByDoctor = ds.Tables[0].Rows[0]["RecommendedByDoctor"].ToString();
AddServiceTPAWise.HideInBilling = ds.Tables[0].Rows[0]["HideInBilling"].ToString();
AddServiceTPAWise.ServiceID = ds.Tables[0].Rows[0]["ServiceID"].ToString();
AddServiceTPAWise.UnitID = ds.Tables[0].Rows[0]["UnitID"].ToString();
AddServiceTPAWise.OrganizationID = ds.Tables[0].Rows[0]["OrganizationID"].ToString();
// DataSet ds1 = ServiceEditTPAWise.GetServicesTPAWiseDetail(ServicesTPAWiseID);
AddServiceTPAWise.ServicesTPAWiseID = ServicesTPAWiseID;
// AddServiceTPAWise.dsServiceTPAWiseCharges = ServiceEditTPAWise.GetServicesTPAWiseDetail(ServicesTPAWiseID);
ds = ServiceEditTPAWise.GetServicesTPAWiseDetail(ServicesTPAWiseID);
searchList.Add(AddServiceTPAWise);
foreach (DataRow dr in ds.Tables[0].Rows)
{
searchList.Add(new ServicesTPAWise
{
WardName = dr["WardName"].ToString(),
GeneralCharges = Convert.ToDecimal(dr["GeneralCharges"]),
EmergencyCharges = Convert.ToDecimal(dr["EmergencyCharges"]),
WardID = Convert.ToInt32(dr["WardID"]),
ServicesDetailsTPAWiseID = Convert.ToInt32(dr["ServicesDetailsTPAWiseID"]),
});
}
//return View(ServiceTPACharges);
return(new JsonResult {
Data = searchList, JsonRequestBehavior = JsonRequestBehavior.AllowGet, MaxJsonLength = 86753090
});
}
public string Save(ServicesTPAWise ServicesTPAWise, ArrayWordDetailTpa TpaDetail)
{
bool flag = true;
Connect();
con.Open();
// ArrayWordDetailTpa TPAWiseDetail = new ArrayWordDetailTpa();
SqlCommand cmd;
string Arror = "Save";
try
{
DataSet dsTPAWise = new DataSet();
// dsTPAWise = GetServicesTPAWise();
cmd = new SqlCommand("IUServicesTPAWise", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@HospitalID", HospitalID);
cmd.Parameters.AddWithValue("@LocationID", LocationID);
cmd.Parameters.AddWithValue("@ServicesTPAWiseID", ServicesTPAWise.ServicesTPAWiseID);
// cmd.Parameters["@ServicesTPAWiseID"].Direction = ParameterDirection.Output;
cmd.Parameters.AddWithValue("@ServiceID", ServicesTPAWise.ServiceID);
cmd.Parameters.AddWithValue("@ReferenceCode", 1);
if (ServicesTPAWise.UnitID == null)
{
cmd.Parameters.AddWithValue("@UnitID", 0);
}
else
{
cmd.Parameters.AddWithValue("@UnitID", ServicesTPAWise.UnitID);
}
//cmd.Parameters.AddWithValue("@OrganizationID", Convert.ToInt32(dsTPAWise.Tables[0].Rows[0]["OrganizationID"].ToString()));
cmd.Parameters.AddWithValue("@OrganizationID", ServicesTPAWise.OrganizationID);
cmd.Parameters.AddWithValue("@GeneralCharges", ServicesTPAWise.GeneralCharges);
cmd.Parameters.AddWithValue("@EmergencyCharges", ServicesTPAWise.EmergencyCharges);
cmd.Parameters.AddWithValue("@ServiceType", ServicesTPAWise.ServiceType);
cmd.Parameters.AddWithValue("@RecommendedByDoctor", ServicesTPAWise.RecommendedByDoctor);
cmd.Parameters.AddWithValue("@HideInBilling", ServicesTPAWise.HideInBilling);
cmd.Parameters.AddWithValue("@CreationID", UserID);
cmd.Parameters.AddWithValue("@Mode", "Edit");
int ServicesTPAWiseID = cmd.ExecuteNonQuery();
ServicesTPAWise.ServicesTPAWiseID = Convert.ToInt32(cmd.Parameters["@ServicesTPAWiseID"].Value.ToString());
int ServicesTPAWiseIDs = Convert.ToInt32(cmd.Parameters["@ServicesTPAWiseID"].Value.ToString());
// }
con.Close();
DataSet dsWardDetailsTPAWise = new DataSet();
dsWardDetailsTPAWise = GetServicesTPAWiseDetail(ServicesTPAWiseIDs);
for (int i = 0; i < TpaDetail.WardID1.Length; i++)
{
con.Open();
cmd = new SqlCommand("IUServicesDetailsTPAWise", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@HospitalID", HospitalID);
cmd.Parameters.AddWithValue("@LocationID", LocationID);
cmd.Parameters.AddWithValue("@ServicesDetailsTPAWiseID", Convert.ToInt32(TpaDetail.ServicesDetailsTPAWiseID[i]));
// cmd.Parameters["@ServicesDetailsTPAWiseID"].Direction = ParameterDirection.Output;
cmd.Parameters.AddWithValue("@ServicesTPAWiseID", Convert.ToInt32(ServicesTPAWise.ServicesTPAWiseID));
cmd.Parameters.AddWithValue("@WardID", Convert.ToInt32(TpaDetail.WardID1[i]));
cmd.Parameters.AddWithValue("@GeneralCharges", Convert.ToDecimal(TpaDetail.GeneralCharges1[i].ToString()));
cmd.Parameters.AddWithValue("@EmergencyCharges", Convert.ToDecimal(TpaDetail.EmergencyCharges1[i]));
cmd.Parameters.AddWithValue("@CreationID", UserID);
cmd.Parameters.AddWithValue("@Mode", "Edit");
int Row2 = cmd.ExecuteNonQuery();
con.Close();
if (Row2 > 0)
{
flag = true;
}
else
{
flag = false;
}
}
}
catch (Exception ex)
{
Arror = ex.Message;
}
return(Arror);
}
