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;
}
}
}
