public SurrogatePersonalInfo SaveSurrogatePersonalInfo(SurrogatePersonalInfo surrogatePersonalInfo) { SurrogatePersonalInfo localSurrogatePersonalInfo = new SurrogatePersonalInfo(); SurrogateData surrogateData = new SurrogateData(); DataSet dataSet = new DataSet(); try { dataSet = surrogateData.SaveSurrogatePersonalInfo(surrogatePersonalInfo); if (dataSet.Tables["SurrogatePersonalInfo"].Rows.Count > 0) { localSurrogatePersonalInfo = new SurrogatePersonalInfo(); localSurrogatePersonalInfo.SurrogateID = dataSet.Tables["SurrogatePersonalInfo"].Rows[0]["SURROGATEID"].ToString(); localSurrogatePersonalInfo.UserID = dataSet.Tables["SurrogatePersonalInfo"].Rows[0]["USERID"].ToString(); localSurrogatePersonalInfo.FirstName = dataSet.Tables["SurrogatePersonalInfo"].Rows[0]["FIRSTNAME"].ToString(); localSurrogatePersonalInfo.LastName = dataSet.Tables["SurrogatePersonalInfo"].Rows[0]["LASTNAME"].ToString(); localSurrogatePersonalInfo.MiddleName = dataSet.Tables["SurrogatePersonalInfo"].Rows[0]["MIDDLENAME"].ToString(); localSurrogatePersonalInfo.DOB = dataSet.Tables["SurrogatePersonalInfo"].Rows[0]["DOB"].ToString(); localSurrogatePersonalInfo.Age = dataSet.Tables["SurrogatePersonalInfo"].Rows[0]["AGE"] == DBNull.Value ? (int?)null : Convert.ToInt32(dataSet.Tables["SurrogatePersonalInfo"].Rows[0]["AGE"].ToString()); localSurrogatePersonalInfo.Citizenship = dataSet.Tables["SurrogatePersonalInfo"].Rows[0]["CITIZENSHIP"].ToString(); localSurrogatePersonalInfo.Height = dataSet.Tables["SurrogatePersonalInfo"].Rows[0]["HEIGHTFEET"].ToString(); localSurrogatePersonalInfo.Weight = dataSet.Tables["SurrogatePersonalInfo"].Rows[0]["WEIGHT"].ToString(); localSurrogatePersonalInfo.MaritalStatus = dataSet.Tables["SurrogatePersonalInfo"].Rows[0]["MARITALSTATUS"].ToString(); localSurrogatePersonalInfo.SpouseFullName = dataSet.Tables["SurrogatePersonalInfo"].Rows[0]["SPOUSEFULLNAME"].ToString(); localSurrogatePersonalInfo.SpouseFullName = dataSet.Tables["SurrogatePersonalInfo"].Rows[0]["SPOUSEFULLNAME"].ToString(); localSurrogatePersonalInfo.SpouseDOB = dataSet.Tables["SurrogatePersonalInfo"].Rows[0]["SPOUSEDOB"].ToString(); localSurrogatePersonalInfo.NoOfChild = dataSet.Tables["SurrogatePersonalInfo"].Rows[0]["NOOFCHILD"].ToString(); localSurrogatePersonalInfo.StepChild = dataSet.Tables["SurrogatePersonalInfo"].Rows[0]["STEPCHILD"].ToString(); localSurrogatePersonalInfo.ChildDescription = dataSet.Tables["SurrogatePersonalInfo"].Rows[0]["CHILDDESCRIPTION"].ToString(); localSurrogatePersonalInfo.Pregnant = dataSet.Tables["SurrogatePersonalInfo"].Rows[0]["PREGNANT"].ToString(); localSurrogatePersonalInfo.Adopted = dataSet.Tables["SurrogatePersonalInfo"].Rows[0]["ADOPTED"].ToString(); localSurrogatePersonalInfo.Residence = dataSet.Tables["SurrogatePersonalInfo"].Rows[0]["RESIDENCE"].ToString(); localSurrogatePersonalInfo.EthnicBackGround = dataSet.Tables["SurrogatePersonalInfo"].Rows[0]["ETHNICBACKGROUND"].ToString(); } } catch (SqlException sqlEx) { localSurrogatePersonalInfo.responseDetail.responseType = ResponseType.Error; localSurrogatePersonalInfo.responseDetail.ResponseMessage = sqlEx.Message; } catch (Exception ex) { localSurrogatePersonalInfo.responseDetail.responseType = ResponseType.Error; localSurrogatePersonalInfo.responseDetail.ResponseMessage = ApplicationManager.GenericErrorMessage; LoggerHelper.WriteToLog(ex); } return(localSurrogatePersonalInfo == null ? new SurrogatePersonalInfo() : localSurrogatePersonalInfo); }
public PregnancyHistory SavePregnancyHistory(PregnancyHistory pregnancyHistory) { PregnancyHistory localsurrogacyhistory = new PregnancyHistory(); SurrogateData pregnancyhistorydata = new SurrogateData(); DataSet dataSet = new DataSet(); try { dataSet = pregnancyhistorydata.SavePregnancyHistory(pregnancyHistory); if (dataSet.Tables["PregnancyHistory"].Rows.Count > 0) { localsurrogacyhistory = new PregnancyHistory(); localsurrogacyhistory.PregnancyHistoryID = dataSet.Tables["PregnancyHistory"].Rows[0]["PREGNANCYHISTORYID"].ToString(); localsurrogacyhistory.UserID = dataSet.Tables["PregnancyHistory"].Rows[0]["USERID"].ToString(); localsurrogacyhistory.NoOfPregnancy = Convert.ToInt16(dataSet.Tables["PregnancyHistory"].Rows[0]["NOOFPREGNANCY"].ToString()); localsurrogacyhistory.NoStillBirth = Convert.ToInt16(dataSet.Tables["PregnancyHistory"].Rows[0]["NOSTILLBIRTH"].ToString()); localsurrogacyhistory.NoMisCarriage = Convert.ToInt16(dataSet.Tables["PregnancyHistory"].Rows[0]["NOMISCARRIAGE"].ToString()); localsurrogacyhistory.NoLiveBirth = Convert.ToInt16(dataSet.Tables["PregnancyHistory"].Rows[0]["NOLIVEBIRTH"].ToString()); localsurrogacyhistory.NoAbortion = Convert.ToInt16(dataSet.Tables["PregnancyHistory"].Rows[0]["NOABORTION"].ToString()); localsurrogacyhistory.List = dataSet.Tables["PregnancyHistory"].Rows[0]["LIST"].ToString(); localsurrogacyhistory.Treatment = dataSet.Tables["PregnancyHistory"].Rows[0]["TREATMENT"].ToString(); localsurrogacyhistory.Complication = dataSet.Tables["PregnancyHistory"].Rows[0]["COMPLICATION"].ToString(); localsurrogacyhistory.Desc = dataSet.Tables["PregnancyHistory"].Rows[0]["DESC"].ToString(); localsurrogacyhistory.ChildDeath = dataSet.Tables["PregnancyHistory"].Rows[0]["CHILDDEATH"].ToString(); localsurrogacyhistory.Problem = dataSet.Tables["PregnancyHistory"].Rows[0]["PROBLEM"].ToString(); localsurrogacyhistory.IsSubmit = Convert.ToInt32(dataSet.Tables["PregnancyHistory"].Rows[0]["ISSUBMIT"].ToString()); } } catch (SqlException sqlEx) { localsurrogacyhistory.responseDetail.responseType = ResponseType.Error; localsurrogacyhistory.responseDetail.ResponseMessage = sqlEx.Message; } catch (Exception ex) { localsurrogacyhistory.responseDetail.responseType = ResponseType.Error; localsurrogacyhistory.responseDetail.ResponseMessage = ApplicationManager.GenericErrorMessage; LoggerHelper.WriteToLog(ex); } return(localsurrogacyhistory == null ? new PregnancyHistory() : localsurrogacyhistory); }
public MedicalInfo SaveMedicalInfo(MedicalInfo medicalInfo) { MedicalInfo localMedicalInfo = new MedicalInfo(); SurrogateData surrogateData = new SurrogateData(); DataSet dataSet = new DataSet(); try { dataSet = surrogateData.SaveMedicalInfo(medicalInfo); if (dataSet.Tables["MedicalInfo"].Rows.Count > 0) { localMedicalInfo = new MedicalInfo(); localMedicalInfo.UserID = dataSet.Tables["MedicalInfo"].Rows[0]["MEDICALINFOID"].ToString(); localMedicalInfo.UserID = dataSet.Tables["MedicalInfo"].Rows[0]["USERID"].ToString(); localMedicalInfo.Ablation = dataSet.Tables["MedicalInfo"].Rows[0]["ABLATION"].ToString(); localMedicalInfo.WeightLoss = dataSet.Tables["MedicalInfo"].Rows[0]["WEIGHLOSS"].ToString(); localMedicalInfo.Medical = dataSet.Tables["MedicalInfo"].Rows[0]["MEDICAL"].ToString(); localMedicalInfo.MedicalDetail = dataSet.Tables["MedicalInfo"].Rows[0]["MEDICALDETAIL"].ToString(); localMedicalInfo.Medication = dataSet.Tables["MedicalInfo"].Rows[0]["MEDICATION"].ToString(); localMedicalInfo.MedicationDetail = dataSet.Tables["MedicalInfo"].Rows[0]["MEDICATIONDETAIL"].ToString(); localMedicalInfo.BreastFeeding = dataSet.Tables["MedicalInfo"].Rows[0]["BREASTFEEDING"].ToString(); localMedicalInfo.Periods = dataSet.Tables["MedicalInfo"].Rows[0]["PERIODS"].ToString(); localMedicalInfo.IsSubmit = Convert.ToInt32(dataSet.Tables["MedicalInfo"].Rows[0]["ISSUBMIT"].ToString()); } } catch (SqlException sqlEx) { localMedicalInfo.responseDetail.responseType = ResponseType.Error; localMedicalInfo.responseDetail.ResponseMessage = sqlEx.Message; } catch (Exception ex) { localMedicalInfo.responseDetail.responseType = ResponseType.Error; localMedicalInfo.responseDetail.ResponseMessage = ApplicationManager.GenericErrorMessage; LoggerHelper.WriteToLog(ex); } return(localMedicalInfo == null ? new MedicalInfo() : localMedicalInfo); }
public LifeStyle SaveLifeStyle(LifeStyle lifestyle) { LifeStyle locallifestyle = new LifeStyle(); SurrogateData lifestyledata = new SurrogateData(); DataSet dataSet = new DataSet(); try { dataSet = lifestyledata.SaveLifeStyle(lifestyle); if (dataSet.Tables["LifeStyle"].Rows.Count > 0) { locallifestyle = new LifeStyle(); locallifestyle.LifeStyleID = dataSet.Tables["LifeStyle"].Rows[0]["LIFESTYLEID"].ToString(); locallifestyle.UserID = dataSet.Tables["LifeStyle"].Rows[0]["USERID"].ToString(); locallifestyle.Smoke = dataSet.Tables["LifeStyle"].Rows[0]["SMOKE"].ToString(); locallifestyle.MemberSmoke = dataSet.Tables["LifeStyle"].Rows[0]["MEMBERSMOKE"].ToString(); locallifestyle.Alcohol = dataSet.Tables["LifeStyle"].Rows[0]["ALCOHOL"].ToString(); locallifestyle.Drug = dataSet.Tables["LifeStyle"].Rows[0]["DRUG"].ToString(); locallifestyle.Past = dataSet.Tables["LifeStyle"].Rows[0]["PAST"].ToString(); locallifestyle.SpouseDrug = dataSet.Tables["LifeStyle"].Rows[0]["SPOUSEDRUG"].ToString(); locallifestyle.IsSubmit = dataSet.Tables["LifeStyle"].Rows[0]["ISSUBMIT"].ToString(); } } catch (SqlException sqlEx) { locallifestyle.responseDetail.responseType = ResponseType.Error; locallifestyle.responseDetail.ResponseMessage = sqlEx.Message; } catch (Exception ex) { locallifestyle.responseDetail.responseType = ResponseType.Error; locallifestyle.responseDetail.ResponseMessage = ApplicationManager.GenericErrorMessage; LoggerHelper.WriteToLog(ex); } return(locallifestyle == null ? new LifeStyle() : locallifestyle); }
public MentalHealth SaveMentalHealth(MentalHealth mentalhealth) { MentalHealth localmentalhealth = new MentalHealth(); SurrogateData mentalhealthdata = new SurrogateData(); DataSet dataSet = new DataSet(); try { dataSet = mentalhealthdata.SaveMentalHealth(mentalhealth); if (dataSet.Tables["MentalHealth"].Rows.Count > 0) { localmentalhealth = new MentalHealth(); localmentalhealth.MentalHealthID = dataSet.Tables["MentalHealth"].Rows[0]["MENTALHEALTHID"].ToString(); localmentalhealth.UserID = dataSet.Tables["MentalHealth"].Rows[0]["USERID"].ToString(); localmentalhealth.Depression = Convert.ToInt16(dataSet.Tables["MentalHealth"].Rows[0]["DEPRESSION"].ToString()); localmentalhealth.Illness = Convert.ToInt16(dataSet.Tables["MentalHealth"].Rows[0]["ILLNESS"].ToString()); localmentalhealth.Suicide = Convert.ToInt16(dataSet.Tables["MentalHealth"].Rows[0]["SUICIDE"].ToString()); localmentalhealth.Thoughts = Convert.ToInt16(dataSet.Tables["MentalHealth"].Rows[0]["THOUGHTS"].ToString()); localmentalhealth.Professional = Convert.ToInt16(dataSet.Tables["MentalHealth"].Rows[0]["PROFESSIONAL"].ToString()); localmentalhealth.Details = dataSet.Tables["MentalHealth"].Rows[0]["DETAILS"].ToString(); localmentalhealth.IsSubmit = Convert.ToInt32(dataSet.Tables["MentalHealth"].Rows[0]["ISSUBMIT"].ToString()); } } catch (SqlException sqlEx) { localmentalhealth.responseDetail.responseType = ResponseType.Error; localmentalhealth.responseDetail.ResponseMessage = sqlEx.Message; } catch (Exception ex) { localmentalhealth.responseDetail.responseType = ResponseType.Error; localmentalhealth.responseDetail.ResponseMessage = ApplicationManager.GenericErrorMessage; LoggerHelper.WriteToLog(ex); } return(localmentalhealth == null ? new MentalHealth() : localmentalhealth); }
public Documents SaveDocuments(Documents documents) { Documents localdocument = new Documents(); SurrogateData documentdata = new SurrogateData(); DataSet dataSet = new DataSet(); try { dataSet = documentdata.SaveDocuments(documents); if (dataSet.Tables["Document"].Rows.Count > 0) { localdocument = new Documents(); localdocument.DocumentID = dataSet.Tables["Document"].Rows[0]["DOCUMENTID"].ToString(); localdocument.UserID = dataSet.Tables["Document"].Rows[0]["USERID"].ToString(); localdocument.IDProof = dataSet.Tables["Document"].Rows[0]["IDPROOF"].ToString(); localdocument.Pic = dataSet.Tables["Document"].Rows[0]["PIC"].ToString(); localdocument.FamilyPic = dataSet.Tables["Document"].Rows[0]["FAMILYPIC"].ToString(); localdocument.UploadPath = dataSet.Tables["Document"].Rows[0]["UPLOADPATH"].ToString(); localdocument.IsSubmit = dataSet.Tables["Document"].Rows[0]["ISSUBMIT"].ToString(); } } catch (SqlException sqlEx) { localdocument.responseDetail.responseType = ResponseType.Error; localdocument.responseDetail.ResponseMessage = sqlEx.Message; } catch (Exception ex) { localdocument.responseDetail.responseType = ResponseType.Error; localdocument.responseDetail.ResponseMessage = ApplicationManager.GenericErrorMessage; LoggerHelper.WriteToLog(ex); } return(localdocument == null ? new Documents() : localdocument); }
public SurrogacyHistory SaveSurrogacyHistory(SurrogacyHistory SurrogacyHistory) { SurrogacyHistory localsurrogacyhistory = new SurrogacyHistory(); SurrogateData surrogacyhistorydata = new SurrogateData(); DataSet dataSet = new DataSet(); try { dataSet = surrogacyhistorydata.SaveSurrogacyHistory(SurrogacyHistory); if (dataSet.Tables["SURROGACYHISTORY"].Rows.Count > 0) { localsurrogacyhistory = new SurrogacyHistory(); localsurrogacyhistory.SurrogacyHistoryID = dataSet.Tables["SurrogacyHistory"].Rows[0]["SURROGACYHISTORYID"].ToString(); localsurrogacyhistory.UserID = dataSet.Tables["SurrogacyHistory"].Rows[0]["USERID"].ToString(); localsurrogacyhistory.SurrogateBefore = dataSet.Tables["SurrogacyHistory"].Rows[0]["SURROGATEBEFORE"].ToString(); localsurrogacyhistory.DetailSurrogate = dataSet.Tables["SurrogacyHistory"].Rows[0]["DETAILSURROGATE"].ToString(); localsurrogacyhistory.EggDonate = dataSet.Tables["SurrogacyHistory"].Rows[0]["EGGDONATE"].ToString(); localsurrogacyhistory.DetailEggDonate = dataSet.Tables["SurrogacyHistory"].Rows[0]["DETAILEGGDONATE"].ToString(); localsurrogacyhistory.IsSubmit = Convert.ToInt32(dataSet.Tables["SurrogacyHistory"].Rows[0]["ISSUBMIT"].ToString()); } } catch (SqlException sqlEx) { localsurrogacyhistory.responseDetail.responseType = ResponseType.Error; localsurrogacyhistory.responseDetail.ResponseMessage = sqlEx.Message; } catch (Exception ex) { localsurrogacyhistory.responseDetail.responseType = ResponseType.Error; localsurrogacyhistory.responseDetail.ResponseMessage = ApplicationManager.GenericErrorMessage; LoggerHelper.WriteToLog(ex); } return(localsurrogacyhistory == null ? new SurrogacyHistory() : localsurrogacyhistory); }
public FinalSubmit SaveFinalSubmit(FinalSubmit finalsubmit) { FinalSubmit localfinalsubmit = new FinalSubmit(); SurrogateData finalsubmitdata = new SurrogateData(); DataSet dataSet = new DataSet(); try { dataSet = finalsubmitdata.SaveFinalSubmit(finalsubmit); if (dataSet.Tables["FinalSubmit"].Rows.Count > 0) { localfinalsubmit = new FinalSubmit(); localfinalsubmit.FinalSubmitID = dataSet.Tables["FinalSubmit"].Rows[0]["FINALSUBMITID"].ToString(); localfinalsubmit.UserID = dataSet.Tables["FinalSubmit"].Rows[0]["USERID"].ToString(); localfinalsubmit.Agree = Convert.ToBoolean(dataSet.Tables["FinalSubmit"].Rows[0]["AGREE"].ToString()); localfinalsubmit.SurrogateSignature = dataSet.Tables["FinalSubmit"].Rows[0]["SURROGATESIGNATURE"].ToString(); localfinalsubmit.SignDate = dataSet.Tables["FinalSubmit"].Rows[0]["SIGNDATE"].ToString(); localfinalsubmit.IsSubmitted = dataSet.Tables["FinalSubmit"].Rows[0]["ISSUBMITTED"].ToString(); } } catch (SqlException sqlEx) { localfinalsubmit.responseDetail.responseType = ResponseType.Error; localfinalsubmit.responseDetail.ResponseMessage = sqlEx.Message; } catch (Exception ex) { localfinalsubmit.responseDetail.responseType = ResponseType.Error; localfinalsubmit.responseDetail.ResponseMessage = ApplicationManager.GenericErrorMessage; LoggerHelper.WriteToLog(ex); } return(localfinalsubmit == null ? new FinalSubmit() : localfinalsubmit); }