public CascadingDropDownNameValue[] GetDentalAdvice(string knownCategoryValues, string category)
{
ORM.OnLinePrescriptionDataContext oOPresDataContext = new ORM.OnLinePrescriptionDataContext();
oOPresDataContext.ObjectTrackingEnabled = false;
IEnumerable<CascadingDropDownNameValue> vals = null;
vals = (from Relationships in oOPresDataContext.lkp_DentalAdvices
select new CascadingDropDownNameValue
{
name = Relationships.DADesc,
value = Relationships.DACode.ToString(),
}).OrderBy(t => t.name);
return vals.ToArray<CascadingDropDownNameValue>();
}
public static string GetChiefComplaince2()
{
ORM.OnLinePrescriptionDataContext oOPresDataContext = new ORM.OnLinePrescriptionDataContext();
oOPresDataContext.ObjectTrackingEnabled = false;
var ChiefComp = (from ChiefCom in oOPresDataContext.lkp_ChiefComplainces
where ChiefCom.CCGroup != null
select new CascadingDropDownNameValue
{
name = ChiefCom.CCDesc,
value = ChiefCom.CCCode.ToString(),
}).OrderBy(t => t.name);
JavaScriptSerializer oJSS = new JavaScriptSerializer();
return oJSS.Serialize(ChiefComp);
}
public CascadingDropDownNameValue[] GetChiefComplaince(string knownCategoryValues, string category)
{
ORM.OnLinePrescriptionDataContext oOPresDataContext = new ORM.OnLinePrescriptionDataContext();
oOPresDataContext.ObjectTrackingEnabled = false;
IEnumerable<CascadingDropDownNameValue> vals = null;
//short targetID = 0;
ORM.lkp_ChiefComplaince olkp_ChiefComplaince = new ORM.lkp_ChiefComplaince();
vals = (from ChiefCom in oOPresDataContext.lkp_ChiefComplainces
where ChiefCom.CCGroup != null
select new CascadingDropDownNameValue
{
name = ChiefCom.CCDesc,
value = ChiefCom.CCCode.ToString(),
}).OrderBy(t => t.name);
return vals.ToArray<CascadingDropDownNameValue>();
}
public static object GetPatientInfo(string PatienID)
{
ORM.OnLinePrescriptionDataContext oOPresDataContext = new ORM.OnLinePrescriptionDataContext();
oOPresDataContext.ObjectTrackingEnabled = false;
//Date calculation*****************************************
var pDOB = (from age in oOPresDataContext.PatientBasicInfos
where age.PatientID.Equals(PatienID)
select age.DateOfBirth).SingleOrDefault();
DateTime PatienceDOB = Convert.ToDateTime(pDOB);
DateTime today = DateTime.Now;
var totalDays = (today - PatienceDOB).TotalDays;
var totalYears = Math.Truncate(totalDays / 365);
var totalMonths = Math.Truncate((totalDays % 365) / 30);
var remainingDays = Math.Truncate((totalDays % 365) % 30);
string strFinalAge = totalYears + "y-" + totalMonths + "m-" + remainingDays + "d";
//End Date calculation*****************************************
var PatientInfo = from Patience in oOPresDataContext.PatientBasicInfos
where
Patience.PatientID == PatienID
select new
{
Relationship = Patience.RelCode,
PatientName = Patience.PatientName,
PatientSex = Patience.Gender,
PatientAge = strFinalAge.ToString()
};
JavaScriptSerializer oJSS = new JavaScriptSerializer();
return oJSS.Serialize(PatientInfo);
}
protected void btnSave_Click(object sender, EventArgs e)
{
ORM.OnLinePrescriptionDataContext oOnLinePrescriptionDataContext = new ORM.OnLinePrescriptionDataContext();
PatientBasicInfo oPatietnBasicInfo = new PatientBasicInfo();
//PatientID,RegistrationDt,PatientType,StudyName,StudyID,EmployeeID,RelCode,PatientName,MaritalStatus,Gender,
oPatietnBasicInfo.RegistrationDt = DateTime.Now;
oPatietnBasicInfo.PatientType = byte.Parse(ddlPatientType.SelectedValue);
if (byte.Parse(ddlPatientType.SelectedValue) == 2)
{
oPatietnBasicInfo.StudyName = ddlStudyName.SelectedValue;
oPatietnBasicInfo.StudyID = txtStudyPatientId.Text;
}
else if (byte.Parse(ddlPatientType.SelectedValue) == 3)
oPatietnBasicInfo.StudyID = txtEmployeeId.Text;
if (txtEmployeeId.Enabled == true)
oPatietnBasicInfo.EmployeeID = txtEmployeeId.Text;
else
oPatietnBasicInfo.EmployeeID = null;
oPatietnBasicInfo.RelCode = byte.Parse(ddlRelationship.SelectedValue);
oPatietnBasicInfo.PatientName = txtPatientName.Text;
oPatietnBasicInfo.MaritalStatus = byte.Parse(ddlMaritalStatus.SelectedValue);
oPatietnBasicInfo.Gender = byte.Parse(ddlSex.SelectedValue);
//SpouseName,FatherName,MotherName,DateOfBirth,NationalID,ContactNo,AreaCode,PDistrict,PThana,PUnion,
oPatietnBasicInfo.SpouseName = txtSpouseName.Text;
oPatietnBasicInfo.FatherName = txtFathersName.Text;
oPatietnBasicInfo.MotherName = txtMothersName.Text;
//DateOfBirth
if (chkDOB.Checked)
oPatietnBasicInfo.DateOfBirth = RdpDOB.SelectedDate;
else
{
int AgeTotalDays;
AgeTotalDays = int.Parse(RNtxtAgeMonth.Text) * 30 + int.Parse(RNtxtAgeDay.Text) + int.Parse(RNtxtAgeYear.Text) * 365;
oPatietnBasicInfo.DateOfBirth = DateTime.Now.AddDays(-AgeTotalDays);
}
//DateOfBirth
oPatietnBasicInfo.NationalID = txtNID.Text;
oPatietnBasicInfo.ContactNo = txtMobile.Text;
var varAreaCode = (from lkpAreDet in oOnLinePrescriptionDataContext.lkp_AreaDetails
where lkpAreDet.DistCode.Equals(ddlDistrict.SelectedValue) &&
lkpAreDet.ThanaCode.Equals(ddlThana.SelectedValue)
select lkpAreDet.AreaCode).SingleOrDefault();
oPatietnBasicInfo.AreaCode = varAreaCode;
oPatietnBasicInfo.PDistrict = ddlDistrict.SelectedValue;
oPatietnBasicInfo.PThana = ddlThana.SelectedValue;
oPatietnBasicInfo.PUnion = txtUnion.Text;
//PVillage,PAddress,RegistrationFee,MedDiscount,TestDiscount,Remarks
oPatietnBasicInfo.PVillage = txtVillage.Text;
oPatietnBasicInfo.PAddress = txtAddress.Text;
//var varRegFee = oOnLinePrescriptionDataContext.lkp_Relationships.Where(id => id.RelMedDiscount.Equals(ddlRelationship.SelectedValue));
var varRegFeeMax = oOnLinePrescriptionDataContext.lkp_RegistrationFees.Max(x => x.RFTaka);
var varMedDis = (from lkpRel in oOnLinePrescriptionDataContext.lkp_Relationships
where lkpRel.RelCode.Equals(ddlRelationship.SelectedValue)
select lkpRel.RelMedDiscount).SingleOrDefault();
var varTestDis = (from lkpRel in oOnLinePrescriptionDataContext.lkp_Relationships
where lkpRel.RelCode.Equals(ddlRelationship.SelectedValue)
select lkpRel.RelTestDiscount).SingleOrDefault();
oPatietnBasicInfo.RegistrationFee = varRegFeeMax;
oPatietnBasicInfo.MedDiscount = varMedDis;
oPatietnBasicInfo.TestDiscount = varTestDis;
oPatietnBasicInfo.Remarks = txtRemarks.Text;
//Create Error message Object
BL.Classes.Patient oPatient = new BL.Classes.Patient();
string sError = oPatient.Verify(oPatietnBasicInfo);
if (string.IsNullOrEmpty(sError))
oPatient.Register(oPatietnBasicInfo);
else
{
RadWindowManager.RadAlert(sError, 200, 200, "Alert!!", null);
return;
}
ClearControlled();
//May be function generation
//lblForFunctionCall.Text = "<script type='text/javascript'>returnToParent();</script>";
}
public CascadingDropDownNameValue[] GetThanaorUpZillaList2(string knownCategoryValues, string category)
{
StringDictionary kv = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
string varCat;
varCat = kv["DistCode"];
List<CascadingDropDownNameValue> Values = new List<CascadingDropDownNameValue>();
StringDictionary kv2 = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
string varDivCode;
varDivCode = kv["DivCode"];
using (ORM.OnLinePrescriptionDataContext oOnLinePrescriptionDataContext = new ORM.OnLinePrescriptionDataContext())
{
var AreaQuery = from AreaD in oOnLinePrescriptionDataContext.lkp_AreaDetails
where (AreaD.DivCode == varDivCode && AreaD.DistCode == varCat)
select new {
AreaD.ThanaCode,
AreaD.ThanaName
}
into AreaResult
select AreaResult;
foreach (var AreaResult in AreaQuery)
{
string ID = AreaResult.ThanaCode;
string Name = AreaResult.ThanaName;
Values.Add(new CascadingDropDownNameValue(Name, Convert.ToString(ID)));
}
//return Values.ToArray();
return Values.ToArray<CascadingDropDownNameValue>();
}
}
public CascadingDropDownNameValue[] GetThanaorUpZillaList(string knownCategoryValues, string category)
{
ORM.OnLinePrescriptionDataContext oOPresDataContext = new ORM.OnLinePrescriptionDataContext();
//oOPresDataContext.ObjectTrackingEnabled = false;
StringDictionary kv = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
string varCat;
varCat = kv["DistCode"];
IEnumerable<CascadingDropDownNameValue> vals = null;
vals = (from AreaD in oOPresDataContext.lkp_AreaDetails.Distinct()
where (AreaD.DistCode == varCat)
select new CascadingDropDownNameValue
{
name = AreaD.ThanaName,
value = AreaD.ThanaCode.ToString()
}).Distinct().OrderBy(t => t.name);
return vals.ToArray<CascadingDropDownNameValue>();
}
public object GetStaffInfo(string StaffID)
{
ORM.OnLinePrescriptionDataContext oOPresDataContext = new ORM.OnLinePrescriptionDataContext();
oOPresDataContext.ObjectTrackingEnabled = false;
var staffInfo = from Staffs in oOPresDataContext.lkp_StaffInfos
where
Staffs.StaffID== StaffID
select new
{
Staffs.StaffID,
Staffs.StaffName,
StaffDOB= Staffs.DateOfBirth,
Staffs.StaffSex
};
JavaScriptSerializer oJSS = new JavaScriptSerializer();
return oJSS.Serialize(staffInfo); ;
}
public CascadingDropDownNameValue[] GetReferredList()
{
ORM.OnLinePrescriptionDataContext oOPresDataContext = new ORM.OnLinePrescriptionDataContext();
//oOPresDataContext.ObjectTrackingEnabled = false;
IEnumerable<CascadingDropDownNameValue> vals = null;
vals = (from Rfd in oOPresDataContext.lkp_Reffereds
select new CascadingDropDownNameValue
{
name = Rfd.RefDesc,
value = Rfd.RefCode.ToString()
}).Distinct().OrderBy(t => t.name);
return vals.ToArray<CascadingDropDownNameValue>();
}
public object GetPatientInfo(string PatienID)
{
ORM.OnLinePrescriptionDataContext oOPresDataContext = new ORM.OnLinePrescriptionDataContext();
oOPresDataContext.ObjectTrackingEnabled = false;
var PatientInfo = (from pid in oOPresDataContext.PatientBasicInfos
where pid.PatientID.Equals(PatienID)
select pid.PatientID).SingleOrDefault();
JavaScriptSerializer oJSS = new JavaScriptSerializer();
return oJSS.Serialize(PatientInfo);
}
public object GetPatientBasicInfoById(string patientID)
{
ORM.OnLinePrescriptionDataContext oHealsDataContext = new ORM.OnLinePrescriptionDataContext();
oHealsDataContext.ObjectTrackingEnabled = false;
var resInfo = from Respondents in oHealsDataContext.lkp_StaffInfos
where
Respondents.StaffID == patientID
select new
{
ResID = Respondents.StaffID,
ResName = Respondents.StaffName,
ResSex = Respondents.StaffSex,
ResAge = Respondents.StaffAge
};
JavaScriptSerializer oJSS = new JavaScriptSerializer();
return oJSS.Serialize(resInfo);
}
public CascadingDropDownNameValue[] GetDrugAllergyList()
{
ORM.OnLinePrescriptionDataContext oOPresDataContext = new ORM.OnLinePrescriptionDataContext();
//oOPresDataContext.ObjectTrackingEnabled = false;
IEnumerable<CascadingDropDownNameValue> vals = null;
vals = (from Mname in oOPresDataContext.lkp_MedicineNames
select new CascadingDropDownNameValue
{
name = Mname.TradeName,
value = Mname.MNCode.ToString()
}).Distinct().OrderBy(t => t.name);
return vals.ToArray<CascadingDropDownNameValue>();
}
public CascadingDropDownNameValue[] GetDoctorFee(string knownCategoryValues, string category)
{
ORM.OnLinePrescriptionDataContext oOPresDataContext = new ORM.OnLinePrescriptionDataContext();
//oOPresDataContext.ObjectTrackingEnabled = false;
StringDictionary kv = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
short varCat;
varCat = Convert.ToSByte(kv["DNCode"]);
IEnumerable<CascadingDropDownNameValue> vals = null;
vals = (from AreaD in oOPresDataContext.lkp_DoctorsNames
where (AreaD.DNCode == varCat)
select new CascadingDropDownNameValue
{
name = AreaD.DoctorFee.ToString(),
value = AreaD.DNCode.ToString()
});
return vals.ToArray<CascadingDropDownNameValue>();
}
public CascadingDropDownNameValue[] GetDistrictList()
{
ORM.OnLinePrescriptionDataContext oOPresDataContext = new ORM.OnLinePrescriptionDataContext();
//oOPresDataContext.ObjectTrackingEnabled = false;
IEnumerable<CascadingDropDownNameValue> vals = null;
vals = (from AreaD in oOPresDataContext.lkp_AreaDetails.Distinct()
select new CascadingDropDownNameValue
{
name = AreaD.DistName,
value = AreaD.DistCode.ToString()
}).Distinct().OrderBy(t => t.name);
return vals.ToArray<CascadingDropDownNameValue>();
}
public static void SavePrescriptions(OnlineOutPatientManagementSystem.UI.Prescription.clsDataTypes.PrescriptionGenDataInfo oPrescriptionGenDataInfo)
{
ORM.OnLinePrescriptionDataContext oOPresDataContext = new ORM.OnLinePrescriptionDataContext();
ORM.ClinicVisitHistory oClinicVisitHistory = new ORM.ClinicVisitHistory();
//Basic Infp************************************
//int intMaxClnVisutId = oOPresDataContext.ClinicVisitHistories.Max(u => u.ClinicVisitID) + 1;
oClinicVisitHistory.ClinicVisitID = oOPresDataContext.ClinicVisitHistories.Max(u => u.ClinicVisitID) + 1;
oClinicVisitHistory.VisitDate = DateTime.Now;
oClinicVisitHistory.PatientID = oPrescriptionGenDataInfo.strPatientID;
oClinicVisitHistory.Relations = oPrescriptionGenDataInfo.strRelations;
oClinicVisitHistory.PatientAge = oPrescriptionGenDataInfo.strPatientAge;
oClinicVisitHistory.DrugHistory = oPrescriptionGenDataInfo.strDrugHistory;
oClinicVisitHistory.DrugAllergy = oPrescriptionGenDataInfo.strDrugAllergy;
//On examinatin Info******************************
oClinicVisitHistory.ExaAnemia = oPrescriptionGenDataInfo.strExaAnemia;
oClinicVisitHistory.ExaJaundice = oPrescriptionGenDataInfo.strExaJaundice;
oClinicVisitHistory.ExaClubbing = oPrescriptionGenDataInfo.strExaClubbing;
oClinicVisitHistory.ExaOedema = oPrescriptionGenDataInfo.strExaOdema;
oClinicVisitHistory.ExaL_N = oPrescriptionGenDataInfo.strExaL_N;
oClinicVisitHistory.ExaHeart = oPrescriptionGenDataInfo.strExaHeart;
oClinicVisitHistory.ExaLung = oPrescriptionGenDataInfo.strExaLung;
oClinicVisitHistory.ExaLiver = oPrescriptionGenDataInfo.strExaLiver;
oClinicVisitHistory.ExaSpleen = oPrescriptionGenDataInfo.strExaSpleen;
oClinicVisitHistory.ExaOthers = oPrescriptionGenDataInfo.strExaOthers;
//Blood Pressure
oClinicVisitHistory.ExaSystolic = oPrescriptionGenDataInfo.strExaSystolic;
oClinicVisitHistory.ExaDiastolic = oPrescriptionGenDataInfo.strExaDiastolic;
oClinicVisitHistory.ExaSystolic = oPrescriptionGenDataInfo.strExaSystolic;
oClinicVisitHistory.ExaDiastolic = oPrescriptionGenDataInfo.strExaDiastolic;
oClinicVisitHistory.ExaPulse = oPrescriptionGenDataInfo.strExaPulse;
oClinicVisitHistory.ExaTemp = oPrescriptionGenDataInfo.strExaTemp;
oClinicVisitHistory.ExaWt = oPrescriptionGenDataInfo.strExaWt;
oClinicVisitHistory.ExaVulva = oPrescriptionGenDataInfo.strExaVulva;
oClinicVisitHistory.ExaVagina = oPrescriptionGenDataInfo.strExaVagina;
oClinicVisitHistory.ExaOS = oPrescriptionGenDataInfo.strExaOS;
oClinicVisitHistory.ExaCervix = oPrescriptionGenDataInfo.strExaCervix;
//Other data
oClinicVisitHistory.ReferredCode = oPrescriptionGenDataInfo.strReferredCode;
//oClinicVisitHistory.Referred = oPrescriptionGenDataInfo.strReferred;
oClinicVisitHistory.DoctorCode1 = oPrescriptionGenDataInfo.strDoctorCode1;
//oPrescriptionGenDataInfo.strDoctorCode2;
oClinicVisitHistory.DoctorCode2 = null;
oClinicVisitHistory.NextVisitDt = null;
oClinicVisitHistory.EntryDate = DateTime.Now;
//Adds an entity in a pending insert state to this System.Data.Linq.Table<TEntity>and parameter is the entity which to be added
oOPresDataContext.ClinicVisitHistories.InsertOnSubmit(oClinicVisitHistory);
// executes the appropriate commands to implement the changes to the database
oOPresDataContext.SubmitChanges();
}
public object GetPatientInfo(string PatienID)
{
ORM.OnLinePrescriptionDataContext oOPresDataContext = new ORM.OnLinePrescriptionDataContext();
oOPresDataContext.ObjectTrackingEnabled = false;
var PatientInfo = from Patience in oOPresDataContext.PatientBasicInfos
where
Patience.PatientID == PatienID
select new
{
Relationship = Patience.Relationship,
PatientName = Patience.PatientName,
PatientSex = Patience.Gender,
PatientAge = Patience.PatientAge,
};
JavaScriptSerializer oJSS = new JavaScriptSerializer();
return oJSS.Serialize(PatientInfo);
}
