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