public List <DentalExamination> DeleteDentalExamination(int Id, int QueueId, string TableName)
{
try
{
SqlParameter[] sqlparam;
sqlparam = new SqlParameter[4];
sqlparam[0] = new SqlParameter("@flag", 5);
sqlparam[1] = new SqlParameter("@Id", Id);
sqlparam[2] = new SqlParameter("@QueueId", QueueId);
sqlparam[3] = new SqlParameter("@TableName", TableName);
DataTable ds = CommonFunction.GetDataTable("USP_delete_Precription", sqlparam, "");
List <DentalExamination> lstDE = new List <DentalExamination>();
DentalExamination objDE = new DentalExamination();
if (ds != null && ds.Rows.Count > 0)
{
DataTable dt = ds;
foreach (DataRow dr in dt.Rows)
{
DentalExamination Model = new DentalExamination();
CommonFunction.ReflectSingleData(Model, dr);
lstDE.Add(Model);
}
}
return(lstDE);
}
catch (Exception Ex)
{
throw Ex;
}
}
public ActionResult GetColorcode(string btnColorcode)
{
try
{
PatientAllDetails patientDETAILS = (PatientAllDetails)Session["patientDetails"];
DentalExamination MD = new DentalExamination();
Session["btnColorcode"] = btnColorcode;
//if (Session["PageDetails"] == null)
//{
// MD = BM.GetDentalExamination(patientDETAILS.QueueId, patientDETAILS.CasePapaerNo, "A");
// return View("DentalExaminationPage", MD);
//}
//else
//{
// if (Session["PageDetails"].ToString() == "A")
// {
// MD = BM.GetDentalExamination(patientDETAILS.QueueId, patientDETAILS.CasePapaerNo, "A");
// return View("DentalExaminationPage", MD);
// }
// else if (Session["PageDetails"].ToString() == "P")
// {
// MD = BM.GetDentalExamination(patientDETAILS.QueueId, patientDETAILS.CasePapaerNo, "P");
// return View("DentalExaminationPage", MD);
// }
//}
//return View("DentalExaminationPage", MD);
return(View());
}
catch (Exception)
{
throw;
}
}
public int SaveAdultDetails(DentalExamination DE)
{
try
{
SqlParameter[] sqlparam;
sqlparam = new SqlParameter[43];
sqlparam[0] = new SqlParameter("@Id", DE.Id);
sqlparam[1] = new SqlParameter("@T1", DE.T1);
sqlparam[2] = new SqlParameter("@T2", DE.T2);
sqlparam[3] = new SqlParameter("@T3", DE.T3);
sqlparam[4] = new SqlParameter("@T4", DE.T4);
sqlparam[5] = new SqlParameter("@T5", DE.T5);
sqlparam[6] = new SqlParameter("@T6", DE.T6);
sqlparam[7] = new SqlParameter("@T7", DE.T7);
sqlparam[8] = new SqlParameter("@T8", DE.T8);
sqlparam[9] = new SqlParameter("@T9", DE.T9);
sqlparam[10] = new SqlParameter("@T10", DE.T10);
sqlparam[11] = new SqlParameter("@T11", DE.T11);
sqlparam[12] = new SqlParameter("@T12", DE.T12);
sqlparam[13] = new SqlParameter("@T13", DE.T13);
sqlparam[14] = new SqlParameter("@T14", DE.T14);
sqlparam[15] = new SqlParameter("@T15", DE.T15);
sqlparam[16] = new SqlParameter("@T16", DE.T16);
sqlparam[17] = new SqlParameter("@T17", DE.T17);
sqlparam[18] = new SqlParameter("@T18", DE.T18);
sqlparam[19] = new SqlParameter("@T19", DE.T19);
sqlparam[20] = new SqlParameter("@T20", DE.T20);
sqlparam[21] = new SqlParameter("@T21", DE.T21);
sqlparam[22] = new SqlParameter("@T22", DE.T22);
sqlparam[23] = new SqlParameter("@T23", DE.T23);
sqlparam[24] = new SqlParameter("@T24", DE.T24);
sqlparam[25] = new SqlParameter("@T25", DE.T25);
sqlparam[26] = new SqlParameter("@T26", DE.T26);
sqlparam[27] = new SqlParameter("@T27", DE.T27);
sqlparam[28] = new SqlParameter("@T28", DE.T28);
sqlparam[29] = new SqlParameter("@T29", DE.T29);
sqlparam[30] = new SqlParameter("@T30", DE.T30);
sqlparam[31] = new SqlParameter("@T31", DE.T31);
sqlparam[32] = new SqlParameter("@T32", DE.T32);
sqlparam[33] = new SqlParameter("@ColorCode", DE.ColorCode);
sqlparam[34] = new SqlParameter("@ToothProcedure", DE.ToothProcedure);
sqlparam[35] = new SqlParameter("@Amount", DE.Amount);
sqlparam[36] = new SqlParameter("@Notes", DE.Notes);
sqlparam[37] = new SqlParameter("@CasePaperNo", DE.CasePaperNo);
sqlparam[38] = new SqlParameter("@HospitalId", DE.HospitalId);
sqlparam[39] = new SqlParameter("@PatientId", DE.PatientId);
sqlparam[40] = new SqlParameter("@CreatedBy", DE.CreatedBy);
sqlparam[41] = new SqlParameter("@QueueId", DE.QueueId);
sqlparam[42] = new SqlParameter("@CreatedDate", DateTime.Parse(DE.CreatedDate));
return(CommonFunction.Save("USP_D_ManageAdultDetails", sqlparam, ""));
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult DentalExaminationPage()
{
PatientAllDetails patientDETAILS = (PatientAllDetails)Session["patientDetails"];
DentalExamination MD = new DentalExamination();
//Load lime always null not requird get data
// Adult
//Adult
if (Session["PageDetails"] == null)
{
MD = BM.GetDentalExamination(patientDETAILS.QueueId, patientDETAILS.CasePapaerNo, "A");
}
else
{
if (Session["PageDetails"].ToString() == "A")
{
MD = BM.GetDentalExamination(patientDETAILS.QueueId, patientDETAILS.CasePapaerNo, "A");
}
else if (Session["PageDetails"].ToString() == "P")
{
MD = BM.GetDentalExamination(patientDETAILS.QueueId, patientDETAILS.CasePapaerNo, "P");
}
}
//foreach (var item in MD)
//{
// item.CpExpiryDate = Convert.ToDateTime(item.\).Date.ToString("dd/MM/yyyy");
//}
return(View("DentalExaminationPage", MD));
//return View("DentalExaminationPage");
}
//public int SavePage(AdultDetails PD)
//{
// try
// {
// SqlParameter[] sqlparam;
// sqlparam = new SqlParameter[24];
// sqlparam[0] = new SqlParameter("@Id", PD.Id);
// sqlparam[1] = new SqlParameter("@PatientName", PD.PatientName);
// sqlparam[2] = new SqlParameter("@Gender", PD.Gender);
// if (PD.DOB == null)
// {
// sqlparam[3] = new SqlParameter("@DOB", DBNull.Value);
// }
// else
// {
// sqlparam[3] = new SqlParameter("@DOB", DateTime.ParseExact(PD.DOB, "dd/MM/yyyy", CultureInfo.InvariantCulture));
// }
// //if (PD.DOB.ToString() == "1/1/0001 12:00:00 AM")
// //{
// // PD.DOB = "01/01/9999";
// // sqlparam[3] = new SqlParameter("@DOB", PD.DOB);
// //}
// //else
// //{
// //}
// sqlparam[4] = new SqlParameter("@Age", PD.Age);
// sqlparam[5] = new SqlParameter("@MaritalStatus", PD.MaritalStatus);
// sqlparam[6] = new SqlParameter("@BloodGroup", PD.BloodGroup);
// sqlparam[7] = new SqlParameter("@WhatsAppNo", PD.WhatsAppNo);
// sqlparam[8] = new SqlParameter("@OtherNo", PD.OtherNo);
// sqlparam[9] = new SqlParameter("@EmailId", PD.EmailId);
// sqlparam[10] = new SqlParameter("@Address", PD.Address);
// sqlparam[11] = new SqlParameter("@ReferedByDoctor", PD.ReferedByDoctor);
// sqlparam[12] = new SqlParameter("@DoctorAddress", PD.DoctorAddress);
// sqlparam[13] = new SqlParameter("@MediClmCompany", PD.MediClmCompany);
// if (PD.AppliedForMediclam == "true")
// {
// sqlparam[14] = new SqlParameter("@AppliedForMediclam", "1");
// }
// else
// {
// sqlparam[14] = new SqlParameter("@AppliedForMediclam", "0");
// }
// sqlparam[15] = new SqlParameter("@CasePaperFees", PD.CasePaperFees);
// sqlparam[16] = new SqlParameter("@Role", PD.Role);
// sqlparam[17] = new SqlParameter("@HospitalId", PD.HospitalId);
// sqlparam[18] = new SqlParameter("@DoctorReceptionId", PD.DoctorReceptionId);
// sqlparam[19] = new SqlParameter("@CreatedBy", PD.CreatedBy);
// sqlparam[20] = new SqlParameter("@CasePapaerNo", PD.CasePapaerNo);
// sqlparam[21] = new SqlParameter("@IsActive", 1);
// sqlparam[22] = new SqlParameter("@HospitlName", PD.HospitalName);
// //if (PD.CpExpiryDate.ToString() == "1/1/0001 12:00:00 AM" || PD.CpExpiryDate ==null)
// //{
// // PD.CpExpiryDate = Convert.ToString("01/01/9999");
// // sqlparam[23] = new SqlParameter("@CpExpiryDate", PD.CpExpiryDate);
// //}
// //else
// //{
// // }
// if (PD.CpExpiryDate == null)
// {
// sqlparam[23] = new SqlParameter("@CpExpiryDate", DBNull.Value);
// }
// else
// {
// sqlparam[23] = new SqlParameter("@CpExpiryDate", DateTime.ParseExact(PD.CpExpiryDate, "dd/MM/yyyy", CultureInfo.InvariantCulture));
// }
// return CommonFunction.Save("USP_ManagePatientDetails", sqlparam, "");
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
public int SavePediatricDetails(DentalExamination DE)
{
try
{
SqlParameter[] sqlparam;
sqlparam = new SqlParameter[31];
sqlparam[0] = new SqlParameter("@Id", DE.Id);
sqlparam[1] = new SqlParameter("@A", DE.A);
sqlparam[2] = new SqlParameter("@B", DE.B);
sqlparam[3] = new SqlParameter("@C", DE.C);
sqlparam[4] = new SqlParameter("@D", DE.D);
sqlparam[5] = new SqlParameter("@E", DE.E);
sqlparam[6] = new SqlParameter("@F", DE.F);
sqlparam[7] = new SqlParameter("@G", DE.G);
sqlparam[8] = new SqlParameter("@H", DE.H);
sqlparam[9] = new SqlParameter("@I", DE.I);
sqlparam[10] = new SqlParameter("@J", DE.J);
sqlparam[11] = new SqlParameter("@K", DE.K);
sqlparam[12] = new SqlParameter("@L", DE.L);
sqlparam[13] = new SqlParameter("@M", DE.M);
sqlparam[14] = new SqlParameter("@N", DE.N);
sqlparam[15] = new SqlParameter("@O", DE.O);
sqlparam[16] = new SqlParameter("@P", DE.P);
sqlparam[17] = new SqlParameter("@Q", DE.Q);
sqlparam[18] = new SqlParameter("@R", DE.R);
sqlparam[19] = new SqlParameter("@S", DE.S);
sqlparam[20] = new SqlParameter("@T", DE.T);
sqlparam[21] = new SqlParameter("@ColorCode", DE.ColorCode);
sqlparam[22] = new SqlParameter("@ToothProcedure", DE.ToothProcedure);
sqlparam[23] = new SqlParameter("@Amount", DE.Amount);
sqlparam[24] = new SqlParameter("@Notes", DE.Notes);
sqlparam[25] = new SqlParameter("@CasePaperNo", DE.CasePaperNo);
sqlparam[26] = new SqlParameter("@HospitalId", DE.HospitalId);
sqlparam[27] = new SqlParameter("@PatientId", DE.PatientId);
sqlparam[28] = new SqlParameter("@CreatedBy", DE.CreatedBy);
sqlparam[29] = new SqlParameter("@QueueId", DE.QueueId);
sqlparam[30] = new SqlParameter("@CreatedDate", DE.CreatedDate);
return(CommonFunction.Save("USP_D_ManagePediaticDetails", sqlparam, ""));
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult PageSwitch(string Page)
{
try
{
PatientAllDetails patientDETAILS = (PatientAllDetails)Session["patientDetails"];
BAL_MyOPD BL = new BAL_MyOPD();
List <DentalExamination> ObjLST = new List <DentalExamination>();
DentalExamination MD = new DentalExamination();
//Session["btnColorcode"] = Page;
if (Page == null)
{
MD = BM.GetDentalExamination(patientDETAILS.QueueId, patientDETAILS.CasePapaerNo, "A");
//return View("DentalExaminationPage", MD);
}
else
{
if (Page == "A")
{
MD = BM.GetDentalExamination(patientDETAILS.QueueId, patientDETAILS.CasePapaerNo, "A");
//return View("DentalExaminationPage", MD);
}
else if (Page == "P")
{
MD = BM.GetDentalExamination(patientDETAILS.QueueId, patientDETAILS.CasePapaerNo, "P");
//return View("DentalExaminationPage", MD);
}
}
if (MD.lst.Count > 0)
{
foreach (var item in MD.lst)
{
item.CreatedDate = Convert.ToDateTime(item.CreatedDate).Date.ToString("dd/MM/yyyy");
}
}
//return View("DentalExaminationPage", MD);
return(Json(MD.lst, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
throw;
}
}
public DentalExamination GetDentalExamination(int QueueId, string CPno, string TableName)
{
try
{
SqlParameter[] sqlparam;
sqlparam = new SqlParameter[4];
sqlparam[0] = new SqlParameter("@flag", 9);
sqlparam[1] = new SqlParameter("@QueueId", QueueId);
sqlparam[2] = new SqlParameter("@CPno", CPno);
sqlparam[3] = new SqlParameter("@TableName", TableName);
DataTable ds = CommonFunction.GetDataTable("USP_Get_Precription", sqlparam, "");
DentalExamination Ob = new DentalExamination();
List <DentalExamination> lst = new List <DentalExamination>();
if (ds != null && ds.Rows.Count > 0)
{
DataTable dt = ds;
foreach (DataRow dr in dt.Rows)
{
DentalExamination Model = new DentalExamination();
CommonFunction.ReflectSingleData(Model, dr);
//if (Model.ColorCode == "1")
//{
// Model.ColorCode = "Red";
//}
// Ob = Model;
lst.Add(Model);
}
}
// return lst;
Ob.lst = lst;
return(Ob);
}
catch (Exception Ex)
{
throw Ex;
}
}
public ActionResult SaveDentalPage(int Id, string CreatedDate, string ToothProcedure, string Amount, string Notes)
{
List <DentalExamination> oblist = new List <DentalExamination>();
try
{
PatientAllDetails patientDETAILS = (PatientAllDetails)Session["patientDetails"];
List <DentalExamination> lst = new List <DentalExamination>();
Bal_Precription BL = new Bal_Precription();
string img = Session["Toothno"].ToString();
if (img == null)
{
//ScriptManager.RegisterClientScriptBlock(, this.GetType(), "alertMessage", "alert('Record Inserted Successfully')", true);
return(View("DentalExaminationPage"));
}
if (CreatedDate == null)
{
return(View("DentalExaminationPage"));
}
if (ToothProcedure == null)
{
return(View("DentalExaminationPage"));
}
if (Amount == null)
{
return(View("DentalExaminationPage"));
}
else if (Notes == null)
{
return(View("DentalExaminationPage"));
}
//DentalExamination
img = img.Substring(3, img.Length - 3);
string btnColorcode = Session["btnColorcode"].ToString();
DE.ColorCode = btnColorcode.ToString();
Session["CreatedDate"] = Convert.ToDateTime(CreatedDate);
Session["ToothProcedure"] = ToothProcedure;
Session["Amount"] = Amount;
Session["Notes"] = Notes;
DE.CreatedDate = Convert.ToDateTime(CreatedDate).Date.ToString("dd/MM/yyyy");
DE.ToothProcedure = ToothProcedure;
DE.Amount = Amount;
DE.Notes = Notes;
DE.QueueId = patientDETAILS.QueueId;
DE.HospitalId = patientDETAILS.HospitalId;
DE.CasePaperNo = patientDETAILS.CasePapaerNo;
DE.PatientId = patientDETAILS.Id;
DE.CreatedBy = patientDETAILS.DoctorReceptionId;
DE.Id = Id;
if (Session["PageDetails"].ToString() == "A")
{
AdultToothNumberSet();
int Flag = BL.SaveAdultDetails(DE);
// BAL_MyOPD BM = new BAL_MyOPD();
// int Flag = BM.GetDentalExamination(DE);
if (Flag > 0)
{
DentalExamination objDE = new DentalExamination();
objDE = BM.GetDentalExamination(patientDETAILS.QueueId, patientDETAILS.CasePapaerNo, "A");
oblist = objDE.lst;
if (oblist.Count > 0)
{
foreach (var item in oblist)
{
item.CreatedDate = Convert.ToDateTime(item.CreatedDate).Date.ToString("dd/MM/yyyy");
}
}
return(Json(oblist, JsonRequestBehavior.AllowGet));
}
else
{
return(Json("", JsonRequestBehavior.AllowGet));
}
//Bal_Precription bp = new Bal_Precription();
//AdultDetails pd = new AdultDetails();
//pd.T12 = img;
//pd = bp.SavePage(pd);
//return View();
// return View("DentalExamination", lstObservation);
}
else if (Session["PageDetails"].ToString() == "P")
{
PediatricToothNumberSet();
int Flag = BL.SavePediatricDetails(DE);
// BAL_MyOPD BM = new BAL_MyOPD();
// int Flag = BM.GetDentalExamination(DE);
if (Flag > 0)
{
DentalExamination objDE = new DentalExamination();
objDE = BM.GetDentalExamination(patientDETAILS.QueueId, patientDETAILS.CasePapaerNo, "P");
oblist = objDE.lst;
if (oblist.Count > 0)
{
foreach (var item in oblist)
{
item.CreatedDate = Convert.ToDateTime(item.CreatedDate).Date.ToString("dd/MM/yyyy");
}
}
return(Json(oblist, JsonRequestBehavior.AllowGet));
}
else
{
return(Json("", JsonRequestBehavior.AllowGet));
}
}
return(Json(oblist, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
throw ex;
}
}
public int SavePediatricDetails(DentalExamination de)
{
return(DP.SavePediatricDetails(de));
}
public int SaveAdultDetails(DentalExamination de)
{
return(DP.SaveAdultDetails(de));
}
