protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { setControl(); // Set Data 30% University espect DurationDataContext systemdb = new DurationDataContext(); var uni = (from p in systemdb.DurationSystems where p.DurationId == Convert.ToInt32(Session["DurationId"]) select p).First(); lblOrganize.Text = uni.Organize.ToString(); lblSelfDev.Text = uni.SelfDev.ToString(); lblProfessional.Text = uni.Professional.ToString(); lblCommunicate.Text = uni.Communicate.ToString(); lblTeamWork.Text = uni.TeamWork.ToString(); lblMind.Text = uni.Mind.ToString(); } // Set Radio button out values O51 = RadioButtonX51.data; O52 = RadioButtonX52.data; O53 = RadioButtonX53.data; O54 = RadioButtonX54.data; O55 = RadioButtonX55.data; O56 = RadioButtonX56.data; }
private int getRate(double data) { DurationDataContext ds = new DurationDataContext(); var q = (from p in ds.DurationSystems where p.DurationId == Convert.ToInt32(Session["DurationId"]) select p).First(); ; int rate; if (data >= q.WorkLoad_Lv_5) { rate = 5; } else if (data >= q.WorkLoad_Lv_4 && data < q.WorkLoad_Lv_5) { rate = 4; } else if (data >= q.WorkLoad_Lv_3 && data < q.WorkLoad_Lv_4) { rate = 3; } else if (data >= q.WorkLoad_Lv_2 && data < q.WorkLoad_Lv_3) { rate = 2; } else { rate = 1; } return rate; }
private Object SetColor(double data, int dura) { DurationDataContext db = new DurationDataContext(); var q = (from p in db.DurationSystems where p.DurationId == dura select p).First(); Color color = new Color(); color = Color.Green; if (data < q.WorkLoad_Lv_2) { color = Color.Red; } else if (data >= q.WorkLoad_Lv_2 && data <= q.WorkLoad_Lv_3) { color = Color.Orange; } return color; }
//******************************************* public void SetControl(String UserName, int DurationId) { username = UserName; Session["OtherCarryUserName"] = username; durationid = DurationId; try { var q = (from p in db.Assessments where p.UserName == UserName where p.DurationId == DurationId select p).First(); //**************************************************************************************** Professor // Percent Workload lblPercentTeach.Text = q.P_Teach + "%"; lblPercentResearch.Text = q.P_Research + "%"; lblPercentAcaService.Text = q.P_Service + "%"; lblPercentOther.Text = q.P_Other + "%"; // Professor lblE_Carry.Text = q.E_CarryWork.ToString(); lblE_Teach.Text = q.E_Teach.ToString(); lblE_Research.Text = q.E_Research.ToString(); lblE_Service.Text = q.E_Service.ToString(); lblE_Other.Text = q.E_Other.ToString(); // Header if (Convert.ToBoolean(q.AssessComplete)) { lblHWorkLoad.Text = q.G_CarryWork.ToString(); lblHTeach.Text = q.G_Teach.ToString(); lblHResearch.Text = q.G_Research.ToString(); lblHService.Text = q.G_Service.ToString(); lblHOther.Text = q.G_Other.ToString(); lblHOrganize.Text = q.G_Organize.ToString(); lblHSelfDev.Text = q.G_SelfDev.ToString(); lblHProfessional.Text = q.G_Professional.ToString(); lblHCommunicate.Text = q.G_Communicate.ToString(); lblHTeamWork.Text = q.G_TeamWork.ToString(); lblHMind.Text = q.G_Mind.ToString(); // Dean ddWorkLoad.SelectedValue = q.D_CarryWork.ToString(); ddTeach.SelectedValue = q.D_Teach.ToString(); ddResearch.SelectedValue = q.D_Research.ToString(); ddService.SelectedValue = q.D_Service.ToString(); ddOther.SelectedValue = q.D_Other.ToString(); ddOrganize.SelectedValue = q.D_Organize.ToString(); ddSelfDev.SelectedValue = q.D_SelfDev.ToString(); ddProfessional.SelectedValue = q.D_Professional.ToString(); ddCommunicate.SelectedValue = q.D_Communicate.ToString(); ddTeamWork.SelectedValue = q.D_TeamWork.ToString(); ddMind.SelectedValue = q.D_Mind.ToString(); lblDWorkLoad.Text = q.D_CarryWork.ToString(); hightLightLabelHeader(q); if (dm.Dean()) { lblDTeach.Text = q.D_Teach.ToString(); lblDResearch.Text = q.D_Research.ToString(); lblDService.Text = q.D_Service.ToString(); lblDOther.Text = q.D_Other.ToString(); lblDOrganize.Text = q.D_Organize.ToString(); lblDSelfDev.Text = q.D_SelfDev.ToString(); lblDProfessional.Text = q.D_Professional.ToString(); lblDCommunicate.Text = q.D_Communicate.ToString(); lblDTeamWork.Text = q.D_TeamWork.ToString(); lblDMind.Text = q.D_Mind.ToString(); hightLightLabelDean(q); } else { lblDWorkLoad.Text = "-"; lblDTeach.Text = "-"; lblDResearch.Text = "-"; lblDService.Text = "-"; lblDOther.Text = "-"; lblDOrganize.Text = "-"; lblDSelfDev.Text = "-"; lblDProfessional.Text = "-"; lblDCommunicate.Text = "-"; lblDTeamWork.Text = "-"; lblDMind.Text = "-"; } } else { lblHWorkLoad.Text = "-"; lblHTeach.Text = "-"; lblHResearch.Text = "-"; lblHService.Text = "-"; lblHOther.Text = "-"; lblHOrganize.Text = "-"; lblHSelfDev.Text = "-"; lblHProfessional.Text = "-"; lblHCommunicate.Text = "-"; lblHTeamWork.Text = "-"; lblHMind.Text = "-"; lblDWorkLoad.Text = "-"; lblDTeach.Text = "-"; lblDResearch.Text = "-"; lblDService.Text = "-"; lblDOther.Text = "-"; lblDOrganize.Text = "-"; lblDSelfDev.Text = "-"; lblDProfessional.Text = "-"; lblDCommunicate.Text = "-"; lblDTeamWork.Text = "-"; lblDMind.Text = "-"; } //**************************************************************************************** University Expect DurationDataContext du = new DurationDataContext(); var r = (from p in du.DurationSystems where p.DurationId == DurationId select p).First(); // University Expect lblOrganize.Text = r.Organize.ToString(); lblSelfDev.Text = r.SelfDev.ToString(); lblProfessional.Text = r.Professional.ToString(); lblComunicate.Text = r.Communicate.ToString(); lblTeamWork.Text = r.TeamWork.ToString(); lblMind.Text = r.Mind.ToString(); CarryWorkCalculate CalCarry = new CarryWorkCalculate(UserName, DurationId); double a = CalCarry.SumOfTeaching(); double b = CalCarry.SumOfResearch(); double c = CalCarry.SumOfService(); double d = CalCarry.SumOfOther();double result = a + b + c + d; popup_1.InnerHtml = q.Duration.WorkLoad_Lv_2.ToString(); popup_2.InnerHtml = q.Duration.WorkLoad_Lv_2.ToString(); popup_3.InnerHtml = (q.Duration.WorkLoad_Lv_3 - 1).ToString(); popup_4.InnerHtml = q.Duration.WorkLoad_Lv_3.ToString(); popup_5.InnerHtml = (q.Duration.WorkLoad_Lv_4 - 1).ToString(); popup_6.InnerHtml = q.Duration.WorkLoad_Lv_4.ToString(); popup_7.InnerHtml = (q.Duration.WorkLoad_Lv_5 - 1).ToString(); popup_8.InnerHtml = q.Duration.WorkLoad_Lv_5.ToString(); lblWorkLoad.ForeColor = (Color)SetColor(result, DurationId); lblWorkLoad.Text = result.ToString(); if (dm.Dean()) { if (Convert.ToBoolean(q.AssessApproved)) { btnUnApproved.Visible = true; btnApproved.Visible = false; btnEdit.Visible = false; } else { btnUnApproved.Visible = false; btnApproved.Visible = true; btnEdit.Visible = true; } btnApproveAll.Visible = true; } } catch (Exception) { } }
private int SetDurationId() { int durationId; try { durationId = dm.getDurationId(); } catch (Exception) { DurationDataContext dr = new DurationDataContext(); var q = (from p in dr.DurationSystems orderby p.DurationId descending select p).First(); DurationSystems newDr = new DurationSystems(); newDr.StartDate = q.EndDate.AddDays(1); newDr.EndDate = newDr.StartDate.AddMonths(6); newDr.Organize = q.Organize; newDr.SelfDev = q.SelfDev; newDr.Professional = q.Professional; newDr.Communicate = q.Communicate; newDr.Mind = q.Mind; newDr.TeamWork = q.TeamWork; newDr.WorkLoad_Lv_2 = q.WorkLoad_Lv_2; newDr.WorkLoad_Lv_3 = q.WorkLoad_Lv_3; newDr.WorkLoad_Lv_4 = q.WorkLoad_Lv_4; newDr.WorkLoad_Lv_5 = q.WorkLoad_Lv_5; dr.DurationSystems.InsertOnSubmit(newDr); dr.SubmitChanges(); var newq = (from p in dr.DurationSystems orderby p.DurationId descending select p).First(); durationId = newq.DurationId; } return durationId; }
public void SetControl(String UserName, int DurationId) { username = UserName; durationid = DurationId; Session["OtherCarryUserName"] = username; try { var q = (from p in db.Assessments where p.UserName == UserName where p.DurationId == DurationId select p).First(); //**************************************************************************************** Professor // Percent Workload lblPercentTeach.Text = q.P_Teach + "%"; lblPercentResearch.Text = q.P_Research + "%"; lblPercentAcaService.Text = q.P_Service + "%"; lblPercentOther.Text = q.P_Other + "%"; // Professor Score lblE_Carry.Text = q.E_CarryWork.ToString(); lblE_Teach.Text = q.E_Teach.ToString(); lblE_Research.Text = q.E_Research.ToString(); lblE_Service.Text = q.E_Service.ToString(); lblE_Other.Text = q.E_Other.ToString(); lblHWorkLoad.Text = q.G_CarryWork.ToString(); lblHTeach.Text = q.G_Teach.ToString(); lblHResearch.Text = q.G_Research.ToString(); lblHService.Text = q.G_Service.ToString(); lblHOther.Text = q.G_Other.ToString(); lblHOrganize.Text = q.G_Organize.ToString(); lblHSelfDev.Text = q.G_SelfDev.ToString(); lblHProfessional.Text = q.G_Professional.ToString(); lblHCommunicate.Text = q.G_Communicate.ToString(); lblHTeamWork.Text = q.G_TeamWork.ToString(); lblHMind.Text = q.G_Mind.ToString(); //**************************************************************************************** University Expect DurationDataContext du = new DurationDataContext(); var r = (from p in du.DurationSystems where p.DurationId == DurationId select p).First(); // University Expect lblOrganize.Text = r.Organize.ToString(); lblSelfDev.Text = r.SelfDev.ToString(); lblProfessional.Text = r.Professional.ToString(); lblComunicate.Text = r.Communicate.ToString(); lblTeamWork.Text = r.TeamWork.ToString(); lblMind.Text = r.Mind.ToString(); CarryWorkCalculate CalCarry = new CarryWorkCalculate(UserName, DurationId); double a = CalCarry.SumOfTeaching(); double b = CalCarry.SumOfResearch(); double c = CalCarry.SumOfService(); double d = CalCarry.SumOfOther(); double result = a + b + c + d; lblWorkLoad.ForeColor = (Color)SetColor(result, DurationId); lblWorkLoad.Text = result.ToString(); popup_1.InnerHtml = q.Duration.WorkLoad_Lv_2.ToString(); popup_2.InnerHtml = q.Duration.WorkLoad_Lv_2.ToString(); popup_3.InnerHtml = (q.Duration.WorkLoad_Lv_3 - 1).ToString(); popup_4.InnerHtml = q.Duration.WorkLoad_Lv_3.ToString(); popup_5.InnerHtml = (q.Duration.WorkLoad_Lv_4 - 1).ToString(); popup_6.InnerHtml = q.Duration.WorkLoad_Lv_4.ToString(); popup_7.InnerHtml = (q.Duration.WorkLoad_Lv_5 - 1).ToString(); popup_8.InnerHtml = q.Duration.WorkLoad_Lv_5.ToString(); hightLightLabelHeader(q); } catch (Exception) { } }