public List <ChiefComplaint> GetChiefComplaints()
{
MySqlConnection Con = new MySqlConnection(ConfigurationManager.ConnectionStrings["gvkemricon"].ConnectionString);
MySqlCommand Cmd = null;
MySqlDataReader dr = null;
using (Con)
{
Con.Open();
Cmd = new MySqlCommand("SELECT * FROM m_chief_complaint ORDER BY chief_complaint_name ASC", Con);
Cmd.CommandType = CommandType.Text;
dr = Cmd.ExecuteReader();
List <ChiefComplaint> chiefComplaints = new List <ChiefComplaint>();
while (dr.Read())
{
ChiefComplaint complaint = new ChiefComplaint();
complaint.ChiefComplaintId = Convert.ToInt16(dr["chief_complaint_id"]);
complaint.Complaint = dr["chief_complaint_name"].ToString();
complaint.IsValid = Convert.ToBoolean(dr["is_active"]);
chiefComplaints.Add(complaint);
}
Con.Close();
return(chiefComplaints);
}
}
public ActionResult ChiefComplaint(ChiefComplaint objChiefCompliant)
{
try
{
if (obj.CheckChiefComplaint(objChiefCompliant.ChiefComplaintID, objChiefCompliant.ChiefComplaintName))
{
if (objChiefCompliant.ChiefComplaintID > 0)
{
if (obj.Save(objChiefCompliant))
{
TempData["msg"] = "Chief Complaint Updated Successfully";
}
}
else
{
if (obj.Save(objChiefCompliant))
{
TempData["msg"] = "Chief Complaint Saved Successfully";
}
}
}
else
{
TempData["msg"] = "Chief Complaint Already Exist's";
}
return(RedirectToAction("ChiefComplaint", "ChiefComplaint"));
}
catch (Exception Ex)
{
TempData["msg"] = Ex.Message;
return(RedirectToAction("ChiefComplaint", "ChiefComplaint"));
}
}
public bool Save(ChiefComplaint obj)
{
Connect();
SqlCommand cmd = new SqlCommand("IUChiefComplaint", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@HospitalID", HospitalID);
cmd.Parameters.AddWithValue("@LocationID", LocationID);
if (obj.ChiefComplaintID == 0)
{
cmd.Parameters.AddWithValue("@ChiefComplaintID", 0);
cmd.Parameters.AddWithValue("@Mode", "Add");
}
else
{
cmd.Parameters.AddWithValue("@ChiefComplaintID", obj.ChiefComplaintID);
cmd.Parameters.AddWithValue("@Mode", "Edit");
}
cmd.Parameters.AddWithValue("@ChiefComplaint", obj.ChiefComplaintName);
if (obj.ReferenceCode == null)
{
cmd.Parameters.AddWithValue("@ReferenceCode", string.Empty);
}
else
{
cmd.Parameters.AddWithValue("@ReferenceCode", obj.ReferenceCode);
}
if (obj.ChiefComplaintDescription == null)
{
cmd.Parameters.AddWithValue("@ChiefComplaintDescription", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@ChiefComplaintDescription", obj.ChiefComplaintDescription);
}
cmd.Parameters.AddWithValue("@CreationID", UserID);
con.Open();
int i = cmd.ExecuteNonQuery();
con.Close();
if (i > 0)
{
return(true);
}
else
{
return(false);
}
}
