public ActionResult HospitalCreation(HospitalCreation obj)
{
try
{
//if (Request.IsAjaxRequest())
//{
// return new EmptyResult();
//}
string A = Request.Form["HospitalName"];
TempData["Msg"] = "";
if (Request.Form["HospitalName"] != null)
{
if (obj.HospitalID > 0)
{
if (creation.Save(obj))
{
obj.HospitalName = "";
TempData["Msg"] = "Update Successfully";
ModelState.Clear();
RedirectToAction("HospitalCreation", "HospitalCreation");
}
RedirectToAction("HospitalCreation", "HospitalCreation");
}
else
{
try
{
if (creation.Save(obj))
{
if (obj.HospitalID > 0)
{
obj.HospitalName = "";
TempData["Msg"] = "Update Successfully";
ModelState.Clear();
RedirectToAction("HospitalCreation", "HospitalCreation");
}
TempData["Msg"] = "Save Successfully";
RedirectToAction("HospitalCreation", "HospitalCreation");
}
}
catch (Exception ex)
{
TempData["Msg"] = ex.Message;
RedirectToAction("HospitalCreation", "HospitalCreation");
}
}
}
}
catch (Exception ex)
{
TempData["Msg"] = ex.Message;
return(RedirectToAction("HospitalCreation", "HospitalCreation"));
}
return(RedirectToAction("HospitalCreation", "HospitalCreation"));
}
public JsonResult ImageUpload(HospitalCreation model)
{
string path = "";
var File = model.ImageFile;
if (File != null)
{
var FileName = Path.GetFileName(File.FileName);
var extention = Path.GetExtension(File.FileName);
var withoutextention = Path.GetFileNameWithoutExtension(File.FileName);
path = Server.MapPath("~/") + "MRDFile/" + File.FileName;
File.SaveAs(path);
ViewData["ImagePath"] = path;
}
return(new JsonResult {
Data = path, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public bool Save(HospitalCreation obj)
{
Connect();
con.Open();
SqlCommand cmd = new SqlCommand("IUHospital", con);
cmd.CommandType = CommandType.StoredProcedure;
if (obj.HospitalID == 0)
{
cmd.Parameters.AddWithValue("@HospitalID", 0);
cmd.Parameters.AddWithValue("@Mode", "ADD");
}
else
{
cmd.Parameters.AddWithValue("@HospitalID", obj.HospitalID);
cmd.Parameters.AddWithValue("@Mode", "Edit");
}
if (obj.HospitalName != null)
{
cmd.Parameters.AddWithValue("@HospitalName", obj.HospitalName);
}
else
{
cmd.Parameters.AddWithValue("@HospitalName", "");
}
if (obj.GroupName == null)
{
cmd.Parameters.AddWithValue("@GroupName", "");
}
else
{
cmd.Parameters.AddWithValue("@GroupName", obj.GroupName);
}
if (obj.ReferenceCode == null)
{
cmd.Parameters.AddWithValue("@ReferenceCode", "");
}
else
{
cmd.Parameters.AddWithValue("@ReferenceCode", obj.ReferenceCode);
}
if (obj.ManagingBody != null)
{
cmd.Parameters.AddWithValue("@ManagingBody", obj.ManagingBody);
}
else
{
cmd.Parameters.AddWithValue("@ManagingBody", "");
}
if (obj.Adminstrator != null)
{
cmd.Parameters.AddWithValue("@Adminstrator", obj.Adminstrator);
}
else
{
cmd.Parameters.AddWithValue("@Adminstrator", "");
}
if (obj.Address != null)
{
cmd.Parameters.AddWithValue("@Address", obj.Address);
}
else
{
cmd.Parameters.AddWithValue("@Address", "");
}
if (obj.Logo == null)
{
SqlParameter imageParameter = new SqlParameter("@Logo", SqlDbType.Image);
imageParameter.Value = DBNull.Value;
cmd.Parameters.Add(imageParameter);
}
else
{
cmd.Parameters.AddWithValue("@Logo", obj.Logo);
}
if (obj.CityID == null)
{
cmd.Parameters.AddWithValue("@CityID", 0);
}
else
{
cmd.Parameters.AddWithValue("@CityID", obj.CityID);
}
if (obj.CountryID == null)
{
cmd.Parameters.AddWithValue("@CountryID", 0);
}
else
{
cmd.Parameters.AddWithValue("@CountryID", obj.CountryID);
}
if (obj.StateID == null)
{
cmd.Parameters.AddWithValue("@StateID", 0);
}
else
{
cmd.Parameters.AddWithValue("@StateID", obj.StateID);
}
if (obj.PinCode != null)
{
cmd.Parameters.AddWithValue("@PinCode", obj.PinCode);
}
else
{
cmd.Parameters.AddWithValue("@PinCode", "");
}
if (obj.PhoneNo != null)
{
cmd.Parameters.AddWithValue("@PhoneNo", obj.PhoneNo);
}
else
{
cmd.Parameters.AddWithValue("@PhoneNo", "");
}
if (obj.PhoneNo1 != null)
{
cmd.Parameters.AddWithValue("@PhoneNo1", obj.PhoneNo1);
}
else
{
cmd.Parameters.AddWithValue("@PhoneNo1", "");
}
if (obj.FaxNo != null)
{
cmd.Parameters.AddWithValue("@FaxNo", obj.FaxNo);
}
else
{
cmd.Parameters.AddWithValue("@FaxNo", "");
}
if (obj.MobileNo != null)
{
cmd.Parameters.AddWithValue("@MobileNo", obj.MobileNo);
}
else
{
cmd.Parameters.AddWithValue("@MobileNo", "");
}
if (obj.EmailID != null)
{
cmd.Parameters.AddWithValue("@EmailID", obj.EmailID);
}
else
{
cmd.Parameters.AddWithValue("@EmailID", "");
}
if (obj.URL != null)
{
cmd.Parameters.AddWithValue("@URL", obj.URL);
}
else
{
cmd.Parameters.AddWithValue("@URL", "");
}
if (UserID != null)
{
cmd.Parameters.AddWithValue("@CreationID", UserID);
}
else
{
}
int i = cmd.ExecuteNonQuery();
con.Close();
if (i > 0)
{
return(true);
}
else
{
return(false);
}
}
public JsonResult Fill(int HospitalID)
{
DataSet ds = new DataSet();
List <HospitalCreation> Search = new List <HospitalCreation>();
ds = creation.GetHospital(HospitalID);
HospitalCreation AddHospital = new HospitalCreation();
AddHospital.HospitalID = Convert.ToInt32(ds.Tables[0].Rows[0]["HospitalID"].ToString());
AddHospital.HospitalName = ds.Tables[0].Rows[0]["HospitalName"].ToString();
AddHospital.GroupName = ds.Tables[0].Rows[0]["GroupName"].ToString();
if (ds.Tables[0].Rows[0]["CityID"].ToString() == "0" || ds.Tables[0].Rows[0]["CityName"].ToString() == "")
{
AddHospital.CityName = "";
}
else
{
int cityID = Convert.ToInt32(ds.Tables[0].Rows[0]["CityID"].ToString());
AddHospital.CityID = cityID.ToString();
AddHospital.CityName = ds.Tables[0].Rows[0]["CityName"].ToString();
}
if (ds.Tables[0].Rows[0]["StateID"].ToString() == "0" || ds.Tables[0].Rows[0]["StateName"].ToString() == "")
{
AddHospital.StateName = "";
}
else
{
int stateID = Convert.ToInt32(ds.Tables[0].Rows[0]["StateID"].ToString());
AddHospital.StateID = stateID.ToString();
AddHospital.StateName = ds.Tables[0].Rows[0]["StateName"].ToString();
}
if (ds.Tables[0].Rows[0]["CountryID"].ToString() == "0" || ds.Tables[0].Rows[0]["CountryName"].ToString() == "")
{
AddHospital.CountryName = "";
}
else
{
int counID = Convert.ToInt32(ds.Tables[0].Rows[0]["CountryID"].ToString());
AddHospital.CountryID = counID.ToString();
AddHospital.CountryName = ds.Tables[0].Rows[0]["CountryName"].ToString();
}
AddHospital.FaxNo = ds.Tables[0].Rows[0]["FaxNo"].ToString();
AddHospital.ManagingBody = ds.Tables[0].Rows[0]["ManagingBody"].ToString();
AddHospital.MobileNo = ds.Tables[0].Rows[0]["MobileNo"].ToString();
AddHospital.PhoneNo = ds.Tables[0].Rows[0]["PhoneNo"].ToString();
AddHospital.PhoneNo1 = ds.Tables[0].Rows[0]["PhoneNo1"].ToString();
AddHospital.ReferenceCode = ds.Tables[0].Rows[0]["ReferenceCode"].ToString();
AddHospital.Address = ds.Tables[0].Rows[0]["Address"].ToString();
AddHospital.Adminstrator = ds.Tables[0].Rows[0]["Adminstrator"].ToString();
AddHospital.PinCode = ds.Tables[0].Rows[0]["PinCode"].ToString();
AddHospital.URL = ds.Tables[0].Rows[0]["URL"].ToString();
AddHospital.EmailID = ds.Tables[0].Rows[0]["EmailID"].ToString();
AddHospital.Mode = "Edit";
Search.Add(AddHospital);
return(new JsonResult {
Data = Search, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
