private void PopulateClientAddress()
{
StoneTimeBusiness.TimeEntryFunctions ui = new StoneTimeBusiness.TimeEntryFunctions();
DataTable dt = ui.GetClientAddress(SelectedClientID.ToString());
// populate the address data
if( dt.Rows.Count > 0 )
{
txtAddress1.Text = dt.Rows[0]["address1"].ToString();
txtAddress2.Text = dt.Rows[0]["address2"].ToString();
txtCity.Text = dt.Rows[0]["CITY"].ToString();
txtZip.Text = dt.Rows[0]["zip"].ToString();
// set the state drop down list
ddlClientState.SelectedValue = dt.Rows[0]["state_id"].ToString();
}
else
{
txtAddress1.Text = "";
txtAddress2.Text = "";
txtCity.Text = "";
txtZip.Text = "";
// set the state drop down list
ddlClientState.SelectedValue = "1";
}
}
private void PopulateUserList()
{
DataTable dt = new DataTable();
StoneTimeBusiness.TimeEntryFunctions ui = new StoneTimeBusiness.TimeEntryFunctions();
dt = ui.GetUserList(LoggedInUserID.ToString());
gvUsers.DataSource = dt;
gvUsers.DataBind();
}
private void PopulateStates()
{
StoneTimeBusiness.TimeEntryFunctions ui = new StoneTimeBusiness.TimeEntryFunctions();
DataTable dt = ui.GetStates();
ddlClientState.DataTextField = "ABBREVIATION";
ddlClientState.DataValueField = "STATE_ID";
ddlClientState.DataSource = dt;
ddlClientState.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
StoneTimeBusiness.TimeEntryFunctions ui = new StoneTimeBusiness.TimeEntryFunctions();
DataTable dt = ui.GetClientList();
gvClients.DataSource = dt;
gvClients.DataBind();
}
}
private void PopulateRoles()
{
StoneTimeBusiness.TimeEntryFunctions ui = new StoneTimeBusiness.TimeEntryFunctions();
DataTable dt = ui.GetRoles();
// populate the role dropdown list.
inputRole.DataTextField = "Name";
inputRole.DataValueField = "USER_TYPE_ID";
inputRole.DataSource = dt;
inputRole.DataBind();
}
private void GetPTOGroupTypes()
{
StoneTimeBusiness.TimeEntryFunctions ui = new StoneTimeBusiness.TimeEntryFunctions();
DataTable dt = ui.GetPTOGroupTypes();
// populate the EmployeeType dropdown list.
inputPTOGroup.DataTextField = "PTO_GROUP_NAME";
inputPTOGroup.DataValueField = "PTO_GROUP_ID";
inputPTOGroup.DataSource = dt;
inputPTOGroup.DataBind();
}
private void PopulateClient()
{
StoneTimeBusiness.TimeEntryFunctions ui = new StoneTimeBusiness.TimeEntryFunctions();
if (SelectedClientID > 0)
{
DataTable dt = ui.GetClientData(SelectedClientID.ToString());
txtCompanyName.Text = dt.Rows[0]["COMPANY_NAME"].ToString();
txtWebsite.Text = dt.Rows[0]["company_website"].ToString();
InputClientComment.Text = dt.Rows[0]["comment"].ToString();
PopulateClientAddress();
}
}
private void PopulateUserData(string userId)
{
StoneTimeBusiness.TimeEntryFunctions ui = new StoneTimeBusiness.TimeEntryFunctions();
DataTable dt = ui.GetUserData(userId);
MembershipUser user = Membership.GetUser(dt.Rows[0]["UserName"].ToString());
if (Roles.IsUserInRole(user.UserName, "ADMIN"))
chkAdmin.Checked = true;
else
chkAdmin.Checked = false;
if (Roles.IsUserInRole(user.UserName, "PM"))
chkProjectManager.Checked = true;
else
chkProjectManager.Checked = false;
if (user.IsLockedOut)
{
chkLocked.Visible = true;
chkLocked.Checked = true;
}else{
chkLocked.Visible = false;
chkLocked.Checked = false;
}
PopulateUserTitleList();
PopulateEmployeeStatus();
PopulateUserTypeList();
GetPTOGroupTypes();
PopulateRoles();
//PopulateEmployeeTypeList();
inputFirstName.Text = "";
inputMiddleName.Text = "";
inputLastName.Text = "";
//inputName.Text = dt.Rows[0]["User_Type_ID][
inputUserName.Text = "";
inputPW.Text = "";
inputConfirmPW.Text = "";
if (!userId.Equals("0"))
{
if(dt.Rows[0]["Email"] != null)
inputUserEmail.Text = dt.Rows[0]["Email"].ToString();
//inputFirstName.Text = dt.Rows[0]["First"].ToString()
inputFirstName.Text = dt.Rows[0]["First"].ToString();
if (dt.Rows[0]["Middle"] != null)
{
inputMiddleName.Text = dt.Rows[0]["Middle"].ToString();
}
inputLastName.Text = dt.Rows[0]["Last"].ToString();
//inputName.Text = dt.Rows[0]["User_Type_ID"].ToString()
inputUserName.Text = dt.Rows[0]["UserName"].ToString();
inputPW.Text = dt.Rows[0]["Password"].ToString();
inputConfirmPW.Text = dt.Rows[0]["Password"].ToString();
inputRole.DataValueField = "USER_TYPE_ID";
inputRole.SelectedValue = dt.Rows[0]["USER_TYPE_ID"].ToString();
inputPTOGroup.DataValueField = "PTO_GROUP_ID";
inputPTOGroup.SelectedValue = dt.Rows[0]["PTO_GROUP_ID"].ToString();
ddlEmpStatus.SelectedValue = dt.Rows[0]["STATUS"].ToString();
if (dt.Rows[0]["TITLE_ID"] != null)
{
ddlTitle.SelectedValue = dt.Rows[0]["TITLE_ID"].ToString();
}
else
{
ddlTitle.SelectedIndex = 0;
}
txtTermDate.Text = dt.Rows[0]["TERMINATION_DATE"].ToString();
txtStartDate.Text = Convert.ToDateTime( dt.Rows[0]["START_DATE"].ToString()).ToShortDateString();
if (dt.Rows[0]["EMPLOYEE_TYPE_ID"] == null)
{
}
else
{
inputEmployeeType.DataValueField = "EMPLOYEE_TYPE_ID";
inputEmployeeType.SelectedValue = dt.Rows[0]["EMPLOYEE_TYPE_ID"].ToString();
}
}
else
{
inputFirstName.Text = "";
inputMiddleName.Text = "";
inputLastName.Text = "";
//inputName.Text = ""
inputUserName.Text = "";
inputPW.Text = "";
inputConfirmPW.Text = "";
}
}
private Boolean Save(DataTable dt, Boolean replace)
{
StoneTimeBusiness.TimeEntryFunctions ui = new StoneTimeBusiness.TimeEntryFunctions();
ui.SaveTime(dt, Convert.ToInt16(ddlUserList.SelectedValue), replace);
return true;
}
public int GetUserId(string username)
{
StoneTimeBusiness.TimeEntryFunctions ui = new StoneTimeBusiness.TimeEntryFunctions();
DataTable dt = ui.GetUserInfo(username);
DataRow dr = dt.Rows[0];
int userid = Convert.ToInt16(dr["USER_ID"].ToString());
return userid;
}
private DataTable GetTimeEntryData()
{
DataTable dt = new DataTable();
StoneTimeBusiness.TimeEntryFunctions ui = new StoneTimeBusiness.TimeEntryFunctions();
dt = ui.GetTimeEntryData(MasterDate, base.SelectedUserId);
return dt;
}
protected void Page_Load(object sender, EventArgs e)
{
StoneTimeBusiness.TimeEntryFunctions ui = new StoneTimeBusiness.TimeEntryFunctions();
//Response.Write(ui.GetUserInfo( User.Identity.Name.ToString()));
if (!IsPostBack)
{
PopulateUserList(); // fill User List
Populate();
}
}
private void GetPhasesAndTasks(int ProjectIndex)
{
int intProject = 0;
StoneTimeBusiness.TimeEntryFunctions ui = new StoneTimeBusiness.TimeEntryFunctions();
DataTable dt = new DataTable();
switch (ProjectIndex)
{
case 1:
intProject = Convert.ToInt16(inputProject1.SelectedValue);
if (intProject < 1) return;
inputBillable1.Checked = Opposite(ui.IsGlobalProject(intProject));
dt = ui.GetPhaseListX(SelectedUserId, intProject);
if (dt != null)
{
inputMilestone1.DataSource = dt;
inputMilestone1.DataTextField = "NAME";
inputMilestone1.DataValueField = "PHASE_ID";
inputMilestone1.DataBind();
}
dt = ui.GetTaskList(SelectedUserId.ToString(), intProject);
if (dt != null)
{
inputTask1.DataSource = dt;
inputTask1.DataTextField = "NAME";
inputTask1.DataValueField = "TASK_ID";
inputTask1.DataBind();
}
break;
case 2:
intProject = Convert.ToInt16(inputProject2.SelectedValue);
if (intProject < 1) return;
inputBillable2.Checked = Opposite(ui.IsGlobalProject(intProject));
dt = ui.GetPhaseListX(SelectedUserId, intProject);
if (dt != null)
{
inputMilestone2.DataSource = dt;
inputMilestone2.DataTextField = "NAME";
inputMilestone2.DataValueField = "PHASE_ID";
inputMilestone2.DataBind();
}
dt = ui.GetTaskList(SelectedUserId.ToString(), intProject);
if (dt != null)
{
inputTask2.DataSource = dt;
inputTask2.DataTextField = "NAME";
inputTask2.DataValueField = "TASK_ID";
inputTask2.DataBind();
}
break;
case 3:
intProject = Convert.ToInt16(inputProject3.SelectedValue);
if (intProject < 1) return;
inputBillable3.Checked = Opposite(ui.IsGlobalProject(intProject));
dt = ui.GetPhaseListX(SelectedUserId, intProject);
if (dt != null)
{
inputMilestone3.DataSource = dt;
inputMilestone3.DataTextField = "NAME";
inputMilestone3.DataValueField = "PHASE_ID";
inputMilestone3.DataBind();
}
dt = ui.GetTaskList(SelectedUserId.ToString(), intProject);
if (dt != null)
{
inputTask3.DataSource = dt;
inputTask3.DataTextField = "NAME";
inputTask3.DataValueField = "TASK_ID";
inputTask3.DataBind();
}
break;
case 4:
intProject = Convert.ToInt16(inputProject4.SelectedValue);
if (intProject < 1) return;
inputBillable4.Checked = Opposite(ui.IsGlobalProject(intProject));
dt = ui.GetPhaseListX(SelectedUserId, intProject);
if (dt != null)
{
inputMilestone4.DataSource = dt;
inputMilestone4.DataTextField = "NAME";
inputMilestone4.DataValueField = "PHASE_ID";
inputMilestone4.DataBind();
}
dt = ui.GetTaskList(SelectedUserId.ToString(), intProject);
if (dt != null)
{
inputTask4.DataSource = dt;
inputTask4.DataTextField = "NAME";
inputTask4.DataValueField = "TASK_ID";
inputTask4.DataBind();
}
break;
case 5:
intProject = Convert.ToInt16(inputProject5.SelectedValue);
if (intProject < 1) return;
inputBillable5.Checked = Opposite(ui.IsGlobalProject(intProject));
dt = ui.GetPhaseListX(SelectedUserId, intProject);
if (dt != null)
{
inputMilestone5.DataSource = dt;
inputMilestone5.DataTextField = "NAME";
inputMilestone5.DataValueField = "PHASE_ID";
inputMilestone5.DataBind();
}
dt = ui.GetTaskList(SelectedUserId.ToString(), intProject);
if (dt != null)
{
inputTask5.DataSource = dt;
inputTask5.DataTextField = "NAME";
inputTask5.DataValueField = "TASK_ID";
inputTask5.DataBind();
}
break;
}
}
protected void gvTime_Updating(Object sender, GridViewUpdateEventArgs e)
{
int projectId = 0;
int taskId = 0;
int phaseId = 0;
int billable = 0;
if (e.Keys["Billable"].ToString().Equals("True"))
{
billable = 1;
}
taskId = Convert.ToInt16(e.Keys["Task"].ToString());
projectId = Convert.ToInt16(e.Keys["Project"].ToString());
phaseId = Convert.ToInt16(e.Keys["Milestone"].ToString());
GridView gv = (GridView)sender;
HiddenField omon = (HiddenField)gv.Rows[e.RowIndex].FindControl("hidMon");
HiddenField omonDesc = (HiddenField)gv.Rows[e.RowIndex].FindControl("hidMonDesc");
HiddenField otue = (HiddenField)gv.Rows[e.RowIndex].FindControl("hidTue");
HiddenField otueDesc = (HiddenField)gv.Rows[e.RowIndex].FindControl("hidTueDesc");
HiddenField owed = (HiddenField)gv.Rows[e.RowIndex].FindControl("hidWed");
HiddenField owedDesc = (HiddenField)gv.Rows[e.RowIndex].FindControl("hidWedDesc");
HiddenField othr = (HiddenField)gv.Rows[e.RowIndex].FindControl("hidThr");
HiddenField othrDesc = (HiddenField)gv.Rows[e.RowIndex].FindControl("hidThrDesc");
HiddenField ofri = (HiddenField)gv.Rows[e.RowIndex].FindControl("hidFri");
HiddenField ofriDesc = (HiddenField)gv.Rows[e.RowIndex].FindControl("hidFriDesc");
HiddenField osat = (HiddenField)gv.Rows[e.RowIndex].FindControl("hidSat");
HiddenField osatDesc = (HiddenField)gv.Rows[e.RowIndex].FindControl("hidSatDesc");
HiddenField osun = (HiddenField)gv.Rows[e.RowIndex].FindControl("hidSun");
HiddenField osunDesc = (HiddenField)gv.Rows[e.RowIndex].FindControl("hidSunDesc");
TextBox mon = (TextBox)gv.Rows[e.RowIndex].FindControl("Monday");
TextBox monDesc = (TextBox)gv.Rows[e.RowIndex].FindControl("editMonDescription");
TextBox tue = (TextBox)gv.Rows[e.RowIndex].FindControl("Tuesday");
TextBox tueDesc = (TextBox)gv.Rows[e.RowIndex].FindControl("editTuesDescription");
TextBox wed = (TextBox)gv.Rows[e.RowIndex].FindControl("Wednesday");
TextBox wedDesc = (TextBox)gv.Rows[e.RowIndex].FindControl("editWedDescription");
TextBox thr = (TextBox)gv.Rows[e.RowIndex].FindControl("Thursday");
TextBox thrDesc = (TextBox)gv.Rows[e.RowIndex].FindControl("editThursDescription");
TextBox fri = (TextBox)gv.Rows[e.RowIndex].FindControl("Friday");
TextBox friDesc = (TextBox)gv.Rows[e.RowIndex].FindControl("editFriDescription");
TextBox sat = (TextBox)gv.Rows[e.RowIndex].FindControl("Saturday");
TextBox satDesc = (TextBox)gv.Rows[e.RowIndex].FindControl("editSatDescription");
TextBox sun = (TextBox)gv.Rows[e.RowIndex].FindControl("Sunday");
TextBox sunDesc = (TextBox)gv.Rows[e.RowIndex].FindControl("editSunDescription");
StoneTimeBusiness.TimeEntryFunctions ui = new StoneTimeBusiness.TimeEntryFunctions();
//ui.DeleteUserTime(projectId, taskId, phaseId, Convert.ToBoolean(billable), SelectedUserId);
DataTable dt = GetTimeTableSchema();
// if the hours change or the hours are greater than zero and the description changes then update.
if ((!GetNumericValue(mon.Text).Equals(GetNumericValue(omon.Value))) || (GetNumericValue(mon.Text)>0 && !monDesc.Text.Equals(omonDesc.Value)))
{
DataRow dr = dt.NewRow();
dr["ID"] = 0;
dr["Date"] = MasterDate;
dr["Project"] = projectId;
dr["Milestone"] = phaseId;
dr["Task"] = taskId;
dr["Person"] = ddlUserList.SelectedValue;
dr["Duration"] = mon.Text;
dr["Billable"] = billable;
dr["Description"] = monDesc.Text;
dt.Rows.Add(dr);
}
if ((!GetNumericValue(tue.Text).Equals(GetNumericValue(otue.Value))) || (GetNumericValue(tue.Text)>0 && !tueDesc.Text.Equals(otueDesc.Value)))
{
DataRow dr = dt.NewRow();
dr["ID"] = 0;
dr["Date"] = MasterDate.AddDays(1);
dr["Project"] = projectId;
dr["Milestone"] = phaseId;
dr["Task"] = taskId;
dr["Person"] = ddlUserList.SelectedValue;
dr["Duration"] = tue.Text;
dr["Billable"] = billable;
dr["Description"] = tueDesc.Text;
dt.Rows.Add(dr);
}
if ((!GetNumericValue(wed.Text).Equals(GetNumericValue(owed.Value))) || (GetNumericValue(wed.Text) > 0 && !wedDesc.Text.Equals(owedDesc.Value)))
{
DataRow dr = dt.NewRow();
dr["ID"] = 0;
dr["Date"] = MasterDate.AddDays(2);
dr["Project"] = projectId;
dr["Milestone"] = phaseId;
dr["Task"] = taskId;
dr["Person"] = ddlUserList.SelectedValue;
dr["Duration"] = wed.Text;
dr["Billable"] = billable;
dr["Description"] = wedDesc.Text;
dt.Rows.Add(dr);
}
if ((!GetNumericValue(thr.Text).Equals(GetNumericValue(othr.Value))) || (GetNumericValue(thr.Text) > 0 && !thrDesc.Text.Equals(othrDesc.Value)))
{
DataRow dr = dt.NewRow();
dr["ID"] = 0;
dr["Date"] = MasterDate.AddDays(3);
dr["Project"] = projectId;
dr["Milestone"] = phaseId;
dr["Task"] = taskId;
dr["Person"] = ddlUserList.SelectedValue;
dr["Duration"] = thr.Text;
dr["Billable"] = billable;
dr["Description"] = thrDesc.Text;
dt.Rows.Add(dr);
}
if ((!GetNumericValue(fri.Text).Equals(GetNumericValue(ofri.Value))) || (GetNumericValue(fri.Text) > 0 && !friDesc.Text.Equals(ofriDesc.Value)))
{
DataRow dr = dt.NewRow();
dr["ID"] = 0;
dr["Date"] = MasterDate.AddDays(4);
dr["Project"] = projectId;
dr["Milestone"] = phaseId;
dr["Task"] = taskId;
dr["Person"] = ddlUserList.SelectedValue;
dr["Duration"] = fri.Text;
dr["Billable"] = billable;
dr["Description"] = friDesc.Text;
dt.Rows.Add(dr);
}
if ((!GetNumericValue(sat.Text).Equals(GetNumericValue(osat.Value))) || (GetNumericValue(sat.Text)>0 && !satDesc.Text.Equals(osatDesc.Value)))
{
DataRow dr = dt.NewRow();
dr["ID"] = 0;
dr["Date"] = MasterDate.AddDays(5);
dr["Project"] = projectId;
dr["Milestone"] = phaseId;
dr["Task"] = taskId;
dr["Person"] = ddlUserList.SelectedValue;
dr["Duration"] = sat.Text;
dr["Billable"] = billable;
dr["Description"] = satDesc.Text;
dt.Rows.Add(dr);
}
if ((!GetNumericValue(sun.Text).Equals(GetNumericValue(osun.Value))) || (GetNumericValue(sun.Text) > 0 && !sunDesc.Text.Equals(osunDesc.Value)))
{
DataRow dr = dt.NewRow();
dr["ID"] = 0;
dr["Date"] = MasterDate.AddDays(6);
dr["Project"] = projectId;
dr["Milestone"] = phaseId;
dr["Task"] = taskId;
dr["Person"] = ddlUserList.SelectedValue;
dr["Duration"] = sun.Text;
dr["Billable"] = billable;
dr["Description"] = sunDesc.Text;
dt.Rows.Add(dr);
}
Save(dt,true);
gvTime.EditIndex = -1;
PopulateDataGrid();
}
protected void inputProject5_SelectedIndexChanged(object sender, EventArgs e)
{
StoneTimeBusiness.TimeEntryFunctions ui = new StoneTimeBusiness.TimeEntryFunctions();
int intProject = 0;
intProject = Convert.ToInt16(inputProject5.SelectedValue);
if (intProject < 1) return;
inputBillable5.Checked = Opposite(ui.IsGlobalProject(intProject));
DataTable dt = new DataTable();
dt = ui.GetPhaseListX(SelectedUserId, intProject);
if (dt != null)
{
inputMilestone5.DataSource = dt;
inputMilestone5.DataTextField = "NAME";
inputMilestone5.DataValueField = "PHASE_ID";
inputMilestone5.DataBind();
//inputMilestone5.SelectedValue = 0
}
dt = ui.GetTaskList(SelectedUserId.ToString(), intProject);
if (dt != null)
{
inputTask5.DataSource = dt;
inputTask5.DataTextField = "NAME";
inputTask5.DataValueField = "TASK_ID";
inputTask5.DataBind();
//inputTask5.SelectedValue = 0;
}
}
private void Save()
{
string userid = SelectedUserId.ToString();
string userName = inputUserName.Text.Trim();
if (userid.Equals("0"))
{
userid = string.Empty;
MembershipUser user = Membership.CreateUser(inputUserName.Text, inputPW.Text, inputUserEmail.Text);
RoleManagerModule roleManager = new RoleManagerModule();
Roles.AddUserToRole(userName, "USER");
if(chkAdmin.Checked==true)
Roles.AddUserToRole(userName, "ADMIN");
if(chkProjectManager.Checked==true)
Roles.AddUserToRole(userName, "PM");
inputUserName.Enabled = true;
}
else
{
MembershipUser user = Membership.GetUser(userName);
if (chkAdmin.Checked == true)
{
if (!Roles.IsUserInRole(userName, "ADMIN"))
Roles.AddUserToRole(userName, "ADMIN");
}
else
{
if (Roles.IsUserInRole(userName, "ADMIN"))
Roles.RemoveUserFromRole(userName, "ADMIN");
}
if (chkProjectManager.Checked == true)
{
if (!Roles.IsUserInRole(userName, "PM"))
Roles.AddUserToRole(userName, "PM");
}
else
{
if (Roles.IsUserInRole(userName, "PM"))
Roles.RemoveUserFromRole(userName, "PM");
}
inputUserName.Enabled = false;
}
StoneTimeBusiness.TimeEntryFunctions ui = new StoneTimeBusiness.TimeEntryFunctions();
ui.SaveUser(userid, inputFirstName.Text, inputLastName.Text, inputMiddleName.Text,
inputRole.SelectedValue, inputEmployeeType.SelectedValue, ddlEmpStatus.SelectedValue,
inputPW.Text, inputUserName.Text,
txtStartDate.Text, txtTermDate.Text,
ddlTitle.SelectedValue,inputPTOGroup.SelectedValue,inputUserEmail.Text );
}
private void Populate()
{
if (SelectedUserId.Equals(0)) SelectedUserId = LoggedInUserID;
PopulateDateRanges(); // Fill "Week of" dropdown listbox
PopulateDataGrid(); // Fill Existing Timerecord datagrid
int strUser = SelectedUserId;
StoneTimeBusiness.TimeEntryFunctions ui = new StoneTimeBusiness.TimeEntryFunctions();
DataTable dtPto = ui.GetPTOAvailable(SelectedUserId);
if (dtPto.Rows.Count > 0)
{
lblPTOAvailable.Text = dtPto.Rows[0][0].ToString();
}
DataTable dtProjects = new DataTable();
dtProjects = ui.GetProjectListX(strUser);
DataRow dr;
dr = dtProjects.NewRow();
dr["PROJECT_ID"] = 0;
dr["PROJECT_NAME"] = "--SELECT--";
dtProjects.Rows.InsertAt(dr, 0);
inputProject1.DataSource = dtProjects;
inputProject1.DataTextField = "PROJECT_NAME";
inputProject1.DataValueField = "PROJECT_ID";
inputProject1.DataBind();
inputProject2.DataSource = dtProjects;
inputProject2.DataTextField = "PROJECT_NAME";
inputProject2.DataValueField = "PROJECT_ID";
inputProject2.DataBind();
inputProject3.DataSource = dtProjects;
inputProject3.DataTextField = "PROJECT_NAME";
inputProject3.DataValueField = "PROJECT_ID";
inputProject3.DataBind();
inputProject4.DataSource = dtProjects;
inputProject4.DataTextField = "PROJECT_NAME";
inputProject4.DataValueField = "PROJECT_ID";
inputProject4.DataBind();
inputProject5.DataSource = dtProjects;
inputProject5.DataTextField = "PROJECT_NAME";
inputProject5.DataValueField = "PROJECT_ID";
inputProject5.DataBind();
//// phases
////StoneTimeBusiness.TimeEntryFunctions ui= new StoneTimeBusiness.TimeEntryFunctions();
//DataTable dtPhases = new DataTable();
//// insert blank row
//dtPhases = ui.GetPhaseList(strUser);
//if (dtPhases == null)
//{ }
//else
//{
// dr = dtPhases.NewRow();
// dr["PHASE_ID"] = 0;
// dr["NAME"] = "--SELECT--";
// dtPhases.Rows.InsertAt(dr, 0);
// inputMilestone1.DataSource = dtPhases;
// inputMilestone1.DataTextField = "NAME";
// inputMilestone1.DataValueField = "PHASE_ID";
// inputMilestone1.DataBind();
// inputMilestone2.DataSource = dtPhases;
// inputMilestone2.DataTextField = "NAME";
// inputMilestone2.DataValueField = "PHASE_ID";
// inputMilestone2.DataBind();
// inputMilestone3.DataSource = dtPhases;
// inputMilestone3.DataTextField = "NAME";
// inputMilestone3.DataValueField = "PHASE_ID";
// inputMilestone3.DataBind();
// inputMilestone4.DataSource = dtPhases;
// inputMilestone4.DataTextField = "NAME";
// inputMilestone4.DataValueField = "PHASE_ID";
// inputMilestone4.DataBind();
// inputMilestone5.DataSource = dtPhases;
// inputMilestone5.DataTextField = "NAME";
// inputMilestone5.DataValueField = "PHASE_ID";
// inputMilestone5.DataBind();
//}
//// tasks
//DataTable dtTasks = new DataTable();
//// insert blank row
//dtTasks = ui.GetTaskList(strUser.ToString());
//if (dtTasks == null)
//{ }
//else
//{
// dr = dtTasks.NewRow();
// dr["TASK_ID"] = 0;
// dr["NAME"] = "--SELECT--";
// dtTasks.Rows.InsertAt(dr, 0);
// inputTask1.DataSource = dtTasks;
// inputTask1.DataTextField = "NAME";
// inputTask1.DataValueField = "TASK_ID";
// inputTask1.DataBind();
// inputTask2.DataSource = dtTasks;
// inputTask2.DataTextField = "NAME";
// inputTask2.DataValueField = "TASK_ID";
// inputTask2.DataBind();
// inputTask3.DataSource = dtTasks;
// inputTask3.DataTextField = "NAME";
// inputTask3.DataValueField = "TASK_ID";
// inputTask3.DataBind();
// inputTask4.DataSource = dtTasks;
// inputTask4.DataTextField = "NAME";
// inputTask4.DataValueField = "TASK_ID";
// inputTask4.DataBind();
// inputTask5.DataSource = dtTasks;
// inputTask5.DataTextField = "NAME";
// inputTask5.DataValueField = "TASK_ID";
// inputTask5.DataBind();
//}
PreloadRecentProjects(SelectedUserId.ToString());
// is the date range being displayed going to be "savable"?
// if not, disable the save button and time datagrid
LockData();
}
private void PreloadRecentProjects(string strUser)
{
// SET MOST RECENT PROJECTS AS DEFAULT
DataTable dtSelected = new DataTable();
StoneTimeBusiness.TimeEntryFunctions ui = new StoneTimeBusiness.TimeEntryFunctions();
dtSelected = ui.GetMostRecentProjects(Convert.ToInt16(strUser));
if (dtSelected != null)
{
if (dtSelected.Rows.Count > 0)
{
if (dtSelected.Rows[0][1] != null)
{
inputProject1.SelectedValue = dtSelected.Rows[0][1].ToString();
GetPhasesAndTasks(1);
if (dtSelected.Rows.Count > 1)
{
if (dtSelected.Rows[1][1] != null)
{
inputProject2.SelectedValue = dtSelected.Rows[1][1].ToString();
GetPhasesAndTasks(2);
if (dtSelected.Rows.Count > 2)
{
if (dtSelected.Rows[1][1] != null)
{
inputProject3.SelectedValue = dtSelected.Rows[2][1].ToString();
GetPhasesAndTasks(3);
if (dtSelected.Rows.Count > 3)
{
if (dtSelected.Rows[2][1] != null)
{
inputProject4.SelectedValue = dtSelected.Rows[3][1].ToString();
GetPhasesAndTasks(4);
if (dtSelected.Rows.Count > 4)
{
if (dtSelected.Rows[3][1] != null)
{
inputProject5.SelectedValue = dtSelected.Rows[4][1].ToString();
GetPhasesAndTasks(5);
}
}
}
}
}
}
}
}
}
}
}
}
private void PopulateUserList()
{
DataTable dt = new DataTable();
StoneTimeBusiness.TimeEntryFunctions ui = new StoneTimeBusiness.TimeEntryFunctions();
dt = ui.GetUserList(LoggedInUserID.ToString());
// // populate the user list.
ddlUserList.DataValueField = "USER_ID";
ddlUserList.DataTextField = "USERNAME";
ddlUserList.DataSource = dt;
ddlUserList.DataBind();
// Dim SELECTEDUSERID As Integer = Session("SELECTEDUSERID")
// ddlUserList.SelectedValue = SELECTEDUSERID
}
private void PopulateDataGrid()
{
// get the data from database
DataTable dtData = new DataTable();
dtData = GetTimeEntryData();
DataTable dt = GetTimeTableSchema();
Boolean bNew = false;
StoneTimeBusiness.TimeEntryFunctions ui = new StoneTimeBusiness.TimeEntryFunctions();
string strUser = SelectedUserId.ToString();
int ItemIndex = 0; // to hold the project or task or phase id
string ItemName = string.Empty; // item//s name
foreach (DataRow drData in dtData.Rows)
{
DataRow dr;
// Determine if there is a row already for the Key: Project+Phase+Task+Billable
DataRow[] drA;
string strKey = drData["PROJECT_ID"] + "," + drData["PHASE_ID"] + "," + drData["TASK_ID"] + "," + drData["BILLABLE"];
// ok... the next select statement is not working... we are getting duplicate records coming thru
Boolean billable = false;
if (drData["BILLABLE"] == DBNull.Value)
{
billable = false;
}
else
{
billable = Convert.ToBoolean(drData["BILLABLE"]);
}
drA = dt.Select("PROJECT = " + drData["PROJECT_ID"] + " AND MILESTONE = " + drData["PHASE_ID"] + " AND TASK = " + drData["TASK_ID"] + " AND BILLABLE = " + billable.ToString());
// I am adding code to loop through and check each one...
dr = dt.NewRow();
//Boolean exists = false;
//DataRow[] drAdt;
//drAdt=
decimal oHours = Convert.ToDecimal(drData["HOURS"]);
//decimal nhours = Convert.ToDecimal(dr["HOURS"]);
//decimal oTotal = Convert.ToDecimal(drData["TOTAL"]);
decimal nTotal = 0;// Convert.ToDecimal(dr["TOTAL"]);
//decimal nMonday = 0;
//if (drData["MONDAY"] != DBNull.Value) Convert.ToDecimal(drData["MONDAY"]);
//decimal nTuesday = 0;
//if (drData["TUESDAY"] != DBNull.Value) Convert.ToDecimal(drData["TUESDAY"]);
//decimal nWednesday = 0;
//if (drData["WEDNESDAY"] != DBNull.Value) Convert.ToDecimal(drData["WEDNESDAY"]);
//decimal nThursday = 0;
//if (drData["THURSDAY"] != DBNull.Value) Convert.ToDecimal(drData["THURSDAY"]);
//decimal nFriday = 0;
//if (drData["FRIDAY"] != DBNull.Value) Convert.ToDecimal(drData["FRIDAY"]);
//decimal nSaturday = 0;
//if (drData["SATURDAY"] != DBNull.Value) Convert.ToDecimal(drData["SATURDAY"]);
//decimal nSunday = 0;
//if (drData["SUNDAY"] != DBNull.Value) Convert.ToDecimal(drData["SUNDAY"]);
if (drA.GetLength(0) > 0)
{
// the Key already exists in the table. Use this row.
dr = drA[0];
bNew = false;
}
else
{
// the Key was not found. Create a new row
dr = dt.NewRow();
dr["ID"] = strKey;
if (drData["BILLABLE"] == DBNull.Value)
{
dr["BILLABLE"] = false;
}
else
{
dr["BILLABLE"] = Convert.ToBoolean(drData["BILLABLE"]);
}
dr["DURATION"] = oHours;
ItemIndex = Convert.ToInt16(drData["TASK_ID"]);
ItemName = ui.GetTaskName(ItemIndex, strUser);
dr["TASK"] = drData["TASK_ID"];
dr["TASKNAME"] = ItemName;
ItemIndex = Convert.ToInt16(drData["PHASE_ID"]);
ItemName = ui.GetPhaseName(ItemIndex, strUser);
dr["MILESTONE"] = drData["PHASE_ID"];
dr["PHASENAME"] = ItemName;
ItemIndex = Convert.ToInt16(drData["PROJECT_ID"]);
ItemName = ui.GetProjectName(ItemIndex, strUser);
dr["PROJECT"] = ItemIndex;
dr["PROJECTNAME"] = ItemName;
dr["PERSON"] = drData["USER_ID"];
dr["TOTAL"] = 0;
bNew = true;
}
decimal oMonday = 0;
if (dr["MONDAY"] != DBNull.Value) oMonday = Convert.ToDecimal(dr["MONDAY"]);
decimal oTuesday = 0;
if (dr["TUESDAY"] != DBNull.Value) oTuesday = Convert.ToDecimal(dr["TUESDAY"]);
decimal oWednesday = 0;
if (dr["WEDNESDAY"] != DBNull.Value) oWednesday = Convert.ToDecimal(dr["WEDNESDAY"]);
decimal oThursday = 0;
if (dr["THURSDAY"] != DBNull.Value) oThursday = Convert.ToDecimal(dr["THURSDAY"]);
decimal oFriday = 0;
if (dr["FRIDAY"] != DBNull.Value) oFriday = Convert.ToDecimal(dr["FRIDAY"]);
decimal oSaturday = 0;
if (dr["SATURDAY"] != DBNull.Value) oSaturday = Convert.ToDecimal(dr["SATURDAY"]);
decimal oSunday = 0;
if (dr["SUNDAY"] != DBNull.Value) oSunday = Convert.ToDecimal(dr["SUNDAY"]);
DateTime dtDate = Convert.ToDateTime(drData["BILL_DATE"].ToString()); //strip time??
int Difference = 0;
DateTime dtA = MasterDate; //strip time??
Difference = dtDate.Subtract(dtA).Days;
if (oHours > 0)
{
switch (Difference)
{
case 0:
{
if (oMonday == 0)
{
dr["Monday"] = oHours;
dr["MonDescription"] = drData["DESCRIPTION"];
}
else
{
dr["Monday"] = oMonday + oHours;
}
nTotal = oMonday + nTotal;
MonTotal = MonTotal + oHours;
WeekTotal = WeekTotal + oHours;
break;
}
case 1:
{
if (oTuesday == 0)
{
dr["Tuesday"] = oHours;
dr["TuesDescription"] = drData["DESCRIPTION"];
}
else
{
dr["Tuesday"] = oTuesday + oHours;
}
nTotal = oTuesday + nTotal;
TueTotal = TueTotal + oHours;
WeekTotal = WeekTotal + oHours;
break;
}
case 2:
{
if (oWednesday == 0)
{
dr["Wednesday"] = oHours;
// 10/
dr["WedDescription"] = drData["DESCRIPTION"];
}
else
{
dr["Wednesday"] = oWednesday + oHours;
}
nTotal = oWednesday + nTotal;
WedTotal = WedTotal + oHours;
WeekTotal = WeekTotal + oHours;
break;
}
case 3:
{
if (oThursday == 0)
{
dr["Thursday"] = oHours;
dr["ThursDescription"] = drData["DESCRIPTION"];
}
else
{
dr["Thursday"] = oThursday + oHours;
}
nTotal = oThursday + nTotal;
ThrTotal = ThrTotal + oHours;
WeekTotal = WeekTotal + oHours;
break;
}
case 4:
{
if (oFriday == 0)
{
dr["Friday"] = oHours;
dr["FriDescription"] = drData["DESCRIPTION"];
}
else
{
dr["Friday"] = oFriday + oHours;
}
nTotal = oFriday + nTotal;
FriTotal = FriTotal + oHours;
WeekTotal = WeekTotal + oHours;
break;
}
case 5:
{
if (oSaturday == 0)
{
dr["Saturday"] = oHours;
dr["SatDescription"] = drData["DESCRIPTION"];
}
else
{
dr["Saturday"] = oSaturday + oHours;
}
dr["Total"] = oSaturday + nTotal;
SatTotal = SatTotal + oHours;
WeekTotal = WeekTotal + oHours;
break;
}
case 6:
{
if (oSunday == 0)
{
dr["Sunday"] = oHours;
dr["SunDescription"] = drData["DESCRIPTION"];
}
else
{
dr["Sunday"] = oSunday + oHours;
}
nTotal = oSunday + nTotal;
SunTotal = SunTotal + oHours;
WeekTotal = WeekTotal + oHours;
break;
}
}
}
else
{
bNew = false;
}
if (bNew == true)
{
dt.Rows.Add(dr);
}
}
dt.AcceptChanges();
gvTime.DataSource = dt;
gvTime.DataBind();
if (Locked(MasterDate))
{
gvTime.Enabled = false;
}
else
{
gvTime.Enabled = true;
}
//ViewState["MonTotal"] = MonTotal;
//VeiwState["TueTotal"] = TueTotal;
//VeiwState["WedTotal"] = WedTotal;
//VeiwState["ThrTotal"] = ThrTotal;
//VeiwState["FriTotal"] = FriTotal;
//VeiwState["SatTotal"] = SatTotal;
//VeiwState["SunTotal"] = SunTotal;
}
protected void gvTime_Delete(Object sender, GridViewDeleteEventArgs e)
{
int projectId = 0;
int taskId = 0;
int phaseId = 0;
int billable = 0;
if (e.Keys["Billable"].ToString().Equals("True"))
{
billable = 1;
}
taskId = Convert.ToInt16(e.Keys["Task"].ToString());
projectId = Convert.ToInt16(e.Keys["Project"].ToString());
phaseId = Convert.ToInt16(e.Keys["Milestone"].ToString());
StoneTimeBusiness.TimeEntryFunctions ui = new StoneTimeBusiness.TimeEntryFunctions();
ui.DeleteUserTime(projectId, taskId, phaseId, Convert.ToBoolean(billable), SelectedUserId);
PopulateDataGrid();
}
private void PopulateUserTypeList()
{
StoneTimeBusiness.TimeEntryFunctions ui = new StoneTimeBusiness.TimeEntryFunctions();
DataTable dt = ui.GetTerms("EmployeeType");
// populate the EmployeeType dropdown list.
inputEmployeeType.DataTextField = "DisplayLabel";
inputEmployeeType.DataValueField = "ID";
inputEmployeeType.DataSource = dt;
inputEmployeeType.DataBind();
}
