public ActionResult RefferToDoctor(RefferToDoctor obj) { try { if (obj.RefferDoctorID == 0) { if (obj_doctor.CheckRefferToDoctor(obj.RefferDoctorID, obj.InstituteName.ToString().Trim()) == false) { TempData["msg"] = "Institute Name Already Exist's"; } else { if (obj_doctor.Save(obj)) { TempData["msg"] = " Institute Name Saved Successfully"; } } } else { if (obj_doctor.Save(obj)) { TempData["msg"] = " Institute Name Updated Successfully"; } } return(RedirectToAction("RefferToDoctor", "RefferToDoctor")); } catch (Exception) { return(RedirectToAction("RefferToDoctor", "RefferToDoctor")); } }
public RefferToDoctor GetRefferToDoctor(int RefferDoctorID) { Connect(); RefferToDoctor doctor = new RefferToDoctor(); SqlCommand cmd = new SqlCommand("GetRefferToDoctor", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@HospitalID", HospitalID)); cmd.Parameters.Add(new SqlParameter("@LocationID", LocationID)); cmd.Parameters.Add(new SqlParameter("@RefferDoctorID", RefferDoctorID)); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); con.Open(); da.Fill(dt); con.Close(); foreach (DataRow dr in dt.Rows) { doctor.RefferDoctorID = Convert.ToInt32(dr["RefferDoctorID"]); doctor.InstituteName = Convert.ToString(dr["InstituteName"]); doctor.PrintName = Convert.ToString(dr["PrintName"]); doctor.ReferenceCode = Convert.ToString(dr["ReferenceCode"]); doctor.PermanentAddress = Convert.ToString(dr["PermanentAddress"]); doctor.TelephoneNo = Convert.ToString(dr["TelephoneNo"]); doctor.FaxNo = Convert.ToString(dr["FaxNo"]); doctor.MobileNo = Convert.ToString(dr["MobileNo"]); doctor.EmailId = Convert.ToString(dr["EmailId"]); } return(doctor); }
public int DeleteRefferDoctor(int RefferDoctorID) { Connect(); int delete = 0; RefferToDoctor doctor = new RefferToDoctor(); SqlCommand cmd = new SqlCommand("DeleteRefferToDoctor", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@HospitalID", HospitalID); cmd.Parameters.AddWithValue("@LocationID", LocationID); cmd.Parameters.AddWithValue("@RefferDoctorID", RefferDoctorID); con.Open(); delete = cmd.ExecuteNonQuery(); return(delete); }
public bool Save(RefferToDoctor obj) { Connect(); SqlCommand cmd = new SqlCommand("IURefferToDoctor", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("HospitalID", HospitalID); cmd.Parameters.AddWithValue("LocationID", LocationID); if (obj.RefferDoctorID == 0) { cmd.Parameters.AddWithValue("@RefferDoctorID", 0); cmd.Parameters.AddWithValue("@Mode", "Add"); } else { cmd.Parameters.AddWithValue("@RefferDoctorID", obj.RefferDoctorID); cmd.Parameters.AddWithValue("@Mode", "Edit"); } cmd.Parameters.AddWithValue("@InstituteName", obj.InstituteName); cmd.Parameters.AddWithValue("@PrintName", obj.PrintName); if (obj.PermanentAddress != null) { cmd.Parameters.AddWithValue("@PermanentAddress", obj.PermanentAddress); } else { cmd.Parameters.AddWithValue("@PermanentAddress", ""); } if (obj.MobileNo != null) { cmd.Parameters.AddWithValue("@MobileNo", obj.MobileNo); } else { cmd.Parameters.AddWithValue("@MobileNo", ""); } if (obj.TelephoneNo == null) { cmd.Parameters.AddWithValue("@TelephoneNo", ""); } else { cmd.Parameters.AddWithValue("@TelephoneNo", obj.TelephoneNo); } if (obj.FaxNo != null) { cmd.Parameters.AddWithValue("@FaxNo", obj.FaxNo); } else { cmd.Parameters.AddWithValue("@FaxNo", ""); } if (obj.EmailId != null) { cmd.Parameters.AddWithValue("@EmailId", obj.EmailId); } else { cmd.Parameters.AddWithValue("@EmailId", ""); } cmd.Parameters.AddWithValue("@CreationID", UserID); cmd.Parameters.AddWithValue("@ReferenceCode", ""); con.Open(); int i = cmd.ExecuteNonQuery(); con.Close(); if (i > 0) { return(true); } else { return(false); } }