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