public bool SaveTest(CollectionCenter obj)
{
Connect();
SqlCommand cmd = new SqlCommand("IUCollectionCenter", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@HospitalID", HospitalID);
cmd.Parameters.AddWithValue("@LocationID", LocationID);
if (obj.CollectionID == "" || obj.CollectionID == null || obj.CollectionID == "0")
{
cmd.Parameters.AddWithValue("@CollectionID", 0);
cmd.Parameters.AddWithValue("@Mode", "Add");
}
else
{
cmd.Parameters.AddWithValue("@CollectionID", obj.CollectionID);
cmd.Parameters.AddWithValue("@Mode", "Edit");
}
cmd.Parameters.AddWithValue("@CollectionName", obj.CollectionName);
cmd.Parameters.AddWithValue("@PhoneNo", obj.PhoneNo);
cmd.Parameters.AddWithValue("@MobileNo", obj.Mobile);
cmd.Parameters.AddWithValue("@Address", obj.Address);
cmd.Parameters.AddWithValue("@EmailID", obj.Email);
cmd.Parameters.AddWithValue("@Admin", obj.AdminInCharge);
cmd.Parameters.AddWithValue("@CreationID", UserID);
con.Open();
int i = cmd.ExecuteNonQuery();
con.Close();
if (i > 0)
{
return(true);
}
else
{
return(false);
}
}
public ActionResult CollectionCenter(CollectionCenter obj, FormCollection fc)
{
try
{
BL_CollectionCenter _CollectionCenter = new BL_CollectionCenter();
if (_CollectionCenter.CheckCollectionCenter(obj.CollectionID, obj.CollectionName))
{
if (obj.CollectionID == "0" || obj.CollectionID == null)
{
obj.CollectionID = "0";
}
else
{
obj.CollectionID = (fc["CollectionID"]);
}
if (obj.CollectionName == "" || obj.CollectionName == null)
{
obj.CollectionName = "";
}
else
{
obj.CollectionName = fc["CollectionName"].ToString();
}
if (obj.Mobile == "")
{
obj.Mobile = "";
}
else
{
obj.Mobile = fc["MobileNo"].ToString();
}
if (obj.PhoneNo == "")
{
obj.PhoneNo = "";
}
else
{
obj.PhoneNo = fc["Phone"].ToString();
}
if (obj.Address == "" || obj.Address == null)
{
obj.Address = "";
}
else
{
obj.Address = fc["Address"].ToString();
}
if (obj.Email == "")
{
obj.Email = "";
}
else
{
obj.Email = fc["EmailID"].ToString();
}
if (obj.AdminInCharge == "")
{
obj.AdminInCharge = "";
}
else
{
obj.AdminInCharge = fc["Admin"].ToString();
}
if (_CollectionCenter.SaveTest(obj))
{
if (Convert.ToInt32(obj.CollectionID) > 0)
{
ModelState.Clear();
TempData["Msg"] = "Collection Center Updated Successfully !";
return(RedirectToAction("CollectionCenter", "CollectionCenter"));
}
else
{
ModelState.Clear();
TempData["Msg"] = "Collection Center Saved Successfully !";
return(RedirectToAction("CollectionCenter", "CollectionCenter"));
}
}
}
else
{
ViewData["flag"] = "Error";
TempData["Msg"] = "Collection Center Already Exists !";
}
return(RedirectToAction("CollectionCenter", "CollectionCenter"));
}
catch (Exception)
{
return(RedirectToAction("CollectionCenter", "CollectionCenter"));
}
}