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));
}
