protected void grdChangeList_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
DataRowView dataRowView = (DataRowView)e.Row.DataItem;
int ControlTofieldId = Convert.ToInt32(dataRowView["ControlTofieldId"]);
int codingTypeId = Convert.ToInt32(dataRowView["CodingId"]);
string OldValue = dataRowView["OldValue"].ToString();
string NewValue = dataRowView["NewValue"].ToString();
DataTable dtCoding = new DataTable();
DropDownList drpOldValue = new DropDownList();
DropDownList drpNewValue = (DropDownList)e.Row.FindControl("drpNewValue");
DataRow dr;
#region MyRegion
switch (ControlTofieldId)
{
case 7: //مدرک تحصیلی -2
//case 9://رشته تحصیلی- 4
case 19: //دانشگاه تحصیل - 1
case 30: //نظام - 7
case 35: //دانشگاه خدمت - 1
#region MyRegion
dtCoding = CB.GetCodingByTypeId(codingTypeId);
dr = dtCoding.NewRow();
dr["id"] = "0";
dr["namecoding"] = "انتخاب نشده";
dr["idTypeCoding"] = codingTypeId;
dtCoding.Rows.Add(dr);
drpOldValue.CssClass = "form-control";
drpOldValue.Enabled = false;
e.Row.Cells[2].Controls.Add(drpOldValue);
drpNewValue.Visible = true;
setSource("namecoding", "Id", dtCoding, ref drpOldValue, OldValue);
setSource("namecoding", "Id", dtCoding, ref drpNewValue, NewValue);
#endregion
break;
case 15: //کشور تحصیل - 5
#region MyRegion
dtCoding = CB.GetCodingByTypeId(codingTypeId).AsEnumerable().Where(row => row.Field <decimal>("ID") < 56).CopyToDataTable();
dr = dtCoding.NewRow();
dr["id"] = "-1";
dr["namecoding"] = "انتخاب نشده";
dr["idTypeCoding"] = codingTypeId;
dtCoding.Rows.Add(dr);
drpOldValue.CssClass = "form-control";
drpOldValue.Enabled = false;
e.Row.Cells[2].Controls.Add(drpOldValue);
drpNewValue.Visible = true;
if (string.IsNullOrEmpty(OldValue))
{
OldValue = "-1";
}
if (string.IsNullOrEmpty(NewValue))
{
NewValue = "-1";
}
setSource("namecoding", "Id", dtCoding, ref drpOldValue, OldValue);
setSource("namecoding", "Id", dtCoding, ref drpNewValue, NewValue);
#endregion
break;
case 9: //رشته تحصیلی- 4
#region MyRegion
dtCoding = CB.GetCodingByTypeId(codingTypeId);
dr = dtCoding.NewRow();
dr["id"] = "-1";
dr["namecoding"] = "انتخاب نشده";
dr["idTypeCoding"] = codingTypeId;
dtCoding.Rows.Add(dr);
drpOldValue.CssClass = "form-control";
drpOldValue.Enabled = false;
e.Row.Cells[2].Controls.Add(drpOldValue);
drpNewValue.Visible = true;
setSource("namecoding", "Id", dtCoding, ref drpOldValue, OldValue);
setSource("namecoding", "Id", dtCoding, ref drpNewValue, NewValue);
#endregion
break;
case 17: //نوع دانشگاه تحصیل
#region MyRegion
dtCoding.Columns.Add("id");
dtCoding.Columns.Add("title");
dr = dtCoding.NewRow();
dr["id"] = 0;
dr["title"] = "انتخاب نشده";
dtCoding.Rows.Add(dr);
dr = dtCoding.NewRow();
dr["id"] = 1;
dr["title"] = "دولتی";
dtCoding.Rows.Add(dr);
dr = dtCoding.NewRow();
dr["id"] = 2;
dr["title"] = "آزاد";
dtCoding.Rows.Add(dr);
dr = dtCoding.NewRow();
dr["id"] = 3;
dr["title"] = "حوزه";
dtCoding.Rows.Add(dr);
dr = dtCoding.NewRow();
dr["id"] = 4;
dr["title"] = "خارج از کشور";
dtCoding.Rows.Add(dr);
dr = dtCoding.NewRow();
dr["id"] = 5;
dr["title"] = "سایر";
dtCoding.Rows.Add(dr);
drpOldValue.CssClass = "form-control";
drpOldValue.Enabled = false;
e.Row.Cells[2].Controls.Add(drpOldValue);
drpNewValue.Visible = true;
setSource("title", "Id", dtCoding, ref drpOldValue, OldValue);
setSource("title", "Id", dtCoding, ref drpNewValue, NewValue);
#endregion
break;
case 33: //تاهل - 3
#region MyRegion
dtCoding.Columns.Add("Id", typeof(int));
dtCoding.Columns.Add("namecoding", typeof(string));
dtCoding.Rows.Add(1, "مجرد");
dtCoding.Rows.Add(2, "متاهل");
drpOldValue.CssClass = "form-control";
drpOldValue.Enabled = false;
e.Row.Cells[2].Controls.Add(drpOldValue);
drpNewValue.Visible = true;
setSource("namecoding", "Id", dtCoding, ref drpOldValue, OldValue);
setSource("namecoding", "Id", dtCoding, ref drpNewValue, NewValue);
#endregion
break;
case 43: //نوع بیمه
#region MyRegion
dtCoding.Columns.Add("id");
dtCoding.Columns.Add("title");
dr = dtCoding.NewRow();
dr["id"] = 0;
dr["title"] = "فاقد بیمه";
dtCoding.Rows.Add(dr);
dr = dtCoding.NewRow();
dr["id"] = 1;
dr["title"] = "مشمول بیمه";
dtCoding.Rows.Add(dr);
dr = dtCoding.NewRow();
dr["id"] = 2;
dr["title"] = "لشکری";
dtCoding.Rows.Add(dr);
dr = dtCoding.NewRow();
dr["id"] = 3;
dr["title"] = "کشوری";
dtCoding.Rows.Add(dr);
dr = dtCoding.NewRow();
dr["id"] = 4;
dr["title"] = "خدمات درمانی";
dtCoding.Rows.Add(dr);
dr = dtCoding.NewRow();
dr["id"] = 5;
dr["title"] = "سلامت";
dtCoding.Rows.Add(dr);
dr = dtCoding.NewRow();
dr["id"] = 6;
dr["title"] = "تامین اجتماعی";
dtCoding.Rows.Add(dr);
dr = dtCoding.NewRow();
dr["id"] = 7;
dr["title"] = "بازنشسته";
dtCoding.Rows.Add(dr);
dr = dtCoding.NewRow();
dr["id"] = 8;
dr["title"] = "سایر موارد";
dtCoding.Rows.Add(dr);
drpOldValue.CssClass = "form-control";
drpOldValue.Enabled = false;
e.Row.Cells[2].Controls.Add(drpOldValue);
drpNewValue.Visible = true;
setSource("title", "Id", dtCoding, ref drpOldValue, OldValue);
setSource("title", "Id", dtCoding, ref drpNewValue, NewValue);
#endregion
break;
case 44: //بازنشستگی
#region MyRegion
dtCoding.Columns.Add("id");
dtCoding.Columns.Add("title");
dr = dtCoding.NewRow();
dr["id"] = "True";
dr["title"] = "بازنشسته";
dtCoding.Rows.Add(dr);
dr = dtCoding.NewRow();
dr["id"] = "False";
dr["title"] = "شاغل";
dtCoding.Rows.Add(dr);
drpOldValue.CssClass = "form-control";
drpOldValue.Enabled = false;
e.Row.Cells[2].Controls.Add(drpOldValue);
drpNewValue.Visible = true;
setSource("title", "Id", dtCoding, ref drpOldValue, OldValue);
setSource("title", "Id", dtCoding, ref drpNewValue, NewValue);
#endregion
break;
case 45: //استان سکونت - 14
case 47: //استان کار - 14
#region MyRegion
dtCoding = CB.GetOstan();
dr = dtCoding.NewRow();
dr["id"] = "-1";
dr["title"] = "انتخاب نشده";
drpOldValue.CssClass = "form-control";
drpOldValue.Enabled = false;
e.Row.Cells[2].Controls.Add(drpOldValue);
drpNewValue.Visible = true;
setSource("title", "Id", dtCoding, ref drpOldValue, OldValue);
setSource("title", "Id", dtCoding, ref drpNewValue, NewValue);
#endregion
break;
case 46: //شهر سکونت - 13
case 48: //شهر کار - 13
#region MyRegion
dtCoding = CB.GetNameCity_fcoding();
dr = dtCoding.NewRow();
dr["id"] = "-1";
dr["title"] = "انتخاب نشده";
drpOldValue.CssClass = "form-control";
drpOldValue.Enabled = false;
e.Row.Cells[2].Controls.Add(drpOldValue);
drpNewValue.Visible = true;
setSource("title", "Id", dtCoding, ref drpOldValue, OldValue);
setSource("title", "Id", dtCoding, ref drpNewValue, NewValue);
#endregion
break;
case 53: //جنسیت
#region MyRegion
dtCoding.Columns.Add("id");
dtCoding.Columns.Add("title");
dr = dtCoding.NewRow();
dr["id"] = 0;
dr["title"] = "انتخاب نشده";
dtCoding.Rows.Add(dr);
dr = dtCoding.NewRow();
dr["id"] = "1";
dr["title"] = "مرد";
dtCoding.Rows.Add(dr);
dr = dtCoding.NewRow();
dr["id"] = "2";
dr["title"] = "زن";
dtCoding.Rows.Add(dr);
drpOldValue.CssClass = "form-control";
drpOldValue.Enabled = false;
e.Row.Cells[2].Controls.Add(drpOldValue);
drpNewValue.Visible = true;
setSource("title", "Id", dtCoding, ref drpOldValue, OldValue);
setSource("title", "Id", dtCoding, ref drpNewValue, NewValue);
#endregion
break;
case 54: //گروه
#region MyRegion
#region get values
DataTable dtSelectedDanesh = new DataTable();
DataTable dtAllDanesh = new DataTable();
DataTable dtAllDep = CB.GetAllDepartman();// گرفتن دپارتمان ها با توجه به دانشکده
DataTable dtShowDepOld = new DataTable();
DataTable dtShowDepNew = new DataTable();
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 + ")");
}
#endregion
#region set oldValue source
if (OldValue.Length > 0)
{
dtShowDepOld = drSelectedDepOld.CopyToDataTable();
}
CheckBoxList chkDepOld = new CheckBoxList();
chkDepOld.DataTextField = "namegroup";
chkDepOld.DataValueField = "id";
chkDepOld.RepeatColumns = 4;
chkDepOld.RepeatDirection = RepeatDirection.Horizontal;
chkDepOld.DataSource = dtShowDepOld;
chkDepOld.DataBind();
List <string> depListOld = new List <string>();
foreach (DataRow eachDr in drSelectedDepOld)
{
depListOld.Add(eachDr["namegroup"].ToString());
}
foreach (ListItem lch in chkDepOld.Items)
{
if (depListOld.Contains(lch.Text))
{
lch.Selected = true;
}
}
#endregion
#region set newValue source
if (drSelectedDepNew.Length > 0)
{
if (NewValue.Length > 0)
{
dtShowDepNew = drSelectedDepNew.CopyToDataTable();
}
CheckBoxList chkDepNew_View = (CheckBoxList)e.Row.FindControl("chkDepNew_View");
chkDepNew_View.Visible = true;
chkDepNew_View.DataTextField = "namegroup";
chkDepNew_View.DataValueField = "id";
chkDepNew_View.DataSource = dtShowDepNew;
chkDepNew_View.DataBind();
List <string> depListNew = new List <string>();
foreach (DataRow eachDr in drSelectedDepNew)
{
depListNew.Add(eachDr["namegroup"].ToString());
}
foreach (ListItem lch in chkDepNew_View.Items)
{
if (depListNew.Contains(lch.Text))
{
lch.Selected = true;
}
}
chkDepNew_View.Enabled = false;
}
#endregion
#region add controls to grid
e.Row.Cells[2].Controls.Add(chkDepOld);
drpNewValue.Visible = false;
TextBox txt = (TextBox)e.Row.FindControl("txtNewValue");
if (txt != null)
{
txt.Visible = false;
}
Label lbl = (Label)e.Row.FindControl("lblNewValue");
if (lbl != null)
{
lbl.Visible = false;
}
#endregion
#endregion
break;
}
#endregion
if (!IsTextBoxField(ControlTofieldId))
{
Label lblNewValue = (Label)e.Row.FindControl("lblNewValue");
lblNewValue.Visible = false;
drpNewValue = (DropDownList)e.Row.FindControl("drpNewValue");
drpNewValue.Visible = true;
}
}
}
private void LoadInfoToControls()
{
ListItem itmSelect = new ListItem("انتخاب کنید", "-1");
ListItem itmOther = new ListItem("سایر", "0");
int codeostad = Convert.ToInt32(Session[sessionNames.userID_StudentOstad]);
DTO.University.Faculty.editInfoStruct editInfo = FRB.getOstadInf(codeostad);
//Session.Add("hrInfoPeopleId", editInfo.hrId);
DataTable dtResault = FRB.GetOstadInfoFromHR(codeostad);
if (dtResault.Rows.Count == 0)
{
string msg = "کد استادی شما در هیچ کدام از سامانه ها فعال نیست. لطفا جهت فعال سازی با کارشناس مربوطه تماس حاصل فرمایید";
RadWindowManager1.RadAlert(msg, 400, 200, "پیام سیستم", "RedirectToMain");
return;
}
Session.Add("hrInfoPeopleId", dtResault.Rows[0]["Id"]);
DataTable dtControlToSidaList = FRB.GetAllControlToSidaFields();
txtCodeMeli.Text = editInfo.idd_Melli;
txtFirstName.Text = editInfo.name;
txtFamily.Text = editInfo.family;
txtFatherName.Text = editInfo.fatherName;
AddValueToChangeList(codeostad, dtControlToSidaList, txtFatherName.Text, txtFatherName.ID);
txtShCode.Text = editInfo.idd;
AddValueToChangeList(codeostad, dtControlToSidaList, txtShCode.Text, txtShCode.ID);
txtYearBorn.Text = editInfo.salTavalod;
AddValueToChangeList(codeostad, dtControlToSidaList, txtYearBorn.Text, txtYearBorn.ID);
drpNezam.DataSource = CB.GetStatusMilitary_fcoding();
drpNezam.DataTextField = "namecoding";
drpNezam.DataValueField = "id";
drpNezam.DataBind();
drpNezam.Items.Insert(0, new ListItem(itmSelect.Text, itmSelect.Value));
drpNezam.Items.Insert(drpNezam.Items.Count, new ListItem(itmOther.Text, itmOther.Value));
drpNezam.SelectedValue = editInfo.nezam.ToString();
AddValueToChangeList(codeostad, dtControlToSidaList, drpNezam.SelectedValue, drpNezam.ID + "Value");
rdblMarriage.SelectedValue = editInfo.taahol ? "2" : "1";
AddValueToChangeList(codeostad, dtControlToSidaList, rdblMarriage.SelectedValue, rdblMarriage.ID);
rblGender.SelectedValue = editInfo.sexIsMan ? "1" : "2";
AddValueToChangeList(codeostad, dtControlToSidaList, rblGender.SelectedValue, rblGender.ID);
if (!editInfo.sexIsMan)
{
pnlMilitary.Visible = false;
}
drpLastMaghta.Items.Clear();
drpLastMaghta.DataSource = CB.GetCodingByTypeId(2);
drpLastMaghta.DataValueField = "Id";
drpLastMaghta.DataTextField = "namecoding";
drpLastMaghta.DataBind();
drpLastMaghta.Items.Insert(0, new ListItem(itmSelect.Text, itmSelect.Value));
drpLastMaghta.SelectedValue = editInfo.maghta.ToString();
AddValueToChangeList(codeostad, dtControlToSidaList, editInfo.maghta == 0 ? "" : editInfo.maghta.ToString(), drpLastMaghta.ID + "Value");
DataTable dtField = CB.SelectField_fcoding();
for (int i = 0; i <= dtField.Rows.Count - 1; i++)
{
dtField.Rows[i]["nameresh"] = dtField.Rows[i]["nameresh"].ToString().Replace("ي", "ی");
}
drpReshte.DataSource = dtField;
drpReshte.DataTextField = "nameresh";
drpReshte.DataValueField = "id";
drpReshte.DataBind();
drpReshte.Items.Insert(0, new RadComboBoxItem(itmSelect.Text, itmSelect.Value));
drpReshte.Items.Insert(drpReshte.Items.Count, new RadComboBoxItem(itmOther.Text, itmOther.Value));
drpReshte.SelectedValue = editInfo.reshte.ToString();
AddValueToChangeList(codeostad, dtControlToSidaList, editInfo.reshte == 0 ? "" : editInfo.reshte.ToString(), drpReshte.ID + "Value");
drpUniversityType.SelectedValue = editInfo.typeUniMadrak.ToString();
AddValueToChangeList(codeostad, dtControlToSidaList, drpUniversityType.SelectedValue, drpUniversityType.ID + "Value");
txtSiba.Text = editInfo.siba;
AddValueToChangeList(codeostad, dtControlToSidaList, editInfo.siba, txtSiba.ID);
txtYearGetMadrak.Text = editInfo.salMadrak;
AddValueToChangeList(codeostad, dtControlToSidaList, editInfo.salMadrak, txtYearGetMadrak.ID);
txtSanavat.Text = editInfo.sanavat;
AddValueToChangeList(codeostad, dtControlToSidaList, editInfo.sanavat, txtSanavat.ID);
DataTable dtCountrySource = CB.GetNameCountry_fcoding();
drpCountry.DataSource = dtCountrySource.Select("id<56").CopyToDataTable();
drpCountry.DataTextField = "namecoding";
drpCountry.DataValueField = "id";
drpCountry.DataBind();
drpCountry.Items.Insert(0, new ListItem(itmSelect.Text, itmSelect.Value));
drpCountry.SelectedValue = editInfo.keshvar.ToString();
AddValueToChangeList(codeostad, dtControlToSidaList, editInfo.keshvar.ToString(), drpCountry.ID + "Value");
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("ي", "ی");
}
drpUniName.DataSource = dtUniName;
drpUniName.DataTextField = "namecoding";
drpUniName.DataValueField = "ID";
drpUniName.DataBind();
drpUniName.Items.Insert(0, new RadComboBoxItem(itmSelect.Text, itmSelect.Value));
drpUniName.Items.Insert(drpUniName.Items.Count, new RadComboBoxItem(itmOther.Text, itmOther.Value));
drpUniName.SelectedValue = editInfo.nameUniMadrak.ToString();
AddValueToChangeList(codeostad, dtControlToSidaList, drpUniName.SelectedValue, drpUniName.ID + "Value");
if (editInfo.bime)
{
rdblBimehStatus.SelectedValue = "1";
drpBimehType.Enabled = true;
txtInsuranceNumber.Enabled = true;
drpBimehType.SelectedValue = editInfo.bimeType.ToString();
txtInsuranceNumber.Text = editInfo.bimeNum;
drpBimehType.Enabled = true;
txtInsuranceNumber.Enabled = true;
}
else
{
rdblBimehStatus.SelectedValue = "2";
}
AddValueToChangeList(codeostad, dtControlToSidaList, drpBimehType.SelectedValue, drpBimehType.ID + "Value");
AddValueToChangeList(codeostad, dtControlToSidaList, txtInsuranceNumber.Text, txtInsuranceNumber.ID);
chbkIsRetired.Checked = editInfo.bazneshaste;
AddValueToChangeList(codeostad, dtControlToSidaList, chbkIsRetired.Checked.ToString(), "chbkIsRetired");
ViewState.Add(listOfChanges, ChangeList);
getScansAreNotInDB();
}
