public DataTable getYearToSigncontract_HOD(int codeOstad = 0) { CooperationRequestDAO dao = new CooperationRequestDAO(); DataTable dt; if (codeOstad == 0) { dt = dao.getYearsOfHodContract(); if (dt.Rows.Count == 0) { string thisYear = "1399"; DataRow drThisYear = dt.NewRow(); drThisYear["year"] = thisYear; dt.Rows.Add(drThisYear); } } else { dt = dao.getYearToSigncontract_HOD(codeOstad); } //string thisYear = DateTime.Now.ToPeString().Substring(0, 4); //if (dt.Rows.Count > 0) //{ // DataRow[] dr = dt.Select("year=" + thisYear); // if (dr.Length == 1) // return dt; //} //DataRow drThisYear=dt.NewRow(); //drThisYear["year"] = thisYear; //dt.Rows.Add(drThisYear); return(dt); }
public DataTable getTermsToContractWithTeachers(int code_Ostad) { DataTable dt = new DataTable(); CooperationRequestDAO dao = new CooperationRequestDAO(); dt = dao.getTermsToContractWithTeachers(code_Ostad); return(dt); }
public DataTable getAllHokmToShowToPortal(string family, string startDate, string endDate, string nationalCode, int martabe) { CooperationRequestDAO CR = new CooperationRequestDAO(); DataTable dtAllHokm = new DataTable(); DataTable dtResult = new DataTable(); dtAllHokm = CR.getAllHokmInfo(); string whereClause = "cooperation in(2,3) and seenByPortal=0"; if (family.Trim() != "") { whereClause += " and (family like '%" + family + "%' or family like '%" + family.Replace("ی", "ي") + "%')"; } if (startDate != "") { whereClause += " and dateUpload>= '" + startDate + "'"; } if (endDate != "") { whereClause += " and dateUpload <= '" + endDate + "'"; } if (nationalCode != "") { whereClause += " and idd_meli = '" + nationalCode + "'"; } if (martabe != -1) { whereClause += " and martabeh=" + martabe; } DataRow[] drResult = dtAllHokm.Select(whereClause); dtResult.Columns.Add("hokmId"); dtResult.Columns.Add("row"); dtResult.Columns.Add("name"); dtResult.Columns.Add("nationalCode"); dtResult.Columns.Add("date"); dtResult.Columns.Add("code_ostad"); dtResult.Columns.Add("InfoPeopleId"); int counter = 1; foreach (DataRow dr in drResult) { DataRow drNew = dtResult.NewRow(); drNew["name"] = string.Format("{0} {1}", dr["name"], dr["family"]); drNew["hokmId"] = dr["HokmId"]; drNew["row"] = counter++; drNew["nationalCode"] = dr["idd_meli"]; drNew["date"] = dr["DateUpload"]; drNew["code_ostad"] = dr["code_ostad"]; drNew["InfoPeopleId"] = dr["InfoPeopleId"]; dtResult.Rows.Add(drNew); } return(dtResult); }
public ProfessorHokmDTO getHokmInfoByHokmId(int hokmId) { CooperationRequestDAO CR = new CooperationRequestDAO(); DataTable dtAllHokm = new DataTable(); dtAllHokm = CR.getAllHokmInfo(); ProfessorHokmDTO oHokm = new ProfessorHokmDTO(); if (dtAllHokm.Rows.Count > 0) { DataRow[] dr = dtAllHokm.Select("hokmId=" + hokmId); if (dr.Length == 1) { oHokm.HokmId = Convert.ToInt32(dr[0]["HokmId"]); oHokm.InfoPeopleId = Convert.ToInt32(dr[0]["InfoPeopleId"]); oHokm.Code_Ostad = Convert.ToInt32(dr[0]["code_ostad"]); oHokm.HokmUrl = dr[0]["hokmurl"].ToString(); oHokm.MablaghHokm = Convert.ToInt64(dr[0]["MablaghHokm"]); oHokm.Number_Hokm = dr[0]["number_hokm"].ToString(); oHokm.Date_RunHokm = dr[0]["date_runhokm"].ToString(); oHokm.Date_Hokm = dr[0]["date_hokm"].ToString(); oHokm.Payeh = Convert.ToInt32(dr[0]["payeh"]); oHokm.Type_Estekhdam = Convert.ToInt32(dr[0]["type_estekhdam"]); oHokm.Uni_Khedmat = Convert.ToInt32(dr[0]["uni_khedmat"]); oHokm.Uni_KhedmatType = Convert.ToInt32(dr[0]["uni_khedmatType"]); oHokm.Nahveh_Hamk = Convert.ToInt32(dr[0]["nahveh_hamk"]); if (dr[0]["isRetired"] != DBNull.Value) { oHokm.IsRetired = Convert.ToBoolean(dr[0]["isRetired"]); } oHokm.DateUpload = dr[0]["dateupload"].ToString(); oHokm.State = Convert.ToInt32(dr[0]["state"]); if (dr[0]["DateRunHokmHere"] != DBNull.Value) { oHokm.DateRunHokmHere = dr[0]["DateRunHokmHere"].ToString(); } oHokm.Martabeh = Convert.ToInt32(dr[0]["Martabeh"]); oHokm.EditRequestId = Convert.ToInt32(dr[0]["EditRequestId"]); oHokm.BoundHour = Convert.ToBoolean(dr[0]["BoundHour"]); } } return(oHokm); }
public DataTable getTeachersHaveNotPersonalImage_CantUpload() { CooperationRequestDAO CR = new CooperationRequestDAO(); return(CR.getTeachersHaveNotPersonalImage_CantUpload()); }
public DataTable getbeginAndEndWorkTimeHOD(Int64 codeOstad, int year) { CooperationRequestDAO dao = new CooperationRequestDAO(); return(dao.getbeginAndEndWorkTimeHOD(codeOstad, year)); }
public DataTable getProfessorsByModifyType(int eventID, string fromDate, string toDate) { CooperationRequestDAO CR = new CooperationRequestDAO(); return(CR.getProfessorsByModifyType(eventID, fromDate, toDate)); }
public DataTable getEmploymentActionHistory() { CooperationRequestDAO CR = new CooperationRequestDAO(); return(CR.getEmploymentActionHistory()); }
public void updateHokmSeenStatus(int requestId, bool seenStatus) { CooperationRequestDAO CR = new CooperationRequestDAO(); CR.updateHokmSeenStatus(requestId, Convert.ToInt16(seenStatus)); }