public JsonResult CheckLogin(string uname, string pwd) { bool result = true; ///* CHECK USER ACCOUNT */ var _school = from s in db.TB_APPLICATION_SCHOOL where s.SCHOOL_EMAIL == uname && s.SCHOOL_PASSWORD == pwd select s; if (_school == null) { result = false; } else { TB_APPLICATION application = db.TB_APPLICATION.FirstOrDefault(); TB_APPLICATION_SCHOOL school = _school.FirstOrDefault(); if (school != null) { result = true; Session["Phet10School"] = (TB_APPLICATION_SCHOOL)school; Session["TB_APPLICATION"] = application; FormsAuthentication.SetAuthCookie(school.SCHOOL_NAME + " (" + uname + ")", true); } else { result = false; } } return(Json(new { Success = result, responseText = "" })); }
public ActionResult Index() { if (Session["Phet10School"] == null) { Session["Phet10School"] = null; FormsAuthentication.SignOut(); } if (Session["TB_APPLICATION"] == null) { Boolean isInRegisterPeriod = false; Boolean isAnnounceDate = false; TB_APPLICATION app = db.TB_APPLICATION.FirstOrDefault(); if (app != null) { int startAppDate = Convert.ToInt32(Convert.ToDateTime(app.PROJECT_REGISTER_START).ToString("yyyyMMdd")); int endAppDate = Convert.ToInt32(Convert.ToDateTime(app.PROJECT_REGISTER_END).ToString("yyyyMMdd")); int announceDate = Convert.ToInt32(Convert.ToDateTime(app.PROJECT_ANNOUNCE_DATE).ToString("yyyyMMdd")); int curDate = CommonUtils.getCurrentDateInt(); if (curDate >= startAppDate && curDate <= endAppDate) { isInRegisterPeriod = true; } if (curDate >= announceDate) { isAnnounceDate = true; } } /* * ตรวจสอบสิ้นสุดระยะเวลารับสมัคร */ Session["isInRegisterPeriod"] = isInRegisterPeriod; /* * ตรวจสอบสามารถกดเมนู "พิมพ์เอกสารยืนยัน" * ตรวจสอบสามารถกดเมนู "ประกาศเลขที่นั่งสอบ * ตรวจสอบสามารถกดเมนู "ประกาศห้องสอบ * ตรวจสอบสามารถกดเมนู "ประกาศผลการแข่งขัน */ Session["isAnnounceDate"] = isAnnounceDate; Session["PROJECT_IS_ANNOUNCE_ROUND1"] = (app.PROJECT_IS_ANNOUNCE_ROUND1 == 1)? "1":"0"; Session["PROJECT_IS_ANNOUNCE_ROUND2"] = (app.PROJECT_IS_ANNOUNCE_ROUND2 == 1)? "1":"0"; } ViewBag.PageContent = "คำนิยม"; return(View("Index")); }
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")); }