/*--------------------------------*/
private void setDDlTermSource(bool isTerm)
{
Business.Common.CommonBusiness cbsn = new Business.Common.CommonBusiness();
ddlTerm.Items.Clear();
switch (isTerm)
{
case true:
DataTable dtTermJary = cbsn.SelectAllTerm();
DataRow[] drTerm = dtTermJary.Select("tterm>='96-97-1'");
foreach (DataRow dr in drTerm)
{
if (!dr["tterm"].ToString().EndsWith("3") || (dr["tterm"].ToString().EndsWith("3") && string.Compare(dr["tterm"].ToString(), "98-99-3") >= 0))
{
ListItem l = new ListItem();
l.Text = dr["tterm"].ToString();
l.Value = dr["tterm"].ToString();
ddlTerm.Items.Add(l);
}
}
break;
case false:
var dt = bsn.getYearToSigncontract_HOD();
ddlTerm.DataSource = dt;
ddlTerm.DataTextField = "year";
ddlTerm.DataValueField = "year";
ddlTerm.DataBind();
break;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string mId = Request.QueryString["id"].ToString();
string[] id = mId.ToString().Split(new char[] { '@' });
string menuId = "";
for (int i = 0; i < id[1].Length; i++)
{
string s = id[1].Substring(i + 1, 1);
if (s != "-")
{
menuId += s;
}
else
{
break;
}
Session[sessionNames.menuID] = menuId;
}
AccessControl1.MenuId = Session[sessionNames.menuID].ToString();
AccessControl1.UserId = Session[sessionNames.userID_Karbar].ToString();
Business.Common.CommonBusiness CB = new Business.Common.CommonBusiness();
rsht = CB.SelectAllField(0);
setComboBind();
}
}
private void setLog(int OstadCode, string Description, bool acceptAgreement)
{
DTO.eventEnum eventType = DTO.eventEnum.امضای_قرارداد_توسط_مدیر_کارگزینی;
if (acceptAgreement)
{
switch (int.Parse(Request.QueryString["uc"]))
{
case (int)DTO.RoleEnums.مدیر_کل_امور_پژوهشی:
eventType = DTO.eventEnum.تایید_تفاهم_نامه_توسط_مدیر_کل_امور_پژوهشی;
break;
case (int)DTO.RoleEnums.سرپرست_واحد:
eventType = DTO.eventEnum.تایید_تفاهم_نامه_توسط_سرپرست_واحد;
break;
}
}
else
{
eventType = DTO.eventEnum.رد_تفاهم_نامه;
}
Business.Common.CommonBusiness CB = new Business.Common.CommonBusiness();
int userId; //کاربری که لاگین کرده
//eventType//کد کاری که انجام شده.
int appId; //کد قسمتی از برنامه که الان توش هستیم. یعنی کارگزینی - 13
string description; //توضیحات اختیاری
int modifyId; //کد استاد ...
userId = int.Parse(Session[sessionNames.userID_Karbar].ToString());
appId = 13;
modifyId = OstadCode;
description = Description;
CB.InsertIntoUserLog(userId, DateTime.Now.ToString("HH:mm"), appId, (int)eventType, description, modifyId);
}
protected void RadGrid1_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
try
{
List <Email_Class> emDTO = new List <Email_Class>();
List <Email_ConnectDTO> emConDTO = new List <Email_ConnectDTO>();
CommonBusiness cmn = new Business.Common.CommonBusiness();
DataTable DT = emB.GiveList_Status(3);
if (DT.Rows.Count == 0)
{
btn_Taeid.Visible = false;
}
DataColumn column;
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "OldEmail";
DT.Columns.Add(column);
for (int i = 0; i < DT.Rows.Count; i++)
{
if (adB.Get_FindUser_SamAccountName(DT.Rows[i]["stcode"].ToString()))
{
DT.Rows[i]["OldEmail"] = DT.Rows[i]["stcode"].ToString();
}
else
{
DT.Rows[i]["OldEmail"] = "-";
}
}
grd_ListAfterCreateEmail.DataSource = DT;
}
catch (Exception)
{
Response.Write("need");
}
}
private void showHistory(int hrID)
{
Business.Common.CommonBusiness cmb = new Business.Common.CommonBusiness();
lst_history.DataSource = cmb.getAgreementHistory(hrID);
lst_history.DataBind();
ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", "openModal();", true);
}
private void setDaneshSource()
{
Business.Common.CommonBusiness cb = new Business.Common.CommonBusiness();
var danesh = cb.SelectAllDaneshkade();
ddlDaneshkade.DataSource = danesh;
ddlDaneshkade.DataValueField = "id";
ddlDaneshkade.DataTextField = "namedanesh";
ddlDaneshkade.DataBind();
}
private void setTerm()
{
Business.Common.CommonBusiness Term = new Business.Common.CommonBusiness();
var te = Term.SelectAllTerm();
drpdTerm.DataSource = te;
drpdTerm.DataValueField = "tterm";
drpdTerm.DataTextField = "tterm";
drpdTerm.DataBind();
}
private void setLog(int modifyId)
{
Business.Common.CommonBusiness CB = new Business.Common.CommonBusiness();
int userId; //کاربری که لاگین کرده
int appId; //کد قسمتی از برنامه که الان توش هستیم. یعنی فارغ التحصیلان - 10
userId = Convert.ToInt32(Session[sessionNames.userID_Karbar]);
appId = 10;
CB.InsertIntoUserLog(userId, DateTime.Now.ToString("HH:mm"), appId, (int)DTO.eventEnum.مشاهده_ريز_نمرات_فارغ_التحصيلان, "", modifyId);
}
private void fillComponents()
{
Business.Common.CommonBusiness CB = new Business.Common.CommonBusiness();
string currentTerm = CB.getCurrentTerm();
txtCurrentTerm.Text = currentTerm;
txtLastTerm.Text = CB.getLastTerm(currentTerm);
txtEntryYear.Text = "13" + currentTerm.Substring(0, 2);
txtByEntryYear.Text = (Convert.ToInt32(txtEntryYear.Text) - 1).ToString();
}
private bool resetPassword(string stcode, string newPassword)
{
try
{
Business.Common.CommonBusiness cb = new Business.Common.CommonBusiness();
return(cb.insertStudentPassword(txtStcode.Text.Trim(), txtNationalCode.Text.Trim()));
}
catch (Exception ex) {
return(false);
}
}
private void setLog(int modifyID)
{
Business.Common.CommonBusiness commonBSN = new Business.Common.CommonBusiness();
string userId; //کاربری که لاگین کرده
//eventType//کد کاری که انجام شده.
int appId; //کد قسمتی از برنامه که الان توش هستیم. یعنی کارگزینی - 13
appId = Convert.ToInt32(Session[sessionNames.appID_StudentOstad]);
commonBSN.InsertIntoStudentLog(ViewState[hrID].ToString(), DateTime.Now.ToString("HH:mm"), 13, 50, Session[sessionNames.userID_StudentOstad].ToString(), modifyID);
}
private void setLog(string description, int requestID, int eventID)
{
Business.Common.CommonBusiness CB = new Business.Common.CommonBusiness();
int userId; //کاربری که لاگین کرده
int appId; //کد قسمتی از برنامه که الان توش هستیم. یعنی کارگزینی - 13
int modifyId; //کد درخواست ویرایش شده
userId = int.Parse(Session[sessionNames.userID_Karbar].ToString());
appId = 12;
modifyId = requestID;
CB.InsertIntoUserLog(userId, DateTime.Now.ToString("HH:mm"), appId, eventID, description, modifyId);
}
private void setDaneshSource()
{
Business.Common.CommonBusiness cb = new Business.Common.CommonBusiness();
var danesh = cb.SelectAllDaneshkade();
drpdDanesh.DataSource = danesh;
drpdDanesh.DataValueField = "id";
drpdDanesh.DataTextField = "namedanesh";
drpdDanesh.DataBind();
ListItem l = new ListItem("تمام دانشکده ها", "0");
drpdDanesh.Items.Insert(0, l);
}
private void setLog(int inquiryID, string Description, DTO.eventEnum eventType)
{
Business.Common.CommonBusiness CB = new Business.Common.CommonBusiness();
int userId; //کاربری که لاگین کرده
int appId; //کد قسمتی از برنامه که الان توش هستیم. یعنی کارگزینی - 13
string description; //توضیحات اختیاری
int modifyId; //کد درخواست ویرایش شده. ویرایش اطلاعات فردی،اطلاعات تماس و ...
userId = int.Parse(Session[sessionNames.userID_Karbar].ToString());
appId = 10;
modifyId = inquiryID;
description = Description;
CB.InsertIntoUserLog(userId, DateTime.Now.ToString("HH:mm"), appId, (int)eventType, description, modifyId);
}
private void openCartAccess(int sheetID)
{
var xApp = new Microsoft.Office.Interop.Excel.Application();
xApp.Visible = false;
var xBook = xApp.Workbooks.Open(getExcel());
Dictionary <int, List <indexColumn> > sheetColumns = ViewState[vs_SheetColumn] as Dictionary <int, List <indexColumn> >;
List <indexColumn> AllColumns;
bool existSheet = sheetColumns.TryGetValue(sheetID, out AllColumns);
if (existSheet)
{
try
{
Business.Common.CommonBusiness CB = new Business.Common.CommonBusiness();
var sheet = (Microsoft.Office.Interop.Excel.Worksheet)xBook.Worksheets.Item[sheetID];
int lastRow = sheet.Cells.SpecialCells(XlCellType.xlCellTypeLastCell, Type.Missing).Row;
int lastCol = 1;
int tempLast = sheet.Cells.SpecialCells(XlCellType.xlCellTypeLastCell, Type.Missing).Column;
for (int col = 1; col < tempLast; col++)
{
if ((sheet.Cells[3, col] as Microsoft.Office.Interop.Excel.Range).Value2 == null)
{
break;
}
else
{
lastCol++;
}
}
int stcodeColumnNumber = Convert.ToInt32(AllColumns.FindLast(c => c.columnName == "stcode").selectedInExcel);
bool res;
for (int i = firstRow + 1; i < lastRow; i++)
{
var stcode = (sheet.Cells[i, stcodeColumnNumber] as Microsoft.Office.Interop.Excel.Range).Value2;
res = CB.openCartAccess(Convert.ToString(stcode));
(sheet.Cells[i, lastCol + 1] as Microsoft.Office.Interop.Excel.Range).Value2 = "دسترسی باز " + (res ? "شد" : "نشد");
}
(sheet.Cells[1, 1] as Microsoft.Office.Interop.Excel.Range).Value2 = null;
xBook.Close(false);
xApp.Quit();
}
catch (Exception ex)
{
showAlert(ex.Message);
}
}
}
private void setTerm()
{
ddlTerm.Items.Clear();
Business.Common.CommonBusiness bsn = new Business.Common.CommonBusiness();
DataTable dtTermJary = bsn.SelectAllTerm();
DataRow[] drTerm = dtTermJary.Select("tterm>='96-97-1'");
foreach (DataRow dr in drTerm)
{
if (!dr["tterm"].ToString().EndsWith("3"))
{
ListItem l = new ListItem();
l.Text = dr["tterm"].ToString();
l.Value = dr["tterm"].ToString();
ddlTerm.Items.Add(l);
}
}
}
private void setResh()
{
Business.Common.CommonBusiness Resh = new Business.Common.CommonBusiness();
var re = Resh.SelectAllField(Convert.ToInt32(drpdDanesh.SelectedItem.Value));
drpdResh.DataSource = re;
drpdResh.DataValueField = "id";
drpdResh.DataTextField = "nameresh";
drpdResh.DataBind();
ListItem l = new ListItem("تمام رشته ها", "0");
drpdResh.Items.Insert(0, l);
//DropDownListItem l = new DropDownListItem("انتخاب کنید", "0");
//drpdResh.Items.Insert(0,l);
//drp.DataSource = re;
//drp.DataValueField = "id";
//drp.DataTextField = "nameresh";
//drp.DataBind();
}
private void setTermSource()
{
ddlTerm.Visible = true;
txtTerm.Visible = false;
Business.Common.CommonBusiness CB = new Business.Common.CommonBusiness();
ddlTerm.DataSource = CB.GetAllAdobeConnectionTerms();
ddlTerm.DataTextField = "term";
ddlTerm.DataValueField = "term";
ddlTerm.DataBind();
if (ddlTerm.Items.Count > 0)
{
setComponentValue(ddlTerm.SelectedItem.Value);
}
else
{
ddlTerm.Visible = false;
txtTerm.Visible = true;
}
}
protected void btnReject_Click(object sender, EventArgs e)
{
Business.university.CooperationRequest.CooperationRequestBusiness bsn = new Business.university.CooperationRequest.CooperationRequestBusiness();
int agreementID;
if (bsn.rejectTeacherAgreement(Convert.ToInt64(Request.QueryString["pc"]), txtRejectReason.Text.Trim(), out agreementID))
{
Business.Common.CommonBusiness common = new Business.Common.CommonBusiness();
string msg = "استاد گرامي، تفاهم نامه سركار / جنابعالي مورد تاييد امور پژوهشی واقع نگرديد. لطفاً جهت كسب اطلاعات بيشتر به سامانه خدمات الكترونيك مراجعه و يا با شماره 42863000 تماس حاصل فرماييد.";
string smsStatusText; bool sentSMS;
common.sendSMS(2, Request.QueryString["pc"].ToString(), msg, out sentSMS, out smsStatusText);
setLog(Convert.ToInt32(Request.QueryString["hc"]), agreementID.ToString(), false);
}
else
{
showMessage("خطایی در رد قرارداد به وجود آمده است. لطفا مجددا تلاش فرمایید.", false);
}
ScriptManager.RegisterStartupScript(uplConfirm, uplConfirm.GetType(), "CloseAndRebind", "CloseAndRebind(true);", true);
}
private void setFieldSource()
{
Business.Common.CommonBusiness cb = new Business.Common.CommonBusiness();
DataTable fields = new DataTable();
if (ddlDaneshkade.CheckedItems.Count > 0)
{
foreach (var a in ddlDaneshkade.CheckedItems)
{
if (a.Checked)
{
fields.Merge(cb.SelectAllField(Convert.ToInt32(a.Value)));
}
}
}
ddlField.DataSource = fields;
ddlField.DataValueField = "id";
ddlField.DataTextField = "nameresh";
ddlField.DataBind();
//if(ddlField.CheckedItems.Count==0)
// ddlField.ch
}
protected void grdContracts_ItemCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e)
{
int teacherCode = 0;
try
{
teacherCode = Convert.ToInt32(e.CommandArgument.ToString());
}
catch { }
if (teacherCode < 1)
{
return;
}
switch (e.CommandName)
{
case "ShowContract":
string TC = ddlContractType.SelectedItem.Value == "1" ? DTO.contract.educationContract : DTO.contract.HeadOfDepartment;
ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", "openWin('sc=" + e.Item.Cells[3].Text + "&hc=" + teacherCode + "&uc=" + ViewState[userType].ToString() + "&vs=" + (ddlContractStatus.SelectedItem.Value.ToString() == "2" ? "s" : "v") + "&TC=" + TC + "');", true);
break;
case "History":
Business.Common.CommonBusiness cmb = new Business.Common.CommonBusiness();
lst_history.DataSource = cmb.getContractHistory(teacherCode);
lst_history.DataBind();
ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", "openModal();", true);
break;
//case "AcceptContract":
// Business.university.CooperationRequest.CooperationRequestBusiness bsn = new Business.university.CooperationRequest.CooperationRequestBusiness();
// if (bsn.updateTeacherContractStatus(teacherCode, Convert.ToInt32(ViewState[userType])))
// {
// setLog(teacherCode, "");
// }
// break;
}
setGrdDatasource();
grdContracts.DataBind();
}
private void InsertTuitions(int sheetID)
{
var xApp = new Microsoft.Office.Interop.Excel.Application();
xApp.Visible = false;
var xBook = xApp.Workbooks.Open(getExcel());
Dictionary <int, List <indexColumn> > sheetColumns = ViewState[vs_SheetColumn] as Dictionary <int, List <indexColumn> >;
List <indexColumn> AllColumns;
bool existSheet = sheetColumns.TryGetValue(sheetID, out AllColumns);
if (existSheet)
{
try
{
Business.Common.CommonBusiness CB = new Business.Common.CommonBusiness();
var sheet = (Microsoft.Office.Interop.Excel.Worksheet)xBook.Worksheets.Item[sheetID];
int lastRow = sheet.Cells.SpecialCells(XlCellType.xlCellTypeLastCell, Type.Missing).Row;
int stcodeColumnNumber = Convert.ToInt32(AllColumns.FindLast(c => c.columnName == "stcode").selectedInExcel);
int tuitionColumnNumber = Convert.ToInt32(AllColumns.FindLast(c => c.columnName == "shah_fix").selectedInExcel);
string term = Convert.ToString((sheet.Cells[1, 1] as Microsoft.Office.Interop.Excel.Range).Value2);
string userName = Session[sessionNames.userName_Karbar].ToString();
string fishNumber = txtIcanNumber.Text;
for (int i = firstRow + 1; i < lastRow; i++)
{
var stcode = (sheet.Cells[i, stcodeColumnNumber] as Microsoft.Office.Interop.Excel.Range).Value2;
var amount = (sheet.Cells[i, tuitionColumnNumber] as Microsoft.Office.Interop.Excel.Range).Value2;
CB.insertTuitional(userName, Convert.ToString(stcode), fishNumber, Convert.ToDecimal(amount), Convert.ToString(term));
}
(sheet.Cells[1, 1] as Microsoft.Office.Interop.Excel.Range).Value2 = null;
xBook.Close(false);
xApp.Quit();
}
catch (Exception ex)
{
showAlert(ex.Message);
}
}
}
protected void btnReject_Click(object sender, EventArgs e)
{
string description = "علت:" + txtRejectReason.Text.Trim(), term = "";
switch (_typeOfContract)
{
case DTO.contract.educationContract:
DataTable dt = bsn.getTerm_Contract(ucContract.term);
if (dt.Rows.Count > 0)
{
description += string.Format(" نیم سال {0} سال تحصیلی {1}", dt.Rows[0]["nimsal"].ToString(), dt.Rows[0]["sal"].ToString());
}
term = ucContract.term;
break;
case DTO.contract.HeadOfDepartment:
description += string.Format(" سال {0} ", ucContract_HeadOfDepartment.year);
term = ucContract_HeadOfDepartment.year;
break;
}
if (bsn.rejectTeacherContract(Convert.ToInt32(Request.QueryString["hc"].Trim()), txtRejectReason.Text.Trim(), term))
{
Business.Common.CommonBusiness common = new Business.Common.CommonBusiness();
string msg = "استاد گرامي، قرارداد ترم " + term + " سركار / جنابعالي مورد تاييد اداره كارگزيني هيات علمي واقع نگرديد. لطفاً جهت كسب اطلاعات بيشتر به سامانه خدمات الكترونيك مراجعه و يا با شماره 42863288 تماس حاصل فرماييد.";
//common.sendSMS(2, Request.QueryString["sc"].ToString(), msg);
//common.SendSMSByUserIdAndType(msg, Request.QueryString["sc"].ToString(), 2);
string smsStatusText; bool sentSMS;
common.sendSMS(2, Request.QueryString["sc"].Trim().ToString(), msg, out sentSMS, out smsStatusText);
setLog(Convert.ToInt32(Request.QueryString["hc"].Trim()), description, false);
}
else
{
showMessage("خطایی در رد قرارداد به وجود آمده است. لطفا مجددا تلاش فرمایید.", false);
}
ScriptManager.RegisterStartupScript(uplConfirm, uplConfirm.GetType(), "CloseAndRebind", "CloseAndRebind(true);", true);
}
protected void btnConfirmToInsert_Click(object sender, EventArgs e)
{
Business.Common.CommonBusiness CB = new Business.Common.CommonBusiness();
bool r;
switch (hdnTypeInsert.Value)
{
case "CurrentEntry":
r = CB.insertTuitionFormol(ddlLevel.SelectedItem.Value, txtEntryYear.Text.Substring(2, 2), txtCurrentTerm.Text, txtByEntryYear.Text.Substring(2, 2), txtLastTerm.Text.Replace("-2", "-1"), Convert.ToInt32(txtFixTuition.Text), Convert.ToInt32(txtVarTuition_CurrentEntry.Text), Convert.ToInt32(txtInsurance.Text), Convert.ToInt64(txtService.Text));
if (r)
{
showMessage(string.Format("کد فرمول برای مقطع {0} ورودی سال {1} بر اساس ورودی {2} درج شد", ddlLevel.SelectedItem.Text, txtEntryYear.Text, txtByEntryYear.Text));
}
else
{
showMessage("کد فرمول درج نشد");
}
break;
case "OtherEntries":
r = CB.insertTuitionFormol_LastEntries(txtCurrentTerm.Text, txtLastTerm.Text, Convert.ToInt32(txtVarTuition_OtherEntries.Text), Convert.ToInt32(ddlLevel_OtherEntries.SelectedItem.Value));
if (r)
{
showMessage(string.Format("کد فرمول برای {0} برای نیمسال {1} بر اساس نیمسال {2} درج شد", ddlLevel_OtherEntries.SelectedItem.Text, txtCurrentTerm.Text, txtLastTerm.Text));
}
else
{
showMessage("کد فرمول درج نشد");
}
break;
}
hdnTypeInsert.Value = "";
}
private void updateExcelTuitional(int sheetID)
{
var xApp = new Microsoft.Office.Interop.Excel.Application();
xApp.Visible = false;
var xBook = xApp.Workbooks.Open(getExcel());
Dictionary <int, List <indexColumn> > sheetColumns = ViewState[vs_SheetColumn] as Dictionary <int, List <indexColumn> >;
List <indexColumn> AllColumns;
bool existSheet = sheetColumns.TryGetValue(sheetID, out AllColumns);
if (existSheet)
{
try
{
Business.Common.CommonBusiness CB = new Business.Common.CommonBusiness();
DataTable dt;
var sheet = (Microsoft.Office.Interop.Excel.Worksheet)xBook.Worksheets.Item[sheetID];
int lastRow = sheet.Cells.SpecialCells(XlCellType.xlCellTypeLastCell, Type.Missing).Row;
int lastCol = 1;
int tempLast = sheet.Cells.SpecialCells(XlCellType.xlCellTypeLastCell, Type.Missing).Column;
for (int col = 1; col < tempLast; col++)
{
if ((sheet.Cells[3, col] as Microsoft.Office.Interop.Excel.Range).Value2 == null)
{
break;
}
else
{
lastCol++;
}
}
(sheet.Cells[firstRow, lastCol + 1] as Microsoft.Office.Interop.Excel.Range).Value2 = "شهریه ثابت";
(sheet.Cells[firstRow, lastCol + 2] as Microsoft.Office.Interop.Excel.Range).Value2 = "شهریه متغیر";
(sheet.Cells[firstRow, lastCol + 3] as Microsoft.Office.Interop.Excel.Range).Value2 = "جمع شهریه";
string term = Convert.ToString((sheet.Cells[1, 1] as Microsoft.Office.Interop.Excel.Range).Value2);
int stcodeColumnNumber = Convert.ToInt32(AllColumns.FindLast(c => c.columnName == "stcode").selectedInExcel);
for (int i = firstRow + 1; i < lastRow; i++)
{
var stcode = (sheet.Cells[i, stcodeColumnNumber] as Microsoft.Office.Interop.Excel.Range).Value2;
if (stcode != null)
{
dt = CB.getStudentTuitional(term, Convert.ToString(stcode));
if (dt.Rows.Count == 0)
{
continue;
}
(sheet.Cells[i, lastCol + 1] as Microsoft.Office.Interop.Excel.Range).Value2 = dt.Rows[0][0];
(sheet.Cells[i, lastCol + 2] as Microsoft.Office.Interop.Excel.Range).Value2 = dt.Rows[0][1];
(sheet.Cells[i, lastCol + 3] as Microsoft.Office.Interop.Excel.Range).Value2 = dt.Rows[0][2];
}
}
(sheet.Cells[1, 1] as Microsoft.Office.Interop.Excel.Range).Value2 = null;
xBook.Close(true);
xApp.Quit();
}
catch (Exception ex)
{
showMessage(ex.Message);
xBook.Close(false);
xApp.Quit();
//System.IO.File.Delete(MapPath(ViewState[vs_ExcelFile].ToString()));
}
}
}
protected void rbConfirmed_RegisterChanges_Click(object sender, EventArgs e)
{
bool sentSMS; string smsStatus;
StudentFeraghatDocument SFD = new StudentFeraghatDocument();
var s = GFB.getStudentFeraghatDocument(txtStcode.Text);
bool mashmulChanged = false;
Business.Common.CommonBusiness CB = new Business.Common.CommonBusiness();
DataTable dtMsg = CB.GetAppIDMessage(0, 12, 1, 1);
if (dtMsg.Rows.Count > 0)
{
paymentReceiptMsg = dtMsg.Rows[0]["text"].ToString();
stampMsg = paymentReceiptMsg;
}
int requestID = s.RequestID;
SFD.stcode = txtStcode.Text;
SFD.HasStamp = !cbxTambr.Checked;
SFD.HasPaymentReceipt = !cbxFish.Checked;
SFD.mashmul = cbxMashmul.Checked;
SFD.SpecialTips = txtMavaredKhas.Text;
SFD.RequestID = requestID;
SFD.serialNumber_Daneshname = txtSerialDaneshname.Text.Trim();
SFD.serialNumber_Movaghat = txtSerialMovaghat.Text.Trim();
SFD.documentNumber_Daneshname = txtDocNumDaneshname.Text.Trim();
SFD.documentNumber_Movaghat = txtDocNumMovaghat.Text.Trim();
if (!s.isOnline)
{
if (s.mashmul != SFD.mashmul)
{
mashmulChanged = true;
}
}
string description = getChangeset(SFD);
int archiveID = 0;
if (GFB.UpdateFeraghatTahsil_GraduateDocument(SFD, mashmulChanged))
{
if (SFD.HasStamp != s.HasStamp)
{
if (SFD.HasStamp)
{
Business.university.Request.CheckOutNaghsBusiness chNaghs = new Business.university.Request.CheckOutNaghsBusiness();
var naghsDT = chNaghs.GetAllNaghsByReqId(requestID);
if (naghsDT.Rows.Count > 0)
{
DataRow[] dr = naghsDT.Select("RequestLogID=29");
if (dr.Length > 0)
{
int naghsID = Convert.ToInt32(dr[0]["naghsID"]);
chNaghs.ResolveNaghsById(naghsID);
archiveID = GFB.insertDocArchiveId(SFD.RequestID);
}
}
}
else
{
naghs.InsertNaghs(new DTO.University.Request.CheckOutNaghsDTO
{
IsResolved = false,
NaghsMessage = stampMsg,
RequestLogId = 29,
ResolveDate = "",
ResolveMessage = "",
StCode = SFD.stcode,
StudentRequestId = SFD.RequestID,
SubmitDate = DateTime.Now.ToPeString(),
Erae_Be = "0"
});
setLog("لطفا تمبر خریداری فرمایید.", requestID, (int)DTO.eventEnum.ارسال_پیام_تسویه);
CB.sendSMS(1, SFD.stcode, stampMsg, out sentSMS, out smsStatus);
}
}
if (SFD.HasPaymentReceipt != s.HasPaymentReceipt)
{
if (SFD.HasPaymentReceipt)
{
Business.university.Request.CheckOutNaghsBusiness chNaghs = new Business.university.Request.CheckOutNaghsBusiness();
var naghsDT = chNaghs.GetAllNaghsByReqId(requestID);
if (naghsDT.Rows.Count > 0)
{
DataRow[] dr = naghsDT.Select("RequestLogID=30");
if (dr.Length > 0)
{
int naghsID = Convert.ToInt32(dr[0]["naghsID"]);
chNaghs.ResolveNaghsById(naghsID);
archiveID = GFB.insertDocArchiveId(SFD.RequestID);
}
}
}
else
{
naghs.InsertNaghs(new DTO.University.Request.CheckOutNaghsDTO
{
IsResolved = false,
NaghsMessage = paymentReceiptMsg,
RequestLogId = 30,
ResolveDate = "",
ResolveMessage = "",
StCode = SFD.stcode,
StudentRequestId = SFD.RequestID,
SubmitDate = DateTime.Now.ToPeString(),
Erae_Be = "0"
});
setLog("لطفا فیش واریزی تهیه فرمایید.", requestID, (int)DTO.eventEnum.ارسال_پیام_تسویه);
string asanak = CB.sendSMS(1, SFD.stcode, paymentReceiptMsg, out sentSMS, out smsStatus);
}
}
if (description.Trim() != "")
{
setLog(description, requestID, (int)DTO.eventEnum.ایجاد_تغییر_در_صفحه_مشاهده_پرونده_دانشجویان_فارغ_التحصیل);
}
}
getStudentInformation(SFD.stcode);
}
