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