private void UpdateDatabase()
        {
            DropDownList ddlOthersFor = (DropDownList)tkrpbLeftMenuOthersTimesheets.FindItemByValue("nbOthersTimesheetsDDL").FindControl("ddlOthersFor");
            Session["ddlOthersForSelectedValue"] = ddlOthersFor.SelectedValue;

            try
            {
                ProjectTimeGateway projectTimeGateway = new ProjectTimeGateway(projectTimeTDS);
                projectTimeGateway.Update();

                projectTimeTDS.AcceptChanges();

                Session["projectTimeTDS"] = projectTimeTDS;
            }
            catch (Exception ex)
            {
                string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' '));
                Response.Redirect(url);
            }
        }
        private void UpdateDatabase()
        {
            try
            {
                ProjectTimeGateway projectTimeGateway = new ProjectTimeGateway(projectTimeTDS);
                projectTimeGateway.Update();

                projectTimeTDS.AcceptChanges();

                Session["projectTimeTDS"] = projectTimeTDS;
            }
            catch (Exception ex)
            {
                string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' '));
                Response.Redirect(url);
            }
        }
        private void UpdateDatabase()
        {
            try
            {
                DataRow[] drEmployees = projectTimeTDSForState.LFS_PROJECT_TIME.Select("ProjectTimeState = 'For Approval'", "EmployeeID ASC", DataViewRowState.OriginalRows);

                ProjectTimeGateway projectTimeGateway = new ProjectTimeGateway(projectTimeTDSForState);
                projectTimeGateway.Update();

                SendMailEmployees(drEmployees);

                projectTimeTDSForState.AcceptChanges();

                Session["projectTimeTDSForState"] = projectTimeTDSForState;
            }
            catch (Exception ex)
            {
                string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' '));
                Response.Redirect(url);
            }
        }