public editInfoStruct getOstadInfoFromPortal(Int64 codeOstad) { editInfoStruct editInfo = new editInfoStruct(); DAO.University.Research.ResearchDAO dao = new DAO.University.Research.ResearchDAO(); DataTable dtOstad; int _codeOstad = int.Parse("200" + codeOstad); dtOstad = dao.GetOstadInfoByCodeOstad_Portal(_codeOstad); if (dtOstad.Rows.Count > 0) { editInfo.codeOstad = codeOstad; if (dtOstad.Rows[0]["name_os"] != DBNull.Value) { editInfo.name = dtOstad.Rows[0]["name_os"].ToString(); } if (dtOstad.Rows[0]["hrId"] != DBNull.Value) { editInfo.hrId = Convert.ToInt32(dtOstad.Rows[0]["hrId"]); } if (dtOstad.Rows[0]["famili_os"] != DBNull.Value) { editInfo.family = dtOstad.Rows[0]["famili_os"].ToString(); } if (dtOstad.Rows[0]["faName"] != DBNull.Value) { editInfo.fatherName = dtOstad.Rows[0]["faName"].ToString(); } if (dtOstad.Rows[0]["addres_os"] != DBNull.Value) { editInfo.addressHome = dtOstad.Rows[0]["addres_os"].ToString(); } if (dtOstad.Rows[0]["add_kar"] != DBNull.Value) { editInfo.addressKar = dtOstad.Rows[0]["add_kar"].ToString(); } if (dtOstad.Rows[0]["mail"] != DBNull.Value) { editInfo.email = dtOstad.Rows[0]["mail"].ToString(); } if (dtOstad.Rows[0]["num_hesab"] != DBNull.Value) { editInfo.siba = dtOstad.Rows[0]["num_hesab"].ToString(); } if (dtOstad.Rows[0]["num_bime"] != DBNull.Value) { editInfo.bimeNum = dtOstad.Rows[0]["num_bime"].ToString(); } if (dtOstad.Rows[0]["tel_home"] != DBNull.Value) { editInfo.telHome = dtOstad.Rows[0]["tel_home"].ToString(); } if (dtOstad.Rows[0]["tel_kar"] != DBNull.Value) { editInfo.telKar = dtOstad.Rows[0]["tel_kar"].ToString(); } if (dtOstad.Rows[0]["mob_os"] != DBNull.Value) { editInfo.telMobile = dtOstad.Rows[0]["mob_os"].ToString(); } if (dtOstad.Rows[0]["code_posti"] != DBNull.Value) { editInfo.codePosti = dtOstad.Rows[0]["code_posti"].ToString(); } if (dtOstad.Rows[0]["sh_shn"] != DBNull.Value) { editInfo.idd = dtOstad.Rows[0]["sh_shn"].ToString(); } if (dtOstad.Rows[0]["code_meli"] != DBNull.Value) { editInfo.idd_Melli = dtOstad.Rows[0]["code_meli"].ToString(); } if (dtOstad.Rows[0]["tarikh_t"] != DBNull.Value) { string birthYear = dtOstad.Rows[0]["tarikh_t"].ToString(); if (birthYear.Length > 4 && birthYear.Contains("/")) { birthYear = birthYear.Split('/')[0]; } editInfo.salTavalod = birthYear; } if (dtOstad.Rows[0]["status_nezam"] != DBNull.Value) { editInfo.nezam = Convert.ToInt32(dtOstad.Rows[0]["status_nezam"]); } if (dtOstad.Rows[0]["magta"] != DBNull.Value) { editInfo.maghta = Convert.ToInt32(dtOstad.Rows[0]["magta"]); } //if (dtOstad.Rows[0]["resh"] != DBNull.Value) // editInfo.reshte = Convert.ToInt32(dtOstad.Rows[0]["resh"]); if (dtOstad.Rows[0]["sal_madrak"] != DBNull.Value) { editInfo.salMadrak = dtOstad.Rows[0]["sal_madrak"].ToString(); } if (dtOstad.Rows[0]["sanavat_tadris"] != DBNull.Value) { editInfo.sanavat = dtOstad.Rows[0]["sanavat_tadris"].ToString(); } if (dtOstad.Rows[0]["country"] != DBNull.Value) { editInfo.keshvar = Convert.ToInt32(dtOstad.Rows[0]["country"]); } if (dtOstad.Rows[0]["MadrakUniType"] != DBNull.Value) { editInfo.typeUniMadrak = Convert.ToInt32(dtOstad.Rows[0]["MadrakUniType"]); } if (dtOstad.Rows[0]["university"] != DBNull.Value) { editInfo.nameUniMadrak = Convert.ToInt32(dtOstad.Rows[0]["university"]); } if (dtOstad.Rows[0]["BimehTypeId"] != DBNull.Value) { editInfo.bimeType = Convert.ToInt32(dtOstad.Rows[0]["BimehTypeId"]); } if (dtOstad.Rows[0]["code_ostan_home"] != DBNull.Value) { editInfo.ostanHome = Convert.ToInt32(dtOstad.Rows[0]["code_ostan_home"]); } if (dtOstad.Rows[0]["code_city_home"] != DBNull.Value) { editInfo.shahrHome = Convert.ToInt32(dtOstad.Rows[0]["code_city_home"]); } if (dtOstad.Rows[0]["code_ostan_work"] != DBNull.Value) { editInfo.ostanKar = Convert.ToInt32(dtOstad.Rows[0]["code_ostan_work"]); } if (dtOstad.Rows[0]["code_city_work"] != DBNull.Value) { editInfo.shahrKar = Convert.ToInt32(dtOstad.Rows[0]["code_city_work"]); } if (dtOstad.Rows[0]["BimehTypeId"] != DBNull.Value) { editInfo.bime = Convert.ToInt32(dtOstad.Rows[0]["BimehTypeId"]) > 0; } if (dtOstad.Rows[0]["IsRetired"] != DBNull.Value) { editInfo.bazneshaste = Convert.ToBoolean(dtOstad.Rows[0]["IsRetired"]); } if (dtOstad.Rows[0]["marital_status"] != DBNull.Value) { editInfo.taahol = dtOstad.Rows[0]["marital_status"].ToString() == "1" ? false : true; } if (dtOstad.Rows[0]["jens"] != DBNull.Value) { editInfo.sexIsMan = Convert.ToInt32(dtOstad.Rows[0]["jens"]) == 1 ? true : false; } } return(editInfo); }
public editInfoStruct getOstadInfoFromSida(int codeOstad) { editInfoStruct editInfo = new editInfoStruct(); DAO.University.Research.ResearchDAO dao = new DAO.University.Research.ResearchDAO(); DataTable dtOstad = dao.GetOstadInfoByCodeOstad(codeOstad); if (dtOstad.Rows.Count >= 1) { editInfo.codeOstad = codeOstad; if (dtOstad.Rows[0]["name"] != DBNull.Value) { editInfo.name = dtOstad.Rows[0]["name"].ToString(); } if (dtOstad.Rows[0]["family"] != DBNull.Value) { editInfo.family = dtOstad.Rows[0]["family"].ToString(); } if (dtOstad.Rows[0]["namep"] != DBNull.Value) { editInfo.fatherName = dtOstad.Rows[0]["namep"].ToString(); } if (dtOstad.Rows[0]["add_hom"] != DBNull.Value) { editInfo.addressHome = dtOstad.Rows[0]["add_hom"].ToString(); } if (dtOstad.Rows[0]["add_kar"] != DBNull.Value) { editInfo.addressKar = dtOstad.Rows[0]["add_kar"].ToString(); } if (dtOstad.Rows[0]["add_email"] != DBNull.Value) { editInfo.email = dtOstad.Rows[0]["add_email"].ToString(); } if (dtOstad.Rows[0]["siba"] != DBNull.Value) { editInfo.siba = dtOstad.Rows[0]["siba"].ToString(); } if (dtOstad.Rows[0]["num_bime"] != DBNull.Value) { editInfo.bimeNum = dtOstad.Rows[0]["num_bime"].ToString(); } if (dtOstad.Rows[0]["tel_hom"] != DBNull.Value) { editInfo.telHome = dtOstad.Rows[0]["tel_hom"].ToString(); } if (dtOstad.Rows[0]["tel_kar"] != DBNull.Value) { editInfo.telKar = dtOstad.Rows[0]["tel_kar"].ToString(); } if (dtOstad.Rows[0]["mobile"] != DBNull.Value) { editInfo.telMobile = dtOstad.Rows[0]["mobile"].ToString(); } if (dtOstad.Rows[0]["code_posti"] != DBNull.Value) { editInfo.codePosti = dtOstad.Rows[0]["code_posti"].ToString(); } if (dtOstad.Rows[0]["hrID"] != DBNull.Value) { editInfo.hrId = Convert.ToInt32(dtOstad.Rows[0]["hrID"]); } if (dtOstad.Rows[0]["idd"] != DBNull.Value) { editInfo.idd = dtOstad.Rows[0]["idd"].ToString(); } if (dtOstad.Rows[0]["idd_meli"] != DBNull.Value) { editInfo.idd_Melli = dtOstad.Rows[0]["idd_meli"].ToString(); } if (dtOstad.Rows[0]["sal_tav"] != DBNull.Value) { editInfo.salTavalod = dtOstad.Rows[0]["sal_tav"].ToString(); } if (dtOstad.Rows[0]["nezam"] != DBNull.Value) { editInfo.nezam = Convert.ToInt32(dtOstad.Rows[0]["nezam"]); } if (dtOstad.Rows[0]["idmadrak"] != DBNull.Value) { editInfo.maghta = Convert.ToInt32(dtOstad.Rows[0]["idmadrak"]); } if (dtOstad.Rows[0]["os_idresh"] != DBNull.Value) { editInfo.reshte = Convert.ToInt32(dtOstad.Rows[0]["os_idresh"]); } if (dtOstad.Rows[0]["sal_madrak"] != DBNull.Value) { editInfo.salMadrak = dtOstad.Rows[0]["sal_madrak"].ToString(); } if (dtOstad.Rows[0]["sanavat_tadris"] != DBNull.Value) { editInfo.sanavat = dtOstad.Rows[0]["sanavat_tadris"].ToString(); } if (dtOstad.Rows[0]["keshvar"] != DBNull.Value) { editInfo.keshvar = Convert.ToInt32(dtOstad.Rows[0]["keshvar"]); } if (dtOstad.Rows[0]["type_university"] != DBNull.Value) { editInfo.typeUniMadrak = Convert.ToInt32(dtOstad.Rows[0]["type_university"]); } if (dtOstad.Rows[0]["university"] != DBNull.Value) { editInfo.nameUniMadrak = Convert.ToInt32(dtOstad.Rows[0]["university"]); } if (dtOstad.Rows[0]["BimehTypeId"] != DBNull.Value) { editInfo.bimeType = Convert.ToInt32(dtOstad.Rows[0]["BimehTypeId"]); } if (dtOstad.Rows[0]["code_ostan_home"] != DBNull.Value) { editInfo.ostanHome = Convert.ToInt32(dtOstad.Rows[0]["code_ostan_home"]); } if (dtOstad.Rows[0]["code_city_home"] != DBNull.Value) { editInfo.shahrHome = Convert.ToInt32(dtOstad.Rows[0]["code_city_home"]); } if (dtOstad.Rows[0]["code_ostan_work"] != DBNull.Value) { editInfo.ostanKar = Convert.ToInt32(dtOstad.Rows[0]["code_ostan_work"]); } if (dtOstad.Rows[0]["code_city_work"] != DBNull.Value) { editInfo.shahrKar = Convert.ToInt32(dtOstad.Rows[0]["code_city_work"]); } if (dtOstad.Rows[0]["note"] != DBNull.Value) { editInfo.description = dtOstad.Rows[0]["note"].ToString(); } if (dtOstad.Rows[0]["BimehTypeId"] != DBNull.Value) { editInfo.bime = Convert.ToInt16(dtOstad.Rows[0]["BimehTypeId"]) > 0; } if (dtOstad.Rows[0]["IsRetired"] != DBNull.Value) { editInfo.bazneshaste = Convert.ToBoolean(dtOstad.Rows[0]["IsRetired"]); } if (dtOstad.Rows[0]["marital_status"] != DBNull.Value) { editInfo.taahol = dtOstad.Rows[0]["marital_status"].ToString() == "1" ? false : true; } if (dtOstad.Rows[0]["sex"] != DBNull.Value) { editInfo.sexIsMan = Convert.ToInt32(dtOstad.Rows[0]["sex"]) == 1 ? true : false; } } return(editInfo); }