public ActionResult Create(TB_SCHOOL_DOCUMENT tb_school_document)
{
if (ModelState.IsValid)
{
db.TB_SCHOOL_DOCUMENT.Add(tb_school_document);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tb_school_document));
}
public ActionResult Create(TB_ROOM tb_room)
{
if (ModelState.IsValid)
{
tb_room.ROOM_FLOOR = 0;
db.TB_ROOM.Add(tb_room);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ROOM_BUILD = new SelectList(db.TB_M_BUILDING, "BUILDING_ID", "BUILDING_NAME", tb_room.ROOM_BUILD);
ViewBag.ROOM_FOR_LEVEL = new SelectList(db.TB_M_LEVEL, "LEVEL_ID", "LEVEL_NAME_TH", tb_room.ROOM_FOR_LEVEL);
return(View(tb_room));
}
public ActionResult Create(TB_ROLE tb_role)
{
if (Session["USER"] == null)
{
return(RedirectToAction("../Account/ManagementLogin"));
}
if (ModelState.IsValid)
{
db.TB_ROLE.Add(tb_role);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tb_role));
}
public ActionResult Create(TB_APPLICATION_STAFF tb_application_staff)
{
if (ModelState.IsValid)
{
int schoolId = (int)Session["Phet10ManagementSchoolId"];
tb_application_staff.STAFF_SCHOOL_ID = schoolId;
db.TB_APPLICATION_STAFF.Add(tb_application_staff);
db.SaveChanges();
return(RedirectToAction("Index/" + schoolId));
}
ViewBag.STAFF_TITLE_ID = new SelectList(db.TB_M_TITLE, "TITLE_ID", "TITLE_NAME_TH", tb_application_staff.STAFF_TITLE_ID);
ViewBag.STAFF_FOR_LEVEL = new SelectList(db.TB_M_LEVEL, "LEVEL_ID", "LEVEL_NAME_TH", tb_application_staff.STAFF_FOR_LEVEL);
return(View(tb_application_staff));
}
public ActionResult Create(TB_ROLE_PERMISSION tb_role_permission)
{
if (Session["USER"] == null)
{
return(RedirectToAction("../Account/ManagementLogin"));
}
if (ModelState.IsValid)
{
db.TB_ROLE_PERMISSION.Add(tb_role_permission);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ROLE_ID = new SelectList(db.TB_ROLE, "ID", "NAME", tb_role_permission.ROLE_ID);
return(View(tb_role_permission));
}
public ActionResult Create(TB_COMMITEE tb_commitee)
{
if (Session["USER"] == null)
{
return(RedirectToAction("../Account/ManagementLogin"));
}
if (ModelState.IsValid)
{
db.TB_COMMITEE.Add(tb_commitee);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.COMMITEE_TITLE_ID = new SelectList(db.TB_M_TITLE, "TITLE_ID", "TITLE_NAME_TH", tb_commitee.COMMITEE_TITLE_ID);
return(View(tb_commitee));
}
public ActionResult doProcessCommittee()
{
if (Session["USER"] == null)
{
return(RedirectToAction("../Account/ManagementLogin"));
}
ViewBag.ResultMsg = "";
int countOfCommittee = 0;
int countOfSuccess = 0;
int countOfFail = 0;
using (ChinaPhet10Entities context = new ChinaPhet10Entities())
{
List <TB_COMMITEE> commitees = db.TB_COMMITEE.OrderBy(c => c.COMMITEE_ID).Include("TB_M_TITLE").ToList();
if (commitees != null)
{
/*
* DELETE TB_COMMITEE_ROOM
*/
foreach (TB_COMMITEE_ROOM dcmtr in context.TB_COMMITEE_ROOM.ToList())
{
context.TB_COMMITEE_ROOM.Remove(dcmtr);
}
//context.TB_COMMITEE_ROOM.ToList().ForEach(context.TB_COMMITEE_ROOM.DeleteObject);
countOfCommittee = context.TB_COMMITEE_ROOM.Count();
var varRoom = from a in db.TB_ROOM orderby a.ROOM_FOR_LEVEL, a.ROOM_NUMBER select a;
List <TB_ROOM> rooms = varRoom.ToList();
if (rooms != null)
{
int index = 0;
foreach (TB_ROOM room in rooms)
{
for (int i = 0; i < Convert.ToInt16(room.ROOM_COMMITTEE_COUNT); i++)
{
if (index < commitees.Count)
{
TB_COMMITEE_ROOM cr = new TB_COMMITEE_ROOM();
cr.COMMITEE_ID = commitees[index].COMMITEE_ID;
cr.COMMITEE_ROOM_ID = room.ROOM_ID;
context.TB_COMMITEE_ROOM.Add(cr);
countOfSuccess++;
index++;
}
else
{
//countOfFail++;
//ViewBag.ResultMsg = "จำนวนคนไม่พอกับจำนวนห้อง !";
}
}
}
}
context.SaveChanges();
}
}
ViewBag.ResultMsg = "ประมวลผลกรรมการคุมสอบเรียบร้อยแล้ว (จำนวนกรรมการทั้งหมด " + countOfCommittee + " คน <br> สำเร็จ " + countOfSuccess + " รายการ <br> ไม่สำเร็จ " + countOfFail + " รายการ)";
return(View("ProcessCommittee"));
}
public ActionResult Edit(TB_APPLICATION_SCHOOL tb_application_school)
{
if (ModelState.IsValid)
{
var _updateSchool = db.TB_APPLICATION_SCHOOL.FirstOrDefault(f => f.SCHOOL_ID == tb_application_school.SCHOOL_ID);
if (_updateSchool != null)
{
_updateSchool.SCHOOL_ADDR_PROVINCE = tb_application_school.SCHOOL_ADDR_PROVINCE;
_updateSchool.SCHOOL_ADDR_AMPHUR = tb_application_school.SCHOOL_ADDR_AMPHUR;
_updateSchool.SCHOOL_ADDR_TOMBON = tb_application_school.SCHOOL_ADDR_TOMBON;
_updateSchool.SCHOOL_ZONE_EDU = tb_application_school.SCHOOL_ZONE_EDU;
_updateSchool.SCHOOL_ZONE = tb_application_school.SCHOOL_ZONE;
_updateSchool.SCHOOL_TYPE_OTHER = tb_application_school.SCHOOL_TYPE_OTHER;
_updateSchool.SCHOOL_ADDR = tb_application_school.SCHOOL_ADDR;
_updateSchool.SCHOOL_ADDR_SOI = tb_application_school.SCHOOL_ADDR_SOI;
_updateSchool.SCHOOL_ADDR_ROAD = tb_application_school.SCHOOL_ADDR_ROAD;
_updateSchool.SCHOOL_ADDR_ZIPCODE = tb_application_school.SCHOOL_ADDR_ZIPCODE;
_updateSchool.SCHOOL_ADDR_PHONE = tb_application_school.SCHOOL_ADDR_PHONE;
_updateSchool.SCHOOL_ADDR_FAX = tb_application_school.SCHOOL_ADDR_FAX;
_updateSchool.SCHOOL_NAME = tb_application_school.SCHOOL_NAME;
_updateSchool.SCHOOL_PROVINCE = tb_application_school.SCHOOL_PROVINCE;
_updateSchool.SCHOOL_PASSWORD = tb_application_school.SCHOOL_PASSWORD;
_updateSchool.SCHOOL_DOC_PATH = tb_application_school.SCHOOL_DOC_PATH;
_updateSchool.SCHOOL_REGISTER_DATE = tb_application_school.SCHOOL_REGISTER_DATE;
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tb_application_school));
}
public ActionResult ManagementLogin(LoginModel model, string returnUrl)
{
if (ModelState.IsValid)
{
using (ChinaPhet10Entities context = new ChinaPhet10Entities())
{
var user = context.TB_USER.FirstOrDefault(x => x.USERNAME == model.UserName && x.PASSWORD == model.Password);
if (user == null)
{
ModelState.AddModelError("LogOnError", "The user name or password provided is incorrect.");
}
else
{
//FormsAuthentication.SetAuthCookie(model.UserName, model.RememberMe);
if (Url.IsLocalUrl(returnUrl) && returnUrl.Length > 1 && returnUrl.StartsWith("/") &&
!returnUrl.StartsWith("//") && !returnUrl.StartsWith("/\\"))
{
return(Redirect(returnUrl));
}
else
{
//update lasted login time
//user.LASTED_LOGIN = DateTime.Now;
//context.ObjectStateManager.ChangeObjectState(user, System.Data.EntityState.Modified);
var _update = db.TB_USER.FirstOrDefault(f => f.ID == user.ID);
if (_update != null)
{
_update.ROLE_ID = user.ROLE_ID;
_update.USERNAME = user.USERNAME;
_update.PASSWORD = user.PASSWORD;
_update.STATUS = user.STATUS;
_update.CREATE_BY = user.CREATE_BY;
_update.EMAIL = user.EMAIL;
}
context.SaveChanges();
//Redirect to default page
Session["USER"] = user;
Session["ROLE"] = user.TB_ROLE.NAME;
String[] rolPermission = new String[user.TB_ROLE.TB_ROLE_PERMISSION.Count];
int index = 0;
foreach (TB_ROLE_PERMISSION item in user.TB_ROLE.TB_ROLE_PERMISSION.ToList())
{
rolPermission[index] = item.PERMISSION_CODE;
index++;
}
Session["ROLE_PERMISSION"] = rolPermission;
return(RedirectToAction("Index", "Management"));
}
}
}
}
// If we got this far, something failed, redisplay form
return(View(model));
}
public ActionResult Create(TB_USER tb_user)
{
if (Session["USER"] == null)
{
return(RedirectToAction("../Account/ManagementLogin"));
}
if (ModelState.IsValid)
{
tb_user.LASTED_LOGIN = DateTime.Now;
tb_user.CREATE_DATE = DateTime.Now;
tb_user.CREATE_BY = 0;
db.TB_USER.Add(tb_user);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.STATUS = new SelectList(db.TB_M_STATUS.Where(s => s.STATUS_GROUP == 2), "STATUS_ID", "STATUS_NAME_TH", tb_user.STATUS);
ViewBag.ROLE_ID = new SelectList(db.TB_ROLE, "ID", "NAME", tb_user.ROLE_ID);
return(View(tb_user));
}
public ActionResult deleteRound2Data()
{
if (Session["USER"] == null)
{
return(RedirectToAction("../Account/ManagementLogin"));
}
using (ChinaPhet10Entities context = new ChinaPhet10Entities())
{
foreach (TB_SCORE_ROUND_2 r1 in context.TB_SCORE_ROUND_2.ToList())
{
context.TB_SCORE_ROUND_2.Remove(r1);
}
//context.TB_SCORE_ROUND_2.ToList().ForEach(context.TB_SCORE_ROUND_2.DeleteObject);
context.SaveChanges();
}
ViewBag.ResultMsg = "ล้างข้อมูลรอบเจียรไนเพชรเรียบร้อยแล้ว";
return(View("Round1"));
}
public ActionResult clearRound21Score(int id)
{
if (Session["USER"] == null)
{
return(RedirectToAction("../Account/ManagementLogin"));
}
using (ChinaPhet10Entities context = new ChinaPhet10Entities())
{
Int32 stdCode = Convert.ToInt32(id);
TB_SCORE_ROUND_2 score21 = context.TB_SCORE_ROUND_2.Where(s21 => s21.STD_CODE == stdCode).FirstOrDefault();
if (score21 != null)
{
score21.SCORE_1_11 = 0;
score21.SCORE_1_12 = 0;
score21.SCORE_1_13 = 0;
score21.SCORE_1_14 = 0;
score21.SCORE_1_15 = 0;
score21.SCORE_1_21 = 0;
score21.SCORE_1_22 = 0;
score21.SCORE_1_23 = 0;
score21.SCORE_1_24 = 0;
score21.SCORE_1_25 = 0;
score21.SCORE_1_31 = 0;
score21.SCORE_1_32 = 0;
score21.SCORE_1_33 = 0;
score21.SCORE_1_34 = 0;
score21.SCORE_1_35 = 0;
context.SaveChanges();
ViewBag.ResultMsg = "ล้างข้อมูลเรียบร้อยแล้ว";
}
else
{
ViewBag.ResultErrorMsg = "ยังไม่มีการบันทึกข้อมูล ไม่สามารถลบได้";
}
}
return(View("Round2_1", new ScoreRound21Model()));
}
public ActionResult Upload(UploadModel model)
{
//if (ModelState.IsValid)
//{
try
{
if (Request.Files["photo"] != null) // If uploaded synchronously
{
model.photo_guid = _fileStore.SaveUploadedFile(Request.Files["photo"]);
model.photo_filename = Request.Files["photo"].FileName;
}
TB_SCHOOL_DOCUMENT schoolDocument = new TB_SCHOOL_DOCUMENT();
schoolDocument.SCHOOL_ID = model.school.SCHOOL_ID;
schoolDocument.DOCUMENT_PATH = model.photo_filename;
db.TB_SCHOOL_DOCUMENT.Add(schoolDocument);
var _update = db.TB_APPLICATION_SCHOOL.FirstOrDefault(f => f.SCHOOL_ID == model.school.SCHOOL_ID);
if (_update != null)
{
_update.SCHOOL_DOC_PATH = model.photo_filename;
_update.SCHOOL_APPROVED_STATUS = 2;
}
db.SaveChanges();
return(RedirectToAction("../School/Index"));
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
ModelState.AddModelError("", "ยังไม่ได้เลือกไฟล์");
}
//}
ViewBag.PageContent = "ส่งเอกสารยืนยันการสมัคร";
return(View("Index", model));
}
public ActionResult Index([Bind(Exclude = "SCHOOL_ID")] ApplicationModel model)
{
//Thread.Sleep(5000);
if (!ModelState.IsValid)
{
/*
* TITLE PROVINCE
*/
IList <TB_M_PROVINCE> mProvinceLists = db.TB_M_PROVINCE.ToList <TB_M_PROVINCE>();
IEnumerable <SelectListItem> provinceLists =
from s in mProvinceLists
select new SelectListItem
{
Text = s.PROVINCE_NAME,
Value = s.PROVINCE_ID.ToString()
};
/*
* SCHOOL TYPE
*/
List <RadioButtonModel> list = new List <RadioButtonModel>();
list.Add(new RadioButtonModel()
{
ID = 1, Name = Resources.Application.Application.SCHOOL_TYPE_01
}); //สพฐ
list.Add(new RadioButtonModel()
{
ID = 2, Name = Resources.Application.Application.SCHOOL_TYPE_02
}); //เอกชน
list.Add(new RadioButtonModel()
{
ID = 3, Name = Resources.Application.Application.SCHOOL_TYPE_03
}); //กทม
list.Add(new RadioButtonModel()
{
ID = 4, Name = Resources.Application.Application.SCHOOL_TYPE_04
}); //อุดมศึกษา
list.Add(new RadioButtonModel()
{
ID = 5, Name = Resources.Application.Application.SCHOOL_TYPE_OTHER
}); //อื่น ๆ
SelectList schoolTypes = new SelectList(list, "ID", "Name");
model.provinceLists = provinceLists;
model.rSchoolTypes = schoolTypes;
return(View(model));
}
//using (ChinaPhet10Entities context = new ChinaPhet10Entities())
//{
//using (TransactionScope tran = new TransactionScope())
//{
try
{
//Check school duplicate
var isExist = db.TB_APPLICATION_SCHOOL.Any(k => k.SCHOOL_EMAIL == model.school.SCHOOL_EMAIL);
if (!isExist)
{
/*
* SCHOOL MODEL
*/
CultureInfo ci = (CultureInfo)this.Session["PhetCulture"];
TB_APPLICATION application = db.TB_APPLICATION.FirstOrDefault();
//VALIDATE NULL VALUE
model.school.SCHOOL_ADDR_PROVINCE = (model.SCHOOL_ADDR_PROVINCE == null) ? -1 : Convert.ToInt32(model.SCHOOL_ADDR_PROVINCE);
model.school.SCHOOL_ADDR_AMPHUR = (model.SCHOOL_ADDR_AMPHUR == null) ? -1 : Convert.ToInt32(model.SCHOOL_ADDR_AMPHUR);
model.school.SCHOOL_ADDR_TOMBON = (model.SCHOOL_ADDR_TOMBON == null) ? -1 : Convert.ToInt32(model.SCHOOL_ADDR_TOMBON);
model.school.SCHOOL_ZONE_EDU = (model.school.SCHOOL_ZONE_EDU == null) ? "" : model.school.SCHOOL_ZONE_EDU;
model.school.SCHOOL_ZONE = (model.school.SCHOOL_ZONE == null) ? "" : model.school.SCHOOL_ZONE;
model.school.SCHOOL_TYPE_OTHER = (model.school.SCHOOL_TYPE_OTHER == null) ? "" : model.school.SCHOOL_TYPE_OTHER;
model.school.SCHOOL_ADDR = (model.school.SCHOOL_ADDR == null) ? "" : model.school.SCHOOL_ADDR;
model.school.SCHOOL_ADDR_SOI = (model.school.SCHOOL_ADDR_SOI == null) ? "" : model.school.SCHOOL_ADDR_SOI;
model.school.SCHOOL_ADDR_ROAD = (model.school.SCHOOL_ADDR_ROAD == null) ? "" : model.school.SCHOOL_ADDR_ROAD;
model.school.SCHOOL_ADDR_ZIPCODE = (model.school.SCHOOL_ADDR_ZIPCODE == null) ? "" : model.school.SCHOOL_ADDR_ZIPCODE;
model.school.SCHOOL_ADDR_PHONE = (model.school.SCHOOL_ADDR_PHONE == null) ? "" : model.school.SCHOOL_ADDR_PHONE;
model.school.SCHOOL_ADDR_FAX = (model.school.SCHOOL_ADDR_FAX == null) ? "" : model.school.SCHOOL_ADDR_FAX;
model.school.SCHOOL_NAME = (model.school.SCHOOL_NAME == null) ? "" : model.school.SCHOOL_NAME;
model.school.SCHOOL_PROVINCE = (model.school.SCHOOL_PROVINCE == null) ? -1 : model.school.SCHOOL_PROVINCE;
model.school.SCHOOL_PASSWORD = (model.school.SCHOOL_PASSWORD == null) ? "" : model.school.SCHOOL_PASSWORD;
model.school.SCHOOL_DOC_PATH = (model.school.SCHOOL_DOC_PATH == null) ? "" : model.school.SCHOOL_DOC_PATH;
model.school.SCHOOL_REGISTER_DATE = (model.school.SCHOOL_REGISTER_DATE == null) ? DateTime.Now : model.school.SCHOOL_REGISTER_DATE;
model.school.SCHOOL_EMAIL = (model.school.SCHOOL_EMAIL == null) ? "" : model.school.SCHOOL_EMAIL;
model.school.SCHOOL_CULTURE = ci.Name;
model.school.SCHOOL_ROUND = Convert.ToInt32(application.PROJECT_ROUND);
model.school.SCHOOL_TYPE = (model.idSelectedSchoolType == null) ? "" : model.idSelectedSchoolType;
model.school.SCHOOL_APPROVED_STATUS = 1; //Y=Approved,N=DisApproved
/* generate password*/
String generatedPassword = GeneratePassword.Generate(8);
model.school.SCHOOL_PASSWORD = generatedPassword; // MD5.md5(generatedPassword);
db.TB_APPLICATION_SCHOOL.Add(model.school);
db.SaveChanges();
/*
* STAFF
*/
if (model.Staffs != null)
{
foreach (TB_APPLICATION_STAFF staff in model.Staffs)
{
////VALIDATE NULL VALUE
staff.STAFF_SCHOOL_ID = model.school.SCHOOL_ID;
staff.STAFF_POSITION = (staff.STAFF_POSITION == null) ? 0 : staff.STAFF_POSITION;
staff.STAFF_NAME = (staff.STAFF_NAME == null) ? "" : staff.STAFF_NAME;
staff.STAFF_SURNAME = (staff.STAFF_SURNAME == null) ? "" : staff.STAFF_SURNAME;
staff.STAFF_PHONE = (staff.STAFF_PHONE == null) ? "" : staff.STAFF_PHONE;
staff.STAFF_TITLE_ID = (staff.STAFF_TITLE_ID == null) ? 0 : staff.STAFF_TITLE_ID;
staff.STAFF_FOR_LEVEL = (staff.STAFF_FOR_LEVEL == null) ? 0 : staff.STAFF_FOR_LEVEL;
if (!String.IsNullOrEmpty(staff.STAFF_NAME) && !String.IsNullOrEmpty(staff.STAFF_SURNAME))
{
staff.STAFF_SCHOOL_ID = model.school.SCHOOL_ID;
db.TB_APPLICATION_STAFF.Add(staff);
}
}
}
/*
* STUDENT
*/
if (model.Students != null)
{
foreach (TB_APPLICATION_STUDENT student in model.Students)
{
//VALIDATE NULL VALUE
student.STD_TITLE_ID = (student.STD_TITLE_ID == null) ? 0 : student.STD_TITLE_ID;
student.STD_NAME = (student.STD_NAME == null) ? "" : student.STD_NAME;
student.STD_SURNAME = (student.STD_SURNAME == null) ? "" : student.STD_SURNAME;
student.STD_LEVEL_ID = (student.STD_LEVEL_ID == null) ? 0 : student.STD_LEVEL_ID;
student.STD_SCHOOL_ID = model.school.SCHOOL_ID;
student.STD_PICTURE_PATH = (student.STD_PICTURE_PATH == null) ? "" : student.STD_PICTURE_PATH;
student.STD_PHONE = (student.STD_PHONE == null) ? "" : student.STD_PHONE;
student.STD_EMAIL = (student.STD_EMAIL == null) ? "" : student.STD_EMAIL;
student.STD_ID_CARD = (student.STD_ID_CARD == null) ? "" : student.STD_ID_CARD;
student.STD_PASSPORT_ID = (student.STD_PASSPORT_ID == null) ? "" : student.STD_PASSPORT_ID;
student.STD_GRADE = (student.STD_GRADE == null) ? 0 : student.STD_GRADE;
student.STD_PHONE_PROVIDER = (student.STD_PHONE_PROVIDER == null) ? "" : student.STD_PHONE_PROVIDER;
student.STD_APPROVED_STATUS = 1;
student.STD_IS_CONCERN = "0";
student.STD_NATION = student.STD_NATION;
student.STD_NATION_OTHER = student.STD_NATION_OTHER;
#region "CONCERN STUDENT."
bool isValidLevel = false;
int currentYear = DateTime.Now.Year;
if (!String.IsNullOrEmpty(student.STD_BIRTH_DAY))
{
currentYear = currentYear - Convert.ToInt16(student.STD_BIRTH_DAY.Split('-')[0]);
}
if (currentYear <= 9)
{
if (student.STD_LEVEL_ID == 1)
{
isValidLevel = true;;
}
}
else if (currentYear >= 10 && currentYear <= 12)
{
if (student.STD_LEVEL_ID == 2)
{
isValidLevel = true;
}
}
else if (currentYear >= 13 && currentYear <= 15)
{
if (student.STD_LEVEL_ID == 3)
{
isValidLevel = true;
}
}
else if (currentYear >= 16 && currentYear <= 18)
{
if (student.STD_LEVEL_ID == 4)
{
isValidLevel = true;
}
}
else
{
if (student.STD_LEVEL_ID == 5)
{
isValidLevel = true;
}
}
if (isValidLevel == false)
{
student.STD_IS_CONCERN = "1";
}
#endregion
if (!String.IsNullOrEmpty(student.STD_NAME) && !String.IsNullOrEmpty(student.STD_SURNAME))
{
db.TB_APPLICATION_STUDENT.Add(student);
}
}
}
db.SaveChanges();
//tran.Complete();
/* send email school account to user*/
if (!String.IsNullOrEmpty(model.school.SCHOOL_EMAIL))
{
if (Email.IsValidEmail(model.school.SCHOOL_EMAIL))
{
Email.SendEmail(model.school, generatedPassword, ci.Name);
}
else
{
logger.Debug(model.school.SCHOOL_ID + "," + model.school.SCHOOL_NAME + "invalid email format.");
}
}
else
{
logger.Debug(model.school.SCHOOL_ID + "," + model.school.SCHOOL_NAME + "no have email.");
}
}
else
{
return(View("Exception"));
}
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
errorMessage += string.Format("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage) + Environment.NewLine;
}
}
throw new Exception(errorMessage, dbEx);
}
//}
//}
ViewBag.UserName = model.school.SCHOOL_EMAIL;
ViewBag.Password = model.school.SCHOOL_PASSWORD;
ViewBag.PageContent = Resources.Application.Application.REGISTER_ITEM016;
return(View("Complete"));
}
public ActionResult Special(ProcessStudentModel model)
{
if (Session["USER"] == null)
{
return(RedirectToAction("../Account/ManagementLogin"));
}
ViewBag.ResultMsg = "";
using (ChinaPhet10Entities context = new ChinaPhet10Entities())
{
List <TB_APPLICATION_STUDENT> students = null;
var _result = from a in db.TB_APPLICATION_STUDENT
orderby a.STD_LEVEL_ID, a.STD_ID
select a;
var sitPlaned = from b in db.TB_STUDENT_SEAT select b.STUDENT_ID;
var stdCodes = from b in db.TB_STUDENT_SEAT orderby b.STUDENT_CODE ascending select b;
int lastLevel1 = 0;
int lastLevel2 = 0;
int lastLevel3 = 0;
int lastLevel4 = 0;
int lastLevel5 = 0;
lastLevel1 = getLastStudentCode(stdCodes.ToList(), 1);
lastLevel2 = getLastStudentCode(stdCodes.ToList(), 2);
lastLevel3 = getLastStudentCode(stdCodes.ToList(), 3);
lastLevel4 = getLastStudentCode(stdCodes.ToList(), 4);
lastLevel5 = getLastStudentCode(stdCodes.ToList(), 5);
//นำข้อมูลรายชื่อนักเรียนที่ยังไม่ได้จัดมาเก็บไว้ใน tmp
var tmp = from x in _result where !sitPlaned.Contains(x.STD_ID) orderby x.STD_LEVEL_ID, x.STD_ID select x;
students = tmp.ToList();
if (students.Count > 0)
{
var varRoom = from a in db.TB_ROOM where a.ROOM_FOR_LEVEL == 6 orderby a.ROOM_FOR_LEVEL, a.ROOM_ID select a;
List <TB_ROOM> rooms = varRoom.ToList();
if (rooms != null)
{
int studentIndex = 0;
String[] rowPrefix = { "A", "B", "C", "D", "E", "G", "H", "I", "J", "K", "L", "M", "N", "O", "P", "Q", "R", "S", "T", "U", "V", "W", "X", "Y", "Z" };
foreach (TB_ROOM room in rooms)
{
int sitIndex = 1;
String[] rows = room.ROOM_ROW.ToUpper().Split('X');
if (rows.Length == 2)
{
int col = Convert.ToInt16(rows[0]); //c
int row = Convert.ToInt16(rows[1]); //r
// 1. วนแต่ละแถวเพื่อเรียงลำดับเลขที่นั่งสอบ
for (int c = 0; c < col; c++)
{
int level = 0;
switch (c + 1)
{
case 1:
level = Convert.ToInt16(room.ROW_1);
break;
case 2:
level = Convert.ToInt16(room.ROW_2);
break;
case 3:
level = Convert.ToInt16(room.ROW_3);
break;
case 4:
level = Convert.ToInt16(room.ROW_4);
break;
case 5:
level = Convert.ToInt16(room.ROW_5);
break;
case 6:
level = Convert.ToInt16(room.ROW_6);
break;
case 7:
level = Convert.ToInt16(room.ROW_7);
break;
case 8:
level = Convert.ToInt16(room.ROW_8);
break;
case 9:
level = Convert.ToInt16(room.ROW_9);
break;
case 10:
level = Convert.ToInt16(room.ROW_10);
break;
case 11:
level = Convert.ToInt16(room.ROW_11);
break;
case 12:
level = Convert.ToInt16(room.ROW_12);
break;
}
for (int r = 0; r < row; r++)
{
if (studentIndex < students.Count)
{
if (level == students[studentIndex].STD_LEVEL_ID)
{
//get last index
logger.Debug(c + 1 + "," + r + "=" + students[studentIndex].STD_ID + "," + room.ROOM_NUMBER + "\n");
TB_STUDENT_SEAT ss = new TB_STUDENT_SEAT();
ss.STUDENT_ID = students[studentIndex].STD_ID;
switch (level)
{
case 1: ss.STUDENT_CODE = Convert.ToInt32(String.Format("{0}{1}", students[studentIndex].STD_LEVEL_ID, (lastLevel1 + sitIndex).ToString("0000")));
break;
case 2: ss.STUDENT_CODE = Convert.ToInt32(String.Format("{0}{1}", students[studentIndex].STD_LEVEL_ID, (lastLevel2 + sitIndex).ToString("0000")));
break;
case 3: ss.STUDENT_CODE = Convert.ToInt32(String.Format("{0}{1}", students[studentIndex].STD_LEVEL_ID, (lastLevel3 + sitIndex).ToString("0000")));
break;
case 4: ss.STUDENT_CODE = Convert.ToInt32(String.Format("{0}{1}", students[studentIndex].STD_LEVEL_ID, (lastLevel4 + sitIndex).ToString("0000")));
break;
case 5: ss.STUDENT_CODE = Convert.ToInt32(String.Format("{0}{1}", students[studentIndex].STD_LEVEL_ID, (lastLevel5 + sitIndex).ToString("0000")));
break;
}
ss.ROOM_ID = room.ROOM_ID;
ss.SIT_NUMBER_PREFIX = rowPrefix[c];
ss.SIT_NUMBER = (r + 1);
context.TB_STUDENT_SEAT.Add(ss);
}
else
{
continue;
}
}
sitIndex++;
studentIndex++;
}
}
}
else
{
logger.Debug(room.ROOM_NUMBER + ":ข้อมูล COLXROW ใน DB ของห้องไม่ถุกต้อง");
}
}
context.SaveChanges();
}
else
{
logger.Debug("ไม่พบข้อมุลห้องว่าง");
}
}
else
{
ViewBag.ResultMsg = "ไม่พบข้อมูลนักเรียนที่ยังไม่ได้ที่นั่งสอบ";
return(View(model));
}
}
ViewBag.ResultMsg = "ประมวลผลที่นั่งสอบเรียบร้อยแล้ว";
return(View(model));
}
private void Import_To_Grid(string FilePath, string Extension, string isHDR)
{
logger.Debug(String.Format("####### --- Begin Start Load File at {0} --- ####", DateTime.Now));
int rejected = 0;
List <TB_SCORE_ROUND_1> stdList = new List <TB_SCORE_ROUND_1>();
List <TB_EXAM_ABSENT> stdAppsentList = new List <TB_EXAM_ABSENT>();
List <TB_CONCERN> stdConcerntList = new List <TB_CONCERN>();
using (ChinaPhet10Entities context = new ChinaPhet10Entities())
{
context.Configuration.AutoDetectChangesEnabled = false;
using (CsvFileReader reader = new CsvFileReader(FilePath))
{
CsvRow row = new CsvRow();
while (reader.ReadRow(row))
{
try
{
int stdCode = ((row[0] == null) ? 0 : (row[0].Equals("")) ? 0 : Convert.ToInt32(row[0]));
if (!stdList.Any(x => x.STD_CODE == stdCode))
{
TB_SCORE_ROUND_1 round1 = new TB_SCORE_ROUND_1();
round1.STD_CODE = stdCode;
round1.ROUND_SCORE = ((row[1] == null) ? 0 : (row[1].Equals("")) ? 0 : Convert.ToInt32(row[1]));
round1.PRIZE_ID = 0;
stdList.Add(round1);
//บันทึกขาดสอบ
if (row[2].ToString().Equals("F") && round1.ROUND_SCORE == 0)
{
if (!stdAppsentList.Any(x => x.STD_CODE == stdCode))
{
TB_EXAM_ABSENT tb_exam_absent = new TB_EXAM_ABSENT();
tb_exam_absent.STD_CODE = stdCode;
stdAppsentList.Add(tb_exam_absent);
}
}
//สงสัยว่าผิดระดับชั้น
if (row[3].ToString().Equals("T"))
{
if (!stdConcerntList.Any(x => x.STD_CODE == stdCode))
{
TB_CONCERN concern = new TB_CONCERN();
concern.STD_CODE = stdCode;
stdConcerntList.Add(concern);
}
}
}
else
{
rejected++;
logger.Debug("Reject>>duplicate student code:" + stdCode);
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
}
}
//Begin Insert
foreach (TB_EXAM_ABSENT _val in stdAppsentList)
{
context.TB_EXAM_ABSENT.Add(_val);
}
context.SaveChanges();
foreach (TB_CONCERN _val in stdConcerntList)
{
context.TB_CONCERN.Add(_val);
}
context.SaveChanges();
int index = 1;
foreach (TB_SCORE_ROUND_1 _val in stdList)
{
context.TB_SCORE_ROUND_1.Add(_val);
index++;
if (index % 200 == 0)
{
context.SaveChanges();
}
}
context.SaveChanges();
}
logger.Debug("######## SUMMARY ########");
logger.Debug(String.Format("Total {0} (s),Reject {1} (s)>>>> Remain {2} (s)", stdList.Count, rejected, stdList.Count - rejected));
logger.Debug(String.Format("####### --- Finish Load File at {0} --- ####", DateTime.Now));
}
public ActionResult doProcessRound1(ScoreRound1Model model)
{
if (Session["USER"] == null)
{
return(RedirectToAction("../Account/ManagementLogin"));
}
int _levelId = Convert.ToInt16(model.studentLevel);
var items = from ss in db.TB_STUDENT_SEAT
join r in db.TB_SCORE_ROUND_1 on ss.STUDENT_CODE equals r.STD_CODE
join s in db.TB_APPLICATION_STUDENT on ss.STUDENT_ID equals s.STD_ID
where s.STD_LEVEL_ID == _levelId && s.STD_NATION != 2
orderby s.STD_LEVEL_ID ascending, r.ROUND_SCORE descending
select new
{
StdCode = ss.STUDENT_CODE,
Score = r.ROUND_SCORE,
StudentLevel = _levelId,
s.STD_NATION,
r.ROUND_SCORE
};
if (items != null)
{
StringBuilder sb = new StringBuilder();
int index = 1;
foreach (var item in items)
{
TB_SCORE_ROUND_1 sr = db.TB_SCORE_ROUND_1.Where(s => s.STD_CODE == item.StdCode).FirstOrDefault();
if (sr != null)
{
if (item.StudentLevel == 5)
{
//check condition
if (index >= 1 && index <= 10)
{
sr.PRIZE_ID = 1;//เข้ารอบเพชรยอดมงกุฏ
}
else if (index > 10 && index <= 20)
{
sr.PRIZE_ID = 2;//รางวัลชอมเชย
}
else
{
sr.PRIZE_ID = 4;
}
}
else
{
if (index >= 1 && index <= 10)
{
sr.PRIZE_ID = 1;//เข้ารอบเพชรยอดมงกุฏ
}
else if (index > 10 && index <= 50)
{
sr.PRIZE_ID = 2;//รางวัลชอมเชย
}
else if (index > 50 && index <= 100)
{
sr.PRIZE_ID = 3;//รางวัลผ่านเกณฑ์
}
else
{
sr.PRIZE_ID = 4;
}
}
index++;
if (index % 200 == 0)
{
db.SaveChanges();
}
}
}
db.SaveChanges();
}
ViewBag.ResultMsg = "ปรับคะแนน 100 อันดับ ระดับชั้นที่ " + model.studentLevel + " รอบเจียรไนเพชรเรียบร้อยแล้ว";
return(View("ProcessRound1"));
}
public ActionResult Index(ProcessStudentModel model)
{
if (Session["USER"] == null)
{
return(RedirectToAction("../Account/ManagementLogin"));
}
StringBuilder noRoomStd = new StringBuilder();
ViewBag.ResultMsg = "";
//int countOfCommittee = 0;
int countOfSuccess = 0;
//int countOfFail = 0;
using (ChinaPhet10Entities context = new ChinaPhet10Entities())
{
List <TB_APPLICATION_STUDENT> students = null;
int studentLevel = Convert.ToInt16(model.StudentLevel);
if (!String.IsNullOrWhiteSpace(model.StudentLevel))
{
var varStudent = from a in db.TB_APPLICATION_STUDENT where a.STD_LEVEL_ID == studentLevel && a.STD_APPROVED_STATUS == 3 orderby a.STD_LEVEL_ID, a.STD_ID select a;
students = varStudent.ToList();
}
if (students != null)
{
/*
* DELETE TB_STUDENT_SEAT BY LEVEL
*/
foreach (TB_APPLICATION_STUDENT std in students)
{
if (std.TB_STUDENT_SEAT != null)
{
TB_STUDENT_SEAT studentSeat = context.TB_STUDENT_SEAT.Where(s => s.STUDENT_CODE == std.TB_STUDENT_SEAT.STUDENT_CODE).FirstOrDefault();
context.TB_STUDENT_SEAT.Remove(studentSeat);
}
}
var varRoom = from a in db.TB_ROOM where a.ROOM_FOR_LEVEL == studentLevel orderby a.ROOM_FOR_LEVEL, a.ROOM_ID select a;
List <TB_ROOM> rooms = varRoom.ToList();
if (rooms != null)
{
int index = 0;
int studentIndex = 1;
int examSitIndex = 1;
int tmpLevel = Convert.ToInt16(rooms[0].ROOM_FOR_LEVEL);
String[] rowPrefix = { "A", "B", "C", "D", "E", "G", "H", "I", "J", "K", "L", "M", "N", "O", "P", "Q", "R", "S", "T", "U", "V", "W", "X", "Y", "Z" };
foreach (TB_ROOM room in rooms)
{
if (tmpLevel != room.ROOM_FOR_LEVEL)
{
studentIndex = 1;
examSitIndex = 1;
}
String[] rows = room.ROOM_ROW.ToUpper().Split('X');
if (rows.Length == 2)
{
int width = Convert.ToInt16(rows[0]);
int height = Convert.ToInt16(rows[1]);
// 1. วนแต่ละแถวเพื่อเรียงลำดับเลขที่นั่งสอบ
for (int w = 0; w < width; w++)
{
for (int h = 0; h < height; h++)
{
if (index < students.Count)
{
TB_STUDENT_SEAT ss = new TB_STUDENT_SEAT();
ss.STUDENT_ID = students[index].STD_ID;
ss.STUDENT_CODE = Convert.ToInt32(String.Format("{0}{1}", students[index].STD_LEVEL_ID, studentIndex.ToString("0000")));
ss.ROOM_ID = room.ROOM_ID;
ss.SIT_NUMBER_PREFIX = rowPrefix[w];
ss.SIT_NUMBER = (h + 1);//Convert.ToInt32(String.Format("{0}{1}", room.ROOM_FOR_LEVEL, examSitIndex.ToString("0000")));
context.TB_STUDENT_SEAT.Add(ss);
index++;
studentIndex++;
examSitIndex++;
countOfSuccess++;
}
else
{
Console.WriteLine("จำนวนคนไม่พอกับจำนวนห้อง !");
}
}
}
}
else
{
//generate row error.
Console.WriteLine();
}
}
}
context.SaveChanges();
}
}
List <TB_M_LEVEL> tbMLevel = db.TB_M_LEVEL.Where(l => l.LEVEL_ID > 0).ToList();
ViewBag.StudentLevel = new SelectList(tbMLevel, "LEVEL_ID", "LEVEL_NAME_TH", model.StudentLevel);
ViewBag.ResultMsg = "ประมวลผลที่นั่งสอบเรียบร้อยแล้ว";//+ ("จำนวนนักเรียนทั้งหมด " + students. + " คน <br> สำเร็จ " + countOfSuccess + " รายการ <br> ไม่สำเร็จ " + countOfFail + " รายการ)";
return(View(model));
}
private void Import_To_Grid(string FilePath, string Extension, string isHDR)
{
string conStr = "";
switch (Extension)
{
case ".xls": //Excel 97-03
conStr = ConfigurationManager.ConnectionStrings["Excel03ConString"].ConnectionString;
break;
case ".xlsx": //Excel 07
conStr = ConfigurationManager.ConnectionStrings["Excel07ConString"].ConnectionString;
break;
}
conStr = String.Format(conStr, FilePath, isHDR);
OleDbConnection connExcel = new OleDbConnection(conStr);
OleDbCommand cmdExcel = new OleDbCommand();
OleDbDataAdapter oda = new OleDbDataAdapter();
DataTable dt = new DataTable();
cmdExcel.Connection = connExcel;
//Get the name of First Sheet
connExcel.Open();
DataTable dtExcelSchema;
dtExcelSchema = connExcel.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
string SheetName = dtExcelSchema.Rows[0]["TABLE_NAME"].ToString();
connExcel.Close();
//Read Data from First Sheet
connExcel.Open();
cmdExcel.CommandText = "SELECT * From [" + SheetName + "]";
oda.SelectCommand = cmdExcel;
oda.Fill(dt);
//String xx = dt.Rows[0][0].ToString();
using (ChinaPhet10Entities context = new ChinaPhet10Entities())
{
//context.TB_COMMITEE.ToList().ForEach(context.TB_COMMITEE);
foreach (TB_COMMITEE deleteCmt in context.TB_COMMITEE.ToList())
{
context.TB_COMMITEE.Remove(deleteCmt);
}
for (int i = 1; i < dt.Rows.Count; i++)
{
TB_COMMITEE commitee = new TB_COMMITEE();
commitee.COMMITEE_TITLE_ID = 0;
commitee.COMMITEE_NAME = dt.Rows[i][1].ToString();
commitee.COMMITEE_SURNAME = dt.Rows[i][2].ToString();
commitee.COMMITEE_PHONE = dt.Rows[i][3].ToString();
commitee.COMMITEE_STATUS = dt.Rows[i][4].ToString();
context.TB_COMMITEE.Add(commitee);
}
context.SaveChanges();
}
connExcel.Close();
//Bind Data to GridView
//GridView1.Caption = Path.GetFileName(FilePath);
//GridView1.DataSource = dt;
//GridView1.DataBind();
}
//
// GET: /ExamAbsent/
public ActionResult Index(Round1ReportModelCriteria _model)
{
if (Session["USER"] == null)
{
return(RedirectToAction("../Account/ManagementLogin"));
}
List <TB_APPLICATION_STUDENT> studentLists = db.TB_APPLICATION_STUDENT.Where(s => s.STD_SCHOOL_ID == _model.id).OrderBy(s => s.STD_ID).ToList();
if (studentLists != null)
{
if (studentLists.Count > 0)
{
if (_model.action.Equals("บันทึก"))
{
//ล้างข้อมูลเก่าออก
foreach (TB_APPLICATION_STUDENT std in studentLists)
{
TB_EXAM_ABSENT studentSeat = db.TB_EXAM_ABSENT.Where(s => s.STD_CODE == std.TB_STUDENT_SEAT.STUDENT_CODE).FirstOrDefault();
if (studentSeat != null)
{
db.TB_EXAM_ABSENT.Remove(studentSeat);
}
}
//บันทึกเด็กที่ขาดใหม่
foreach (String id in _model.SelectedStudentIDs)
{
int absentId = Convert.ToInt32(id);
TB_EXAM_ABSENT tb_exam_absent = new TB_EXAM_ABSENT();
tb_exam_absent.STD_CODE = absentId;
db.TB_EXAM_ABSENT.Add(tb_exam_absent);
}
db.SaveChanges();
}
List <Round1Report01Model> lists = new List <Round1Report01Model>();
int seq = 1;
foreach (TB_APPLICATION_STUDENT std in studentLists)
{
if (std.TB_STUDENT_SEAT == null)
{
ViewBag.ResultMsg = "ยังไม่ได้จัดผังสอบ ไม่สามารถทำรายการได้!";
return(RedirectToAction("../Management/SchoolList"));
//return View("Management/SchoolList");
}
Round1Report01Model rpt = new Round1Report01Model();
rpt.seq = seq;
rpt.studentCode = std.TB_STUDENT_SEAT.STUDENT_CODE + "";
rpt.studentFullName = std.TB_M_TITLE.TITLE_NAME_TH + std.STD_NAME + " " + std.STD_SURNAME;
rpt.schoolName = std.TB_APPLICATION_SCHOOL.SCHOOL_NAME;
rpt.remark = "";
seq++;
lists.Add(rpt);
}
List <String> absentStudents = new List <string>();
foreach (TB_EXAM_ABSENT exam in db.TB_EXAM_ABSENT.ToList())
{
absentStudents.Add(exam.STD_CODE + "");
}
if (lists != null)
{
var pageIndex = _model.Page ?? 1;
_model.reports = lists.ToPagedList(pageIndex, 50);
_model.SelectedStudentIDs = absentStudents;
}
}
}
return(View(_model));
}
