/// <summary> /// با فشردن کلید تایید یا رد درخواست ارسال گواهی اشتغال به تحصیل، این متد فعال می گردد /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="Telerik.Web.UI.GridCommandEventArgs"/> instance containing the event data.</param> protected void grd_GovahiRequest_ItemCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e) { CommonBusiness cmnb = new CommonBusiness(); if (e.CommandName == "radedarkhast") { RadWindowManager windowManager = new RadWindowManager(); RadWindow widnow1 = new RadWindow(); widnow1.NavigateUrl = "../CMS/InsertRejectDescription.aspx?params=" + e.CommandArgument.ToString(); widnow1.ID = "RadWindow1"; windowManager.Width = System.Web.UI.WebControls.Unit.Pixel(500); windowManager.Height = System.Web.UI.WebControls.Unit.Pixel(400); widnow1.VisibleOnPageLoad = true; windowManager.Windows.Add(widnow1); ContentPlaceHolder mpContentPlaceHolder; mpContentPlaceHolder = (ContentPlaceHolder)Page.Master.FindControl("ContentPlaceHolder1"); mpContentPlaceHolder.Controls.Add(widnow1); } if (e.CommandName == "printgovahi") { this.StiWebViewer1.ResetReport(); string[] commandArgs = e.CommandArgument.ToString().Split(new char[] { ',' }); Session["stcode"] = commandArgs[0]; Session["RequestTypeID"] = commandArgs[1]; Session["StudentRequestID"] = commandArgs[2]; Session["Erae_Be"] = commandArgs[3]; var studentRegisterInCurrentTerm = GovahiBusiness.GetStRegisterd(Session["stcode"].ToString()); var studentsInfo = CartBusiness.GetStudentsInfo(Session["stcode"].ToString()); var studentRequest = GovahiBusiness.GetRequestByRequestID(int.Parse(Session["StudentRequestID"].ToString())); var currentTerm = unibusiness.GetTermJary(); var mashmulNumber = studentRequest?.Rows[0]["MashmulNumber"].ToString(); TextBox txt_EraeBe = (TextBox)e.Item.FindControl("txt_EraeBe"); if (studentRegisterInCurrentTerm.Rows.Count == 0) { CartBusiness.UpdateStudentRequestLogID(Session["stcode"].ToString(), 5, 3, int.Parse(Session["StudentRequestID"].ToString())); GovahiBusiness.UpdateStudentPOstNumber(Session["stcode"].ToString(), " عدم ثبت نام در ترم جاری", 3, int.Parse(Session["StudentRequestID"].ToString())); cmnb.InsertIntoUserLog(int.Parse(Session[sessionNames.userID_Karbar].ToString()), DateTime.Now.ToShortTimeString(), int.Parse(Session[sessionNames.appID_Karbar].ToString()), 31, "ارائه به : " + txt_EraeBe.Text, Convert.ToInt32(Session["StudentRequestID"].ToString())); GovahiBusiness.UpdateAmount(Convert.ToInt32(Session["StudentRequestID"]), int.Parse(Session["StudentRequestID"].ToString())); rwm_Validations.RadAlert("به دلیل عدم ثبت نام در ترم جدید امکان چاپ گواهی وجود ندارد و درخواست مورد نظر رد می شود", 500, 100, "خطا", null); grd_GovahiRequest.Rebind(); return; } else { if (currentTerm.Rows[0]["termCode"].ToString() == studentRequest.Rows[0]["Term"].ToString()) { CartBusiness.UpdateStudentRequestLogID(Session["stcode"].ToString(), 7, 3, int.Parse(Session["StudentRequestID"].ToString())); cmnb.InsertIntoUserLog(int.Parse(Session[sessionNames.userID_Karbar].ToString()), DateTime.Now.ToShortTimeString(), int.Parse(Session[sessionNames.appID_Karbar].ToString()), 33, "ارائه به : " + txt_EraeBe.Text, Convert.ToInt32(Session["StudentRequestID"].ToString())); StiWebViewer1.Visible = true; StiReport rpt = new StiReport(); rpt.Load(Server.MapPath("../Reports/eshteghal.mrt")); rpt.Dictionary.Databases.Clear(); rpt.Dictionary.Databases.Add(new StiSqlDatabase("Connection1", CB.ReportConnection.ToString())); rpt.Compile(); rpt.CompiledReport.DataSources["[Request].[SP_Get_StudentInfo]"].Parameters["@stcode"].ParameterValue = Session["stcode"].ToString(); rpt.CompiledReport.DataSources["[Request].[SP_GetRequestByRequestID]"].Parameters["@StudentRequestID"].ParameterValue = int.Parse(Session["StudentRequestID"].ToString()); rpt.RegData(studentsInfo); StiWebViewer1.Report = rpt; StiWebViewer1.Visible = true; } else { var requestID = int.Parse(business.InsertInToStudentRequest(Session["stcode"].ToString(), 3, 7, Session["Erae_Be"].ToString(), mashmulNumber, 1).ToString()); CartBusiness.UpdateStudentRequestLogID(Session["stcode"].ToString(), 5, 3, int.Parse(Session["StudentRequestID"].ToString())); GovahiBusiness.UpdatePayment(Convert.ToInt32(Session["StudentRequestID"]), requestID); GovahiBusiness.UpdateStudentPOstNumber(Session["stcode"].ToString(), " عدم ثبت نام در ترم جاری", 3, int.Parse(Session["StudentRequestID"].ToString())); cmnb.InsertIntoUserLog(int.Parse(Session[sessionNames.userID_Karbar].ToString()), DateTime.Now.ToShortTimeString(), int.Parse(Session[sessionNames.appID_Karbar].ToString()), 31, "ارائه به : " + txt_EraeBe.Text, Convert.ToInt32(Session["StudentRequestID"].ToString())); rwm_Validations.RadAlert("درخواست مورد نظر به دلیل ثبت در ترم قبل رد و درخواست جدیدی در ترم جاری ثبت می گردد همچنین دانشجو در ترم جاری ثبت نام کرده است", 400, 100, "خطا", null); CartBusiness.UpdateStudentRequestLogID(Session["stcode"].ToString(), 7, 3, requestID); cmnb.InsertIntoUserLog(int.Parse(Session[sessionNames.userID_Karbar].ToString()), DateTime.Now.ToShortTimeString(), int.Parse(Session[sessionNames.appID_Karbar].ToString()), 33, "ارائه به : " + txt_EraeBe.Text, Convert.ToInt32(Session["StudentRequestID"].ToString())); StiWebViewer1.Visible = true; StiReport rpt = new StiReport(); rpt.Load(Server.MapPath("../Reports/eshteghal.mrt")); rpt.Dictionary.Databases.Clear(); rpt.Dictionary.Databases.Add(new StiSqlDatabase("Connection1", CB.ReportConnection.ToString())); rpt.Compile(); rpt.CompiledReport.DataSources["[Request].[SP_Get_StudentInfo]"].Parameters["@stcode"].ParameterValue = Session["stcode"].ToString(); rpt.CompiledReport.DataSources["[Request].[SP_GetRequestByRequestID]"].Parameters["@StudentRequestID"].ParameterValue = requestID; rpt.RegData(studentsInfo); StiWebViewer1.Report = rpt; StiWebViewer1.Visible = true; } } } if (e.CommandName == "Edit_EraeBe") { Session["StudentRequestID"] = e.CommandArgument.ToString(); if (e.Item is GridDataItem) { GridDataItem item = (GridDataItem)e.Item; TextBox txt_EraeBe = e.Item.FindControl("txt_EraeBe") as TextBox; Session["EraeBe"] = txt_EraeBe.Text; GovahiBusiness.UpdateEraeBe(Session["EraeBe"].ToString(), int.Parse(Session["StudentRequestID"].ToString())); cmnb.InsertIntoUserLog(int.Parse(Session[sessionNames.userID_Karbar].ToString()), DateTime.Now.ToShortTimeString(), int.Parse(Session[sessionNames.appID_Karbar].ToString()), 34, "ارائه به : " + txt_EraeBe.Text, Convert.ToInt32(Session["StudentRequestID"].ToString())); } } }