protected void Page_Load(object sender, EventArgs e)
{
System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("sv-SE");
if (!IsPostBack)
{
Utilities.DisableTextBox(EventForm_Name);
Utilities.DisableTextBox(EventForm_Description);
Utilities.DisableTextBox(EventForm_From);
Utilities.DisableTextBox(EventForm_To);
Utilities.DisableTextBox(EventForm_Comment);
Utilities.DisableTextBox(EventForm_Budget);
Utilities.DisableTextBox(EventForm_Guests);
Utilities.DisableTextBox(EventForm_Type);
Utilities.DisableTextBox(Task_Feedback);
Utilities.DisableTextBox(NewEventRequestForm_Feedback);
Utilities.DisableTextBox(RequestEvent_Name);
Utilities.DisableTextBox(RequestEvent_Descr);
Utilities.DisableTextBox(RequestEvent_From);
Utilities.DisableTextBox(RequestEvent_To);
Utilities.DisableTextBox(RequestEvent_Comment);
Utilities.DisableTextBox(RequestEvent_Budget);
Utilities.DisableTextBox(RequestEvent_Guests);
Utilities.DisableTextBox(RequestEvent_Type);
Utilities.DisableTextBox(RequestEvent_EventId);
Utilities.DisableTextBox(ViewTask_Name);
Utilities.DisableTextBox(ViewTask_Descr);
Utilities.DisableTextBox(ViewTask_CreatedInfo);
Utilities.DisableTextBox(ViewTask_DueDate);
Utilities.DisableTextBox(ViewTask_Budget);
Utilities.DisableTextBox(FinanceRequest_Event);
Utilities.DisableTextBox(FinanceRequest_Name);
Utilities.DisableTextBox(FinanceRequest_Department);
Utilities.DisableTextBox(FinanceRequest_Descr);
Utilities.DisableTextBox(OutsourceRequest_Regarding);
Utilities.DisableTextBox(OutsourceRequest_Descr);
Utilities.DisableTextBox(OutsourceRequest_Name);
Utilities.DisableTextBox(OutsourceRequest_Subteam);
Utilities.DisableTextBox(EventOutsourceRequest_Feedback);
Utilities.SetStandardGrid(Radgrid_Events);
if (User.Identity.IsAuthenticated)
{
AuthDiv.Style.Add("display", "inline");
NoAuthDiv.Style.Add("display", "none");
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
//ugh - lazy
if (_userRole == "SDM")
{
Task_Subteams.Items.Add(new RadComboBoxItem("Chef", "CHEF"));
Task_Subteams.Items.Add(new RadComboBoxItem("Catering", "CATERING"));
EventOutsourceRequest_Subteam.Items.Add(new RadComboBoxItem("Chef", "CHEF"));
EventOutsourceRequest_Subteam.Items.Add(new RadComboBoxItem("Catering", "CATERING"));
}
if (_userRole == "PM")
{
Task_Subteams.Items.Add(new RadComboBoxItem("Audio Technician", "AUDIO"));
Task_Subteams.Items.Add(new RadComboBoxItem("Decoration", "DECORATION"));
Task_Subteams.Items.Add(new RadComboBoxItem("Graphic Designer", "GRAPHIC_DESIGNER"));
Task_Subteams.Items.Add(new RadComboBoxItem("IT department", "IT"));
Task_Subteams.Items.Add(new RadComboBoxItem("Photographer", "PHOTOGRAPHER"));
EventOutsourceRequest_Subteam.Items.Add(new RadComboBoxItem("Audio Technician", "AUDIO"));
EventOutsourceRequest_Subteam.Items.Add(new RadComboBoxItem("Decoration", "DECORATION"));
EventOutsourceRequest_Subteam.Items.Add(new RadComboBoxItem("Graphic Designer", "GRAPHIC_DESIGNER"));
EventOutsourceRequest_Subteam.Items.Add(new RadComboBoxItem("IT department", "IT"));
EventOutsourceRequest_Subteam.Items.Add(new RadComboBoxItem("Photographer", "PHOTOGRAPHER"));
}
InterfaceByUser();
//Data_Utilities.ModifyDataBase_Parameters("insert into [Table] ([RoleId], [RoleName]) values (@ROLEID, @ROLENAME)", _parameters);
}
else
{
AuthDiv.Style.Add("display", "none");
NoAuthDiv.Style.Add("display", "inline");
}
}
}
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);
}
}
