public DataTable ToDataTablePatientMedication(List <PatientMedication> datalist) { dataTable = new DataTable(); DataRow row = null; dataTable.Columns.Add("DoctorTreatmentMedicationId", typeof(long)); dataTable.Columns.Add("DoctorTreatmentIdRef", typeof(long)); dataTable.Columns.Add("MedicineIdRef", typeof(long)); dataTable.Columns.Add("DosageIdRef", typeof(long)); dataTable.Columns.Add("NoOfTimeInDay", typeof(int)); dataTable.Columns.Add("Quantities", typeof(int)); dataTable.Columns.Add("DentalAdultMainId", typeof(long)); for (int i = 0; i < datalist.Count; i++) { row = dataTable.NewRow(); row["DoctorTreatmentMedicationId"] = DataTypesUtilities.LongNZ(datalist[i].DoctorTreatmentMedicationId); row["DoctorTreatmentIdRef"] = DataTypesUtilities.LongNZ(datalist[i].DoctorTreatmentIdRef); row["MedicineIdRef"] = DataTypesUtilities.IntNZ(datalist[i].MedicineIdRef); row["DosageIdRef"] = DataTypesUtilities.LongNZ(datalist[i].DosageIdRef); row["NoOfTimeInDay"] = DataTypesUtilities.IntNZ(datalist[i].NoOfTimes); row["Quantities"] = DataTypesUtilities.IntNZ(datalist[i].Quantities); row["DentalAdultMainId"] = DataTypesUtilities.LongNZ(datalist[i].DentalAdultMainId); dataTable.Rows.Add(row); } return(dataTable); }
public DataTable ToDataTableDentalResources(List <DentalResources> datalist) { dataTable = new DataTable(); DataRow row = null; dataTable.Columns.Add("ResourceId", typeof(int)); dataTable.Columns.Add("ResourceLabel", typeof(string)); dataTable.Columns.Add("EnglishText", typeof(string)); dataTable.Columns.Add("ArabicText", typeof(string)); dataTable.Columns.Add("LanguageID", typeof(int)); dataTable.Columns.Add("ScreenID", typeof(int)); for (int i = 0; i < datalist.Count; i++) { row = dataTable.NewRow(); row["ResourceId"] = DataTypesUtilities.IntNZ(datalist[i].ResourceId); row["ResourceLabel"] = DataTypesUtilities.StringNZ(datalist[i].ResourceLabel); row["EnglishText"] = DataTypesUtilities.StringNZ(datalist[i].EnglishText); row["ArabicText"] = DataTypesUtilities.StringNZ(datalist[i].ArabicText); row["LanguageID"] = DataTypesUtilities.IntNZ(datalist[i].LanguageID); row["ScreenID"] = DataTypesUtilities.IntNZ(datalist[i].ScreenID); dataTable.Rows.Add(row); } return(dataTable); }
public DataTable ToDataTableChiefCompliant(List <DoctorTreatment> datalist) { dataTable = new DataTable(); DataRow row = null; dataTable.Columns.Add("DoctorTreatmentDiagnosisId", typeof(long)); dataTable.Columns.Add("DoctorTreatmentIdRef", typeof(long)); dataTable.Columns.Add("DiagnosisIdRef", typeof(int)); dataTable.Columns.Add("Level", typeof(long)); dataTable.Columns.Add("Comment", typeof(string)); dataTable.Columns.Add("TeethNumber", typeof(string)); for (int i = 0; i < datalist.Count; i++) { row = dataTable.NewRow(); row["DoctorTreatmentDiagnosisId"] = DataTypesUtilities.LongNZ(datalist[i].DoctorTreatmentDiagnosisId); row["DoctorTreatmentIdRef"] = DataTypesUtilities.LongNZ(datalist[i].DoctorTreatmentIdRef); row["DiagnosisIdRef"] = DataTypesUtilities.IntNZ(datalist[i].DiagnosisIdRef); row["Level"] = DataTypesUtilities.LongNZ(datalist[i].Level); row["Comment"] = DataTypesUtilities.StringNZ(datalist[i].Comment); row["TeethNumber"] = DataTypesUtilities.StringNZ(datalist[i].TeethNumber); dataTable.Rows.Add(row); } return(dataTable); }
public DataTable ToDataTableTeetNotationList(List <TeethSectionNotationMapping> datalist) { dataTable = new DataTable(); DataRow row = null; dataTable.Columns.Add("TeethSectionNotationMappingId", typeof(int)); dataTable.Columns.Add("DentalTeethMasterId", typeof(int)); dataTable.Columns.Add("DentalTeethSectionMasterId", typeof(int)); dataTable.Columns.Add("DentalNotationId", typeof(int)); dataTable.Columns.Add("PatientId", typeof(long)); dataTable.Columns.Add("DoctorId", typeof(long)); dataTable.Columns.Add("UpdatedBy", typeof(long)); dataTable.Columns.Add("DentalAdultMainId", typeof(long)); dataTable.Columns.Add("VisitRegisterId", typeof(long)); dataTable.Columns.Add("Color", typeof(string)); for (int i = 0; i < datalist.Count; i++) { row = dataTable.NewRow(); row["TeethSectionNotationMappingId"] = DataTypesUtilities.IntNZ(datalist[i].TeethSectionNotationMappingId); row["DentalTeethMasterId"] = DataTypesUtilities.IntNZ(datalist[i].DentalTeethMasterId); row["DentalTeethSectionMasterId"] = DataTypesUtilities.IntNZ(datalist[i].DentalTeethSectionMasterId); row["DentalNotationId"] = DataTypesUtilities.IntNZ(datalist[i].DentalNotationId); row["PatientId"] = DataTypesUtilities.LongNZ(datalist[i].PatientId); row["DoctorId"] = DataTypesUtilities.LongNZ(datalist[i].DoctorId); row["UpdatedBy"] = DataTypesUtilities.LongNZ(datalist[i].UpdatedBy); row["DentalAdultMainId"] = DataTypesUtilities.LongNZ(datalist[i].DentalAdultMainId); row["VisitRegisterId"] = DataTypesUtilities.LongNZ(datalist[i].VisitRegisterId); row["Color"] = DataTypesUtilities.StringNZ(datalist[i].Color); dataTable.Rows.Add(row); } return(dataTable); }