public CreateUserDataNextTurn(string UserName) { var t = (from p in dr.DurationSystems where DateTime.Now >= p.StartDate where DateTime.Now <= p.EndDate select p.DurationId).First(); Assessment asm = new Assessment(); // Set properties before insert asm.UserName = UserName; asm.DurationId = t + 1; asm.G_Organize = 0; asm.G_SelfDev = 0; asm.G_Professional = 0; asm.G_TeamWork = 0; asm.G_Communicate = 0; asm.G_Mind = 0; asm.U_Strength = ""; asm.U_Weakness = ""; asm.D_Teach = 0; asm.E_Teach = 0; asm.G_Teach = 0; asm.P_Teach = 20; asm.D_Research = 0; asm.E_Research = 0; asm.G_Research = 0; asm.P_Research = 10; asm.D_Service = 0; asm.E_Service = 0; asm.G_Service = 0; asm.P_Service = 5; asm.D_Other = 0; asm.E_Other = 0; asm.G_Other = 0; asm.P_Other = 5; asm.E_CarryWork = 0; asm.G_CarryWork = 0; asm.Pro_AssessStatus = false; asm.Dean_AssessStatus = false; asm.Dept_AssessStatus = false; asm.Uni_AssessStatus = false; db.Assessments.InsertOnSubmit(asm); db.SubmitChanges(); }
public CreateAssessment(string UserName) { var t = (from p in dr.DurationSystems where DateTime.Now >= p.StartDate where DateTime.Now <= p.EndDate select p.DurationId).First(); var h = (from p in db.Users where p.UserName == UserName select p.DeptId).First(); var UserHeader = (from p in db.Users where p.DeptId == h where p.UserLevelId == 1 select p.UserName).First(); Assessment asm = new Assessment(); // Set properties before insert asm.UserName = UserName; // ชื่อเข้าใช้งานระบบ (Username) asm.DurationId = t; // ช่วงเวลา asm.E_CarryWork = 1; // ค่าความคาดหวัง asm.E_Teach = 1; asm.E_Research = 1; asm.E_Service = 1; asm.E_Other = 1; asm.P_Teach = 20; // เปอร์เซนต์คาดหวัง asm.P_Research = 10; asm.P_Service = 5; asm.P_Other = 5; asm.DealWorkLoadDetail = ""; // บันทึกข้อตกลง asm.DealTeachDetail = ""; asm.DealResearchDetail = ""; asm.DealServiceDetail = ""; asm.DealOtherDetail = ""; asm.DealCreate = true; // สถานะจัดทำข้อตกลง asm.G_CarryWork = 0; //คะแนนที่ได้จาก หัวหน้าภาค asm.G_Teach = 0; asm.G_Research = 0; asm.G_Service = 0; asm.G_Other = 0; asm.G_Organize = 0; asm.G_SelfDev = 0; asm.G_Professional = 0; asm.G_TeamWork = 0; asm.G_Communicate = 0; asm.G_Mind = 0; asm.D_CarryWork = 1; //คะแนนที่ได้จาก คณบดี asm.D_Teach = 1; asm.D_Research = 1; asm.D_Service = 1; asm.D_Other = 1; asm.D_Organize = 1; asm.D_SelfDev = 1; asm.D_Professional = 1; asm.D_TeamWork = 1; asm.D_Communicate = 1; asm.D_Mind = 1; asm.Assessor = UserHeader; // Username ผู้ทำการประเมิณ asm.U_Strength = ""; asm.U_Weakness = ""; asm.AssessComplete = false; // สถานะการประเมิณจากหัวหน้าภาควิชา asm.AssessApproved = false; // สถานะการยื่นยันจาก คณบดี db.Assessments.InsertOnSubmit(asm); db.SubmitChanges(); }
private void detach_Assessments(Assessment entity) { this.SendPropertyChanging(); entity.User = null; }
private void attach_Assessments(Assessment entity) { this.SendPropertyChanging(); entity.User = this; }
partial void DeleteAssessment(Assessment instance);
partial void UpdateAssessment(Assessment instance);
partial void InsertAssessment(Assessment instance);
private void hightLightLabelHeader(Assessment q) { if (q.E_CarryWork > q.G_CarryWork) { lblG_CarryWork.ForeColor = Color.Red; } else { lblG_CarryWork.ForeColor = Color.Black; } if (q.E_Teach > q.G_Teach) { lblG_Teach.ForeColor = Color.Red; } else { lblG_Teach.ForeColor = Color.Black; } if (q.E_Research > q.G_Research) { lblG_Research.ForeColor = Color.Red; } else { lblG_Research.ForeColor = Color.Black; } if (q.E_Service > q.G_Service) { lblG_Service.ForeColor = Color.Red; } else { lblG_Service.ForeColor = Color.Black; } if (q.E_Other > q.G_Other) { lblG_Other.ForeColor = Color.Red; } else { lblG_Other.ForeColor = Color.Black; } // University if (q.Duration.Organize > q.G_Organize) { lblG_Organize.ForeColor = Color.Red; } else { lblG_Organize.ForeColor = Color.Black; } if (q.Duration.SelfDev > q.G_SelfDev) { lblG_SelfDev.ForeColor = Color.Red; } else { lblG_SelfDev.ForeColor = Color.Black; } if (q.Duration.Professional > q.G_Professional) { lblG_Professional.ForeColor = Color.Red; } else { lblG_Professional.ForeColor = Color.Black; } if (q.Duration.Communicate > q.G_Communicate) { lblG_Communicate.ForeColor = Color.Red; } else { lblG_Communicate.ForeColor = Color.Black; } if (q.Duration.TeamWork > q.G_TeamWork) { lblG_TeamWork.ForeColor = Color.Red; } else { lblG_TeamWork.ForeColor = Color.Black; } if (q.Duration.Mind > q.G_Mind) { lblG_Mind.ForeColor = Color.Red; } else { lblG_Mind.ForeColor = Color.Black; } }
public void CreateAssessment(string UserName,int duraId) { Random r = new Random(); var q = (from p in db.Users where p.UserName == UserName select p).First(); var UserHeader = (from p in db.Users where p.DeptId == q.DeptId where p.UserLevelId == 1 select p.UserName).First(); Assessment asm = new Assessment(); // Set properties before insert asm.UserName = UserName; // ชื่อเข้าใช้งานระบบ (Username) asm.DurationId = duraId; // ช่วงเวลา asm.E_CarryWork = r.Next(1, 5); // ค่าความคาดหวัง asm.E_Teach = r.Next(1, 5); asm.E_Research = r.Next(1, 5); asm.E_Service = r.Next(1, 5); asm.E_Other = r.Next(1, 5); int a = r.Next(1, 5); if (a==1) { asm.P_Teach = 20; // เปอร์เซนต์คาดหวัง asm.P_Research = 10; asm.P_Service = 5; asm.P_Other = 5; } else if (a == 2) { asm.P_Teach = 10; // เปอร์เซนต์คาดหวัง asm.P_Research = 20; asm.P_Service = 5; asm.P_Other = 5; } else if (a == 3) { asm.P_Teach = 5; // เปอร์เซนต์คาดหวัง asm.P_Research = 10; asm.P_Service = 20; asm.P_Other = 5; } else if (a == 4) { asm.P_Teach = 5; // เปอร์เซนต์คาดหวัง asm.P_Research = 10; asm.P_Service = 5; asm.P_Other = 20; } else if (a == 5) { asm.P_Teach = 5; // เปอร์เซนต์คาดหวัง asm.P_Research = 10; asm.P_Service = 20; asm.P_Other = 5; } asm.DealWorkLoadDetail = ""; // บันทึกข้อตกลง asm.DealTeachDetail = ""; asm.DealResearchDetail = ""; asm.DealServiceDetail = ""; asm.DealOtherDetail = ""; asm.DealCreate = true; // สถานะจัดทำข้อตกลง //asm.G_CarryWork = r.Next(1, 5); //คะแนนที่ได้จาก หัวหน้าภาค //asm.G_Teach = r.Next(1, 5); //asm.G_Research = r.Next(1, 5); //asm.G_Service = r.Next(1, 5); //asm.G_Other = r.Next(1, 5); //asm.G_Organize = r.Next(1, 5); //asm.G_SelfDev = r.Next(1, 5); //asm.G_Professional = r.Next(1, 5); //asm.G_TeamWork = r.Next(1, 5); //asm.G_Communicate = r.Next(1, 5); //asm.G_Mind = r.Next(1, 5); //asm.D_CarryWork = r.Next(1, 5); ; //คะแนนที่ได้จาก คณบดี //asm.D_Teach = r.Next(1, 5); ; //asm.D_Research = r.Next(1, 5); ; //asm.D_Service = r.Next(1, 5); ; //asm.D_Other = r.Next(1, 5); ; //asm.D_Organize = r.Next(1, 5); ; //asm.D_SelfDev = r.Next(1, 5); ; //asm.D_Professional = r.Next(1, 5); ; //asm.D_TeamWork = r.Next(1, 5); ; //asm.D_Communicate = r.Next(1, 5); ; //asm.D_Mind = r.Next(1, 5); ; asm.G_CarryWork = 0; //คะแนนที่ได้จาก หัวหน้าภาค asm.G_Teach = 0; asm.G_Research = 0; asm.G_Service = 0; asm.G_Other = 0; asm.G_Organize = 0; asm.G_SelfDev = 0; asm.G_Professional = 0; asm.G_TeamWork = 0; asm.G_Communicate = 0; asm.G_Mind = 0; asm.D_CarryWork = 1; //คะแนนที่ได้จาก คณบดี asm.D_Teach = 1; asm.D_Research = 1; asm.D_Service = 1; asm.D_Other = 1 ; asm.D_Organize =1; asm.D_SelfDev = 1; asm.D_Professional = 1 ; asm.D_TeamWork = 1 ; asm.D_Communicate = 1 ; asm.D_Mind =1 ; asm.Assessor = UserHeader; // Username ผู้ทำการประเมิณ asm.U_Strength = ""; asm.U_Weakness = ""; asm.AssessComplete = false; // สถานะการประเมิณจากหัวหน้าภาควิชา asm.AssessApproved = false; // สถานะการยื่นยันจาก คณบดี db.Assessments.InsertOnSubmit(asm); db.SubmitChanges(); }