public ProfessorHokmDTO GetNewHokmInfo(int reqId)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "Request.SP_GetProfessorNewHokmByReqId";
cmd.Parameters.AddWithValue("@reqId", reqId);
DataTable dt = new DataTable();
ProfessorHokmDTO oHokm = new ProfessorHokmDTO();
try
{
conn.Open();
SqlDataReader rdr;
rdr = cmd.ExecuteReader();
dt.Load(rdr);
if (dt.Rows.Count > 0)
{
oHokm.HokmId = Convert.ToInt32(dt.Rows[0]["HokmId"]);
oHokm.InfoPeopleId = Convert.ToInt32(dt.Rows[0]["InfoPeopleId"]);
oHokm.Code_Ostad = Convert.ToInt32(dt.Rows[0]["code_ostad"]);
oHokm.HokmUrl = dt.Rows[0]["hokmurl"].ToString();
oHokm.MablaghHokm = Convert.ToInt64(dt.Rows[0]["MablaghHokm"]);
oHokm.Number_Hokm = dt.Rows[0]["number_hokm"].ToString();
oHokm.Date_RunHokm = dt.Rows[0]["date_runhokm"].ToString();
oHokm.Date_Hokm = dt.Rows[0]["date_hokm"].ToString();
oHokm.Payeh = Convert.ToInt32(dt.Rows[0]["payeh"]);
oHokm.Type_Estekhdam = Convert.ToInt32(dt.Rows[0]["type_estekhdam"]);
oHokm.Uni_Khedmat = Convert.ToInt32(dt.Rows[0]["uni_khedmat"]);
oHokm.Uni_KhedmatType = Convert.ToInt32(dt.Rows[0]["uni_khedmatType"]);
oHokm.Nahveh_Hamk = Convert.ToInt32(dt.Rows[0]["nahveh_hamk"]);
if (dt.Rows[0]["isRetired"] != DBNull.Value)
{
oHokm.IsRetired = Convert.ToBoolean(dt.Rows[0]["isRetired"]);
}
oHokm.DateUpload = dt.Rows[0]["dateupload"].ToString();
oHokm.State = Convert.ToInt32(dt.Rows[0]["state"]);
if (dt.Rows[0]["DateRunHokmHere"] != DBNull.Value)
{
oHokm.DateRunHokmHere = dt.Rows[0]["DateRunHokmHere"].ToString();
}
oHokm.Martabeh = Convert.ToInt32(dt.Rows[0]["Martabeh"]);
oHokm.EditRequestId = Convert.ToInt32(dt.Rows[0]["EditRequestId"]);
if (dt.Rows[0]["BoundHour"] != DBNull.Value)
{
oHokm.BoundHour = Convert.ToBoolean(dt.Rows[0]["BoundHour"]);
}
}
conn.Close();
}
catch (Exception)
{
throw;
}
return(oHokm);
}
public bool updateHokmInThreeTables(ProfessorHokmDTO oHokm)
{
try
{
return(reqDAO.updateHokmInThreeTables(oHokm));
}
catch
{
return(false);
}
}
private void setHokmInfoSource(int hokmId)
{
ProfessorHokmDTO oNewHokm = CRB.getHokmInfoByHokmId(hokmId);
if (oNewHokm.HokmId == 0)
{
lblHokmId.InnerText = "کد حکم : " + hokmId.ToString();
dvHokmBody.Visible = false;
return;
}
dvHokmBody.Visible = true;
hdnReqId.Value = hokmId.ToString();
lblHokmId.InnerText = "کد حکم : " + hokmId.ToString();
DataTable dtUniName = CB.GetNameUni_fcoding();
for (int i = 0; i <= dtUniName.Rows.Count - 1; i++)
{
dtUniName.Rows[i][0] = dtUniName.Rows[i][0].ToString().Replace("ي", "ی");
}
drpPastUni.DataSource = dtUniName;
drpPastUni.DataTextField = "namecoding";
drpPastUni.DataValueField = "ID";
drpPastUni.DataBind();
drpPastUni.SelectedValue = oNewHokm.Uni_Khedmat.ToString();
txtCodeOstad.Text = oNewHokm.Code_Ostad.ToString();
txtHokmNumber.Text = oNewHokm.Number_Hokm.ToString();
txtDateEjraHokm.Text = oNewHokm.Date_RunHokm;
txtDateSodoorHokm.Text = oNewHokm.Date_Hokm;
txtMablaghHokm.Text = oNewHokm.MablaghHokm.ToString();
txtPaye.Text = oNewHokm.Payeh.ToString();
imgNewHokm.Visible = false;
string hokmUrl = oNewHokm.HokmUrl.ToString();
if (hokmUrl.Length > 0)
{
int subIndex = hokmUrl.IndexOf(substringScanFile) + substringScanFile.Length + 1;
imgNewHokm.HRef = "OpenScanImage.aspx?o=" + oNewHokm.Code_Ostad.ToString() + "&f=" + hokmUrl.Substring(subIndex);
imgNewHokm.Visible = true;
}
drpHireType.SelectedValue = oNewHokm.Type_Estekhdam.ToString();
if (drpMartabe.Items.FindByValue(oNewHokm.Martabeh.ToString()) != null)
{
drpMartabe.SelectedValue = oNewHokm.Martabeh.ToString();
}
else
{
drpMartabe.SelectedValue = "-1";
}
rdblHireType.SelectedValue = oNewHokm.Nahveh_Hamk.ToString();
chkBoundHour.Checked = oNewHokm.BoundHour;
}
public bool ApproveNewHokm(ProfessorHokmDTO oHokm)
{
int Id = reqDAO.ApproveNewHokm(oHokm);
if (Id > 0)
{
return(true);
}
else
{
return(false);
}
}
public ProfessorHokmDTO GetLastHokmInfoByInfoPeopleID(int infoPeopleId)
{
ProfessorHokmDTO oHokm = new ProfessorHokmDTO();
DataTable dt = reqDAO.GetLastHokmInfoByInfoPeopleID(infoPeopleId);
if (dt.Rows.Count > 0)
{
oHokm.HokmId = Convert.ToInt32(dt.Rows[0]["HokmId"]);
oHokm.InfoPeopleId = Convert.ToInt32(dt.Rows[0]["InfoPeopleId"]);
oHokm.Code_Ostad = Convert.ToInt32(dt.Rows[0]["code_ostad"]);
oHokm.HokmUrl = dt.Rows[0]["hokmurl"].ToString();
oHokm.MablaghHokm = Convert.ToInt64(dt.Rows[0]["MablaghHokm"]);
oHokm.Number_Hokm = dt.Rows[0]["number_hokm"].ToString();
oHokm.Date_RunHokm = dt.Rows[0]["date_runhokm"].ToString();
oHokm.Date_Hokm = dt.Rows[0]["date_hokm"].ToString();
oHokm.Payeh = Convert.ToInt32(dt.Rows[0]["payeh"]);
oHokm.Type_Estekhdam = Convert.ToInt32(dt.Rows[0]["type_estekhdam"]);
oHokm.Uni_Khedmat = Convert.ToInt32(dt.Rows[0]["uni_khedmat"]);
oHokm.Uni_KhedmatType = dt.Rows[0]["uni_khedmatType"] == System.DBNull.Value ? 0 : Convert.ToInt32(dt.Rows[0]["uni_khedmatType"]);
oHokm.Nahveh_Hamk = Convert.ToInt32(dt.Rows[0]["nahveh_hamk"]);
if (dt.Rows[0]["isRetired"] != DBNull.Value)
{
oHokm.IsRetired = Convert.ToBoolean(dt.Rows[0]["isRetired"]);
}
oHokm.DateUpload = dt.Rows[0]["dateupload"].ToString();
oHokm.State = Convert.ToInt32(dt.Rows[0]["state"]);
if (dt.Rows[0]["BoundHour"] != DBNull.Value)
{
oHokm.BoundHour = Convert.ToBoolean(dt.Rows[0]["boundHour"]);
}
if (dt.Rows[0]["DateRunHokmHere"] != DBNull.Value)
{
oHokm.DateRunHokmHere = dt.Rows[0]["DateRunHokmHere"].ToString();
}
oHokm.Martabeh = Convert.ToInt32(dt.Rows[0]["Martabeh"]);
oHokm.EditRequestId = Convert.ToInt32(dt.Rows[0]["EditRequestId"]);
if (dt.Rows[0]["BoundHour"] != DBNull.Value)
{
oHokm.BoundHour = Convert.ToBoolean(dt.Rows[0]["BoundHour"]);
}
}
return(oHokm);
}
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 int ApproveNewHokm(ProfessorHokmDTO oHokm)
{
SqlCommand cmds = new SqlCommand();
cmds.Connection = hrConnection;
cmds.CommandType = CommandType.StoredProcedure;
cmds.CommandText = "HR.SP_ApproveNewHokm";
cmds.Parameters.AddWithValue("@HokmId", oHokm.HokmId);
cmds.Parameters.AddWithValue("@MablaghHokm", oHokm.MablaghHokm);
cmds.Parameters.AddWithValue("@number_hokm", oHokm.Number_Hokm);
cmds.Parameters.AddWithValue("@date_runhokm", oHokm.Date_RunHokm);
cmds.Parameters.AddWithValue("@date_hokm", oHokm.Date_Hokm);
cmds.Parameters.AddWithValue("@payeh", oHokm.Payeh);
cmds.Parameters.AddWithValue("@type_estekhdam", oHokm.Type_Estekhdam);
cmds.Parameters.AddWithValue("@uni_khedmat", oHokm.Uni_Khedmat);
cmds.Parameters.AddWithValue("@uni_khedmatType", oHokm.Uni_KhedmatType);
cmds.Parameters.AddWithValue("@nahveh_hamk", oHokm.Nahveh_Hamk);
cmds.Parameters.AddWithValue("@IsRetired", oHokm.IsRetired);
cmds.Parameters.AddWithValue("@State", oHokm.State);
cmds.Parameters.AddWithValue("@Martabeh", oHokm.Martabeh);
cmds.Parameters.AddWithValue("@DateRunHokmHere", oHokm.DateRunHokmHere);
cmds.Parameters.AddWithValue("@BoundHour", oHokm.BoundHour?1:0);
try
{
hrConnection.Open();
int reqId = cmds.ExecuteNonQuery();
hrConnection.Close();
return(reqId);
}
catch (Exception ex)
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
throw;
}
}
public bool updateHokmInThreeTables(ProfessorHokmDTO oHokm)
{
SqlCommand cmds = new SqlCommand();
cmds.Connection = hrConnection;
cmds.CommandType = CommandType.StoredProcedure;
cmds.CommandText = "dbo.sp_UpdateHokmInThreeTables";
cmds.Parameters.AddWithValue("@MablaghHokm", oHokm.MablaghHokm);
cmds.Parameters.AddWithValue("@number_hokm", oHokm.Number_Hokm);
cmds.Parameters.AddWithValue("@date_runhokm", oHokm.Date_RunHokm);
cmds.Parameters.AddWithValue("@date_hokm", oHokm.Date_Hokm);
cmds.Parameters.AddWithValue("@payeh", oHokm.Payeh);
cmds.Parameters.AddWithValue("@type_estekhdam", oHokm.Type_Estekhdam);
cmds.Parameters.AddWithValue("@uni_khedmat", oHokm.Uni_Khedmat);
cmds.Parameters.AddWithValue("@uni_khedmatType", oHokm.Uni_KhedmatType);
cmds.Parameters.AddWithValue("@nahveh_hamk", oHokm.Nahveh_Hamk);
cmds.Parameters.AddWithValue("@IsRetired", oHokm.IsRetired);
cmds.Parameters.AddWithValue("@Martabeh", oHokm.Martabeh);
cmds.Parameters.AddWithValue("@BoundHour", oHokm.BoundHour ? 1 : 0);
cmds.Parameters.AddWithValue("@hrID", oHokm.InfoPeopleId);
cmds.Parameters.AddWithValue("@codeOstad", oHokm.Code_Ostad);
try
{
hrConnection.Open();
int count = cmds.ExecuteNonQuery();
hrConnection.Close();
return(count > 0);
}
catch (Exception ex)
{
if (hrConnection.State == ConnectionState.Open)
{
hrConnection.Close();
}
return(false);
}
}
public void AddNewHokm(ProfessorHokmDTO oProfessorHokmDTO)
{
SqlCommand cmds = new SqlCommand();
cmds.Connection = hrConnection;
cmds.CommandType = CommandType.StoredProcedure;
cmds.CommandText = "HR.SP_InsertHokmInfo";
cmds.Parameters.AddWithValue("@InfoPeopleId", oProfessorHokmDTO.InfoPeopleId);
cmds.Parameters.AddWithValue("@code_ostad", oProfessorHokmDTO.Code_Ostad);
cmds.Parameters.AddWithValue("@HokmUrl", (object)oProfessorHokmDTO.HokmUrl ?? DBNull.Value);
cmds.Parameters.AddWithValue("@MablaghHokm", oProfessorHokmDTO.MablaghHokm);
cmds.Parameters.AddWithValue("@number_hokm", oProfessorHokmDTO.Number_Hokm);
cmds.Parameters.AddWithValue("@date_runhokm", oProfessorHokmDTO.Date_RunHokm);
cmds.Parameters.AddWithValue("@date_hokm", oProfessorHokmDTO.Date_Hokm);
cmds.Parameters.AddWithValue("@payeh", oProfessorHokmDTO.Payeh);
cmds.Parameters.AddWithValue("@type_estekhdam", oProfessorHokmDTO.Type_Estekhdam);
cmds.Parameters.AddWithValue("@uni_khedmat", oProfessorHokmDTO.Uni_Khedmat);
cmds.Parameters.AddWithValue("@uni_khedmatType", oProfessorHokmDTO.Uni_KhedmatType);
cmds.Parameters.AddWithValue("@nahveh_hamk", oProfessorHokmDTO.Nahveh_Hamk);
cmds.Parameters.AddWithValue("@IsRetired", oProfessorHokmDTO.IsRetired);
cmds.Parameters.AddWithValue("@DateUpload", oProfessorHokmDTO.DateUpload);
cmds.Parameters.AddWithValue("@State", oProfessorHokmDTO.State);
cmds.Parameters.AddWithValue("@Martabeh", oProfessorHokmDTO.Martabeh);
cmds.Parameters.AddWithValue("@EditRequestId", oProfessorHokmDTO.EditRequestId);
cmds.Parameters.AddWithValue("@BoundHour", oProfessorHokmDTO.BoundHour);
try
{
hrConnection.Open();
int reqId = cmds.ExecuteNonQuery();
hrConnection.Close();
}
catch (Exception)
{
throw;
}
}
public DataTable getCustomizedProfessorEditedFields(int requestId)
{
DataTable dt = new DataTable();
dt.Columns.Add("fieldName");
dt.Columns.Add("oldValue");
dt.Columns.Add("newValue");
DataTable dtFields = GetProfessorEditInfoFieldsByProfessorRequestId(requestId);
if (dtFields.Rows.Count > 0)
{
DataTable dtfCoding;
Faculty.FacultyReportsBusiness FRB = new Faculty.FacultyReportsBusiness();
Common.CommonBusiness CB = new Common.CommonBusiness();
DataTable dtFieldName = FRB.GetAllControlToSidaFields();
foreach (DataRow dr in dtFields.Rows)
{
DataRow drNew = dt.NewRow();
DataRow[] drFieldName = dtFieldName.Select("id=" + dr["controlToFieldId"]);
if (drFieldName.Length == 1)
{
drNew["fieldName"] = drFieldName[0]["Description"];
drNew["oldValue"] = "";
drNew["newValue"] = "";
if (Convert.ToInt32(drFieldName[0]["codingid"]) != 0)//مقادیر را از جدول بخواند
{
dtfCoding = CB.GetCodingByTypeId(Convert.ToInt32(drFieldName[0]["codingId"]));
if (dtfCoding.Rows.Count > 0)
{
DataRow[] drfCoding;
if (dr["oldValue"] != DBNull.Value && dr["oldValue"].ToString() != "")
{
drfCoding = dtfCoding.Select("id=" + dr["oldValue"]);
if (drfCoding.Length == 1)
{
drNew["oldValue"] = drfCoding[0]["namecoding"];
}
}
if (dr["newValue"] != DBNull.Value && dr["newValue"].ToString() != "")
{
drfCoding = dtfCoding.Select("id=" + dr["newValue"]);
if (drfCoding.Length == 1)
{
drNew["newValue"] = drfCoding[0]["namecoding"];
}
}
}
}
else if (Convert.ToInt32(drFieldName[0]["id"]) == 44)//وضعیت بازنشستگی
{
if (dr["oldvalue"] != DBNull.Value)
{
drNew["oldvalue"] = dr["oldvalue"].ToString() == "1" ? "بازنشسته" : "شاغل";
}
if (dr["newvalue"] != DBNull.Value)
{
drNew["newvalue"] = dr["newvalue"].ToString() == "1" ? "بازنشسته" : "شاغل";
}
}
else if (Convert.ToInt32(drFieldName[0]["id"]) == 53)//جنسیت
{
if (dr["oldvalue"] != DBNull.Value)
{
drNew["oldvalue"] = dr["oldvalue"].ToString() == "1" ? "مرد" : "زن";
}
if (dr["newvalue"] != DBNull.Value)
{
drNew["newvalue"] = dr["newvalue"].ToString() == "1" ? "مرد" : "زن";
}
}
else if (Convert.ToInt32(drFieldName[0]["id"]) == 45 || Convert.ToInt32(drFieldName[0]["id"]) == 47)
{
dtfCoding = CB.GetOstan();
if (dtfCoding.Rows.Count > 0)
{
DataRow[] drfCoding = dtfCoding.Select("id=" + dr["oldValue"]);
if (drfCoding.Length == 1)
{
drNew["oldValue"] = drfCoding[0]["title"];
}
drfCoding = dtfCoding.Select("id=" + dr["newValue"]);
if (drfCoding.Length == 1)
{
drNew["newValue"] = drfCoding[0]["title"];
}
}
}
else if (Convert.ToInt32(drFieldName[0]["id"]) == 46 || Convert.ToInt32(drFieldName[0]["id"]) == 48)
{
dtfCoding = CB.getShahrestan();
if (dtfCoding.Rows.Count > 0)
{
DataRow[] drfCoding = dtfCoding.Select("id=" + dr["oldValue"]);
if (drfCoding.Length == 1)
{
drNew["oldValue"] = drfCoding[0]["title"];
}
drfCoding = dtfCoding.Select("id=" + dr["newValue"]);
if (drfCoding.Length == 1)
{
drNew["newValue"] = drfCoding[0]["title"];
}
}
}
else if (Convert.ToInt32(drFieldName[0]["id"]) == 54)
{
DataTable dtAllDep = CB.GetAllDepartman();// گرفتن دپارتمان ها با توجه به دانشکده
DataTable dtShowDepOld = new DataTable();
DataTable dtShowDepNew = new DataTable();
string NewValue = dr["newvalue"].ToString();
string OldValue = dr["oldvalue"].ToString();
NewValue = NewValue.EndsWith(",") ? NewValue.TrimEnd(',') : NewValue;
OldValue = OldValue.EndsWith(",") ? OldValue.TrimEnd(',') : OldValue;
DataRow[] drSelectedDepOld = new DataRow[0]; if (OldValue.Length > 0)
{
drSelectedDepOld = dtAllDep.Select("id in(" + OldValue + ")");
}
DataRow[] drSelectedDepNew = new DataRow[0]; if (NewValue.Length > 0)
{
drSelectedDepNew = dtAllDep.Select("id in(" + NewValue + ")");
}
foreach (DataRow drOld in drSelectedDepOld)
{
drNew["oldValue"] += drOld["NameGroup"].ToString().Replace("دپارتمان", "") + ",";
}
foreach (DataRow drDepNew in drSelectedDepNew)
{
drNew["newValue"] += drDepNew["namegroup"].ToString().Replace("دپارتمان", "") + ",";
}
drNew["oldValue"] = drNew["oldValue"].ToString().TrimEnd(',');
drNew["newValue"] = drNew["newValue"].ToString().TrimEnd(',');
}
else if (Convert.ToInt32(drFieldName[0]["id"]) == 42)
{
if (dr["oldvalue"] == DBNull.Value)
{
drNew["oldvalue"] = "مشخص نشده";
}
else
{
switch (Convert.ToInt32(dr["oldvalue"]))
{
case 1:
drNew["oldvalue"] = "همکاری برای تدریس";
break;
case 2:
drNew["oldvalue"] = "همکاری برای مشاوره یا راهنمایی پروژه";
break;
case 3:
drNew["oldvalue"] = "همکاری برای تدریس و مشاوره یا راهنمایی پروژه";
break;
default:
drNew["oldvalue"] = "مشخص نشده";
break;
}
}
if (dr["newvalue"] == DBNull.Value)
{
drNew["newvalue"] = "مشخص نشده";
}
else
{
switch (Convert.ToInt32(dr["newvalue"]))
{
case 1:
drNew["newvalue"] = "همکاری برای تدریس";
break;
case 2:
drNew["newvalue"] = "همکاری برای مشاوره یا راهنمایی پروژه";
break;
case 3:
drNew["newvalue"] = "همکاری برای تدریس و مشاوره یا راهنمایی پروژه";
break;
default:
drNew["newvalue"] = "مشخص نشده";
break;
}
}
}
else//همان مقدار را برگرداند
{
if (dr["oldvalue"] != DBNull.Value)
{
drNew["oldvalue"] = dr["oldvalue"];
}
if (dr["newvalue"] != DBNull.Value)
{
drNew["newvalue"] = dr["newvalue"];
}
}
dt.Rows.Add(drNew);
}
}
}
else
{
Common.CommonBusiness CB = new Common.CommonBusiness();
ProfessorHokmDTO newHokm = GetNewHokmInfo(requestId);
if (newHokm.InfoPeopleId > 0)
{
DataRow dr = dt.NewRow();
dr["fieldName"] = "مرتبه دانشگاهی";
switch (newHokm.Martabeh)
{
case 0:
dr["newValue"] = "فاقد مرتبه علمی";
break;
case 1:
dr["newValue"] = "مربی";
break;
case 2:
dr["newValue"] = "دانشیار";
break;
case 3:
dr["newValue"] = "استادیار";
break;
case 4:
dr["newValue"] = "استاد";
break;
}
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["fieldName"] = "پایه";
dr["newValue"] = newHokm.Payeh;
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["fieldName"] = "نوع استخدام";
switch (newHokm.Type_Estekhdam)
{
case 0:
dr["newValue"] = "رسمی";
break;
case 1:
dr["newValue"] = "پیمانی";
break;
case 2:
dr["newValue"] = "قراردادی";
break;
case 3:
dr["newValue"] = "آزمایشی";
break;
}
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["fieldName"] = "نام دانشگاه محل خدمت";
if (newHokm.Uni_Khedmat != 0)
{
DataRow[] drUni = CB.GetNameUni_fcoding().Select("id=" + newHokm.Uni_Khedmat);
if (drUni.Length == 1)
{
dr["newValue"] = drUni[0]["namecoding"];
}
}
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["fieldName"] = "نوع دانشگاه محل خدمت";
switch (newHokm.Uni_KhedmatType)
{
case 1:
dr["newValue"] = "دولتی";
break;
case 2:
dr["newValue"] = "آزاد";
break;
case 3:
dr["newValue"] = "حوزه";
break;
case 4:
dr["newValue"] = "خارج از کشور";
break;
case 5:
dr["newValue"] = "سایر";
break;
}
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["fieldName"] = "تاریخ صدور حکم کارگزینی";
dr["newValue"] = newHokm.Date_Hokm;
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["fieldName"] = "تاریخ اجرای حکم کارگزینی";
dr["newValue"] = newHokm.DateRunHokmHere;
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["fieldName"] = "شماره حکم";
dr["newValue"] = newHokm.Number_Hokm;
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["fieldName"] = "مبلغ حکم";
dr["newValue"] = string.Format("{0:C}", newHokm.MablaghHokm);
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["fieldName"] = "متقاضی تکمیل ساعت موظفی";
dr["newValue"] = newHokm.BoundHour ? "می باشم" : "نمی باشم";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["fieldName"] = "نحوه همکاری";
switch (newHokm.Nahveh_Hamk)
{
case 1:
dr["newValue"] = string.Format("{0} {1}", "تمام وقت 32 ساعت", newHokm.Nahveh_Hamk);
break;
case 2:
dr["newValue"] = string.Format("{0} {1}", "نیمه وقت", newHokm.Nahveh_Hamk);
break;
case 3:
dr["newValue"] = string.Format("{0} {1}", "ساعتی", newHokm.Nahveh_Hamk);
break;
case 4:
dr["newValue"] = string.Format("{0} {1}", "تمام وقت طرح مشمولان", newHokm.Nahveh_Hamk);
break;
case 5:
dr["newValue"] = string.Format("{0} {1}", "بورسیه دکتری", newHokm.Nahveh_Hamk);
break;
case 6:
dr["newValue"] = string.Format("{0} {1}", "کارمند", newHokm.Nahveh_Hamk);
break;
case 7:
dr["newValue"] = string.Format("{0} {1}", "تمام وقت 44 ساعت", newHokm.Nahveh_Hamk);
break;
}
dt.Rows.Add(dr);
}
}
return(dt);
}
//private bool CheckInfo(int newCooperation)
//{
// var codeOstad = Convert.ToInt32(Session["user"]);
// errorMsg = string.Empty;
// if (newCooperation != 2)
// {
// DataTable dtResult = ProfReqBuss.GetProfessorFromResearchByCode(codeOstad);
// if (dtResult.Rows.Count == 0)
// {
// var profReqs = ProfReqBuss.GetAllRequestsByProfCode(codeOstad);
// if (profReqs.Rows.Count > 0)
// {
// var prof = FRB.GetOstadInfoFromHR(codeOstad).Rows[FRB.GetOstadInfoFromHR(codeOstad).Rows.Count - 1];
// // Check Existing Requests
// var personalInfoRequested = profReqs.AsEnumerable().Where(w => w.Field<long>("RequestTypeID") == (int)RequestTypeId.EditPersonalInfo).Count() > 0;
// var contactInfoRequested = profReqs.AsEnumerable().Where(w => w.Field<long>("RequestTypeID") == (int)RequestTypeId.EditContactInfo).Count() > 0;
// var hokmRequested = profReqs.AsEnumerable().Where(w => w.Field<long>("RequestTypeID") == (int)RequestTypeId.EditHokm).Count() > 0;
// // Check Existing Documents
// var docs = ProfReqBuss.GetAllRequestDocsByProfCode(codeOstad);
// if (docs.Rows.Count > 0)
// {
// if (personalInfoRequested)
// {
// if (
// docs.AsEnumerable().Where(w => w.Field<int>("DocType") == (int)Hire.Hire.DocType.صفحه_اول_شناسنامه).Count() > 0
// && docs.AsEnumerable().Where(w => w.Field<int>("DocType") == (int)Hire.Hire.DocType.اسکن_کارت_ملی).Count() > 0
// && docs.AsEnumerable().Where(w => w.Field<int>("DocType") == (int)Hire.Hire.DocType.عکس_پرسنلی).Count() > 0
// && docs.AsEnumerable().Where(w => w.Field<int>("DocType") == (int)Hire.Hire.DocType.آخرین_مدرک_تحصیلی).Count() > 0
// )
// {
// if(Convert.ToInt32(prof["sex"]) == 1
// && Convert.ToInt32(prof["status_nezam"]) != (int)Hire.Hire.militaryStatus.برگ_اعزام
// && Convert.ToInt32(prof["status_nezam"]) != (int)Hire.Hire.militaryStatus.درحين_خدمت
// && Convert.ToInt32(prof["status_nezam"]) != (int)Hire.Hire.militaryStatus.مشمول
// && Convert.ToInt32(prof["status_nezam"]) != (int)Hire.Hire.militaryStatus.غير_مشمول
// && docs.AsEnumerable().Where(w => w.Field<int>("DocType") == (int)Hire.Hire.DocType.اسکن_کارت_پایان_خدمت).Count() == 0
// )
// personalInfoRequested = false;
// if(prof["BimehTypeId"] != null
// || Convert.ToInt32(prof["BimehTypeId"]) == 0
// || (Convert.ToInt32(prof["BimehTypeId"]) > 0
// && docs.AsEnumerable().Where(w => w.Field<int>("DocType") == (int)Hire.Hire.DocType.اسکن_بیمه).Count() == 0))
// personalInfoRequested = false;
// if(Convert.ToInt32(prof["university"]) == 0
// || (Convert.ToInt32(prof["university"]) > 0
// && (Convert.ToInt32(prof["university"]) != 27 ) && Convert.ToInt32(prof["university"]) < 56
// && docs.AsEnumerable().Where(w => w.Field<int>("DocType") == (int)Hire.Hire.DocType.ارزشنامه_تحصیلی_وزارت_علوم).Count() == 0))
// personalInfoRequested = false;
// }
// else
// personalInfoRequested = false;
// }
// if (hokmRequested)
// {
// if (prof["martabeh"] == null)
// hokmRequested = false;
// else if(Convert.ToInt32(prof["martabeh"]) > 0
// && docs.AsEnumerable().Where(w => w.Field<int>("DocType") == (int)Hire.Hire.DocType.آخرین_حکم_کارگزینی).Count() == 0)
// hokmRequested = false;
// else if(prof["idmadrak"] == null)
// hokmRequested = false;
// else if (Convert.ToInt32(prof["idmadrak"]) == (int)Hire.Hire.MadrakType.دانشجوی_دکتری_بعد_امتحان_جامع
// && docs.AsEnumerable().Where(w => w.Field<int>("DocType") == (int)Hire.Hire.DocType.گواهی_امتحان_جامع).Count() == 0)
// hokmRequested = false;
// }
// }
// else
// {
// personalInfoRequested = false;
// contactInfoRequested = false;
// hokmRequested = false;
// }
// // Set Results
// if (!personalInfoRequested)
// errorMsg += "اطلاعات فردی";
// if (!contactInfoRequested)
// {
// errorMsg += errorMsg.Length > 0 ? "، " : "";
// errorMsg += "اطلاعات تماس";
// }
// if (!hokmRequested)
// {
// errorMsg += errorMsg.Length > 0 ? "، " : "";
// errorMsg += "اطلاعات کارگزینی";
// }
// }
// else
// errorMsg = "اطلاعات فردی، اطلاعات تماس و اطلاعات کارگزینی";
// }
// }
// if (string.IsNullOrEmpty(errorMsg))
// return true;
// else
// return false;
//}
private bool CheckInfo(int newCooperation)
{
var personalInfoRequested = true;
var hokmRequested = true;
var contactInfoRequested = true;
var codeOstad = Convert.ToInt32(Session[sessionNames.userID_StudentOstad]);
errorMsg = string.Empty;
if (newCooperation != 2)
{
//var prof = ProfReqBuss.GetProfessorFromResearchByCode(codeOstad);
var prof = FRB.getOstadInf(codeOstad);
var lastHokm = ProfReqBuss.GetLastHokmInfoByInfoPeopleID(Convert.ToInt32(Session["hrInfoPeopleId"]));
lastHokm = new ProfessorHokmDTO();
if (lastHokm.Code_Ostad == 0)
{
var lastReqOfHokm = ProfReqBuss.GetRequestByTypeAndStatus("19", "6");
if (lastReqOfHokm != null)
{
if (lastReqOfHokm.Count > 0)
{
var aa = lastReqOfHokm.AsEnumerable().OrderByDescending(a => a.Id).Where(a => a.Code_Ostad == codeOstad).FirstOrDefault();
if (aa != null)
{
if (aa.Code_Ostad == codeOstad)
{
int reqID = aa.Id;
lastHokm = ProfReqBuss.GetNewHokmInfo(reqID);
}
}
}
}
}
//if (prof.Rows.Count > 0)
if (lastHokm != null && lastHokm.Code_Ostad != 0)
{
var infoId = Convert.ToInt32(prof.hrId);
var shenasnameDoc = ProfReqBuss.GetDocByInfoIdAndType(infoId, (int)Hire.Hire.DocType.صفحه_اول_شناسنامه);
//var cardMeliDoc = ProfReqBuss.GetDocByInfoIdAndType(infoId, (int)Hire.Hire.DocType.اسکن_کارت_ملی);
//var personalPictureDoc = ProfReqBuss.GetDocByInfoIdAndType(infoId, (int)Hire.Hire.DocType.عکس_پرسنلی);
var madrakDoc = ProfReqBuss.GetDocByInfoIdAndType(infoId, (int)Hire.Hire.DocType.آخرین_مدرک_تحصیلی);
if (!string.IsNullOrEmpty(prof.idd) &&
!string.IsNullOrEmpty(prof.idd_Melli) &&
!string.IsNullOrEmpty(prof.salTavalod) &&
!string.IsNullOrEmpty(prof.fatherName) &&
!string.IsNullOrEmpty(prof.name) &&
!string.IsNullOrEmpty(prof.family) &&
prof.maghta > 0 &&
prof.reshte > 0 &&
!string.IsNullOrEmpty(prof.salMadrak) &&
prof.nameUniMadrak > 0 &&
prof.typeUniMadrak > 0 &&
!string.IsNullOrEmpty(prof.sanavat)
//&& !string.IsNullOrEmpty(prof.taahol)
&& !string.IsNullOrEmpty(prof.siba) &&
madrakDoc.Rows.Count > 0 &&
shenasnameDoc.Rows.Count > 0
//&& cardMeliDoc.Rows.Count > 0
//&& personalPictureDoc.Rows.Count > 0
)
{
var nezamDoc = ProfReqBuss.GetDocByInfoIdAndType(infoId, (int)Hire.Hire.DocType.اسکن_کارت_پایان_خدمت);
if (((prof.sexIsMan
//&& !string.IsNullOrEmpty(prof.Rows[0]["status_nezam"].ToString())
&& prof.nezam != (int)Hire.Hire.militaryStatus.درحين_خدمت &&
prof.nezam != (int)Hire.Hire.militaryStatus.غير_مشمول &&
prof.nezam != (int)Hire.Hire.militaryStatus.برگ_اعزام &&
prof.nezam != (int)Hire.Hire.militaryStatus.مشمول &&
nezamDoc.Rows.Count > 0) ||
!prof.sexIsMan ||
(prof.nezam == (int)Hire.Hire.militaryStatus.درحين_خدمت ||
prof.nezam == (int)Hire.Hire.militaryStatus.غير_مشمول ||
prof.nezam == (int)Hire.Hire.militaryStatus.برگ_اعزام ||
prof.nezam == (int)Hire.Hire.militaryStatus.مشمول)))
{
var BimeDoc = ProfReqBuss.GetDocByInfoIdAndType(infoId, (int)Hire.Hire.DocType.آخرین_مدرک_تحصیلی);
if ((prof.bimeType > 0 &&
!string.IsNullOrEmpty(prof.bimeNum) &&
BimeDoc.Rows.Count > 0) || !prof.bime)
{
var vezaratDoc = ProfReqBuss.GetDocByInfoIdAndType(infoId, (int)Hire.Hire.DocType.ارزشنامه_تحصیلی_وزارت_علوم);
if (prof.keshvar > 0 &&
(prof.keshvar != 27 &&
vezaratDoc.Rows.Count > 0) ||
prof.keshvar == 27
)
{
var govahiJameDoc = ProfReqBuss.GetDocByInfoIdAndType(infoId, (int)Hire.Hire.DocType.گواهی_امتحان_جامع);
if (prof.maghta > 0 && prof.keshvar > 0 &&
(
(prof.maghta == 13 &&
prof.keshvar == 27 &&
govahiJameDoc.Rows.Count > 0
) ||
(prof.maghta != 13 ||
prof.keshvar == 27)
))
{
if ((lastHokm.Martabeh >= 0 &&
lastHokm.Payeh > 0 &&
lastHokm.Type_Estekhdam >= 0 &&
(lastHokm.Nahveh_Hamk > 0) &&
(lastHokm.Uni_Khedmat > 0) &&
(lastHokm.Uni_KhedmatType > 0) &&
!string.IsNullOrEmpty(lastHokm.Date_Hokm) &&
lastHokm.Number_Hokm != "" &&
(lastHokm.MablaghHokm > 0) &&
!string.IsNullOrEmpty(lastHokm.HokmUrl)) ||
(lastHokm.Martabeh < 0)
)
{
return(true);
}
else
{
hokmRequested = false;
}
}
else
{
personalInfoRequested = false;
}
}
else
{
personalInfoRequested = false;
}
}
else
{
personalInfoRequested = false;
}
}
else
{
personalInfoRequested = false;
}
}
else
{
personalInfoRequested = false;
}
}
else
{
personalInfoRequested = false;
hokmRequested = false;
}
if (!string.IsNullOrEmpty(prof.telHome) &&
!string.IsNullOrEmpty(prof.telMobile) &&
!string.IsNullOrEmpty(prof.addressHome) &&
!string.IsNullOrEmpty(prof.codePosti) &&
!string.IsNullOrEmpty(prof.email) &&
(prof.ostanHome > 0) &&
(prof.shahrHome > 0)
)
{
contactInfoRequested = false;
}
}
else
{
return(true);
}
// Set Results
if (personalInfoRequested)
{
errorMsg += "اطلاعات فردی";
}
if (contactInfoRequested)
{
errorMsg += errorMsg.Length > 0 ? "، " : "";
errorMsg += "اطلاعات تماس";
}
if (hokmRequested)
{
errorMsg += errorMsg.Length > 0 ? "، " : "";
errorMsg += "اطلاعات کارگزینی";
}
if (string.IsNullOrEmpty(errorMsg))
{
return(true);
}
else
{
return(false);
}
}
protected void btnSubmitChangesNo_OnClick(object sender, EventArgs e)
{
if (HasHrId())
{
if (IsValid)
{
if (rblIsHeiat.SelectedItem.Value == "1")
{
return;
}
ProfessorEditRequestDTO oEditDTO = new ProfessorEditRequestDTO();
oEditDTO.Code_Ostad = Convert.ToInt32(Session[sessionNames.userID_StudentOstad]);
oEditDTO.Createdate = DateTime.Now.ToPeString();
oEditDTO.RequestTypeID = (int)RequestTypeId.EditHokm; // درخواست ویرایش حکم
oEditDTO.RequestLogID = (int)RequestLogId.submitted; // در حال بررسی
oEditDTO.HR_InfoPeople_Id = Convert.ToInt32(Session["hrInfoPeopleId"]);
oEditDTO.ChangeSet = 1;
if (Session["ScanMadarekURL"] != null)
{
oEditDTO.ScanImageUrl = Session["ScanMadarekURL"].ToString().improveFileName();
}
ProfessorHokmDTO oHokm = new ProfessorHokmDTO(oEditDTO.HR_InfoPeople_Id);
oHokm.Code_Ostad = oEditDTO.Code_Ostad;
if (!string.IsNullOrEmpty(txtHokmNumber.Text))
{
oHokm.Number_Hokm = txtHokmNumber.Text;
}
if (!string.IsNullOrEmpty(txtDateSodoorHokm.Text))
{
oHokm.Date_Hokm = txtDateSodoorHokm.Text;
}
if (!string.IsNullOrEmpty(txtDateEjraHokm.Text))
{
oHokm.Date_RunHokm = txtDateEjraHokm.Text;
}
if (!string.IsNullOrEmpty(txtMablaghHokm.Text))
{
oHokm.MablaghHokm = Convert.ToInt64(txtMablaghHokm.Text.Replace(",", ""));
}
if (!string.IsNullOrEmpty(txtPaye.Text))
{
oHokm.Payeh = Convert.ToInt32(txtPaye.Text);
}
if (drpHireType.SelectedValue != "-1")
{
oHokm.Type_Estekhdam = Convert.ToInt32(drpHireType.SelectedValue);
}
if (drpPastUni.SelectedValue != "0" && drpPastUni.SelectedValue != "")
{
oHokm.Uni_Khedmat = Convert.ToInt32(drpPastUni.SelectedValue);
}
if (ddlPastUniType.SelectedValue != "0")
{
oHokm.Uni_KhedmatType = Convert.ToInt32(ddlPastUniType.SelectedValue);
}
if (!string.IsNullOrEmpty(rdblHireType.SelectedValue))
{
oHokm.Nahveh_Hamk = Convert.ToInt32(rdblHireType.SelectedValue);
}
oHokm.DateUpload = DateTime.Now.ToPeString();
if (Session["ScanMadarekURL"] != null)
{
oHokm.HokmUrl = Session["ScanMadarekURL"].ToString().improveFileName();
}
oHokm.State = (int)ChangeState.submitted;
if (rblIsHeiat.SelectedItem.Value == "1")
{
oHokm.Martabeh = Convert.ToInt32(drpMartabe.SelectedValue);
}
else
{
oHokm.Martabeh = 8;
}
oHokm.BoundHour = chkBoundHour.Checked;
oEditDTO.Hokm = oHokm;
int Id = ProfReqBuss.AddNewEditRequest(oEditDTO);
string msg = null;
if (Id > 0)
{
CB.InsertIntoStudentLog(oEditDTO.HR_InfoPeople_Id.ToString(), DateTime.Now.ToString("HH:mm"),
13, 34, Id.ToString());
msg = "درخواست شما با شماره " + Id.ToString() + "با موفقیت ثبت گردید.";
Session["hrInfoPeopleId"] = null;
}
else
{
msg = "خطا در هنگام ثبت درخواست ، لطفا مجددا تلاش کنید.";
}
RadWindowManager1.RadAlert(msg, 400, 100, "پیام سیستم", "RedirectToMain");
}
else if (!string.IsNullOrEmpty(customError))
{
RadWindowManager1.RadAlert(customError, 400, 100, "پیام سیستم", null);
}
}
else
{
RadWindowManager1.RadAlert("به دلیل کامل نبودن سامانه ثبت اطلاعات اساتید امکان این درخواست برای شما وجود ندارد", 400, 100, "پیام سیستم", "RedirectToMain");
}
}
private void BindData(int reqId, int reqType, int reqStatus)
{
if (reqType == (int)RequestTypeId.EditHokm)
{
ProfessorHokmDTO oNewHokm = ProfReqBuss.GetNewHokmInfo(reqId);
if (oNewHokm.Code_Ostad == 0)
{
rblIsHeiat.SelectedValue = 2.ToString();
DivInfoHokm.Visible = false;
}
else
{
DivInfoHokm.Visible = true;
DivimgNewHokm.Visible = true;
DataTable dtUniName = CB.GetNameUni_fcoding();
for (int i = 0; i <= dtUniName.Rows.Count - 1; i++)
{
dtUniName.Rows[i][0] = dtUniName.Rows[i][0].ToString().Replace("ي", "ی");
}
drpPastUni.DataSource = dtUniName;
drpPastUni.DataTextField = "namecoding";
drpPastUni.DataValueField = "ID";
drpPastUni.DataBind();
drpPastUni.SelectedValue = oNewHokm.Uni_Khedmat.ToString();
hdnfHokmId.Value = oNewHokm.HokmId.ToString();
txtCodeOstad.Text = oNewHokm.Code_Ostad.ToString();
txtHokmNumber.Text = oNewHokm.Number_Hokm.ToString();
txtDateEjraHokm.Text = oNewHokm.Date_RunHokm;
txtDateSodoorHokm.Text = oNewHokm.Date_Hokm;
txtMablaghHokm.Text = oNewHokm.MablaghHokm.ToString();
txtPaye.Text = oNewHokm.Payeh.ToString();
if (oNewHokm.HokmUrl != null)
{
string hokmUrl = oNewHokm.HokmUrl.ToString();
int subIndex = hokmUrl.IndexOf(substringScanFile) +
substringScanFile.Length + 1;
if (hokmUrl.Length > 0)
{
imgNewHokm.HRef = "../OpenScanImage.aspx?o=" + oNewHokm.Code_Ostad.ToString() + "&f=" +
hokmUrl.Substring(subIndex);
}
else
{
imgNewHokm.Visible = false;
}
}
else
{
imgNewHokm.Visible = false;
}
drpHireType.SelectedValue = oNewHokm.Type_Estekhdam.ToString();
if (oNewHokm.Martabeh > 0 && oNewHokm.Martabeh < 8)
{
if (drpMartabe.Items.FindByValue(oNewHokm.Martabeh.ToString()) != null)
{
drpMartabe.SelectedValue = oNewHokm.Martabeh.ToString();
}
rblIsHeiat.SelectedValue = "1";
}
else
{
rblIsHeiat.SelectedValue = "2";
}
if (oNewHokm.Nahveh_Hamk != 0)
{
rdblHireType.SelectedValue = oNewHokm.Nahveh_Hamk.ToString();
}
else
{
rdblHireType.Visible = false;
}
dvChangeList.Visible = false;
if (oNewHokm.BoundHour != null)
{
chkBoundHour.Checked = Convert.ToBoolean(oNewHokm.BoundHour);
}
ddlPastUniType.SelectedValue = oNewHokm.Uni_KhedmatType > 0
? oNewHokm.Uni_KhedmatType.ToString()
: "0";
}
dvNewHokm.Visible = true;
dvPersonalInfo.Visible = false;
dvChangeList.Visible = false;
}
else
{
dvChangeList.Visible = true;
dvPersonalInfo.Visible = false;
dvNewHokm.Visible = false;
DataTable oChangeList = ProfReqBuss.GetChangeListByReqId(reqId);
foreach (DataRow row in oChangeList.Rows)
{
foreach (DataColumn col in oChangeList.Columns)
{
if (row["Description"].ToString() == "نحوه همکاری")
{
if (row["OldValue"].ToString() == "1")
{
row["OldValue"] = "همکاری برای تدریس";
}
if (row["OldValue"].ToString() == "2")
{
row["OldValue"] = "همکاری برای مشاوره یا راهنمایی پروژه";
}
if (row["OldValue"].ToString() == "3")
{
row["OldValue"] = "همکاری برای تدریس و مشاوره یا راهنمایی پروژه";
}
if (row["NewValue"].ToString() == "1")
{
row["NewValue"] = "همکاری برای تدریس";
}
if (row["NewValue"].ToString() == "2")
{
row["NewValue"] = "همکاری برای مشاوره یا راهنمایی پروژه";
}
if (row["NewValue"].ToString() == "3")
{
row["NewValue"] = "همکاری برای تدریس و مشاوره یا راهنمایی پروژه";
}
if (row["NewValue"].ToString() == "0")
{
row["NewValue"] = "مشخص نشده";
}
if (row["OldValue"].ToString() == "0")
{
row["OldValue"] = "مشخص نشده";
}
}
}
}
if (reqType == (int)RequestTypeId.EditPersonalInfo)
{
int docStatus = -1;
switch (reqStatus)
{
case 5: //رد شده
docStatus = 2;
break;
case 6: //در حال بررسی
docStatus = 0;
break;
case 7: //تایید شده
docStatus = 1;
break;
}
dvNewHokm.Visible = false;
dvPersonalInfo.Visible = true;
dvChangeList.Visible = false;
DataRow[] drTemp;
dvIdd.Visible = false;
dvMadrak.Visible = false;
dvBime.Visible = false;
dvInf.Visible = false;
drTemp = oChangeList.Select("id1 in(49,50,51,53)");
if (drTemp.Length > 0)
{
dvIdd.Visible = true;
DataTable dtIdd = drTemp.CopyToDataTable();
grdIDD.DataSource = dtIdd;
grdIDD.DataBind();
}
addScanUrlToButton(btnScanIdd, 1, docStatus, dvIdd, reqId);
addScanUrlToButton(btnScanPersonelly, 10, docStatus, dvIdd, reqId);
addScanUrlToButton(btnScanMeli, 5, docStatus, dvIdd, reqId);
drTemp = oChangeList.Select("id1 in(7,9,14,15,17,19)");
if (drTemp.Length > 0)
{
dvMadrak.Visible = true;
DataTable dtMadrak = drTemp.CopyToDataTable();
grdMadrak.DataSource = dtMadrak;
grdMadrak.DataBind();
}
addScanUrlToButton(btnScanMadrak, 4, docStatus, dvMadrak, reqId);
addScanUrlToButton(btnScanArzesh, 14, docStatus, dvMadrak, reqId);
drTemp = oChangeList.Select("id1 in(43,40,44)");
if (drTemp.Length > 0)
{
dvBime.Visible = true;
DataTable dtBime = drTemp.CopyToDataTable();
grdBime.DataSource = dtBime;
grdBime.DataBind();
}
addScanUrlToButton(btnScanBime, 6, docStatus, dvBime, reqId);
addScanUrlToButton(btnScanBazneshaste, 18, docStatus, dvBime, reqId);
drTemp = oChangeList.Select("id1 in(30,31,32,33)");
if (drTemp.Length > 0)
{
dvInf.Visible = true;
DataTable dtOther = drTemp.CopyToDataTable();
grdInf.DataSource = dtOther;
grdInf.DataBind();
}
addScanUrlToButton(btnScanInf, 7, docStatus, dvInf, reqId);
}
else
{
grdChangeList.Visible = true;
dvChangeList.Visible = true;
grdChangeList.DataSource = oChangeList;
grdChangeList.DataBind();
}
LoadChangeListGridBaseInfo(reqType);
}
}
