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, "پیام", "");
}
}
}
}
