public ActionResult UpdateHospital(HospitalForTableModel UDHospital)
{
try
{
UserDetailsModel udModel = (UserDetailsModel)Session["userModel"];
//UDBusiness.UpdateHospitalDetails(UDHospital);
UDBusiness.UpdateHospitalDetailsEF(UDHospital);
if (UDHospital.PrimaryMark.Equals("Yes"))
{
//UDBusiness.UpdatePrimaryMark(udModel.userId, UDHospital.HospitalID);
UDBusiness.UpdatePrimaryMarkEF(udModel.userId, UDHospital.HospitalID);
}
return(JavaScript("location.reload(true)"));
}
catch (Exception ex)
{
WriteLog write = new WriteLog();
string message = ex.Message;
write.WriteLogMessage(message);
string strMsg = UDBusiness.IngnoreSpecialCharacter(message);
string script = "<script language=\"javascript\" type=\"text/javascript\">alert('" + strMsg + "');</script>";
Response.Write(script);
return(JavaScript("location.reload(true)"));
}
}
public List <HospitalForTableModel> GetHospitalList(Int32 userID)
{
List <HospitalForTableModel> listHospital = new List <HospitalForTableModel>();
using (SqlConnection con = new SqlConnection(cs))
{
SqlCommand cmd = new SqlCommand("spSelectDataForHospitalGrid", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("userID", userID);
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
HospitalForTableModel HTableModel = new HospitalForTableModel();
HTableModel.HospitalID = Int32.Parse(reader[0].ToString());
HTableModel.HospitalName = reader[1].ToString();
HTableModel.Address = reader[2].ToString();
HTableModel.EmailID = reader[3].ToString();
HTableModel.Contact1 = Int64.Parse(reader[4].ToString());
HTableModel.Contact2 = Int64.Parse(reader[5].ToString());
HTableModel.PrimaryMark = reader[6].ToString();
listHospital.Add(HTableModel);
}
}
return(listHospital);
}
//Update Hospital
public void UpdateHospitalDetailsEF(HospitalForTableModel hospital)
{
using (var dbContext = new HealthcareDBEntities())
{
var hos = dbContext.UserHospitals.First(r => r.UserID == hospital.UserID && r.HospitalID == hospital.HospitalID);
hos.HospitalID = hospital.HospitalID;
hos.HospitalName = hospital.HospitalName;
hos.EmailID = hospital.EmailID;
hos.Address = hospital.Address;
hos.ContactNumber1 = hospital.Contact1;
hos.ContactNumber2 = hospital.Contact2;
hos.PrimaryMark = hospital.PrimaryMark;
hos.UserID = hospital.UserID;
try
{
dbContext.SaveChanges();
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
throw;
}
}
}
public void UpdateHospitalDetails(HospitalForTableModel UDHospital)
{
SqlConnection con = new SqlConnection(cs);
con.Open();
SqlCommand cmd = new SqlCommand("spUpdateHospital", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("hospitalID", UDHospital.HospitalID);
cmd.Parameters.AddWithValue("hospitalName", UDHospital.HospitalName);
cmd.Parameters.AddWithValue("address", UDHospital.Address);
cmd.Parameters.AddWithValue("email", UDHospital.EmailID);
cmd.Parameters.AddWithValue("primaryContact", UDHospital.Contact1);
cmd.Parameters.AddWithValue("seconadryContact", UDHospital.Contact2);
cmd.Parameters.AddWithValue("primaryMark", UDHospital.PrimaryMark);
cmd.Parameters.AddWithValue("userID", UDHospital.UserID);
SqlDataReader reader = cmd.ExecuteReader();
}
public void UpdateHospitalDetails(HospitalForTableModel UDHospital)
{
UDDataAccess.UpdateHospitalDetails(UDHospital);
}
public void UpdateHospitalDetailsEF(HospitalForTableModel hospital)
{
var accessLayer = new AccessLayer();
accessLayer.UpdateHospitalDetailsEF(hospital);
}
