protected void NewEventRequestForm_SendNewRequest_Click(object sender, EventArgs e)
{
string _description = "DESCR: " + NewEventRequestForm_Descr.Text + ". EMAIL: " + NewEventRequestForm_Email.Text + ". NUMBER: " + NewEventRequestForm_Number.Text;
List <string[]> _parameters = new List <string[]>();
_parameters.Add(new string[] { "@EventName", NewEventRequestForm_Name.Text });
_parameters.Add(new string[] { "@EventDescr", _description });
_parameters.Add(new string[] { "@EventFrom", (NewEventRequestForm_DateFrom.SelectedDate.Value).ToString("yyyy.MM.dd") });
_parameters.Add(new string[] { "@EventTo", (NewEventRequestForm_DateTo.SelectedDate.Value).ToString("yyyy.MM.dd") });
_parameters.Add(new string[] { "@EventBudget", "0" });
_parameters.Add(new string[] { "@EventType", NewEventRequestForm_Type.SelectedValue });
_parameters.Add(new string[] { "@EventGuests", NewEventRequestForm_Guests.Value.ToString() });
_parameters.Add(new string[] { "@EventStatus", "PENDING" });
string _createEventQuery = "insert into [Events] ([EventName], [EventDescr], [EventFrom], [EventTo], [EventBudget], [EventType], [EventGuests], [EventStatus]) " +
" values (@EventName, @EventDescr, @EventFrom, @EventTo, @EventBudget, @EventType, @eventGuests, @EventStatus)";
Data_Utilities.ModifyDataBase_Parameters(_createEventQuery, _parameters);
string _getNewEventId = Data_Utilities.getSQLDataByQuery("select max(EventId) from [Events]").Rows[0][0].ToString();
_parameters.Clear();
_parameters.Add(new string[] { "@ReqType", "EVENT" });
_parameters.Add(new string[] { "@ReqResp", "SCS" });
_parameters.Add(new string[] { "@ReqDescr", _description });
_parameters.Add(new string[] { "@ReqDate", (DateTime.Today).ToString("yyyy.MM.dd") });
_parameters.Add(new string[] { "@ReqTaskId", _getNewEventId });
_parameters.Add(new string[] { "@ReqStatus", "OPEN" });
_parameters.Add(new string[] { "@ReqBudget", NewEventRequestForm_Budget.Value.ToString() });
string _createRequestQuery = "insert into [Request] ([ReqType], [ReqResp], [ReqDescr], [ReqDate], [ReqTaskId], [ReqStatus], [ReqBudget]) " +
" values (@ReqType, @ReqResp, @ReqDescr, @ReqDate, @ReqTaskId, @ReqStatus, @ReqBudget)";
Data_Utilities.ModifyDataBase_Parameters(_createRequestQuery, _parameters);
NewEventRequestForm_Feedback.Text = "New event request created.";
NewEventRequestForm_Name.Text = "";
NewEventRequestForm_Email.Text = "";
NewEventRequestForm_Number.Text = "";
NewEventRequestForm_Budget.Value = 0;
NewEventRequestForm_Type.SelectedIndex = 0;
NewEventRequestForm_DateFrom.Clear();
NewEventRequestForm_DateTo.Clear();
NewEventRequestForm_Descr.Text = "";
InterfaceByUser();
}
protected void Radgrid_Events_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
RadGrid _sender = (RadGrid)sender;
_sender.DataSource = Data_Utilities.getSQLDataByQuery("select * from [Events] where [EventStatus] in('APPROVED','PENDING_REPORT') order by EventFrom asc");
}
protected void Events_AjaxManager_AjaxRequest(object sender, AjaxRequestEventArgs e)
{
string[] _arguments = e.Argument.Split(';');
if (_arguments.Length > 1)
{
if (_arguments[0] == "init_Task")
{
// List<string[]> _reqParamenter = new List<string[]>();
// _reqParamenter.Add(new string[] { "@reqId", _arguments[1].Trim() });
// DataTable _reqInfo = Data_Utilities.getSQLDataByQuery_Parameters("select * from [Requests] where [ReqId]=@ReqId", _reqParamenter);
List <string[]> _taskParamenter = new List <string[]>();
_taskParamenter.Add(new string[] { "@TaskId", _arguments[1].Trim() });// _reqInfo.Rows[0]["ReqTaskId"].ToString() });
DataTable _taskInfo = Data_Utilities.getSQLDataByQuery_Parameters("select * from [Task] where [TaskId]=@TaskId", _taskParamenter);
ViewTask_Name.Text = _taskInfo.Rows[0]["TaskName"].ToString();
ViewTask_Descr.Text = _taskInfo.Rows[0]["TaskDescr"].ToString();
ViewTask_CreatedInfo.Text = _taskInfo.Rows[0]["TaskCreator"].ToString() + " (" + _taskInfo.Rows[0]["TaskDCreated"].ToString() + ")";
ViewTask_OpenEventInformation.Text = "View event";
ViewTask_OpenEventInformation.Value = _taskInfo.Rows[0]["TaskEventId"].ToString();
ViewTask_DueDate.Text = "Do before: " + _taskInfo.Rows[0]["TaskDueDate"].ToString();
foreach (GridDataItem item in Radgrid_Events.MasterTableView.Items)
{
if (item["EventId"].Text == _taskInfo.Rows[0]["TaskEventId"].ToString())
{
item.Selected = true;
}
}
string _extraBudget = _taskInfo.Rows[0]["TaskExtraBudget"].ToString();
double _extraAsDouble = !String.IsNullOrEmpty(_taskInfo.Rows[0]["TaskExtraBudget"].ToString()) ? Convert.ToDouble(_taskInfo.Rows[0]["TaskExtraBudget"].ToString()) : 0;
ViewTask_Budget.Text = _taskInfo.Rows[0]["TaskBudget"].ToString();
ViewTask_ExtraBudget.Value = _extraAsDouble;
ViewTask_ExtraComment.Text = _taskInfo.Rows[0]["TaskExtraComment"].ToString();
string _taskStatus = _taskInfo.Rows[0]["TaskStatus"].ToString();
ViewTask_ExtraBudget.ReadOnly = false;
ViewTask_ExtraComment.ReadOnly = false;
if (_taskStatus == "PENDING FINANCIAL REQUEST")
{
ViewTask_Accept.Text = "Send financial request";
ViewTask_Accept.CommandName = "FINANCIAL";
}
else if (_taskStatus == "IN PROGRESS")
{
ViewTask_ExtraBudget.ReadOnly = true;
ViewTask_ExtraComment.ReadOnly = true;
ViewTask_Accept.Text = "Mark task finished";
ViewTask_Accept.CommandName = "CLOSE";
}
else if (_taskStatus == "PENDING")
{
ViewTask_Accept.Text = "Send task accept";
ViewTask_Accept.CommandName = "PENDING";
}
ViewTask_Accept.Value = _arguments[1].Trim();
}
if (_arguments[0] == "init_Request")
{
List <string[]> _reqParamenter = new List <string[]>();
_reqParamenter.Add(new string[] { "@ReqId", _arguments[1].Trim() });
DataTable _requestInfo = Data_Utilities.getSQLDataByQuery_Parameters("select * from [Request] where [ReqId]=@ReqId and [ReqType]='EVENT'", _reqParamenter);
List <string[]> _eventParamenter = new List <string[]>();
_eventParamenter.Add(new string[] { "@EventId", _requestInfo.Rows[0]["ReqTaskId"].ToString() });
DataTable _eventInfo = Data_Utilities.getSQLDataByQuery_Parameters("select * from [Events] where [EventId]=@EventId", _eventParamenter);
RequestEvent_Name.Text = _eventInfo.Rows[0]["EventName"].ToString();
RequestEvent_Descr.Text = _eventInfo.Rows[0]["EventDescr"].ToString();
RequestEvent_From.Text = _eventInfo.Rows[0]["EventFrom"].ToString();
RequestEvent_To.Text = _eventInfo.Rows[0]["EventTo"].ToString();
//RequestEvent_Comment.Text = _eventInfo.Rows[0]["FinancialComment"].ToString();
RequestEvent_Guests.Text = _eventInfo.Rows[0]["EventGuests"].ToString();
RequestEvent_Type.Text = _eventInfo.Rows[0]["EventType"].ToString();
RequestEvent_Budget.Text = _requestInfo.Rows[0]["ReqBudget"].ToString();
RequestEvent_EventId.Text = _requestInfo.Rows[0]["ReqId"].ToString();
RequestEvent_FM_Budget.Text = _eventInfo.Rows[0]["EventBudget"].ToString();
RequestEvent_FM_Comment.Text = _eventInfo.Rows[0]["FinancialComment"].ToString();
if (_requestInfo.Rows[0]["ReqResp"].ToString() == "SCS")
{
RequestEvent_FM_Budget.ReadOnly = true;
RequestEvent_FM_Comment.ReadOnly = true;
}
if (_requestInfo.Rows[0]["ReqResp"].ToString() == "FM")
{
RequestEvent_Reject.Enabled = false;
}
if (_requestInfo.Rows[0]["ReqResp"].ToString() == "ADM")
{
RequestEvent_FM_Budget.ReadOnly = true;
RequestEvent_FM_Comment.ReadOnly = true;
}
// if request is ready, display meeting and hide buttins
if (_requestInfo.Rows[0]["ReqStatus"].ToString() == "READY")
{
RequestEvent_Reject.Visible = false;
RequestEvent_Forward.Visible = false;
RequestEvent_Meeting.Visible = true;
}
else
{
RequestEvent_Reject.Visible = true;
RequestEvent_Forward.Visible = true;
RequestEvent_Meeting.Visible = false;
}
}
if (_arguments[0] == "init_RequestFinance")
{
List <string[]> _reqParamenter = new List <string[]>();
_reqParamenter.Add(new string[] { "@ReqId", _arguments[1].Trim() });
DataTable _requestInfo = Data_Utilities.getSQLDataByQuery_Parameters("select * from [Request] where [ReqId]=@ReqId ", _reqParamenter);
List <string[]> _taskParamenter = new List <string[]>();
_taskParamenter.Add(new string[] { "@TaskId", _requestInfo.Rows[0]["ReqTaskId"].ToString() });
DataTable _taskInfo = Data_Utilities.getSQLDataByQuery_Parameters("select * from [Task] where [TaskId]=@TaskId ", _taskParamenter);
List <string[]> _eventParamenter = new List <string[]>();
_eventParamenter.Add(new string[] { "@EventId", _taskInfo.Rows[0]["TaskEventId"].ToString() });
DataTable _eventInfo = Data_Utilities.getSQLDataByQuery_Parameters("select * from [Events] where [EventId]=@EventId", _eventParamenter);
foreach (GridDataItem item in Radgrid_Events.MasterTableView.Items)
{
if (item["EventId"].Text == _taskInfo.Rows[0]["TaskEventId"].ToString())
{
item.Selected = true;
}
}
FinanceRequest_Event.Text = _eventInfo.Rows[0]["EventName"].ToString();
FinanceRequest_ViewEvent.Value = _taskInfo.Rows[0]["TaskEventId"].ToString();
FinanceRequest_Name.Text = _taskInfo.Rows[0]["TaskName"].ToString();
FinanceRequest_Department.Text = _taskInfo.Rows[0]["TaskStatusMsg"].ToString();
FinanceRequest_Descr.Text = _taskInfo.Rows[0]["TaskExtraComment"].ToString() + " | " + _taskInfo.Rows[0]["TaskDescr"].ToString();
FinanceRequest_Original.Text = _taskInfo.Rows[0]["TaskBudget"].ToString();
//FinanceRequest_Extra.Text = _taskInfo.Rows[0]["TaskExtraBudget"].ToString();
FinanceRequest_Reject.CommandName = _arguments[1].Trim();
FinanceRequest_Accept.CommandName = _arguments[1].Trim();
}
if (_arguments[0] == "init_RequestOutsource")
{
List <string[]> _reqParamenter = new List <string[]>();
_reqParamenter.Add(new string[] { "@ReqId", _arguments[1].Trim() });
DataTable _requestInfo = Data_Utilities.getSQLDataByQuery_Parameters("select * from [Request] where [ReqId]=@ReqId ", _reqParamenter);
//List<string[]> _taskParamenter = new List<string[]>();
//_taskParamenter.Add(new string[] { "@TaskId", _requestInfo.Rows[0]["ReqTaskId"].ToString() });
//DataTable _taskInfo = Data_Utilities.getSQLDataByQuery_Parameters("select * from [Task] where [TaskId]=@TaskId ", _taskParamenter);
List <string[]> _eventParamenter = new List <string[]>();
_eventParamenter.Add(new string[] { "@EventId", _requestInfo.Rows[0]["ReqTaskId"].ToString() });
DataTable _eventInfo = Data_Utilities.getSQLDataByQuery_Parameters("select * from [Events] where [EventId]=@EventId", _eventParamenter);
foreach (GridDataItem item in Radgrid_Events.MasterTableView.Items)
{
if (item["EventId"].Text == _requestInfo.Rows[0]["ReqTaskId"].ToString())
{
item.Selected = true;
}
}
string[] _outsourceInfo = _requestInfo.Rows[0]["ReqDescr"].ToString().Split('|');
OutsourceRequest_Name.Text = _outsourceInfo[0]; // _taskInfo.Rows[0]["TaskName"].ToString();
OutsourceRequest_Subteam.Text = Data_Utilities.getSQLDataByQuery("select UserRoleDisplay from [Users] where UserRole='" + _outsourceInfo[2] + "'").Rows[0][0].ToString(); // _taskInfo.Rows[0]["TaskStatusMsg"].ToString();
OutsourceRequest_Descr.Text = _outsourceInfo[1];
OutsourceRequest_Regarding.Text = _eventInfo.Rows[0]["EventName"].ToString();
OutsourceRequest_ViewEvent.Value = _eventInfo.Rows[0]["EventId"].ToString();
OutsourceRequest_Reject.Value = _arguments[1].Trim();
OutsourceRequest_Accept.Value = _arguments[1].Trim();
}
}
else
{
if (e.Argument == "init_Event")
{
GridDataItem _selectedEvent = Radgrid_Events.MasterTableView.GetSelectedItems()[0];
EventForm_Name.Text = _selectedEvent["EventName"].Text;
EventForm_Description.Text = _selectedEvent["EventDescr"].Text;
EventForm_From.Text = _selectedEvent["EventFrom"].Text;
EventForm_To.Text = _selectedEvent["EventTo"].Text;
EventForm_Comment.Text = _selectedEvent["FinancialComment"].Text;
EventForm_Budget.Text = _selectedEvent["EventBudget"].Text;
EventForm_Guests.Text = _selectedEvent["EventGuests"].Text;
EventForm_Type.Text = _selectedEvent["EventType"].Text;
Task_Feedback.Text = "";
EventOutsourceRequest_Feedback.Text = "";
//return;
EventForm_Task_Info.Controls.Clear();
GridView DisplayTaskToEvent = new GridView();
DisplayTaskToEvent.DataSource = Data_Utilities.getSQLDataByQuery(
"select TaskName, TaskDescr, TaskStatus, TaskCreator, TaskTeam from [Task] where TaskEventId=" + _selectedEvent["EventId"].Text);
DisplayTaskToEvent.DataBind();
EventForm_Task_Info.Controls.Add(DisplayTaskToEvent);
EventForm_OutsourceRequest_Info.Controls.Clear();
GridView DisplayRequestToEvent = new GridView();
DisplayRequestToEvent.DataSource = Data_Utilities.getSQLDataByQuery(
"select ReqType, ReqStatus, ReqDescr, ReqDate,ReqResp from [Request] where ReqType in ('OUTSOURCE', 'FINANCE') AND ReqTaskId=" + _selectedEvent["EventId"].Text);
DisplayRequestToEvent.DataBind();
EventForm_OutsourceRequest_Info.Controls.Add(DisplayRequestToEvent);
}
if (e.Argument == "init_NewRequest")
{
}
}
}
private void InterfaceByUser()
{
// Can User create new client request
// Refactor here
List <string[]> _parameters = new List <string[]>();
_parameters.Add(new string[] { "@UserName", User.Identity.Name.ToUpper() });
DataTable _table = Data_Utilities.getSQLDataByQuery_Parameters("select userrole from users where Username = @UserName", _parameters);
string _userRole = _table.Rows[0][0].ToString();
// Set the create new event request view
if (_userRole == "SCS" || _userRole == "CS")
{
}
else
{
Div_CreateNewEventRequest.Style.Add("display", "none");
}
// Set the task creation view
if (_userRole == "SDM" || _userRole == "PM")
{
}
else
{
EventForm_Task.Style.Add("display", "none");
EventForm_OutsourceRequest.Style.Add("display", "none");
}
Div_GeneratedTasks.Controls.Clear();
Div_GeneratedRequests.Controls.Clear();
// Populate Tabs list
List <string[]> _tParameters = new List <string[]>();
_tParameters.Add(new string[] { "@TaskTeam", _userRole });
DataTable _taskTable = Data_Utilities.getSQLDataByQuery_Parameters("select * from [Task] where [TaskTeam]=@TaskTeam and [TaskStatus] not in('CLOSED') order by [TaskDueDate] asc", _tParameters);
if (_taskTable.Rows.Count != 0)
{
for (int i = 0; i < _taskTable.Rows.Count; i++)
{
string _status = _taskTable.Rows[i]["TaskStatus"].ToString();
RadButton _generatedTask_Button = new RadButton();
_generatedTask_Button.RenderMode = RenderMode.Lightweight;
_generatedTask_Button.Text = _taskTable.Rows[i]["TaskName"].ToString() + " | "
+ (DateTime.Parse(_taskTable.Rows[i]["TaskDueDate"].ToString())).ToString("yyyy.MM.dd") + " | " + _status;
_generatedTask_Button.Value = _taskTable.Rows[i]["TaskId"].ToString();
_generatedTask_Button.AutoPostBack = false;
_generatedTask_Button.Width = 350;
_generatedTask_Button.Style.Add("margin", "10px 0px");
_generatedTask_Button.OnClientClicked = "openTaskForm";
_generatedTask_Button.Skin = _status == "IN PROGRESS" ? "Sunset" : "Office2007";
Div_GeneratedTasks.Controls.Add(_generatedTask_Button);
}
}
else
{
RadLabel _label = new RadLabel();
_label.RenderMode = RenderMode.Lightweight;
_label.Text = "You have no tasks assigned to you at the moment";
Div_GeneratedTasks.Controls.Add(_label);
}
// Populate Request list
List <string[]> _rParameters = new List <string[]>();
_rParameters.Add(new string[] { "@ReqResp", _userRole });
DataTable _requestTable = Data_Utilities.getSQLDataByQuery_Parameters("select * from [Request] where [ReqResp]=@ReqResp and [ReqStatus] in('OPEN', 'READY') order by [ReqDate] asc", _rParameters);
if (_requestTable.Rows.Count != 0)
{
for (int i = 0; i < _requestTable.Rows.Count; i++)
{
string _reqType = _requestTable.Rows[i]["ReqType"].ToString();
string _displayName;
if (_reqType == "OUTSOURCE")
{
_displayName = Data_Utilities.getSQLDataByQuery("select EventName from [Events] where EventId=" + _requestTable.Rows[i]["ReqTaskId"].ToString()).Rows[0][0].ToString();
}
else if (_reqType == "EVENT")
{
_displayName = Data_Utilities.getSQLDataByQuery("select EventName from [Events] where EventId=" + _requestTable.Rows[i]["ReqTaskId"].ToString()).Rows[0][0].ToString();
}
else
{
_displayName = Data_Utilities.getSQLDataByQuery("select TaskName from [Task] where TaskId=" + _requestTable.Rows[i]["ReqTaskId"].ToString()).Rows[0][0].ToString();
}
RadButton _generatedRequest_Button = new RadButton();
_generatedRequest_Button.RenderMode = RenderMode.Lightweight;
_generatedRequest_Button.Text = _displayName + " | " + _requestTable.Rows[i]["ReqType"].ToString() + " | "
+ (DateTime.Parse(_requestTable.Rows[i]["ReqDate"].ToString())).ToString("yyyy.MM.dd");
_generatedRequest_Button.Value = _requestTable.Rows[i]["ReqId"].ToString(); // var reqtaskid
_generatedRequest_Button.AutoPostBack = false;
_generatedRequest_Button.Width = 350;
_generatedRequest_Button.Skin = "Office2007";
_generatedRequest_Button.Style.Add("margin", "10px 0px");
if (_reqType == "EVENT")
{
// Set different javscripts here
_generatedRequest_Button.OnClientClicked = "openRequestForm";
}
else if (_reqType == "FINANCE")
{
// Set different javscripts here
_generatedRequest_Button.OnClientClicked = "openRequestForm_Finance";
}
else if (_reqType == "OUTSOURCE")
{
// Set different javscripts here
_generatedRequest_Button.OnClientClicked = "openRequestForm_Outsource";
}
Div_GeneratedRequests.Controls.Add(_generatedRequest_Button);
}
}
else
{
RadLabel _label = new RadLabel();
_label.RenderMode = RenderMode.Lightweight;
_label.Text = "You have no requests assigned to you at the moment";
Div_GeneratedRequests.Controls.Add(_label);
}
}
