public string FormatText(object objval) { string StrReturn = ""; try { CustomFacade objCustomFacade = new CustomFacade(); string UserID = Convert.ToString(objval); StrReturn = objCustomFacade.GetRoleDetailsBYUserId(UserID); } catch (Exception ex) { } return StrReturn; }
void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { if ((Page.User.IsInRole("ProjectAdministrator") || Page.User.IsInRole("ProjectManager"))) { UserList.DataSourceID = "ProjectMembers"; //if (Page.User.ToString() != null && Page.User.ToString() != "") //{ // UserList.SelectedValue = Page.User.ToString(); //} //UserList.SelectedValue= if (Page.User.IsInRole("ProjectAdministrator")) { ProjectData.SortParameterName = "sortParameter"; ProjectData.SelectMethod = "GetAllProjects"; divTimeSheet.Visible = false; AllProjectList.DataBind(); ListItem select = new ListItem("Select", "0"); if (AllProjectList.Items.Contains(select).ToString() != "True") { AllProjectList.Items.Insert(0, new ListItem("Select All", "0")); } UserList.DataBind(); ProjectList.Items.Insert(0, new ListItem("Select", "0")); admin.Attributes.Add("style","width:0px;"); admin.Visible = false; } else if (Page.User.IsInRole("ProjectManager")) { ProjectData.SelectParameters.Add(new Parameter("userName", TypeCode.String, Page.User.Identity.Name)); ProjectData.SelectMethod = "GetProjectsByUserName"; SQLDataAccess objSQLDataAccess = new SQLDataAccess(); List<Category> objCategorylist = objSQLDataAccess.GetCategoriesByUserName(Convert.ToString("")); CategoryList.DataSource = objCategorylist; CategoryList.DataTextField = "Name"; CategoryList.DataValueField = "Id"; //CategoryList.DA =Convert.ToString(objCategorylist[0].Name); //CategoryList.SelectedValue = Convert.ToString(objCategorylist[0].Id); CategoryList.DataBind(); AllProjectList.DataBind(); ListItem select = new ListItem("Select", "0"); if (AllProjectList.Items.Contains(select).ToString() != "True") { AllProjectList.Items.Insert(0, new ListItem("Select All", "0")); } UserList.DataBind(); UserList.Items.Insert(0, new ListItem("Select", "0")); //ProjectList.Items.Insert(0, new ListItem("Select", "0")); } } else if (Page.User.IsInRole("TeamLeader")) { ProjectData.SelectParameters.Add(new Parameter("userName", TypeCode.String, Page.User.Identity.Name)); ProjectData.SelectMethod = "GetProjectsByUserName"; UserList.Items.Add(Page.User.Identity.Name); SQLDataAccess objSQLDataAccess = new SQLDataAccess(); List<Category> objCategorylist = objSQLDataAccess.GetCategoriesByUserName(Convert.ToString(Page.User.Identity.Name)); CategoryList.DataSource = objCategorylist; CategoryList.DataTextField = "Name"; CategoryList.DataValueField = "Id"; //CategoryList.DA =Convert.ToString(objCategorylist[0].Name); //CategoryList.SelectedValue = Convert.ToString(objCategorylist[0].Id); CategoryList.DataBind(); AllProjectList.DataBind(); ListItem select = new ListItem("Select", "0"); if (AllProjectList.Items.Contains(select).ToString() != "True") { AllProjectList.Items.Insert(0, new ListItem("Select All", "0")); } // ProjectList.Items.Insert(0, new ListItem("Select", "0")); / } else { ProjectData.SelectParameters.Add(new Parameter("userName", TypeCode.String, Page.User.Identity.Name)); ProjectData.SelectMethod = "GetProjectsByUserName"; CustomFacade objCustomFacade = new CustomFacade(); List<Project> listProject = new List<Project>(); //listProject = objCustomFacade.GetProjectsByUserName(Page.User.Identity.Name); UserList.Items.Add(Page.User.Identity.Name); //UserList.Items.Insert(0, new ListItem("Select", "0")); SQLDataAccess objSQLDataAccess = new SQLDataAccess(); List<Category> objCategorylist = objSQLDataAccess.GetCategoriesByUserName(Convert.ToString(Page.User.Identity.Name)); CategoryList.DataSource = objCategorylist; CategoryList.DataTextField = "Name"; CategoryList.DataValueField = "Id"; //CategoryList.DA =Convert.ToString(objCategorylist[0].Name); //CategoryList.SelectedValue = Convert.ToString(objCategorylist[0].Id); CategoryList.DataBind(); AllProjectList.DataBind(); ListItem select = new ListItem("Select", "0"); if (AllProjectList.Items.Contains(select).ToString() != "True") { AllProjectList.Items.Insert(0, new ListItem("Select All", "0")); } //ProjectList.Items.Insert(0, new ListItem("Select", "0")); } username.Text = "Welcome: " + Session["username"]; ProjectList.DataBind(); //ProjectList.Items.Insert(0, new ListItem("Select", "0")); //if (ProjectList.SelectedValue != "0" && ProjectList.SelectedValue != "") //{ // if (Session["username"] != null && Session["username"] != "") // { // UserList.SelectedItem.Text = Convert.ToString(Session["username"]); // } //} //if (ProjectListGridView.Rows.Count==0) //{ // lblexport.Visible =false; // lnkexport.Visible = false; //} if (ProjectList.Items.Count >= 1) { TimeEntryView.Visible = true; MessageView.Visible = false; } else { TimeEntryView.Visible = true; MessageView.Visible = false; } StartDate.Text = DateTime.Now.Date.AddDays(-7).ToShortDateString(); EndDate.Text = DateTime.Now.ToShortDateString(); ProjectListGridView.DataBind(); } if (UserList.Items.Count == 0) { AddEntry.Enabled = false; } }
public static List<UserTotalDurationReport> GetUserReportsByUserNamesAndMonthAndyear(string userNames, int Month, int Year,string ProjectId) { if (String.IsNullOrEmpty(userNames)) return (new List<UserTotalDurationReport>()); char[] separator = new char[] { ',' }; string[] substrings = userNames.Split(separator); //string[] substringProject = ProjectId.Split(separator); List<UserTotalDurationReport> list = new List<UserTotalDurationReport>(); if (ProjectId != null && ProjectId!="0") { if (ProjectId.Length > 0) { ProjectId = ProjectId.Trim().Substring(0, ProjectId.Length - 1); } } foreach (string str in substrings) { if (ProjectId=="0") { CustomFacade ObjCustomFacade = new CustomFacade(); List<Project> objlstProject = new List<Project>(); objlstProject = ObjCustomFacade.GetProjectDetailsByUserDetails(Convert.ToString(str)); if (objlstProject.Count > 0) { for (int i = 0; i < objlstProject.Count; i++) { if (ProjectId == "") { ProjectId = ProjectId + "," + Convert.ToString(objlstProject[i].Id); } else { ProjectId = Convert.ToString(objlstProject[i].Id); } } } } if (!string.IsNullOrEmpty(str)) { //foreach (var item in substringProject) //{ // if (!string.IsNullOrEmpty(item)) // { List<UserTotalDurationReport> tempList = UserTotalDurationReport.GetUserReportsByUserNameAndMonthAndyear(str, Month, Year, ProjectId); foreach (UserTotalDurationReport userReport in tempList) { list.Add(userReport); } // } //} } } return list; }
private void BindClientDeatails() { try { List<Project> lstProjectDetails = new List<Project>(); CustomFacade objCustomFacade = new CustomFacade(); lstProjectDetails = objCustomFacade.GetClientDeatils(); if (lstProjectDetails.Count > 0) { ddlClientName.DataSource = lstProjectDetails; ddlClientName.DataTextField = "Name"; ddlClientName.DataValueField = "Id"; ddlClientName.DataBind(); } ddlClientName.Items.Insert(0, new ListItem("Select", "0")); ddlClientName.SelectedValue = "0"; } catch (Exception) { } }
protected void SaveButton_Click(object obj, EventArgs args) { if (Page.IsValid == false) return; Project newProject; if (CurrentProject != null) { newProject = Project.GetProjectById(CurrentProject.Id); } else { newProject = new Project(Page.User.Identity.Name, Page.User.Identity.Name, ProjectName.Text); } try { CustomFacade objCustomFacade = new CustomFacade(); newProject.ClientName = Convert.ToString(ddlClientName.SelectedValue); newProject.Name = ProjectName.Text; newProject.CompletionDate = Convert.ToDateTime(EstimatedDate.Text); newProject.Description = Description.Text; newProject.DevelopmentEstimateDuration = Convert.ToDecimal(txtDevHours.Text); newProject.TestingEstimateDuration = Convert.ToDecimal(txtTestingHrs.Text); newProject.DesignEstimateDuration = Convert.ToDecimal(txtDesignHrs.Text); newProject.BAEstimateDuration = Convert.ToDecimal(txtBAHrs.Text); newProject.ProjectManagementEstimateDuration = Convert.ToDecimal(txtProjectHrs.Text); newProject.OtherDuration = Convert.ToDecimal(txtOtherDuration.Text); //Duration.Enabled = true; //if (Duration.Text.Trim() != "") //{ // newProject.EstimateDuration = Convert.ToDecimal(Duration.Text); //} //else //{ newProject.EstimateDuration = Convert.ToDecimal(hdnDuration.Value); //} //Duration.Enabled = false; newProject.ManagerUserName = Managers.SelectedItem.Value; if (chkIsCompleted.Checked == true) { newProject.IsCompleted = true; } else { newProject.IsCompleted = false; } if (CurrentProject != null) { if (!objCustomFacade.IsProjectExists(ProjectName.Text.Trim(), CurrentProject.Id)) { if (!newProject.Save()) { // ErrorMessage.Text = "There was an error. Please fix it and try it again."; } UpdateProjectMembers(newProject.Id); string strUrl = "Project_Details.aspx?ProjectId=" + newProject.Id.ToString() + "&succ=true"; Response.Redirect(strUrl); } else { Error.Visible = true; Error.Text = "Already the project name is exists."; } } else { if (!newProject.Save()) { // ErrorMessage.Text = "There was an error. Please fix it and try it again."; } UpdateProjectMembers(newProject.Id); string strUrl = "Project_Details.aspx?ProjectId=" + newProject.Id.ToString() + "&succ=true"; Response.Redirect(strUrl); } } catch (Exception ex) { string strUrl1 = "Project_Details.aspx?ProjectId=" + newProject.Id.ToString() + "&error=false"; Error.Text = "Project name already exists."; //Response.Redirect(strUrl1); } }
protected void Consultants_DataBound(object sender, EventArgs e) { int count = Consultants.Items.Count; string RoleName = ""; if (count>0) { for (int i = 0; i < Consultants.Items.Count; i++) { CustomFacade objCustomFacade = new CustomFacade(); RoleName = objCustomFacade.GetRoleDetailsBYUserName(Consultants.Items[i].Value); if (RoleName.ToLower().Contains("projectadministrator") || RoleName.ToLower().Contains("projectmanager")) { Consultants.Items.Remove(Consultants.Items[i].Value); } } } }