protected void ViewTask_Accept_Click(object sender, EventArgs e)
{
Decimal _deciInput = Convert.ToDecimal(ViewTask_ExtraBudget.Value);
string _commentText = ViewTask_ExtraComment.Text;
RadButton _sender = (RadButton)sender;
if (_sender.CommandName == "FINANCIAL")
{
#region insert financial request
List <string[]> _parameters = new List <string[]>();
_parameters.Add(new string[] { "@ReqType", "FINANCE" });
_parameters.Add(new string[] { "@ReqResp", "FM" });
_parameters.Add(new string[] { "@ReqDescr", "" });
_parameters.Add(new string[] { "@ReqDate", (DateTime.Today).ToString("yyyy.MM.dd") });
_parameters.Add(new string[] { "@ReqTaskId", _sender.Value });
_parameters.Add(new string[] { "@ReqStatus", "OPEN" });
_parameters.Add(new string[] { "@ReqBudget", "" });
string _createRequestQuery = "insert into [Request] ([ReqType], [ReqResp], [ReqDescr], [ReqDate], [ReqTaskId], [ReqStatus], [ReqBudget]) " +
" values (@ReqType, @ReqResp, @ReqDescr, @ReqDate, @ReqTaskId, @ReqStatus, @ReqBudget)";
#endregion
Data_Utilities.ModifyDataBase_Parameters(_createRequestQuery, _parameters);
TaskControl.SubmitTask(Convert.ToInt32(_sender.Value), _deciInput, _commentText);
}
if (_sender.CommandName == "CLOSE")
{
TaskControl.SubmitTask(Convert.ToInt32(_sender.Value), _deciInput, _commentText);
}
if (_sender.CommandName == "PENDING")
{
TaskControl.SubmitTask(Convert.ToInt32(_sender.Value), _deciInput, _commentText);
}
InterfaceByUser();
}
protected void Task_AddTaskToEvent_Click(object sender, EventArgs e)
{
//Task_Feedback.Text = (Task_DueDate.SelectedDate.Value).ToString("dd.MM.yyyy"); return;
GridDataItem _selectedEvent = Radgrid_Events.MasterTableView.GetSelectedItems()[0];
string _eventId = _selectedEvent["EventId"].Text;
List <string[]> _parameters = new List <string[]>();
_parameters.Add(new string[] { "@TaskCreator", User.Identity.Name.ToUpper() });
_parameters.Add(new string[] { "@TaskTeam", Task_Subteams.SelectedValue });
_parameters.Add(new string[] { "@TaskStatusMsg", Task_Subteams.SelectedValue });
_parameters.Add(new string[] { "@TaskEventId", _eventId });
_parameters.Add(new string[] { "@TaskBudget", Task_Budget.Value.ToString() });
_parameters.Add(new string[] { "@TaskDueDate", (Task_DueDate.SelectedDate.Value).ToString("yyyy.MM.dd") });
_parameters.Add(new string[] { "@TaskDCreated", (DateTime.Today).ToString("yyyy.MM.dd") });//"GETDATE()" });
_parameters.Add(new string[] { "@TaskStatus", "PENDING" });
_parameters.Add(new string[] { "@TaskName", Task_Name.Text });
_parameters.Add(new string[] { "@TaskDescr", Task_Descr.Text });
string _createTaskQuery = "insert into [Task] ([TaskCreator], [TaskTeam], [TaskStatusMsg], [TaskEventId], [TaskBudget], [TaskDueDate], [TaskDCreated], [TaskStatus], [TaskName], [TaskDescr]) " +
" values (@TaskCreator, @TaskTeam, @TaskStatusMsg, @TaskEventId, @TaskBudget, @TaskDueDate, @TaskDCreated, @TaskStatus, @TaskName, @TaskDescr)";
Data_Utilities.ModifyDataBase_Parameters(_createTaskQuery, _parameters);
Task_Name.Text = "";
Task_Descr.Text = "";
Task_Subteams.ClearSelection();
Task_DueDate.SelectedDate = null;
Task_Budget.Value = 0;
//Task_DueDate.
Task_Feedback.Text = "Task successfuly created";
}
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 EventOutsourceRequest_Create_Click(object sender, EventArgs e)
{
GridDataItem _selectedEvent = Radgrid_Events.MasterTableView.GetSelectedItems()[0];
string _eventId = _selectedEvent["EventId"].Text;
List <string[]> _parameters = new List <string[]>();
_parameters.Add(new string[] { "@ReqType", "OUTSOURCE" });
_parameters.Add(new string[] { "@ReqResp", "HR" });
_parameters.Add(new string[] { "@ReqDescr", EventOutsourceRequest_Name.Text + "|" + EventOutsourceRequest_Description.Text + "|" + EventOutsourceRequest_Subteam.SelectedValue });
_parameters.Add(new string[] { "@ReqDate", (DateTime.Today).ToString("yyyy.MM.dd") });
_parameters.Add(new string[] { "@ReqTaskId", _eventId });
_parameters.Add(new string[] { "@ReqStatus", "OPEN" });
_parameters.Add(new string[] { "@ReqBudget", "" });
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);
EventOutsourceRequest_Name.Text = "";
EventOutsourceRequest_Subteam.ClearSelection();
EventOutsourceRequest_Description.Text = "";
EventOutsourceRequest_Feedback.Text = "Outsource request created";
}
