public ActionResult InsertNewAccount() { DateTime dt = DateTime.Now; try { ANYID_DATA_ITMX item = new ANYID_DATA_ITMX(); item.PROXY_TYPE = Request.Form["ITMXProxyType"]; item.PROXY_VALUE = (item.PROXY_TYPE == "MSISDN") ? "+66" + Request.Form["ITMXProxyValue"].Substring(1, Request.Form["ITMXProxyValue"].Length - 1) : Request.Form["ITMXProxyValue"]; item.ACCOUNT_TYPE = "DUMMY"; item.ACCOUNT_NUMBER = Request.Form["AccountNumber"]; // Bank Code + เลขบัญชี Dummy item.ACCOUNT_NAME = Request.Form["ITMXAcctName"]; item.DISPLAY_NAME = Request.Form["ITMXDisplayName"]; item.PERSON_FIRSTNAME = Request.Form["ITMXFirstName"]; item.PERSON_LASTNAME = Request.Form["ITMXSecondName"]; item.PERSON_LASTNAME = Request.Form["ITMXLastName"]; item.BUSINESS_NAME = Request.Form["ITMXBusinessName"]; if (Request.Form["ITMXBusinessRegisterDate"] != "") { item.BUSINESS_REGISTERED_DATE = DateTime.ParseExact(Convert.ToString(Request.Form["ITMXBusinessRegisterDate"]), "dd-MM-yyyy", CultureInfo.InvariantCulture); } item.CREATED_DATE = dt; item.CREATED_USER = Convert.ToString(Session["UserID"]); /* ดึงจาก Session*/ item.REGISTRATION_STATUS = "Active"; using (OracleContext db = new OracleContext()) { var QueryHaveDataInAnyID = from st in db.ANYID_DATA_ITMX where st.PROXY_TYPE == item.PROXY_TYPE && st.PROXY_VALUE == item.PROXY_VALUE select st; int CountHaveDataInAnyID = QueryHaveDataInAnyID.Count(); var QueryRegis3Mobile = from m in db.ANYID_DATA_ITMX where m.ACCOUNT_NUMBER == item.ACCOUNT_NUMBER && m.PROXY_TYPE == "MSISDN" select m; int CountRegis3Mobile = QueryRegis3Mobile.Count(); if (CountHaveDataInAnyID == 0 && CountRegis3Mobile < 3) { db.AddToANYID_DATA_ITMX(item); db.SaveChanges(); /**** Log *****/ RegisterModel.LogsInsert(dt, null, item); /**** !Log *****/ TempData["Notify"] = Constants.NotifyTrue.ToString(); TempData["Class"] = Constants.ClassSuccess.ToString(); TempData["Message"] = Constants.MsgSaveSuccess.ToString(); } else { TempData["Notify"] = Constants.NotifyTrue.ToString(); TempData["Class"] = Constants.ClassError.ToString(); TempData["Message"] = (CountRegis3Mobile >= 3) ? Convert.ToString(Constants.MsgMoreLimit) : Convert.ToString(Constants.MsgHaveData); } return(RedirectToAction("Index")); } } catch (Exception e) { TempData["Notify"] = Constants.NotifyTrue.ToString(); TempData["Class"] = Constants.ClassError.ToString(); TempData["Message"] = Constants.MsgError.ToString(); log.Error(CommonHelper.ErrMsg(e)); return(RedirectToAction("Index")); } }