protected void BindExamPlace(string cityId) { var cityName = ExamBusiness.GetAllExamPlaceAddress().AsEnumerable() .Where(w => w.Field <decimal>("ID") == decimal.Parse(cityId)) .Select(s => s.Field <string>("Name_City")).FirstOrDefault(); DataTable dt = new DataTable(); dt = ExamBusiness.Get_ExamPlaceName(cityName); ddl_ClassNumber.DataSource = dt; ddl_ClassNumber.DataTextField = "ExamPlace"; ddl_ClassNumber.DataValueField = "ExamPlaceID"; ddl_ClassNumber.DataBind(); ddl_ClassNumber.Items.Insert(0, "انتخاب نمایید"); ddl_ClassNumber.SelectedIndex = 0; }
private void LoadForm() { var choose = new ListItem { Text = "انتخاب کنید", Value = "-1" }; pnlResult.Visible = false; //---------Fill ddlUnits var units = eBusiness.GetAllExamPlaceAddress().AsEnumerable() .Where(w => w.Field <bool>("IsActive")) .Select(s => new { Name = s.Field <string>("Name_City"), Id = s.Field <decimal>("ID") }); ddlUnits.DataSource = units; ddlUnits.DataTextField = "Name"; ddlUnits.DataValueField = "Id"; ddlUnits.DataBind(); ddlUnits.Items.Insert(0, choose); //--------------------- //---------Fill ddlTerms var terms = cmnb.SelectAllTerm(); ddlTerms.DataTextField = "tterm"; ddlTerms.DataSource = terms; ddlTerms.DataBind(); ddlTerms.Items.Insert(0, choose); //--------------------- }
protected void btn_Save_Click(object sender, EventArgs e) { if (txt_Address.Text != "" && txt_City.Text != "") { eBusiness.InsertExamPlaceAddress(txt_City.Text, txt_Address.Text); DataTable dt = new DataTable(); dt = eBusiness.GetAllExamPlaceAddress(); grd_ExamPlace.DataSource = dt; grd_ExamPlace.DataBind(); cmnb.InsertIntoUserLog(int.Parse(Session[sessionNames.userID_Karbar].ToString()), DateTime.Now.ToShortTimeString(), int.Parse(Session[sessionNames.appID_Karbar].ToString()), 41, "ثبت شهر امتحانات"); txt_Address.Text = ""; txt_City.Text = ""; rwm.RadAlert("با موفقیت ثبت گردید", null, 100, "پیام", ""); } else { rwm.RadAlert("نام شهر و آدرس باید وارد گردد", null, 100, "خطا", ""); } }
protected void BindCityList() { var cityName = ExamBusiness.GetAllExamPlaceAddress().AsEnumerable() .Where(w => w.Field <bool>("IsActive")) .Select(s => new { Name = s.Field <string>("Name_City"), Id = s.Field <decimal>("ID") }); ddl_Shahr.DataSource = cityName; ddl_Shahr.DataTextField = "Name"; ddl_Shahr.DataValueField = "Id"; ddl_Shahr.DataBind(); }
protected void BindCityList() { var cityName = ExamBusiness.GetAllExamPlaceAddress().AsEnumerable() .Where(w => w.Field <bool>("IsActive")) .Select(s => new { Name = s.Field <string>("Name_City"), Id = s.Field <int>("ID") }); ddlExaminerPlaceId.DataSource = cityName; ddlExaminerPlaceId.DataTextField = "Name"; ddlExaminerPlaceId.DataValueField = "Id"; ddlExaminerPlaceId.DataBind(); ddlExaminerPlaceId.Items.Insert(0, "انتخاب نمایید"); ddlExaminerPlaceId.SelectedIndex = 0; }
protected void grd_Class_ItemCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e) { if (e.CommandName == "bookinglist") { string[] commandArgs = e.CommandArgument.ToString().Split(new char[] { ',' }); coursecode = commandArgs[0]; var classCode = commandArgs[3]; var did = commandArgs[0]?.ToString() ?? "-1"; var Zarfiat = int.Parse(commandArgs[1]?.ToString() ?? "0"); var cityId = int.Parse(hdnSearchedCity.Value ?? "0"); var dt = examBusiness.CheckIsClassSetRange(did, Zarfiat, cityId); if (dt.Rows.Count > 0) { if (dt.Rows[0][0].ToString() == "0") { rwm.RadAlert("برای این کد مشخصه، بازه کلاس تخصیص یافته است", null, 100, "پیام", ""); } else { RadWindowManager windowManager = new RadWindowManager(); RadWindow widnow1 = new RadWindow(); widnow1.NavigateUrl = "../CMS/testforms/classrangelistUI.aspx?Zarfiat=" + Zarfiat + "&Coursecode=" + coursecode + "&c=" + hdnSearchedCity.Value; widnow1.ID = "RadWindow1"; windowManager.Width = System.Web.UI.WebControls.Unit.Pixel(800); windowManager.Height = System.Web.UI.WebControls.Unit.Pixel(400); widnow1.VisibleOnPageLoad = true; windowManager.OnClientClose = "ReloadGrid"; windowManager.Windows.Add(widnow1); ContentPlaceHolder mpContentPlaceHolder; mpContentPlaceHolder = (ContentPlaceHolder)Page.Master.FindControl("ContentPlaceHolder1"); mpContentPlaceHolder.Controls.Add(widnow1); //Response.Redirect("classrangelistUI.aspx?Zarfiat=" + Zarfiat + "&Coursecode=" + coursecode + "&c=" + ddl_shahr.SelectedValue + "&id=" + generaterandomstr(11) + "@A" + Session["menuId"].ToString() + "-" + generaterandomstr(2), false); } } } if (e.CommandName == "SeatSpecify") { string[] commandArgs = e.CommandArgument.ToString().Split(new char[] { ',' }); coursecode = commandArgs[0]; string Zarfiat = commandArgs[1]; var cityName = examBusiness.GetAllExamPlaceAddress().AsEnumerable() .Where(w => w.Field <decimal>("ID") == decimal.Parse(hdnSearchedCity.Value)) .Select(s => s.Field <string>("Name_City")).FirstOrDefault(); DataTable dtk = new DataTable(); dtk = examBusiness.Check_Noduplicate_did(coursecode, cityName); if (dtk.Rows.Count > 0) { rwm.RadAlert("برای این کد درس تخصیص صندلی انجام گرفته است", null, 100, "پیام", ""); } else { //DataTable dt1 = new DataTable(); //dt1 = examBusiness.Get_did_detail(int.Parse(coursecode)); //saatexam = dt1.Rows[0]["saatexam"].ToString(); //dateexam = dt1.Rows[0]["dateexam"].ToString(); DataTable dt = new DataTable(); dt = examBusiness.GetStudentByDidAndExamPlace(coursecode, int.Parse(ddl_shahr.SelectedValue)); //int tedad_daneshju = examBusiness.Get_tedad_daneshju(int.Parse(coursecode), saatexam, dateexam); // int tedad_class = examBusiness.Get_tedad_class(int.Parse(coursecode)); DataTable ExamClass = new DataTable(); ExamClass = examBusiness.Get_ExamClassSavedDetail(coursecode, commandArgs[2]); bool t = true; //if (tedad_class != 0) if (ExamClass.Rows.Count > 0) { List <int> classsaved = new List <int>(); for (int j = 0; j < ExamClass.Rows.Count; j++) { for (int z = int.Parse(ExamClass.Rows[j]["StartRange"].ToString()); z <= int.Parse(ExamClass.Rows[j]["EndRange"].ToString()); z++) { classsaved.Add(z); } } for (int i = 0; i < int.Parse(Zarfiat); i++) { Random random = new Random(); int randomNumber1 = random.Next(0, (classsaved.Count)); // if (classsaved.Count>=1) //{ examBusiness.Insert_ExamSeat(dt.Rows[i]["stcode"].ToString(), int.Parse(coursecode), classsaved[randomNumber1], cityName); classsaved.RemoveAt(randomNumber1); // } //do //{ // int randomNumber1 = random.Next(0, (classsaved.Count)); // classorder = (int)ExamClass.Rows[randomNumber1]["IDExamClass"]; // seatnumber = random.Next((int)ExamClass.Rows[randomNumber1]["StartRange"], ((int)ExamClass.Rows[randomNumber1]["EndRange"]) + 1); //} while (examBusiness.Get_No_DuplicateSeatNumber(ddl_saat.SelectedValue, ddl_day.SelectedValue, seatnumber, int.Parse(coursecode)).Rows.Count>0); //examBusiness.Insert_ExamSeat(dt.Rows[i]["stcode"].ToString(), int.Parse(coursecode), seatnumber, ddl_shahr.SelectedItem.Text); } cmnb.InsertIntoUserLog(int.Parse(Session[sessionNames.userID_Karbar].ToString()), DateTime.Now.ToShortTimeString(), int.Parse(Session[sessionNames.appID_Karbar].ToString()), 39, "تخصیص صندلی", int.Parse(coursecode)); rwm.RadAlert("تخصیص صندلی با موفقیت انجام شد", null, 100, "پیام", ""); } } } }