private void UpdateDatabase()
{
// Get ids
int companyId = Int32.Parse(hdfCompanyId.Value);
DB.Open();
DB.BeginTransaction();
try
{
// ... Update general todo list state
ToDoListInformationBasicInformation toDoListInformationBasicInformation = new ToDoListInformationBasicInformation(toDoListInformationTDS);
toDoListInformationBasicInformation.Save(companyId);
// ... Save to do list details
ToDoListInformationActivityInformation toDoListInformationActivityInformation = new ToDoListInformationActivityInformation(toDoListInformationTDS);
toDoListInformationActivityInformation.Save(companyId);
// ... Send mails
if (hdfCompleted.Value == "True")
{
SendMailForCompletedToDo();
}
DB.CommitTransaction();
// Store datasets
toDoListInformationTDS.AcceptChanges();
Session["toDoListInformationTDS"] = toDoListInformationTDS;
}
catch (Exception ex)
{
DB.RollbackTransaction();
string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' '));
Response.Redirect(url);
}
}
// ////////////////////////////////////////////////////////////////////////
// EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
// Register client scripts
this.RegisterClientScripts();
if (!IsPostBack)
{
// Security check
if (!(Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_TODOLIST_VIEW"]) && Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_TODOLIST_EDIT"])))
{
Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
}
// Validate query string
if (((string)Request.QueryString["source_page"] == null) || ((string)Request.QueryString["toDo_id"] == null) || ((string)Request.QueryString["action"] == null))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in toDoList_activity.aspx");
}
// Tag Page
hdfCompanyId.Value = Session["companyID"].ToString();
hdfToDoId.Value = Request.QueryString["toDo_id"].ToString();
hdfAction.Value = Request.QueryString["action"].ToString();
hdfDashboard.Value = Request.QueryString["dashboard"].ToString();
// If coming from
int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
int currentToDoId = Int32.Parse(hdfToDoId.Value.ToString());
Session.Remove("activityInformationDummy");
// ... toDoList_navigator2.aspx
if (Request.QueryString["source_page"] == "toDoList_navigator2.aspx")
{
StoreNavigatorState();
toDoListInformationTDS = new ToDoListInformationTDS();
activityInformation = new ToDoListInformationTDS.ActivityInformationDataTable();
ToDoListInformationBasicInformation toDoListInformationBasicInformation = new ToDoListInformationBasicInformation(toDoListInformationTDS);
toDoListInformationBasicInformation.LoadAllByToDoId(currentToDoId, companyId);
ToDoListInformationBasicInformationGateway toDoListInformationBasicInformationGatewayForState = new ToDoListInformationBasicInformationGateway(toDoListInformationBasicInformation.Data);
string state = toDoListInformationBasicInformationGatewayForState.GetState(currentToDoId);
if (state == "Completed") hdfCompleted.Value = "True";
ToDoListInformationActivityInformation toDoListInformationActivityInformation = new ToDoListInformationActivityInformation(toDoListInformationTDS);
toDoListInformationActivityInformation.LoadAllByToDoId(currentToDoId, companyId);
// Store dataset
Session["toDoListInformationTDS"] = toDoListInformationTDS;
Session["activityInformation"] = activityInformation;
}
// ... toDoList_summary.aspx or toDoList_edit.aspx
if ((Request.QueryString["source_page"] == "toDoList_summary.aspx") || (Request.QueryString["source_page"] == "toDoList_edit.aspx"))
{
StoreNavigatorState();
ViewState["update"] = Request.QueryString["update"];
// Restore dataset
toDoListInformationTDS = (ToDoListInformationTDS)Session["toDoListInformationTDS"];
activityInformation = (ToDoListInformationTDS.ActivityInformationDataTable)Session["activityInformation"];
if (ViewState["update"].ToString().Trim() == "yes")
{
ToDoListInformationBasicInformation toDoListInformationBasicInformation = new ToDoListInformationBasicInformation(toDoListInformationTDS);
toDoListInformationBasicInformation.LoadAllByToDoId(currentToDoId, companyId);
ToDoListInformationBasicInformationGateway toDoListInformationBasicInformationGatewayForState = new ToDoListInformationBasicInformationGateway(toDoListInformationBasicInformation.Data);
string state = toDoListInformationBasicInformationGatewayForState.GetState(currentToDoId);
if (state == "Completed") hdfCompleted.Value = "True";
ToDoListInformationActivityInformation toDoListInformationActivityInformation = new ToDoListInformationActivityInformation(toDoListInformationTDS);
toDoListInformationActivityInformation.LoadAllByToDoId(currentToDoId, companyId);
// Store dataset
Session["toDoListInformationTDS"] = toDoListInformationTDS;
Session["activityInformation"] = activityInformation;
}
}
// Prepare initial data
// ... for subject
ToDoListInformationBasicInformationGateway toDoListInformationBasicInformationGateway = new ToDoListInformationBasicInformationGateway();
toDoListInformationBasicInformationGateway.LoadAllByToDoId(currentToDoId, companyId);
lblTitleSubjectName.Text = " " + toDoListInformationBasicInformationGateway.GetSubject(currentToDoId);
// ... Data for current to do list
LoadToDoListData(currentToDoId, companyId);
}
else
{
// Restore datasets
toDoListInformationTDS = (ToDoListInformationTDS)Session["toDoListInformationTDS"];
activityInformation = (ToDoListInformationTDS.ActivityInformationDataTable)Session["activityInformation"];
}
}
private void GrdToDoAdd()
{
if (ValidateToDoFooter())
{
Page.Validate("activityDataNew");
if (Page.IsValid)
{
int employeeId = 0;
EmployeeGateway employeeGateway = new EmployeeGateway();
string dateTime_ = ((TextBox)grdToDoList.FooterRow.FindControl("tbxDateTimeNew")).Text;
string comment = ((TextBox)grdToDoList.FooterRow.FindControl("tbxCommentsNew")).Text;
string type_ = "";
string employeeFullName = "";
GridViewRow row = grdToDoList.FooterRow;
DropDownList action = ((DropDownList)row.FindControl("ddlActionsNew"));
switch (action.SelectedValue)
{
case "Assign To User":
employeeId = Int32.Parse(((DropDownList)grdToDoList.FooterRow.FindControl("ddlAssignToTeamMemberNew")).SelectedValue);
employeeGateway.LoadByEmployeeId(employeeId);
employeeFullName = employeeGateway.GetFullName(employeeId);
type_ = "AssignUser";
hdfToDoListState.Value = "In Progress";
break;
case "Add Comment":
int loginId = Convert.ToInt32(Session["loginID"]);
employeeId = employeeGateway.GetEmployeIdByLoginId(loginId);
type_ = "AddComment";
employeeFullName = employeeGateway.GetFullName(employeeId);
hdfToDoListState.Value = "In Progress";
break;
case "Complete":
employeeId = Int32.Parse(hdfAssignedUser.Value);
employeeGateway.LoadByEmployeeId(employeeId);
employeeFullName = employeeGateway.GetFullName(employeeId);
type_ = "CloseToDo";
hdfCompleted.Value = "True";
hdfToDoListState.Value = "Completed";
break;
case "Put On Hold":
int loginIdOnHold = Convert.ToInt32(Session["loginID"]);
employeeId = employeeGateway.GetEmployeIdByLoginId(loginIdOnHold);
type_ = "OnHoldToDo";
employeeFullName = employeeGateway.GetFullName(employeeId);
hdfToDoListState.Value = "On Hold";
break;
}
// static values
int toDoId = Int32.Parse(hdfToDoId.Value);
int companyId = Int32.Parse(hdfCompanyId.Value);
bool inDatabase = false;
ToDoListInformationBasicInformation generalModel = new ToDoListInformationBasicInformation(toDoListInformationTDS);
generalModel.UpdateState(toDoId, hdfToDoListState.Value);
ToDoListInformationActivityInformation model = new ToDoListInformationActivityInformation(toDoListInformationTDS);
model.Insert(toDoId, employeeId, type_, DateTime.Parse(dateTime_), comment, false, companyId, inDatabase, employeeFullName);
Session.Remove("activityInformationDummy");
Session["toDoListInformationTDS"] = toDoListInformationTDS;
grdToDoList.DataBind();
}
}
}
// ////////////////////////////////////////////////////////////////////////
// EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
// Register client scripts
this.RegisterClientScripts();
if (!IsPostBack)
{
// Security check
if (!(Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_TODOLIST_VIEW"]) && Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_TODOLIST_DELETE"])))
{
Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
}
// Validate query string
if (((string)Request.QueryString["source_page"] == null) || ((string)Request.QueryString["toDo_id"] == null) || ((string)Request.QueryString["dashboard"] == null))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in toDoList_delete.aspx");
}
// Tag Page
hdfCompanyId.Value = Session["companyID"].ToString();
hdfToDoListId.Value = Request.QueryString["toDo_id"].ToString();
hdfDashboard.Value = Request.QueryString["dashboard"].ToString();
hdfFmType.Value = "ToDoList";
// If comming from
// ... toDoList_navigator2.aspx
if (Request.QueryString["source_page"] == "toDoList_navigator2.aspx")
{
StoreNavigatorState();
ViewState["update"] = "no";
toDolistInformationTDS = new ToDoListInformationTDS();
toDoListTDS = new ToDoListTDS();
int toDolistId = Int32.Parse(hdfToDoListId.Value);
int companyId = Int32.Parse(hdfCompanyId.Value);
ToDoListInformationBasicInformation toDolistInformationBasicInformation = new ToDoListInformationBasicInformation(toDolistInformationTDS);
toDolistInformationBasicInformation.LoadAllByToDoId(toDolistId, companyId);
ToDoListInformationActivityInformation toDoListInformationActivityInformation = new ToDoListInformationActivityInformation(toDolistInformationTDS);
toDoListInformationActivityInformation.LoadAllByToDoId(toDolistId, companyId);
// Store dataset
Session["toDolistInformationTDS"] = toDolistInformationTDS;
Session["toDoListTDS"] = toDoListTDS;
}
// ... toDoList_summary.aspx
if (Request.QueryString["source_page"] == "toDoList_summary.aspx")
{
StoreNavigatorState();
ViewState["update"] = Request.QueryString["update"];
// Restore dataset
toDoListTDS = (ToDoListTDS)Session["toDoListTDS"];
toDolistInformationTDS = (ToDoListInformationTDS)Session["toDolistInformationTDS"];
}
}
else
{
// Restore datasets
toDoListTDS = (ToDoListTDS)Session["toDoListTDS"];
toDolistInformationTDS = (ToDoListInformationTDS)Session["toDolistInformationTDS"];
}
}
private void Delete()
{
Page.Validate();
if (Page.IsValid)
{
// Delete all data for toDolist
int toDolistId = Int32.Parse(hdfToDoListId.Value);
ToDoListInformationBasicInformation toDolistInformationBasicInformation = new ToDoListInformationBasicInformation(toDolistInformationTDS);
toDolistInformationBasicInformation.Delete(toDolistId);
ToDoListInformationActivityInformation toDoListInformationActivityInformation = new ToDoListInformationActivityInformation(toDolistInformationTDS);
toDoListInformationActivityInformation.DeleteAll(toDolistId);
// Update databse
UpdateDatabase();
// Store datasets
Session["toDolistInformationTDS"] = toDolistInformationTDS;
// Redirect
string url = "";
if (Request.QueryString["dashboard"] == "True")
{
url = "./../../FleetManagement/Dashboard/dashboard_login.aspx?source_page=out";
}
else
{
url = "./toDoList_navigator2.aspx?source_page=toDoList_delete.aspx&toDo_id=" + hdfToDoListId.Value + GetNavigatorState() + "&update=yes";
}
Response.Redirect(url);
}
}
private void UpdateDatabase()
{
// Get ids & location
//string workType = hdfWorkType.Value.Trim();
int companyId = Int32.Parse(hdfCompanyId.Value);
int toDoId = Int32.Parse(hdfToDoId.Value);
DB.Open();
DB.BeginTransaction();
try
{
// Save toDo details
ToDoListInformationBasicInformation toDoListInformationBasicInformation = new ToDoListInformationBasicInformation(toDoListInformationTDS);
toDoListInformationBasicInformation.Save(companyId);
//// Save work details
//PointToDoWorkDetails pointToDoWorkDetails = new PointToDoWorkDetails(toDoListInformationTDS);
//pointToDoWorkDetails.Save(countryId, provinceId, countyId, cityId, projectId, sectionAssetId, companyId);
DB.CommitTransaction();
// Store datasets
toDoListInformationTDS.AcceptChanges();
Session["toDoListInformationTDS"] = toDoListInformationTDS;
}
catch (Exception ex)
{
DB.RollbackTransaction();
string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' '));
Response.Redirect(url);
}
}
private void Save()
{
// Save data
int toDoId = Int32.Parse(hdfToDoId.Value);
DateTime? newDueDate = null; if (tkrdpDueDate.SelectedDate.HasValue) newDueDate = tkrdpDueDate.SelectedDate;
int? newUnitId = null; if (ddlUnit.SelectedValue != "-1") newUnitId = Int32.Parse(ddlUnit.SelectedValue);
// Insert to dataset
ToDoListInformationBasicInformation toDoListInformationBasicInformation = new ToDoListInformationBasicInformation(toDoListInformationTDS);
toDoListInformationBasicInformation.Update(toDoId, newDueDate, newUnitId);
// Store datasets
Session["toDoListInformationTDS"] = toDoListInformationTDS;
// Update database
UpdateDatabase();
ViewState["update"] = "yes";
// Redirect
string url = "";
if (Request.QueryString["source_page"] == "toDoList_navigator2.aspx")
{
url = "./toDoList_navigator2.aspx?source_page=toDoList_edit.aspx&toDo_id=" + hdfToDoId.Value + GetNavigatorState() + "&update=yes";
}
if (Request.QueryString["source_page"] == "toDoList_summary.aspx")
{
url = "./toDoList_summary.aspx?source_page=toDoList_edit.aspx&toDo_id=" + hdfToDoId.Value + "&dashboard=" + hdfDashboard.Value + GetNavigatorState() + "&update=yes";
}
Response.Redirect(url);
}
private void Apply()
{
// Save data
int toDoId = Int32.Parse(hdfToDoId.Value);
DateTime? newDueDate = null; if (tkrdpDueDate.SelectedDate.HasValue) newDueDate = tkrdpDueDate.SelectedDate;
int? newUnitId = null; if (ddlUnit.SelectedValue != "-1") newUnitId = Int32.Parse(ddlUnit.SelectedValue);
// Insert to dataset
ToDoListInformationBasicInformation toDoListInformationBasicInformation = new ToDoListInformationBasicInformation(toDoListInformationTDS);
toDoListInformationBasicInformation.Update(toDoId, newDueDate, newUnitId);
// Store datasets
Session["toDoListInformationTDS"] = toDoListInformationTDS;
// Update database
UpdateDatabase();
ViewState["update"] = "yes";
}
