public ActionResult GetPatientName(string prefix)
{
BL_PatientLabAppointment objPatient = new BL_PatientLabAppointment();
List <PatientLabAppointment> searchList = new List <PatientLabAppointment>();
DataSet ds1 = objPatient.GetPatient(prefix);
// int i = 0;
// string a = Session["chk"].ToString();
// if (chk == "false" || chk == "")
{
foreach (DataRow dr in ds1.Tables[0].Rows)
{
PatientLabAppointment Patient = new PatientLabAppointment();
Patient.PatientLabAppointmentID = dr["PatientLabAppointmentID"].ToString();
Patient.PatientName = dr["PatientName"].ToString();
Patient.AppointmentID = Convert.ToInt32(dr["AppointmentID"].ToString());
Patient.MobileNo = dr["MobileNo"].ToString();
Patient.DOB = Convert.ToDateTime(dr["DateOfBirth"]).ToString("dd-MM-yyyy");
Patient.Address = dr["Address"].ToString();
Patient.Gender = dr["Gender"].ToString();
searchList.Add(Patient);
}
}
return(new JsonResult {
Data = searchList, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult GetAllPatientLabAppointment()
{
BL_PatientLabAppointment objPatient = new BL_PatientLabAppointment();
List <PatientLabAppointment> searchList = new List <PatientLabAppointment>();
PatientLabAppointment catl = new PatientLabAppointment();
DataSet ds = objPatient.GetAllPatientLabAppointment();
foreach (DataRow dr in ds.Tables[0].Rows)
{
searchList.Add(new PatientLabAppointment
{
PatientLabAppointmentID = dr["PatientLabAppointmentID"].ToString(),
PatientName = dr["PatientName"].ToString(),
Address = dr["Address"].ToString(),
MobileNo = dr["MobileNo"].ToString(),
AppointmentDate = Convert.ToDateTime(dr["PatientLabAppointmentDate"]).ToString("dd-MM-yyyy"),
});
}
return(new JsonResult {
Data = searchList, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public DataSet GetNextAppointentID(PatientLabAppointment obj)
{
Connect();
DataSet ds = new DataSet();
try
{
SqlCommand cmd = new SqlCommand("GetNextAppointentID", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@HospitalID", HospitalID);
cmd.Parameters.AddWithValue("@LocationID", LocationID);
cmd.Parameters.AddWithValue("@PatientLabAppointmentID", 0);
con.Open();
SqlDataAdapter ad = new SqlDataAdapter(cmd);
ad.Fill(ds);
con.Close();
return(ds);
}
catch (Exception)
{
return(ds);
}
}
public JsonResult Edit(string PatientAppID)
{
BL_PatientLabAppointment obj = new BL_PatientLabAppointment();
List <PatientLabAppointment> SearchLabAppointment = new List <PatientLabAppointment>();
List <PatientLabAppointment> SearchLabAppointmentDetails = new List <PatientLabAppointment>();
PatientLabAppointment objGet = new PatientLabAppointment();
DataSet ds1 = obj.GetPatientLabAppointment(PatientAppID);
DataSet ds = obj.GetPatientLabAppointmentDetails(PatientAppID);
foreach (DataRow dr in ds1.Tables[0].Rows)
{
SearchLabAppointment.Add(new PatientLabAppointment
{
LocationId = Convert.ToInt32(dr["HospitalID"]),
HospitalId = Convert.ToInt32(dr["LocationID"]),
PatientLabAppointmentID = dr["PatientLabAppointmentID"].ToString(),
PrefixName = dr["PatientPrefixName"].ToString(),
PatientName = dr["PatientName"].ToString(),
GuardianName = dr["GuardianName"].ToString(),
Year = dr["Age"].ToString(),
AgeType = dr["AgeType"].ToString(),
DOB = Convert.ToDateTime(dr["DateOfBirth"]).ToString("yyyy-MM-dd"),
Gender = dr["Gender"].ToString(),
Address = dr["Address"].ToString(),
ConsultantDr = dr["ConsultantDr"].ToString(),
ConsultantDrID = dr["ConsultantDrID"].ToString(),
RefferedDr = dr["RefferredDr"].ToString(),
RefferedDrID = dr["RefferredDrID"].ToString(),
MobileNo = dr["MobileNo"].ToString(),
SampleCollectionBy = dr["SampleCollectedBy"].ToString(),
CollectionCentreName = dr["CollectionCentre"].ToString(),
AppointmentDate = Convert.ToDateTime(dr["PatientLabAppointmentDate"]).ToString("yyyy-MM-dd"),
CreationID = dr["CreationID"].ToString(),
Mode = dr["Mode"].ToString(),
});
}
foreach (DataRow dr in ds.Tables[0].Rows)
{
SearchLabAppointmentDetails.Add(new PatientLabAppointment
{
HospitalId = Convert.ToInt32(dr["HospitalID"]),
LocationId = Convert.ToInt32(dr["LocationID"]),
PatientLabAppointmentID = dr["PatientLabAppointmentID"].ToString(),
PatientLabAppointmentDetailID = dr["PatientLabAppointmentDetailID"].ToString(),
TestID = dr["TestID"].ToString(),
TestName = dr["TestName"].ToString(),
Rate = dr["Rate"].ToString(),
Quantity = dr["Quantity"].ToString(),
TotalAmount = dr["TotalAmount"].ToString(),
TestType = dr["TestType"].ToString(),
OrganizationName = dr["TPAWiseCollect"].ToString(),
CreationID = dr["CreationID"].ToString(),
Mode = dr["Mode"].ToString(),
});
}
return(Json(new { SearchLabAppointmentDetails = SearchLabAppointmentDetails, SearchLabAppointment = SearchLabAppointment }, JsonRequestBehavior.AllowGet));
}
public ActionResult GetNextAppointentID()
{
BL_PatientLabAppointment objPatient = new BL_PatientLabAppointment();
List <PatientLabAppointment> searchList = new List <PatientLabAppointment>();
PatientLabAppointment catl = new PatientLabAppointment();
string PatientLabAppointment = "";
PatientLabAppointment = objPatient.GetNextAppointentID(catl).Tables[0].Rows[0]["PatientLabAppointmentID"].ToString();
return(Json(PatientLabAppointment));
}
public ActionResult CollectionCentre(string prefix)
{
BL_PatientLabAppointment objPatient = new BL_PatientLabAppointment();
List <PatientLabAppointment> searchList = new List <PatientLabAppointment>();
DataSet ds = objPatient.CollectionCentreBind(prefix);
foreach (DataRow dr in ds.Tables[0].Rows)
{
PatientLabAppointment name = new PatientLabAppointment();
name.CollectionCentreID = dr["CollectionID"].ToString();
name.CollectionCentreName = dr["CollectionName"].ToString();
searchList.Add(name);
}
return(new JsonResult {
Data = searchList, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public ActionResult GetRefferedDoctor(string prefix)
{
BL_PatientLabAppointment objPatient = new BL_PatientLabAppointment();
List <PatientLabAppointment> searchList = new List <PatientLabAppointment>();
DataSet ds = objPatient.GetRefferedDoctor(prefix);
foreach (DataRow dr in ds.Tables[0].Rows)
{
PatientLabAppointment catl = new PatientLabAppointment();
catl.RefferedDrID = dr["DoctorID"].ToString();
catl.RefferedDr = dr["DoctorPrintName"].ToString();
searchList.Add(catl);
}
return(new JsonResult {
Data = searchList, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public ActionResult GetUser(string prefix)
{
BL_PatientLabAppointment objPatient = new BL_PatientLabAppointment();
List <PatientLabAppointment> searchList = new List <PatientLabAppointment>();
DataSet ds = objPatient.GetUser(prefix);
foreach (DataRow dr in ds.Tables[0].Rows)
{
PatientLabAppointment cat = new PatientLabAppointment();
cat.UserID = Convert.ToInt32(dr["UserID"].ToString());
cat.FullName = dr["FullName"].ToString();
searchList.Add(cat);
}
return(new JsonResult {
Data = searchList, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public ActionResult Package(string prefix)
{
BL_PatientLabAppointment objPatient = new BL_PatientLabAppointment();
List <PatientLabAppointment> searchList = new List <PatientLabAppointment>();
DataSet ds1 = objPatient.GetPackage(prefix);
foreach (DataRow dr in ds1.Tables[0].Rows)
{
PatientLabAppointment cat = new PatientLabAppointment();
cat.ProfileID = Convert.ToInt32(dr["TestID"].ToString());
cat.ProfileName = dr["TestName"].ToString();
cat.Rate = dr["Rate"].ToString();
searchList.Add(cat);
}
return(new JsonResult {
Data = searchList, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public ActionResult TestName(string prefix)
{
BL_PatientLabAppointment objPatient = new BL_PatientLabAppointment();
List <PatientLabAppointment> searchList = new List <PatientLabAppointment>();
DataSet ds = objPatient.GetTest(prefix);
int i = 0;
foreach (DataRow dr in ds.Tables[0].Rows)
{
PatientLabAppointment cat = new PatientLabAppointment();
cat.TestID = dr["TestID"].ToString().ToString();
cat.TestName = dr["TestName"].ToString();
cat.GeneralCharges = dr["GeneralCharges"].ToString();
cat.EmergencyCharges = dr["EmergencyCharges"].ToString();
searchList.Add(cat);
}
return(new JsonResult {
Data = searchList, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public ActionResult PatientLabAppointment(PatientLabAppointment obj, FormCollection collection)
{
BL_PatientLabAppointment _PatientLabAppointment = new BL_PatientLabAppointment();
if (obj.PatientLabAppointmentID != null)
{
obj.PatientLabAppointmentID = collection["PatientLabAppointmentID"].ToString();
}
else
{
obj.PatientLabAppointmentID = "";
}
if (obj.PatientLabAppointmentDetailID != null)
{
obj.PatientLabAppointmentDetailID = collection["PatientLabAppointmentDetailID"].ToString();
}
else
{
obj.PatientLabAppointmentDetailID = "";
}
if (obj.PrefixName == "")
{
obj.PrefixName = "";
}
else
{
obj.PrefixName = collection["PFPatientName"].ToString();
}
if (obj.PatientName == null || obj.PatientName == "")
{
obj.PatientName = "";
}
else
{
obj.PatientName = collection["PatientName"].ToString();
}
if (obj.MobileNo == null || obj.MobileNo == "")
{
obj.MobileNo = "";
}
else
{
obj.MobileNo = collection["MobileNo"].ToString();
}
if (obj.Address == null || obj.Address == "")
{
obj.Address = "";
}
else
{
obj.Address = collection["Address"].ToString();
}
if (obj.AppointmentDate == "")
{
obj.AppointmentDate = "";
}
else
{
obj.AppointmentDate = collection["AppointmentDate"].ToString();
}
//if ( obj.AppointmentTime == "0")
//{
// obj.AppointmentTime = "";
//}
//else
//{
// obj.AppointmentTime = collection["AppTime"].ToString();
//}
if (obj.ConsultantDr == "")
{
obj.ConsultantDr = "";
}
else
{
obj.ConsultantDr = collection["ConDR"].ToString();
}
if (obj.ConsultantDrID == "0")
{
obj.ConsultantDrID = "0";
}
else
{
obj.ConsultantDrID = collection["ConDRID"].ToString();
}
if (obj.RefferedDr == "")
{
obj.RefferedDr = "";
}
else
{
obj.RefferedDr = collection["ReffDR"].ToString();
}
if (obj.RefferedDrID == "0")
{
obj.RefferedDrID = "0";
}
else
{
obj.RefferedDrID = collection["ReffDRID"].ToString();
}
if (obj.DOB == null || obj.DOB == "")
{
obj.DOB = "";
}
else
{
obj.DOB = collection["DOB"].ToString();
}
if (obj.SampleCollectionBy == "")
{
obj.SampleCollectionBy = "";
}
else
{
obj.SampleCollectionBy = collection["SampleCollectBy"].ToString();
}
if (obj.Gender == null || obj.Gender == "")
{
obj.Gender = "";
}
else
{
obj.Gender = collection["Gender"].ToString();
}
if (obj.Year == null || obj.Year == "")
{
obj.Year = "0";
}
else
{
obj.Year = collection["Year"].ToString();
}
if (obj.CollectionCentreName == "")
{
obj.CollectionCentreName = "";
}
else
{
obj.CollectionCentreName = collection["CollectionCentre"].ToString();
}
if (obj.OrganizationName == "")
{
obj.OrganizationName = "";
}
else
{
obj.OrganizationName = collection["CompanyName"].ToString();
}
if (obj.GuardianName == null || obj.GuardianName == "")
{
obj.GuardianName = "";
}
else
{
obj.GuardianName = collection["GuardianName"].ToString();
}
obj.TestName = collection["TestNamerow"].ToString();
obj.TestID = collection["TesttableID"].ToString();
obj.Rate = collection["rate1"].ToString();
obj.Quantity = collection["Qty"].ToString();
obj.Mode = collection["mode"].ToString();
if (Request.Form["TotalAmt"] != null)
{
obj.TotalAmount = Request.Form["TotalAmt"].ToString();
}
else
{
obj.TotalAmount = Convert.ToDecimal(0.00).ToString();
}
obj.TestType = collection["ServiceType"].ToString();
if (_PatientLabAppointment.SaveTest(obj))
{
ModelState.Clear();
ViewData["flag"] = "Done";
}
else
{
ViewData["flag"] = "Error";
}
return(RedirectToAction("PatientLabAppointment", "PatientLabAppointment"));
}
public bool SaveTest(PatientLabAppointment obj)
{
Connect();
con.Open();
//string[] Add1 = obj.Mode.Split(',');
//string[] TestID = obj.TestID.Split(',');
//string[] Testname = obj.TestName.Split(',');
//string[] Rate = obj.Rate.Split(',');
//string[] Quantity = obj.Quantity.Split(',');
//string[] Total = obj.TotalAmount.Split(',');
//string[] TestType = obj.TestType.Split(',');
//string[] PatientLAbDetailID = obj.PatientLabAppointmentDetailID.Split(',');
//for (int row = 0; row < Add1.Length; row++)
//{
// if (Add1[row] == "Add")
// {
if (obj.PatientLabAppointmentID == "")
{
SqlCommand cmd = new SqlCommand("IUPatientLabAppointment", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@HospitalID", HospitalID);
cmd.Parameters.AddWithValue("@LocationID", LocationID);
//if (obj.PatientLabAppointmentID == null)
//{
cmd.Parameters.AddWithValue("@PatientLabAppointmentID", 0);
cmd.Parameters["@PatientLabAppointmentID"].Direction = ParameterDirection.Output;
cmd.Parameters.AddWithValue("@Mode", "Add");
//}
//else
//{
// cmd.Parameters.AddWithValue("@PatientLabAppointmentID", obj.PatientLabAppointmentID);
// cmd.Parameters.AddWithValue("@Mode", "Edit");
//}
cmd.Parameters.AddWithValue("@PatientPrefixName", obj.PrefixName);
cmd.Parameters.AddWithValue("@PatientName", obj.PatientName);
cmd.Parameters.AddWithValue("@GuardianName", obj.GuardianName);
cmd.Parameters.AddWithValue("@Age", obj.Year);
cmd.Parameters.AddWithValue("@AgeType", "Year");
cmd.Parameters.AddWithValue("@DateOfBirth", obj.DOB);
cmd.Parameters.AddWithValue("@Gender", obj.Gender);
cmd.Parameters.AddWithValue("@MobileNo", obj.MobileNo);
cmd.Parameters.AddWithValue("@Address", obj.Address);
cmd.Parameters.AddWithValue("@ConsultantDr", obj.ConsultantDr);
cmd.Parameters.AddWithValue("@ConsultantDrID", obj.ConsultantDrID);
cmd.Parameters.AddWithValue("@RefferredDr", obj.RefferedDr);
cmd.Parameters.AddWithValue("@RefferredDrID", obj.RefferedDrID);
cmd.Parameters.AddWithValue("@SampleCollectedBy", obj.SampleCollectionBy);
cmd.Parameters.AddWithValue("@CollectionCentre", obj.CollectionCentreName);
cmd.Parameters.AddWithValue("@PatientLabAppointmentDate", obj.AppointmentDate);
cmd.Parameters.AddWithValue("@CreationID", UserID);
//con.Open();
int i = cmd.ExecuteNonQuery();
obj.PatientLabAppointmentID = (cmd.Parameters["@PatientLabAppointmentID"].Value).ToString();
con.Close();
if (i > 0)
{
string[] TestID = obj.TestID.Split(',');
string[] Testname = obj.TestName.Split(',');
string[] Rate = obj.Rate.Split(',');
string[] Quantity = obj.Quantity.Split(',');
string[] Total = obj.TotalAmount.Split(',');
string[] TestType = obj.TestType.Split(',');
for (int row2 = 0; row2 < TestID.Length; row2++)
{
SqlCommand cmd1 = new SqlCommand("IUPatientLabAppointmentDetails", con);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@HospitalID", HospitalID);
cmd1.Parameters.AddWithValue("@LocationID", LocationID);
cmd1.Parameters.AddWithValue("@PatientLabAppointmentDetailID", 0);
cmd1.Parameters.AddWithValue("@Mode", "Add");
cmd1.Parameters.AddWithValue("@PatientLabAppointmentID", obj.PatientLabAppointmentID);
cmd1.Parameters.AddWithValue("@TestID", TestID[row2]);
cmd1.Parameters.AddWithValue("@TestName", Testname[row2]);
cmd1.Parameters.AddWithValue("@Rate", Rate[row2]);
cmd1.Parameters.AddWithValue("@Quantity", Quantity[row2]);
cmd1.Parameters.AddWithValue("@TotalAmount", Total[row2]);
cmd1.Parameters.AddWithValue("@TestType", TestType[row2]);
cmd1.Parameters.AddWithValue("@TPAWiseCollect", obj.OrganizationName);
cmd1.Parameters.AddWithValue("@CreationID", UserID);
con.Open();
int j = cmd1.ExecuteNonQuery();
con.Close();
}
}
}
else
{
SqlCommand cmd = new SqlCommand("IUPatientLabAppointment", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@HospitalID", HospitalID);
cmd.Parameters.AddWithValue("@LocationID", LocationID);
cmd.Parameters.AddWithValue("@PatientLabAppointmentID", obj.PatientLabAppointmentID);
cmd.Parameters.AddWithValue("@Mode", "Edit");
cmd.Parameters.AddWithValue("@PatientPrefixName", obj.PrefixName);
cmd.Parameters.AddWithValue("@PatientName", obj.PatientName);
cmd.Parameters.AddWithValue("@GuardianName", obj.GuardianName);
cmd.Parameters.AddWithValue("@Age", obj.Year);
cmd.Parameters.AddWithValue("@AgeType", "Year");
cmd.Parameters.AddWithValue("@DateOfBirth", obj.DOB);
cmd.Parameters.AddWithValue("@Gender", obj.Gender);
cmd.Parameters.AddWithValue("@MobileNo", obj.MobileNo);
cmd.Parameters.AddWithValue("@Address", obj.Address);
cmd.Parameters.AddWithValue("@ConsultantDr", obj.ConsultantDr);
cmd.Parameters.AddWithValue("@ConsultantDrID", obj.ConsultantDrID);
cmd.Parameters.AddWithValue("@RefferredDr", obj.RefferedDr);
cmd.Parameters.AddWithValue("@RefferredDrID", obj.RefferedDrID);
cmd.Parameters.AddWithValue("@SampleCollectedBy", obj.SampleCollectionBy);
cmd.Parameters.AddWithValue("@CollectionCentre", obj.CollectionCentreName);
cmd.Parameters.AddWithValue("@PatientLabAppointmentDate", obj.AppointmentDate);
cmd.Parameters.AddWithValue("@CreationID", UserID);
int i = cmd.ExecuteNonQuery();
obj.PatientLabAppointmentID = (cmd.Parameters["@PatientLabAppointmentID"].Value).ToString();
con.Close();
string[] TestID = obj.TestID.Split(',');
string[] Testname = obj.TestName.Split(',');
string[] Rate = obj.Rate.Split(',');
string[] Quantity = obj.Quantity.Split(',');
string[] Total = obj.TotalAmount.Split(',');
string[] TestType = obj.TestType.Split(',');
string[] PatientLAbDetailID = obj.PatientLabAppointmentDetailID.Split(',');
for (int row1 = 0; row1 < TestID.Length; row1++)
{
SqlCommand cmd1 = new SqlCommand("IUPatientLabAppointmentDetails", con);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@HospitalID", HospitalID);
cmd1.Parameters.AddWithValue("@LocationID", LocationID);
if (PatientLAbDetailID[row1] == "")
{
cmd1.Parameters.AddWithValue("@PatientLabAppointmentDetailID", 0);
cmd1.Parameters.AddWithValue("@Mode", "Add");
}
else
{
cmd1.Parameters.AddWithValue("@PatientLabAppointmentDetailID", PatientLAbDetailID[row1]);
cmd1.Parameters.AddWithValue("@Mode", "Edit");
}
cmd1.Parameters.AddWithValue("@PatientLabAppointmentID", obj.PatientLabAppointmentID);
cmd1.Parameters.AddWithValue("@TestID", TestID[row1]);
cmd1.Parameters.AddWithValue("@TestName", Testname[row1]);
cmd1.Parameters.AddWithValue("@Rate", Rate[row1]);
cmd1.Parameters.AddWithValue("@Quantity", Quantity[row1]);
cmd1.Parameters.AddWithValue("@TotalAmount", Total[row1]);
cmd1.Parameters.AddWithValue("@TPAWiseCollect", obj.OrganizationName);
cmd1.Parameters.AddWithValue("@TestType", TestType[row1]);
cmd1.Parameters.AddWithValue("@CreationID", UserID);
con.Open();
int j = cmd1.ExecuteNonQuery();
con.Close();
}
}
// }
return(true);
}
