protected void btn_Save_Click(object sender, EventArgs e) { DataTable dtbedehi = new DataTable(); dtbedehi = GovahiBusiness.GetBedehkar(txt_StNo.Text); bedehi = Convert.ToDouble((dtbedehi.Rows[0]["bedehi"].ToString())); DataTable dtmojazcart = new DataTable(); dtmojazcart = ebusiness.StInMojazCart(txt_StNo.Text); if (dtmojazcart.Rows.Count == 0 && bedehi > 0) { rwm.RadAlert("به علت بدهکاری دانشجو، امکان دریافت کارت مقدور نمی باشد", null, 100, "پیام", ""); } else { DataTable dt = new DataTable(); dt = ebusiness.CardQuizStudents(txt_StNo.Text); this.StiWebViewer1.ResetReport(); StiWebViewer1.Visible = true; StiReport rpt = new StiReport(); rpt.Load(Server.MapPath("../Reports/Exam123.mrt")); rpt.Dictionary.Databases.Clear(); rpt.Dictionary.Databases.Add(new StiSqlDatabase("Supplementary", CB.ReportConnection.ToString())); rpt.Compile(); rpt.CompiledReport.DataSources["[Exam].[SP_CardQuiz]"].Parameters["@stcode"].ParameterValue = txt_StNo.Text; rpt.RegData(dt); StiWebViewer1.Report = rpt; StiWebViewer1.Visible = true; CB.InsertIntoUserLog(int.Parse(Session[sessionNames.userID_Karbar].ToString()), DateTime.Now.ToShortTimeString(), int.Parse(Session[sessionNames.appID_Karbar].ToString()), 45, "چاپ کارت امتحان دانشجو"); } }
private void loginToLMS() { DataTable dtbedehi = new DataTable(); double bedehi; dtbedehi = GovahiBusiness.GetBedehkar(Session[sessionNames.userID_StudentOstad].ToString()); bedehi = Convert.ToDouble((dtbedehi.Rows[0]["bedehi"].ToString())); DataTable dtReg = new DataTable(); dtReg = GovahiBusiness.GetStRegisterd(Session[sessionNames.userID_StudentOstad].ToString()); DataTable dtnaghs = new DataTable(); dtnaghs = logBusiness.StHasNaghs(Session[sessionNames.userID_StudentOstad].ToString()); DataTable dt = new DataTable(); dt = logBusiness.GetStIdVaz(Session[sessionNames.userID_StudentOstad].ToString()); //if (bedehi > 0) //{ // Session["LogStatus"] = "1-2";//bedehkar // Response.Redirect("../University/LMS/Pages/LmsMain.aspx"); //} if (dtnaghs.Rows.Count > 0) { Session["LogStatus"] = "1-4";//naghs darad Response.Redirect("../University/LMS/Pages/LmsMain.aspx"); } else if (dtReg.Rows.Count == 0) { Session["LogStatus"] = "1-3";//sabtenam dashte dar in term Response.Redirect("../University/LMS/Pages/LmsMain.aspx"); } else if (dt.Rows[0]["idvazkol"].ToString() == "7") { Session["LogStatus"] = "1-5";//fareghotahsil Response.Redirect("../University/LMS/Pages/LmsMain.aspx"); } else { Session["LogStatus"] = "1-1";//vurud Response.Redirect("../University/LMS/Pages/LmsMain.aspx"); } }
protected void grd_GovahiRequestState_ItemCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e) { var cmnb = new CommonBusiness(); try { if (e.CommandName == "EditEraeBe") { var txtEditEraeBe = e.Item.FindControl("txt_EditEraeBe") as TextBox; if (txtEditEraeBe != null) { GovahiBusiness.UpdateEraeBe(txtEditEraeBe.Text, int.Parse(e.CommandArgument.ToString())); } business.UpdateStudentRequestLogID(Session[sessionNames.userID_StudentOstad].ToString(), 6, 3, int.Parse(e.CommandArgument.ToString())); GovahiBusiness.UpdateStudentPOstNumber(Session[sessionNames.userID_StudentOstad].ToString(), "", 3, int.Parse(e.CommandArgument.ToString())); cmnb.InsertIntoStudentLog(Session[sessionNames.userID_StudentOstad].ToString(), DateTime.Now.ToShortTimeString(), int.Parse(Session[sessionNames.appID_StudentOstad].ToString()), 19, "ویرایش محل ارائه"); var dtgo = GovahiBusiness.GetGovahiStatus(Session[sessionNames.userID_StudentOstad].ToString()); if (dtgo.Rows.Count > 0) { grd_GovahiRequestState.Visible = true; grd_GovahiRequestState.DataSource = dtgo; grd_GovahiRequestState.DataBind(); } } if (e.CommandName == "pay") { var dtbedehi = GovahiBusiness.GetBedehkar(Session[sessionNames.userID_StudentOstad].ToString()); var dts = GovahiBusiness.GetStRegisterd(Session[sessionNames.userID_StudentOstad].ToString()); var bedehi = Convert.ToDouble((dtbedehi.Rows[0]["bedehi"].ToString())); var dtmojazgovahi = GovahiBusiness.GetMojazGovahi(Session[sessionNames.userID_StudentOstad].ToString()); if (!GovahiBusiness.CanPay(Session[sessionNames.userID_StudentOstad].ToString())) { rwm_Validations.RadAlert("درخواست شما برای ترم کنونی نمی باشد لطفا درخواست ها رو حذف نمایید و مجددادرخواستی ثبت نمایید", 600, 100, "خطا", null); return; } if (dtmojazgovahi.Rows.Count == 0 && bedehi > 0) { rwm_Validations.RadAlert("به علت بدهکاری درخواست گواهی اشتغال به تحصیل مقدور نمی باشد ", 420, 100, "خطا", null); return; } else if (dts.Rows.Count == 0) { rwm_Validations.RadAlert("دانشجو در این ترم ثبت نام نکرده است", 300, 100, "خطا", null); return; } long orderid;//= new bmp_PaymentBusiness().GenerateOrderId(); SetDefaultDateTime(); var pay = new PaymentDTO(); var bmp = new bmp_PaymentBusiness(); var dt = GovahiBusiness.GetAmountForPay(Session[sessionNames.userID_StudentOstad].ToString()); grd_pay.DataSource = dt; pay.Amount = int.Parse(dt.Rows[0]["mablagh"].ToString()); pay.PayDate = PayDate + "_" + PayTime; pay.stcode = Session[sessionNames.userID_StudentOstad].ToString(); pay.bankId = 2; pay.tterm = ConfigurationManager.AppSettings["Term"]; var result = bmp.pay(pay.Amount, pay.stcode, out orderid, Convert.ToInt32(Session[sessionNames.appID_StudentOstad]), 0); pay.OrderId = orderid; var resultArray = result.Split(','); pay.ReqKey = resultArray[1]; pay.AppStatus = "none"; pay.TraceNumber = 0; pay.Result = -1; pay.PayType = 1; var reqIdArray = Session["ReqID"].ToString().Split(new char[] { ',' }); var payId = Session["PayID"].ToString().Split(new char[] { ',' }); for (var i = 0; i < reqIdArray.Length; i++) { if (i == 0) { pay.RequestId = int.Parse(reqIdArray[i]); GovahiBusiness.UpdatePymentDetail(pay.OrderId, pay.PayDate, int.Parse(payId[i]), 140000, pay.ReqKey); } else { pay.RequestId = int.Parse(reqIdArray[i]); GovahiBusiness.UpdatePymentDetail(pay.OrderId, pay.PayDate, int.Parse(payId[i]), 20000, pay.ReqKey); } } Session["ReqID"] = null; Session["PayID"] = null; if (resultArray[0] == "0") { ClientScript.RegisterStartupScript(typeof(Page), "ClientScript", "<script language='javascript' type='text/javascript'> postRefId('" + resultArray[1] + "');</script> ", false); } } if (e.CommandName == "Del") { var deloCommands = e.CommandArgument.ToString().Split(new char[] { ',' }); GovahiBusiness.DeleteGovahiRequest(int.Parse(deloCommands[0]), int.Parse(deloCommands[1])); business.InsertInToStudentLog(Session[sessionNames.userID_StudentOstad].ToString(), DateTime.Now.Date, DateTime.Now.ToShortTimeString(), 1); var dtgo = GovahiBusiness.GetGovahiStatus(Session[sessionNames.userID_StudentOstad].ToString()); if (dtgo.Rows.Count > 0) { grd_GovahiRequestState.Visible = true; grd_GovahiRequestState.DataSource = dtgo; grd_GovahiRequestState.DataBind(); } var dt = GovahiBusiness.GetAmountForPay(Session[sessionNames.userID_StudentOstad].ToString()); grd_pay.DataSource = dt; grd_pay.DataBind(); if (dt.Rows.Count > 0 && (int.Parse(dt.Rows[0]["amount"].ToString())) > 0) { grd_pay.Visible = true; } else { grd_pay.Visible = false; } } } catch (Exception exp) { Response.Write("Error: " + exp.Message); } }