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