public List <RequestDateTime> GetDateTimeListByRequestIdForStudent(int requestId) { List <RequestDateTime> dateTimelist = null; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@requestId", requestId), }; using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("[Resource_Control].[SP_GetDateTimeListByRequestIdForStudent]", CommandType.StoredProcedure, parameters)) { if (table.Rows.Count > 0) { dateTimelist = new List <RequestDateTime>(); foreach (DataRow row in table.Rows) { RequestDateTime dateTime = new RequestDateTime(); dateTime.DateTimeId = Convert.ToInt32(row["DateTimeId"]); dateTime.Date = row["Date"].ToString(); dateTime.StartTime = Convert.ToInt64(row["StartTime"]); dateTime.EndTime = Convert.ToInt64(row["EndTime"]); dateTime.RequestId = Convert.ToInt32(row["RequestId"]); dateTime.ResourceId = Convert.ToInt32(row["ResourceId"] ?? 0); dateTime.MayConflict = Convert.ToBoolean(row["MayConflict"]); dateTime.ClassName = row["ClassName"].ToString(); dateTimelist.Add(dateTime); } } } return(dateTimelist); }
public static string btnSubmitFinalClick(string[][] array) { List <RequestDateTime> dateTimeList = new List <RequestDateTime>(); foreach (var item in array) { RequestDateTime rqdt = new RequestDateTime(); rqdt.Date = item[1]; rqdt.StartTime = TimeSpan.Parse(item[2]).Ticks; rqdt.EndTime = TimeSpan.Parse(item[3]).Ticks; rqdt.DateTimeId = Convert.ToInt32(item[5]); rqdt.ResourceId = Convert.ToInt32(item[4]); rqdt.RequestId = Convert.ToInt32(item[6]); rqdt.MayConflict = false; dateTimeList.Add(rqdt); } RequestDateTimeHandler rqdtHandler = new RequestDateTimeHandler(); bool flag = rqdtHandler.UpdateAllDateTimeRequest(dateTimeList, (int)RequestStatus.sent, userIDStr); if (flag) { return("success"); } else { return("error"); } }
public int InsertNewDateTimeForDefenceV2(RequestDateTime dateTime, int collegeId) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@Date", dateTime.Date), new SqlParameter("@StartTime", dateTime.StartTime), new SqlParameter("@EndTime", dateTime.EndTime), new SqlParameter("@RequestId", dateTime.RequestId), new SqlParameter("@collegeId", collegeId), }; return(SqlDBHelper.ExecuteScalar("[Resource_Control].[sp_InsertRequestDateTimeForDefenceAddRequest]", CommandType.StoredProcedure, parameters));; }
public int UpdateOneDateTimeRequest(RequestDateTime reqDateTime) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@dateTimeId", reqDateTime.DateTimeId), new SqlParameter("@Date", reqDateTime.Date), new SqlParameter("@StartTime", reqDateTime.StartTime), new SqlParameter("@EndTime", reqDateTime.EndTime), new SqlParameter("@ResourceId", reqDateTime.ResourceId) }; return(SqlDBHelper.ExecuteScalar("[Resource_Control].[SP_UpdateOneDateTimeRequest]", CommandType.StoredProcedure, parameters)); }
public bool UpdateOneDateTimeRequestForDefence(RequestDateTime reqDateTime) { int count = _dateTimeDB.UpdateOneDateTimeRequestForDefence(reqDateTime); if (count > 0) { return(true); } else { return(false); } }
protected void grdDateTime_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { RequestDateTime reqDateTime = (RequestDateTime)e.Row.DataItem; DropDownList drpResource = (DropDownList)e.Row.FindControl("drpResource"); _resList = (List <ResourceControl.Entity.Resource>)ViewState["_resList"]; drpResource.DataSource = _resList; drpResource.DataTextField = "name"; drpResource.DataValueField = "ID"; drpResource.DataBind(); drpResource.Items.Insert(0, new ListItem { Value = "0", Text = "انتخاب کنید..." }); if (drpRequestTypeList.SelectedValue == "0" || drpRequestTypeList.SelectedValue == "3") { drpResource.Items.FindByValue(drpCandidateResource.SelectedValue).Selected = true; if (drpCandidateResource.SelectedIndex > 0) { if (!reqDateTime.MayConflict) { if (e.Row.RowState != DataControlRowState.Edit) { e.Row.CssClass = "bg-success"; drpResource.Enabled = false; } } else { e.Row.CssClass = "bg-danger"; drpResource.Enabled = true; //btnSubmitFinal.Enabled = false; } } } else { drpResource.Items.FindByValue(reqDateTime.ResourceId.ToString()).Selected = true; drpResource.Enabled = false; } if (drpResource.SelectedValue == "0") { e.Row.CssClass = "bg-default"; } } }
protected void grdDateTime_RowUpdating(object sender, GridViewUpdateEventArgs e) { TextBox txtDate = (TextBox)grdDateTime.Rows[e.RowIndex].FindControl("txtDate"); RadTimePicker startTime = (RadTimePicker)grdDateTime.Rows[e.RowIndex].FindControl("RadTimePicker1"); RadTimePicker endTime = (RadTimePicker)grdDateTime.Rows[e.RowIndex].FindControl("RadTimePicker2"); DropDownList drpResource = (DropDownList)grdDateTime.Rows[e.RowIndex].FindControl("drpResource"); TextBox datetimeId = (TextBox)grdDateTime.Rows[e.RowIndex].FindControl("lblDateTimeId"); //TableCell row = (TableCell)grdDateTime.Rows[e.RowIndex].Cells[5]; //string hdnfDateTimeId = row.f.Text; //int dateTimeId = Convert.ToInt32(hdnfDateTimeId); RequestDateTime reqDateTime = new RequestDateTime(); reqDateTime.DateTimeId = Convert.ToInt32(datetimeId.Text); reqDateTime.Date = txtDate.Text; reqDateTime.StartTime = startTime.SelectedTime.Value.Ticks; reqDateTime.EndTime = endTime.SelectedTime.Value.Ticks; reqDateTime.ResourceId = Convert.ToInt32(drpResource.SelectedValue); RequestDateTimeHandler reqdtH = new RequestDateTimeHandler(); bool hasConflict = reqdtH.UpdateOneDateTimeRequest(reqDateTime); if (hasConflict) { grdDateTime.Rows[e.RowIndex].CssClass = "bg-danger"; } else { grdDateTime.Rows[e.RowIndex].CssClass = "bg-success"; } grdDateTime.EditIndex = -1; int reqId = (int)ViewState["reqId"]; RequestDateTimeHandler rqdateTimeH = new RequestDateTimeHandler(); _dateTimeList = rqdateTimeH.GetDateTimeListByRequestId(reqId); grdDateTime.DataSource = _dateTimeList; grdDateTime.DataBind(); }
public static string btnSubmitFinalClick(string[][] array) { List <RequestDateTime> dateTimeList = new List <RequestDateTime>(); foreach (var item in array) { RequestDateTime rqdt = new RequestDateTime(); rqdt.Date = item[1]; rqdt.StartTime = TimeSpan.Parse(item[2]).Ticks; rqdt.EndTime = TimeSpan.Parse(item[3]).Ticks; rqdt.DateTimeId = Convert.ToInt32(item[5]); rqdt.ResourceId = Convert.ToInt32(item[4]); rqdt.RequestId = Convert.ToInt32(item[7]); rqdt.MayConflict = false; dateTimeList.Add(rqdt); } RequestDateTimeHandler rqdtHandler = new RequestDateTimeHandler(); var roleId = Convert.ToInt32(HttpContext.Current.Session["RoleId"]); RequestDateTimeHandler reqdtH = new RequestDateTimeHandler(); bool flag = rqdtHandler.UpdateAllDateTimeRequestForDefence(dateTimeList, (int)RequestStatus.approved, userID.ToString(), roleId); if (flag) { RequestHandler reqH = new RequestHandler(); reqH.UpdateRequestAnswerTimeByIdrequest(dateTimeList[0].RequestId); return("success"); } else { return("error"); } }
protected void grdDateTime_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "submit") { int reqId = (int)ViewState["reqId"]; GridViewRow row = (GridViewRow)(((Control)e.CommandSource).NamingContainer); DropDownList drpResource = row.FindControl("drpResource") as DropDownList; Button btnSingleSubmit = row.FindControl("btnSingleSubmit") as Button; if (drpResource.SelectedValue != "0") { RequestDateTime rqdt = new RequestDateTime(); RequestDateTimeHandler rqdateTimeH = new RequestDateTimeHandler(); List <RequestDateTime> dateTimeList = new List <RequestDateTime>(); _dateTimeList = rqdateTimeH.GetDateTimeListByRequestId(reqId); rqdt.Date = _dateTimeList[row.DataItemIndex].Date; rqdt.StartTime = _dateTimeList[row.DataItemIndex].StartTime; rqdt.EndTime = _dateTimeList[row.DataItemIndex].EndTime; rqdt.DateTimeId = _dateTimeList[row.DataItemIndex].DateTimeId; rqdt.ResourceId = Convert.ToInt32(drpResource.SelectedValue); rqdt.RequestId = reqId; rqdt.MayConflict = false; dateTimeList.Add(rqdt); RequestDateTimeHandler rqdtHandler = new RequestDateTimeHandler(); bool flag = rqdtHandler.UpdateAllDateTimeRequest(dateTimeList, (int)RequestStatus.sent, userIDStr); btnSingleSubmit.Enabled = false; string msg = "کلاسی با موفقیت ثبت شد"; RadWindowManager1.RadAlert(msg, 300, 100, "پیام سیستم", ""); } else { string msg = "کلاسی را پیشنهاد نداده اید"; RadWindowManager1.RadAlert(msg, 300, 100, "پیام سیستم", ""); } } }
protected void grdDateTime_OnRowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "Register") { GridViewRow gvr = (GridViewRow)((Control)e.CommandSource).NamingContainer; int rowIndex = gvr.RowIndex; var txtDate = ((Label)grdDateTime.Rows[rowIndex].Cells[1].Controls[1]).Text; var startTime = ((Label)grdDateTime.Rows[rowIndex].Cells[2].Controls[1]).Text; var endTime = ((Label)grdDateTime.Rows[rowIndex].Cells[3].Controls[1]).Text; var drpResource = Convert.ToInt32(((DropDownList)grdDateTime.Rows[rowIndex].Cells[4].Controls[1]).SelectedValue); var datetimeId = ((TextBox)grdDateTime.Rows[rowIndex].Cells[5].Controls[1]).Text; RequestDateTime reqDateTime = new RequestDateTime(); reqDateTime.DateTimeId = Convert.ToInt32(datetimeId); reqDateTime.Date = txtDate; reqDateTime.StartTime = TimeSpan.Parse(startTime).Ticks; reqDateTime.EndTime = TimeSpan.Parse(endTime).Ticks; reqDateTime.ResourceId = Convert.ToInt32(drpResource); RequestDateTimeHandler reqdtH = new RequestDateTimeHandler(); bool hasConflict = reqdtH.UpdateOneDateTimeRequest(reqDateTime); if (hasConflict) { grdDateTime.Rows[rowIndex].CssClass = "bg-danger"; var dropDownList = (DropDownList)grdDateTime.Rows[rowIndex].Cells[4].Controls[1]; dropDownList.Enabled = true; var Registerbtn = ((Button)grdDateTime.Rows[rowIndex].Cells[6].Controls[1]); Registerbtn.Visible = true; var Canclebtn = ((Button)grdDateTime.Rows[rowIndex].Cells[6].Controls[3]); Canclebtn.Visible = true; var Editbtn = ((Button)grdDateTime.Rows[rowIndex].Cells[6].Controls[5]); Editbtn.Visible = false; } else { grdDateTime.Rows[rowIndex].CssClass = "bg-success"; var dropDownList = (DropDownList)grdDateTime.Rows[rowIndex].Cells[4].Controls[1]; dropDownList.Enabled = false; var Registerbtn = ((Button)grdDateTime.Rows[rowIndex].Cells[6].Controls[1]); Registerbtn.Visible = false; var Canclebtn = ((Button)grdDateTime.Rows[rowIndex].Cells[6].Controls[3]); Canclebtn.Visible = false; var Editbtn = ((Button)grdDateTime.Rows[rowIndex].Cells[6].Controls[5]); Editbtn.Visible = true; } grdDateTime.EditIndex = -1; int reqId = (int)ViewState["reqId"]; RequestDateTimeHandler rqdateTimeH = new RequestDateTimeHandler(); _dateTimeList = rqdateTimeH.GetDateTimeListByRequestId(reqId); grdDateTime.DataSource = _dateTimeList.OrderBy(c => c.Date); grdDateTime.DataBind(); } if (e.CommandName == "Cancle") { grdDateTime.EditIndex = -1; int reqId = (int)ViewState["reqId"]; RequestDateTimeHandler rqdateTimeH = new RequestDateTimeHandler(); _dateTimeList = rqdateTimeH.GetDateTimeListByRequestId(reqId); grdDateTime.DataSource = _dateTimeList.OrderBy(c => c.Date); grdDateTime.DataBind(); GridViewRow gvr = (GridViewRow)((Control)e.CommandSource).NamingContainer; int rowIndex = gvr.RowIndex; var datetimeId = Convert.ToInt32(((TextBox)grdDateTime.Rows[rowIndex].Cells[5].Controls[1]).Text); RequestDateTimeHandler reqdtH = new RequestDateTimeHandler(); var hasResource = reqdtH.GetDateTimeListByRequestId(reqId).FirstOrDefault(c => c.DateTimeId == datetimeId).ResourceId; if (hasResource != 0) { var dropDownList = (DropDownList)grdDateTime.Rows[rowIndex].Cells[4].Controls[1]; dropDownList.Enabled = false; var Registerbtn = ((Button)grdDateTime.Rows[rowIndex].Cells[6].Controls[1]); Registerbtn.Visible = false; var Canclebtn = ((Button)grdDateTime.Rows[rowIndex].Cells[6].Controls[3]); Canclebtn.Visible = false; var Editbtn = ((Button)grdDateTime.Rows[rowIndex].Cells[6].Controls[5]); Editbtn.Visible = true; } } if (e.CommandName == "Edit") { GridViewRow gvr = (GridViewRow)((Control)e.CommandSource).NamingContainer; int rowIndex = gvr.RowIndex; var Registerbtn = ((Button)grdDateTime.Rows[rowIndex].Cells[6].Controls[1]); Registerbtn.Visible = true; var Canclebtn = ((Button)grdDateTime.Rows[rowIndex].Cells[6].Controls[3]); Canclebtn.Visible = true; var Editbtn = ((Button)grdDateTime.Rows[rowIndex].Cells[6].Controls[5]); Editbtn.Visible = false; var dropDownList = (DropDownList)grdDateTime.Rows[rowIndex].Cells[4].Controls[1]; dropDownList.Enabled = true; foreach (GridViewRow row in grdDateTime.Rows) { if (row.RowIndex != rowIndex) { row.Enabled = false; } } } }
protected void grdDateTime_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { e.Row.Enabled = true; RequestDateTime reqDateTime = (RequestDateTime)e.Row.DataItem; DropDownList drpResource = (DropDownList)e.Row.FindControl("drpResource"); _resList = (List <ResourceControl.Entity.Resource>)ViewState["_resList"]; drpResource.DataSource = _resList; drpResource.DataTextField = "name"; drpResource.DataValueField = "ID"; drpResource.DataBind(); drpResource.Items.Insert(0, new ListItem { Value = "0", Text = "انتخاب کنید..." }); if (drpCandidateResource.SelectedIndex > 0) { if (drpResource.Items.FindByValue(drpCandidateResource.SelectedValue) != null) { drpResource.Items.FindByValue(drpCandidateResource.SelectedValue).Selected = true; } } else { if (drpResource.Items.FindByValue(reqDateTime.ResourceId.ToString()) != null) { drpResource.Items.FindByValue(reqDateTime.ResourceId.ToString()).Selected = true; } } if (drpRequestTypeList.SelectedValue == "1") { if (!reqDateTime.MayConflict) { e.Row.CssClass = "bg-success"; btnSubmitFinal.Enabled = true; } else { e.Row.CssClass = "bg-danger"; drpResource.Enabled = true; btnSubmitFinal.Enabled = false; } } else { drpResource.Enabled = false; } if (drpResource.SelectedValue == "0") { e.Row.CssClass = "bg-default"; drpResource.Enabled = true; var Registerbtn = ((Button)e.Row.Cells[6].Controls[1]); Registerbtn.Visible = true; var Canclebtn = ((Button)e.Row.Cells[6].Controls[3]); Canclebtn.Visible = true; var Editbtn = ((Button)e.Row.Cells[6].Controls[5]); Editbtn.Visible = false; } else { drpResource.Enabled = false; var Registerbtn = ((Button)e.Row.Cells[6].Controls[1]); Registerbtn.Visible = false; var Canclebtn = ((Button)e.Row.Cells[6].Controls[3]); Canclebtn.Visible = false; var Editbtn = ((Button)e.Row.Cells[6].Controls[5]); Editbtn.Visible = true; } if (reqDateTime.MayConflict) { drpResource.Enabled = true; var Registerbtn = ((Button)e.Row.Cells[6].Controls[1]); Registerbtn.Visible = false; var Canclebtn = ((Button)e.Row.Cells[6].Controls[3]); Canclebtn.Visible = true; var Editbtn = ((Button)e.Row.Cells[6].Controls[5]); Editbtn.Visible = false; } //int reqId = (int) ViewState["reqId"]; //RequestDateTimeHandler reqdtH = new RequestDateTimeHandler(); //var listOfDateTime = reqdtH.GetDateTimeListByRequestId(reqId); //var listOfHasResource = new List<int>(); //foreach (var item in listOfDateTime) //{ // if (item.ResourceId != 0) // { // var id = item.ResourceId.ToString(); // drpResource.ClearSelection(); // drpResource.Items.FindByValue(id).Selected = true; // var dropDownList = (DropDownList) e.Row.Cells[4].Controls[1]; // dropDownList.Enabled = false; // var Registerbtn = ((Button) e.Row.Cells[6].Controls[1]); // Registerbtn.Visible = false; // var Canclebtn = ((Button) e.Row.Cells[6].Controls[3]); // Canclebtn.Visible = false; // var Editbtn = ((Button) e.Row.Cells[6].Controls[5]); // Editbtn.Visible = true; // } // else // { // drpResource.ClearSelection(); // var dropDownList = (DropDownList)e.Row.Cells[4].Controls[1]; // dropDownList.Enabled = true; // var Registerbtn = ((Button)e.Row.Cells[6].Controls[1]); // Registerbtn.Visible = true; // var Canclebtn = ((Button)e.Row.Cells[6].Controls[3]); // Canclebtn.Visible = true; // var Editbtn = ((Button)e.Row.Cells[6].Controls[5]); // Editbtn.Visible = false; // } //} if (!drpRequestTypeList.Items.FindByValue("1").Selected) { e.Row.Enabled = false; e.Row.FindControl("btnRegister").Visible = false; e.Row.FindControl("btnCancle").Visible = false; e.Row.FindControl("btnEdi").Visible = false; } } }
public static string btnSubmitFinalClick(string[][] array) { // int reqId = Convert.ToInt32(hdnfReqId.Value); List <RequestDateTime> dateTimeList = new List <RequestDateTime>(); var RequestId = Convert.ToInt32(array[0][7]); var startTime = TimeSpan.Parse(array[0][2]).Hours; var date = array[0][1]; foreach (var item in array) { RequestDateTime rqdt = new RequestDateTime(); rqdt.Date = item[1]; rqdt.StartTime = TimeSpan.Parse(item[2]).Ticks; rqdt.EndTime = TimeSpan.Parse(item[3]).Ticks; rqdt.DateTimeId = Convert.ToInt32(item[5]); rqdt.ResourceId = Convert.ToInt32(item[4]); rqdt.RequestId = Convert.ToInt32(item[7]); rqdt.MayConflict = false; dateTimeList.Add(rqdt); } RequestDateTimeHandler rqdtHandler = new RequestDateTimeHandler(); var roleId = Convert.ToInt32(HttpContext.Current.Session["RoleId"]); RequestDateTimeHandler reqdtH = new RequestDateTimeHandler(); int id = reqdtH.CheckOneDateTimeWithResourceIdPlusForStudent(dateTimeList.FirstOrDefault().DateTimeId, dateTimeList.FirstOrDefault().ResourceId); if (id == 0) { bool flag = rqdtHandler.UpdateAllDateTimeRequestForDefence(dateTimeList, (int)RequestStatus.approved, userID.ToString(), roleId); if (flag) { RequestHandler reqH = new RequestHandler(); reqH.UpdateRequestAnswerTimeByIdrequest(dateTimeList[0].RequestId); RequestDateTime rqdt = new RequestDateTime(); var dtReq = reqH.GetRequestDetails(RequestId); var stCode = reqH.GetStCodeByReqId(RequestId); //##################### edit by mehdi 1398/04/24 var serverLogger = HttpContext.Current.Server.MapPath("~/logger.txt"); var sendDone = reqH.SendSMSForDef(stCode.ToString(), 1, dtReq.Location, dtReq.ResourceName, startTime, date, dateTimeList[0].RequestId, dtReq.ResourceId, serverLogger); //##################### var SendForAricle = reqH.SendSMSForArticle(stCode.ToString(), 1, dtReq.Location, dtReq.ResourceName, startTime, date, dateTimeList[0].RequestId, dtReq.ResourceId); //#################### Sadegh Saryazdi AdobeDefenceBusiness.CreateMeeting(stCode.ToString(), date, startTime.ToString(), 1, dtReq.IssuerName, false, RequestId.ToString()); //end return("success"); } else { return("error"); } } else { return("conflict"); } }
private void CreateRequest() { RequestFR req = new RequestFR(); req.CatID = Convert.ToInt32(drpCategory.SelectedValue); req.Subject = "nosub"; req.Note = txtDescription.Text; req.Location = drpLocation.SelectedValue; RC_User user = new RC_User(); RC_UserHandler us = new RC_UserHandler(); var user1 = Session["UserName"].ToString(); //user = us.Get_Ostad_DetailsByCourseId(Convert.ToInt32(drpCourse.SelectedValue)); req.IssuerID = int.Parse(Session[sessionNames.userID_Karbar].ToString()); req.IssuerName = Session["UserName"].ToString(); //int coursedid = Convert.ToInt32(drpCourse.SelectedValue); req.Capacity = Convert.ToInt32(txtCapacity.Text); req.CourseName = txt_courseName.Text; req.DaneshID = 5;//dorehaye kootah modat req.CourseDID = 0; req.Issue_time = DateTime.Now.ToPeString(); req.Status = (int)RequestStatus.sent; if (chbRepeat.Checked == false) { if (CheckReqDate(pcal1.Text)) { RequestDateTime rdt = new RequestDateTime(); rdt.Date = pcal1.Text; rdt.StartTime = RadTimePicker1.SelectedTime.Value.Ticks; rdt.EndTime = RadTimePicker2.SelectedTime.Value.Ticks; req.DateTimeRange = new List <RequestDateTime>(); req.DateTimeRange.Add(rdt); } else { string scrp = "تاریخ درخواست باید بعد از تاریخ امروز باشد."; RadWindowManager1.RadAlert(scrp, 300, 100, "خطا", ""); //ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", scrp, true); return; } } else { if (CheckReqDate(pcal1.Text) && CheckReqDate(pcal2.Text)) { req.DateTimeRange = FillRequestDateTime(pcal1.Text, pcal2.Text, RadTimePicker1.SelectedTime, RadTimePicker2.SelectedTime, chblWeekDates); } else { string scrp = "تاریخ درخواست باید بعد از تاریخ امروز باشد.";//باید این پیام عوض شود. RadWindowManager1.RadAlert(scrp, 300, 100, "خطا", ""); //ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", scrp, true); return; } } optlist = new List <Option>(); foreach (ListItem item in chblOptions.Items) { if (item.Selected) { Option opt = new Option(); opt.ID = Convert.ToInt32(item.Value); opt.Name = item.Text; opt.IsActive = item.Selected; optlist.Add(opt); } } RequestHandler rqh = new RequestHandler(); //DataTable dt = rqh.HasRequestBefore(req.IssuerID, req.DateTimeRange); //if (dt.Rows.Count > 0) //{ // if (dt.Select().ToList().Exists(row => row["MayConflict"].ToString() == "1")) // { // string scrp = "تداخل در ساعت و تاریخ درخواست ، با ساعات درخواست های پیشین این استاد."; // RadWindowManager1.RadAlert(scrp, 300, 100, "خطا", ""); // return; // } //} if (RequestHandler.IsNotSpecifiedDay(DayOfWeek.Friday, req.DateTimeRange)) { string scrp = "در روز جمعه امکان برگزاری وجود ندارد"; RadWindowManager1.RadAlert(scrp, 300, 100, "خطا", ""); return; } try { var address = ViewState["GoBackTo"].ToString(); int reqid = rqh.AddNewRequest(req, optlist, Session[sessionNames.userID_Karbar].ToString()); var comman = new CommonBusiness(); comman.InsertIntoUserLog(Convert.ToInt32(Session[sessionNames.userID_Karbar].ToString()), "", 11, 114, "ثبت درخواست کلاس دوره کوتاه مدت", reqid); string resdirectFunc = "function redirectToLast(){ window.location= '" + address + "' ; }"; string scrp = "درخواست شما با شماره " + reqid.ToString() + " با موفقیت ثبت گردید"; RadWindowManager1.RadAlert(scrp, 300, 100, "پیام سیستم", resdirectFunc); } catch (Exception) { throw; } }
private void CreateRequest() { RequestFR req = new RequestFR(); req.CatID = Convert.ToInt32(drpCategory.SelectedValue); req.Subject = "nosub"; req.Note = txtDescription.Text; req.Location = drpLocation.SelectedValue; req.Status = (int)RequestStatus.sent; RC_User user = new RC_User(); RC_UserHandler us = new RC_UserHandler(); CourseHandler corH = new CourseHandler(); if (chkMeeting.Checked == true) { req.IssuerID = Convert.ToInt32(Session[sessionNames.userID_Karbar].ToString()); user.Name = Session["UserName"].ToString(); req.IssuerName = user.Name; if (drpCategory.SelectedIndex == 3) { req.CourseName = "درخواست جلسه"; } else { req.CourseName = "درخواست کلاس بدون استاد"; } Session["isMeeting"] = true; daneshID = Convert.ToInt32(Session["DaneshId"]); req.DaneshID = daneshID; req.Capacity = Convert.ToInt32(txtCapacity.Text); } else { if (UtilityFunction.IsMasouleDaftarUser(roleID)) { req.IssuerID = Convert.ToInt32(Session[sessionNames.userID_Karbar].ToString()); user.Name = Session["UserName"].ToString(); req.IssuerName = user.Name; if (drpCategory.SelectedIndex == 3) { req.CourseName = "درخواست جلسه"; } else { req.CourseName = "درخواست کلاس بدون استاد"; } Session["isMeeting"] = true; daneshID = Convert.ToInt32(Session["DaneshId"]); req.DaneshID = daneshID; req.Capacity = Convert.ToInt32(txtCapacity.Text); } else { req.IssuerID = Convert.ToInt32(RadComboBoxField.SelectedValue.ToString()); user = us.Get_Ostad_Details(req.IssuerID); req.IssuerName = user.Name; courselist = corH.GetCourseListByUserID(req.IssuerID); int coursedid = Convert.ToInt32(drpCourse.SelectedValue); req.Capacity = Convert.ToInt32(txtCapacity.Text); req.CourseName = drpCourse.SelectedItem.ToString(); req.DaneshID = courselist.Find(i => i.DID == coursedid).DaneshID; req.CourseDID = coursedid; } } req.Issue_time = DateTime.Now.ToPeString(); if (chbRepeat.Checked == false) { if (CheckReqDate(pcal1.Text)) { RequestDateTime rdt = new RequestDateTime(); rdt.Date = pcal1.Text; rdt.StartTime = RadTimePicker1.SelectedTime.Value.Ticks; rdt.EndTime = RadTimePicker2.SelectedTime.Value.Ticks; req.DateTimeRange = new List <RequestDateTime>(); req.DateTimeRange.Add(rdt); } else { string scrp = "تاریخ درخواست باید بعد از تاریخ امروز باشد."; RadWindowManager1.RadAlert(scrp, 300, 100, "خطا", ""); //ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", scrp, true); return; } } else { if (CheckReqDate(pcal1.Text) && CheckReqDate(pcal2.Text)) { req.DateTimeRange = FillRequestDateTime(pcal1.Text, pcal2.Text, RadTimePicker1.SelectedTime, RadTimePicker2.SelectedTime, chblWeekDates); } else { string scrp = "تاریخ درخواست باید بعد از تاریخ امروز باشد.";//باید این پیام عوض شود. RadWindowManager1.RadAlert(scrp, 300, 100, "خطا", ""); //ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", scrp, true); return; } } optlist = new List <Option>(); foreach (ListItem item in chblOptions.Items) { if (item.Selected) { Option opt = new Option(); opt.ID = Convert.ToInt32(item.Value); opt.Name = item.Text; opt.IsActive = item.Selected; optlist.Add(opt); } } RequestHandler rqh = new RequestHandler(); DataTable dt = rqh.HasRequestBefore(req.IssuerID, req.DateTimeRange); if (dt.Rows.Count > 0) { if (dt.Select().ToList().Exists(row => row["MayConflict"].ToString() == "1")) { string scrp = "تداخل در ساعت و تاریخ درخواست ، با ساعات درخواست های پیشین این استاد."; RadWindowManager1.RadAlert(scrp, 300, 100, "خطا", ""); return; } } if (RequestHandler.IsNotSpecifiedDay(DayOfWeek.Friday, req.DateTimeRange)) { string scrp = "در روز جمعه امکان برگزاری وجود ندارد"; RadWindowManager1.RadAlert(scrp, 300, 100, "خطا", ""); return; } try { int reqid = rqh.AddNewRequest(req, optlist, Session[sessionNames.userID_Karbar].ToString()); var comman = new CommonBusiness(); comman.InsertIntoUserLog(userID, "", 11, 114, "ثبت درخواست کلاس ", reqid); string scrp = "درخواست شما با شماره " + reqid.ToString() + " با موفقیت ثبت گردید"; string address = prevPage + "?id=" + generaterandomstr() + "@A" + "0" + "-" + generaterandomstr(); string resdirectFunc = "function redirectToLast(){ window.location= '" + address + "' ; }"; RadWindowManager1.RadAlert(scrp, 300, 100, "پیام سیستم", resdirectFunc); //ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", scrp, true); } catch (Exception) { throw; } }
protected void btnEditRequest_Click(object sender, EventArgs e) { if (Page.IsValid) { RequestFR req = new RequestFR(); RequestHandler rqH = new RequestHandler(); req = rqH.GetRequestDetails(reqID); req.CatID = Convert.ToInt32(drpCategory.SelectedValue); RC_User user = new RC_User(); RC_UserHandler us = new RC_UserHandler(); user = us.Get_Ostad_Details(req.IssuerID); req.Subject = "nosub"; req.Note = txtDescription.Text; req.Location = drpLocation.SelectedValue; if (chbRepeat.Checked == false) { if (CheckReqDate(pcal1.Text)) { RequestDateTime rdt = new RequestDateTime(); rdt.Date = pcal1.Text; rdt.StartTime = RadTimePicker1.SelectedTime.Value.Ticks; rdt.EndTime = RadTimePicker2.SelectedTime.Value.Ticks; rdt.RequestId = req.ID; req.DateTimeRange = new List <RequestDateTime>(); req.DateTimeRange.Add(rdt); } else { string scrp = "تاریخ درخواست باید بعد از تاریخ امروز باشد."; RadWindowManager1.RadAlert(scrp, 300, 100, "خطا", ""); //ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", scrp, true); return; } } else { if (CheckReqDate(pcal1.Text) && CheckReqDate(pcal2.Text)) { req.DateTimeRange = FillRequestDateTime(pcal1.Text, pcal2.Text, RadTimePicker1.SelectedTime, RadTimePicker2.SelectedTime, chblWeekDates, req.ID); } else { string scrp = "تاریخ درخواست باید بعد از تاریخ امروز باشد.";//باید این پیام عوض شود. RadWindowManager1.RadAlert(scrp, 300, 100, "خطا", ""); //ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", scrp, true); return; } } req.IssuerID = user.ID; req.IssuerName = user.Name; if ((bool)Session["isMeeting"]) { trProfCrs.Visible = false; } CourseHandler corH = new CourseHandler(); courselist = corH.GetCourseListByUserID(user.ID); int coursedid = Convert.ToInt32(drpCourse.SelectedValue); req.Capacity = courselist.Find(i => i.DID == coursedid).Capacity; req.CourseName = drpCourse.SelectedItem.ToString(); req.DaneshID = courselist.Find(i => i.DID == coursedid).DaneshID; req.CourseDID = coursedid; req.Capacity = Convert.ToInt32(txtCapacity.Text); req.Issue_time = DateTime.Now.ToPeString(); if (CheckReqDate(pcal1.Text)) { //req.Sessiondate = pcal1.Text; } else { string scrp = "تاریخ درخواست باید بعد از تاریخ امروز باشد"; RadWindowManager1.RadAlert(scrp, 300, 100, "خطا", ""); return; } optlist = new List <Option>(); foreach (ListItem item in chblOptions.Items) { Option optstat = new Option(); optstat.ID = Convert.ToInt32(item.Value); optstat.Name = item.Text; optstat.IsActive = item.Selected; optlist.Add(optstat); } if (RequestHandler.IsNotSpecifiedDay(DayOfWeek.Friday, req.DateTimeRange)) { string scrp = "در روز جمعه امکان برگزاری وجود ندارد"; RadWindowManager1.RadAlert(scrp, 300, 100, "خطا", ""); return; } try { RequestHandler rq = new RequestHandler(); req.Status = 1;//sent int reqid = rq.EditRequest(req, optlist); var commanBusiness = new CommonBusiness(); userID = Convert.ToInt32(Session[sessionNames.userID_Karbar]); commanBusiness.InsertIntoUserLog(userID, "", 11, 115, "تایید آموزش درخواست رزرواسیون", reqid); var address = ViewState["GoBackTo"].ToString(); string resdirectFunc = "function redirectToLast(){ window.location= '" + address + "' ; }"; string scrp = "درخواست شما با شماره " + reqid.ToString() + " با موفقیت ویرایش و ثبت گردید"; RadWindowManager1.RadAlert(scrp, 300, 100, "پیام سیستم", resdirectFunc); } catch (Exception) { throw; } } }