protected void Page_Load(object sender, EventArgs e) { CarryWorkCalculate crt = new CarryWorkCalculate(HttpContext.Current.User.Identity.Name); // Teaching Undirect GridView1.DataSource = crt.Teaching_UnDirect_Main().ToList(); GridView1.DataBind(); Label1.Text = crt.SumOfTeachingUnDirect_Main().ToString(); }
protected void Page_Load(object sender, EventArgs e) { CarryWorkCalculate c = new CarryWorkCalculate(HttpContext.Current.User.Identity.Name); GridView1.DataSource = c.Culture().ToList(); GridView1.DataBind(); Label1.Text = c.SumOfCulture().ToString(); }
protected void Page_Load(object sender, EventArgs e) { ddResearchRefer.Enabled = CheckBox1.Checked; CarryWorkCalculate cwcl = new CarryWorkCalculate(HttpContext.Current.User.Identity.Name); GridView1.DataSource = cwcl.Research().ToList(); GridView1.DataBind(); Label1.Text = cwcl.SumOfResearch_Main().ToString(); ResearchDataContext tcd = new ResearchDataContext(); GridView2.DataSource = cwcl.Research_Article().ToList(); GridView2.DataBind(); Label2.Text = cwcl.SumOfResearch_Article().ToString(); Label3.Text = cwcl.SumOfResearch().ToString(); }
public void setData(String userName,int durationId) { string username = userName; CarryWorkCalculate CalCarry = new CarryWorkCalculate(username, durationId); double a = CalCarry.SumOfTeaching(); double b = CalCarry.SumOfResearch(); double c = CalCarry.SumOfService(); double d = CalCarry.SumOfOther(); lblTeaching.Text = a.ToString(); lblResearching.Text = b.ToString(); lblService.Text = c.ToString(); lblOther.Text = d.ToString(); double result = a + b + c + d; lblSum.Text = result.ToString(); lblGrade.Text = getRate(result).ToString(); }
private void FillData() { CarryWorkCalculate cr = new CarryWorkCalculate(username); foreach (var item in cr.CenterService().ToList()) { switch (item.PositionTypeId) { case 0: CheckBox0.Checked = true; lbl0.Text = item.Result.ToString(); break; case 1: CheckBox1.Checked = true; lbl1.Text = item.Result.ToString(); break; case 2: CheckBox2.Checked = true; lbl2.Text = item.Result.ToString(); break; case 3: CheckBox3.Checked = true; lbl3.Text = item.Result.ToString(); break; case 4: CheckBox4.Checked = true; lbl4.Text = item.Result.ToString(); break; case 5: CheckBox5.Checked = true; lbl5.Text = item.Result.ToString(); break; case 6: CheckBox6.Checked = true; lbl6.Text = item.Result.ToString(); break; case 7: CheckBox7.Checked = true; lbl7.Text = item.Result.ToString(); break; case 8: CheckBox8.Checked = true; lbl8.Text = item.Result.ToString(); break; case 9: CheckBox9.Checked = true; lbl9.Text = item.Result.ToString(); break; case 10: CheckBox10.Checked = true; lbl10.Text = item.Result.ToString(); break; case 11: CheckBox11.Checked = true; lbl11.Text = item.Result.ToString(); break; case 12: CheckBox12.Checked = true; lbl12.Text = item.Result.ToString(); break; case 13: CheckBox13.Checked = true; lbl13.Text = item.Result.ToString(); break; case 14: CheckBox14.Checked = true; lbl14.Text = item.Result.ToString(); break; case 15: CheckBox15.Checked = true; txtValue15.Text = item.CenterServiceValue.ToString(); lbl15.Text = item.Result.ToString(); txtValue15.Enabled = true; break; case 16: CheckBox16.Checked = true; txtValue16.Text = item.CenterServiceValue.ToString(); lbl16.Text = item.Result.ToString(); txtValue16.Enabled = true; break; default: break; } } }
public void setData() { string username = Session["OtherCarryUserName"].ToString(); DateTime dt = DateTime.Now; CarryWorkCalculate CalCarry = new CarryWorkCalculate(username, Convert.ToInt32(Session["DurationId"])); double a = CalCarry.SumOfTeaching(); double b = CalCarry.SumOfResearch(); double c = CalCarry.SumOfService(); double d = CalCarry.SumOfOther(); lblTeaching.Text = a.ToString(); lblResearching.Text = b.ToString(); lblService.Text = c.ToString(); lblOther.Text = d.ToString(); double result = a + b + c + d; lblSum.Text = result.ToString(); lblGrade.Text = getRate(result).ToString(); }
public void setData() { string username = HttpContext.Current.User.Identity.Name; DateTime dt = DateTime.Now; CarryWorkCalculate CalCarry = new CarryWorkCalculate(username); double a = CalCarry.SumOfTeaching(); double b = CalCarry.SumOfResearch(); double c = CalCarry.SumOfService(); double d = CalCarry.SumOfOther(); lblTeaching.Text = a.ToString(); lblResearching.Text = b.ToString(); lblService.Text = c.ToString(); lblOther.Text = d.ToString(); double result = a + b + c + d; lblSum.Text = result.ToString(); getRate(result); }
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) { } }
private void FillGridView() { CarryWorkCalculate cr = new CarryWorkCalculate(username); ASPxGridView1.DataSource = cr.AcademicService().ToList(); ASPxGridView1.DataBind(); }
private void FillGridView2() { CarryWorkCalculate cr = new CarryWorkCalculate(username); ASPxGridView2.DataSource = cr.Teaching_Direct_Supervision().ToList(); ASPxGridView2.DataBind(); }
private void FillGridView() { CarryWorkCalculate cr = new CarryWorkCalculate(username, durationId); ASPxGridView1.DataSource = cr.StdDevelopment().ToList(); ASPxGridView1.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { username = Session["OtherCarryUserName"].ToString(); durationId = Convert.ToInt32(Session["DurationId"]); if (!IsPostBack) { CarryWorkCalculate cr = new CarryWorkCalculate(username, durationId); ASPxGridView1.DataSource = cr.AcademicService().ToList(); ASPxGridView1.DataBind(); } AssessmentSystemsDBDataContext db = new AssessmentSystemsDBDataContext(); var q = (from p in db.Users where p.UserName == Session["OtherCarryUserName"].ToString() select p.Prefix.Prefix1 + "" + p.FirstName + " " + p.LastName).First(); FullName.InnerText = q; }
private void FillGridView() { CarryWorkCalculate cr = new CarryWorkCalculate(username, durationId); ASPxGridView1.DataSource = cr.Teaching_Direct_Main().ToList(); ASPxGridView1.DataBind(); }
//*********************************************************************************************** private void FillGridView2() { CarryWorkCalculate cr = new CarryWorkCalculate(username, durationId); ASPxGridView2.DataSource = cr.Research_Article().ToList(); ASPxGridView2.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { String UserName = Session["UserName"].ToString(); Int32 DurationId = Convert.ToInt32(Session["PreviousDurationId"]); if (!IsPostBack) { ReportParameter[] para = new ReportParameter[28]; var q = (from p in db.Assessments where p.UserName == UserName where p.DurationId == DurationId select p).First(); var r = (from p in db.Users where p.UserName == q.Assessor select p).First(); String Date = DateDisplay(q.Duration.StartDate); String FullName = q.User.Prefix.Prefix1+q.User.FirstName+" "+q.User.LastName; String DeptName = q.User.Department.DeptName; 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; String WorkLoadSum = result.ToString(); String WorkLoadGrade = q.D_CarryWork.ToString(); if (WorkLoadSum=="") { WorkLoadSum = "0"; } if (WorkLoadGrade == "") { WorkLoadGrade = "0"; } para[0] = new ReportParameter("Date", Date); para[1] = new ReportParameter("FullName", FullName); para[2] = new ReportParameter("DeptName", DeptName); para[3] = new ReportParameter("WorkLoadSum", WorkLoadSum); para[4] = new ReportParameter("WorkLoadGrade", WorkLoadGrade); //**************************************************************************** String DirectTeach = CalCarry.SumOfTeachingDirect().ToString(); String UnDirectTeach = CalCarry.SumOfResearch().ToString(); String Research = CalCarry.SumOfService().ToString(); String AcademicService = CalCarry.SumOfService().ToString(); String Culture = CalCarry.SumOfCulture().ToString(); String StudentDev = CalCarry.SumOfStdDevelopment().ToString(); String CenterService = CalCarry.SumOfCenterService().ToString(); para[5] = new ReportParameter("DirectTeach", DirectTeach); para[6] = new ReportParameter("UnDirectTeach", UnDirectTeach); para[7] = new ReportParameter("Research", Research); para[8] = new ReportParameter("AcademicService", AcademicService); para[9] = new ReportParameter("Culture", Culture); para[10] = new ReportParameter("StudentDev", StudentDev); para[11] = new ReportParameter("CenterService", CenterService); //**************************************************************************** int Teaching_40 = Convert.ToInt32(q.P_Teach); int Researching_40 = Convert.ToInt32(q.P_Research); int Service_40 = Convert.ToInt32(q.P_Service); int Other_40 = Convert.ToInt32(q.P_Other); int Teaching_40_Get = Convert.ToInt32(q.D_Teach); int Researching_40_Get = Convert.ToInt32(q.D_Research); int Service_40_Get = Convert.ToInt32(q.D_Service); int Other_40_Get = Convert.ToInt32(q.D_Other); para[12] = new ReportParameter("WorkPrimary", Teaching_40.ToString()); para[13] = new ReportParameter("WorkSecondary", Researching_40.ToString()); para[14] = new ReportParameter("WorkGen1", Service_40.ToString()); para[15] = new ReportParameter("WorkGen2", Other_40.ToString()); para[16] = new ReportParameter("Teaching_40_Get", Teaching_40_Get.ToString()); para[17] = new ReportParameter("Researching_40_Get", Researching_40_Get.ToString()); para[18] = new ReportParameter("Service_40_Get", Service_40_Get.ToString()); para[19] = new ReportParameter("Other_40_Get", Other_40_Get.ToString()); double SeventyPercentPoint = Math.Round(((Convert.ToInt32(WorkLoadGrade) * 6) + (Teaching_40_Get * Teaching_40 / 5) + (Researching_40_Get * Researching_40 / 5) + (Service_40_Get * Service_40 / 5) + (Other_40_Get * Other_40 / 5)) / 70.00F, 3); //**************************************************************************** String Organize = q.D_Organize.ToString(); String SelfDev = q.D_SelfDev.ToString(); String Professional = q.D_Professional.ToString(); String Communicate = q.D_Communicate.ToString(); String TeamWork = q.D_TeamWork.ToString(); String Mind = q.D_Mind.ToString(); para[20] = new ReportParameter("Organize", Organize); para[21] = new ReportParameter("SelfDev", SelfDev); para[22] = new ReportParameter("Professional", Professional); para[23] = new ReportParameter("Communicate", Communicate); para[24] = new ReportParameter("TeamWork", TeamWork); para[25] = new ReportParameter("Mind", Mind); //**************************************************************************** CompareCalculate(q.Duration.Organize.ToString(), Organize); CompareCalculate(q.Duration.SelfDev.ToString(), SelfDev); CompareCalculate(q.Duration.Professional.ToString(), Professional); CompareCalculate(q.Duration.Communicate.ToString(), Communicate); CompareCalculate(q.Duration.TeamWork.ToString(), TeamWork); CompareCalculate(q.Duration.Mind.ToString(), Mind); double ThirtyPercentPoint = Math.Round(((Mul3 * 3) + (Mul2 * 2) + Mul1) / 18.00F, 3); para[26] = new ReportParameter("ThirtyPercentPoint", ThirtyPercentPoint.ToString()); para[27] = new ReportParameter("SeventyPercentPoint", SeventyPercentPoint.ToString()); ReportViewer1.LocalReport.SetParameters(para); // Report data source code... ReportViewer1.LocalReport.Refresh(); } }
private void FillGridView() { CarryWorkCalculate cr = new CarryWorkCalculate(username); ASPxGridView1.DataSource = cr.Research().ToList(); ASPxGridView1.DataBind(); SqlDataSource2.DataBind(); }
//******************************************* 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) { } }
protected void Page_Load(object sender, EventArgs e) { if (dr.Header() || dr.Dean()) { Session["OtherCarryUserName"] = HttpContext.Current.User.Identity.Name; Response.Redirect("~/CarryShowOnly/CarryCalculateMain.aspx"); } durationId = dr.getDurationId(); if (!IsPostBack) { CarryWorkCalculate cr = new CarryWorkCalculate(username); ASPxGridView1.DataSource = cr.AcademicService().ToList(); ASPxGridView1.DataBind(); } }
private void setControl() { var q = (from p in db.Assessments where p.UserName == HttpContext.Current.User.Identity.Name where p.DurationId == dm.getDurationId() select p).First(); // Set Data 70% ProfessorForm70.RG2 = Convert.ToInt32(q.E_Teach); ProfessorForm70.RG3 = Convert.ToInt32(q.E_Research); ProfessorForm70.RG4 = Convert.ToInt32(q.E_Service); ProfessorForm70.RG5 = Convert.ToInt32(q.E_Other); ProfessorForm70.dd1 = q.P_Teach.ToString(); ProfessorForm70.dd2 = q.P_Research.ToString(); ProfessorForm70.dd3 = q.P_Service.ToString(); ProfessorForm70.dd4 = q.P_Other.ToString(); // Set Document Status DocumentTableStatus1.Professor =Convert.ToBoolean(q.Pro_AssessStatus); DocumentTableStatus1.Header = Convert.ToBoolean(q.Dept_AssessStatus); DocumentTableStatus1.Dean = Convert.ToBoolean(q.Dean_AssessStatus); DocumentTableStatus1.University = Convert.ToBoolean(q.Uni_AssessStatus); // First time when you login. System will get data from CarryWork if (q.E_CarryWork == 0) { // Set Radio CarryGroup CarryWorkCalculate CalCarry = new CarryWorkCalculate(HttpContext.Current.User.Identity.Name); double a = CalCarry.SumOfTeaching(); double b = CalCarry.SumOfResearch(); double c = CalCarry.SumOfService(); double d = CalCarry.SumOfOther(); double result = a + b + c + d; ProfessorForm70.RG1 = getRate(result); } else { ProfessorForm70.RG1 = Convert.ToInt32(q.E_CarryWork); } }