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