public ActionResult PriviledgeCard(PrivilegeCard obPri, priviledgecardarray Arry)
{
try
{
if (dbPrivilege.CheckPrivilegeCard(obPri.PrivilegeCardID, obPri.CardName))
{
var id = obPri.PrivilegeCardID;
//int PrivilegeCardID = Convert.ToInt32(obPri.PrivilegeCardID);
string message = dbPrivilege.Save(obPri, Arry);
if (id > 0)
{
if (message == "Save")
{
TempData["msg"] = "Privilege Card Updated Successfully !";
return(RedirectToAction("PriviledgeCard", "PriviledgeCard"));
}
}
else
{
if (message == "Save")
{
TempData["msg"] = "Privilege Card Saved Successfully !";
return(RedirectToAction("PriviledgeCard", "PriviledgeCard"));
}
}
}
else
{
TempData["msg"] = "Privilege Card Already Exists !";
return(RedirectToAction("PriviledgeCard", "PriviledgeCard"));
}
return(RedirectToAction("PriviledgeCard", "PriviledgeCard"));
}
catch (Exception ex)
{
ViewData["Msg"] = ex.Message;
return(RedirectToAction("PriviledgeCard", "PriviledgeCard"));
}
}
public string Save(PrivilegeCard objPriviledge, priviledgecardarray arrr)
{
bool flag = true;
Connect();
con.Open();
int PrivilegeCardID = 0;
try
{
SqlCommand cmd = new SqlCommand("IUPrivilegeCard", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@HospitalID", HospitalID);
cmd.Parameters.AddWithValue("@LocationID", LocationID);
if (objPriviledge.PrivilegeCardID == 0)
{
cmd.Parameters.AddWithValue("@PrivilegeCardID", 0);
cmd.Parameters["@PrivilegeCardID"].Direction = ParameterDirection.Output;
cmd.Parameters.AddWithValue("@Mode", "Add");
}
else
{
cmd.Parameters.AddWithValue("@PrivilegeCardID", objPriviledge.PrivilegeCardID);
cmd.Parameters.AddWithValue("@Mode", "Edit");
}
cmd.Parameters.AddWithValue("@CardName", objPriviledge.CardName);
if (objPriviledge.Path == null)
{
cmd.Parameters.AddWithValue("@Path", "");
}
else
{
cmd.Parameters.AddWithValue("@Path", objPriviledge.Path + ".docx");
}
cmd.Parameters.AddWithValue("@Remark", objPriviledge.Remark);
cmd.Parameters.AddWithValue("@CreationID", UserID);
PrivilegeCardID = cmd.ExecuteNonQuery();
objPriviledge.PrivilegeCardID = Convert.ToInt32(cmd.Parameters["@PrivilegeCardID"].Value.ToString());
if (PrivilegeCardID > 0)
{
// string[] Price = arrr.Price.ToString().Split(',');
//if()
//{
//}
for (int a = 0; a < arrr.PriceName.Length; a++)
{
if (arrr.PriceName[a].ToString() != "")
{
cmd = new SqlCommand("IUPrivilegePriceDetail", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@HospitalID", HospitalID);
cmd.Parameters.AddWithValue("@LocationID", LocationID);
cmd.Parameters.AddWithValue("@PrivilegeCardID", objPriviledge.PrivilegeCardID);
if (arrr.PrivilegePriceDetailID[a].ToString() == "0" || arrr.PrivilegePriceDetailID.ToString() == null)
{
cmd.Parameters.AddWithValue("@PrivilegePriceDetailID", 0);
//cmd.Parameters["@PrivilegePriceDetailID"].Direction = ParameterDirection.Output;
cmd.Parameters.AddWithValue("@Mode", "Add");
}
else
{
cmd.Parameters.AddWithValue("@PrivilegePriceDetailID", arrr.PrivilegePriceDetailID[a]);
cmd.Parameters.AddWithValue("@Mode", "Edit");
}
cmd.Parameters.AddWithValue("@PriceName", arrr.PriceName[a]);
cmd.Parameters.AddWithValue("@Price", arrr.Price[a]);
cmd.Parameters.AddWithValue("@CreationID", UserID);
int PrivilegePriceDetailID = cmd.ExecuteNonQuery();
}
}
if (arrr.ServiceName1 != null)
{
for (int a = 0; a < arrr.ServiceName1.Length; a++)
{
cmd = new SqlCommand("IUPrivilegeServiceDetail", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@HospitalID", HospitalID);
cmd.Parameters.AddWithValue("@LocationID", LocationID);
cmd.Parameters.AddWithValue("@PrivilegeCardID", objPriviledge.PrivilegeCardID);
cmd.Parameters.AddWithValue("@PrivilegeServiceDetailID", 0);
// cmd.Parameters["@PrivilegeServiceDetailID"].Direction = ParameterDirection.Output;
cmd.Parameters.AddWithValue("@Mode", "Add");
cmd.Parameters.AddWithValue("@ServiceID", arrr.ServiceID1[a]);
cmd.Parameters.AddWithValue("@ServiceName", arrr.ServiceName1[a]);
cmd.Parameters.AddWithValue("@DiscountPer", arrr.DiscountService[a]);
cmd.Parameters.AddWithValue("@CreationID", UserID);
int PrivilegeServiceDetailID = cmd.ExecuteNonQuery();
}
}
if (arrr.TestName1 != null)
{
for (int a = 0; a < arrr.TestName1.Length; a++)
{
cmd = new SqlCommand("IUPrivilegeTestDetail", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@HospitalID", HospitalID);
cmd.Parameters.AddWithValue("@LocationID", LocationID);
cmd.Parameters.AddWithValue("@PrivilegeCardID", objPriviledge.PrivilegeCardID);
cmd.Parameters.AddWithValue("@PrivilegeTestDetailID", 0);
// cmd.Parameters["@PrivilegeTestDetailID"].Direction = ParameterDirection.Output;
cmd.Parameters.AddWithValue("@Mode", "Add");
cmd.Parameters.AddWithValue("@TestID", arrr.TestID1[a]);
cmd.Parameters.AddWithValue("@TestName", arrr.TestName1[a]);
cmd.Parameters.AddWithValue("@DiscountPer", arrr.DiscountTest[a]);
cmd.Parameters.AddWithValue("@CreationID", UserID);
int PrivilegeTestDetailID = cmd.ExecuteNonQuery();
}
}
if (arrr.ServiceGroupName != null)
{
for (int a = 0; a < arrr.ServiceGroupName.Length; a++)
{
cmd = new SqlCommand("IUPrivilegeServiceGroup", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@HospitalID", HospitalID);
cmd.Parameters.AddWithValue("@LocationID", LocationID);
cmd.Parameters.AddWithValue("@PrivilegeCardID", objPriviledge.PrivilegeCardID);
cmd.Parameters.AddWithValue("@PrivilegeServiceGroupID", 0);
// cmd.Parameters["@PrivilegeServiceGroupID"].Direction = ParameterDirection.Output;
cmd.Parameters.AddWithValue("@Mode", "Add");
cmd.Parameters.AddWithValue("@ServiceGroupID", arrr.ServiceGroupID[a]);
cmd.Parameters.AddWithValue("@ServiceGroupName", arrr.ServiceGroupName[a]);
cmd.Parameters.AddWithValue("@DiscountPer", arrr.DiscountPer[a]);
cmd.Parameters.AddWithValue("@CreationID", UserID);
int PrivilegeServiceGroupID = cmd.ExecuteNonQuery();
}
}
}
else
{
flag = false;
}
}
catch (Exception ex)
{
return(ex.Message);
}
return("Save");
}
