public static bool LogsInsert(DateTime dt, ANYID_DATA_CBS rsCBS, ANYID_DATA_ITMX rsITMX) { try { ANYID_LOGS rsLog = new ANYID_LOGS(); if (rsCBS != null) { rsLog.LOG_ACTION = "SEARCH"; rsLog.LOG_DATA = JsonConvert.SerializeObject(rsCBS); } if (rsITMX != null) { rsLog.LOG_ACTION = "INSERT"; rsLog.LOG_DATA = JsonConvert.SerializeObject(rsITMX); } rsLog.CREATED_DATE = dt; rsLog.CREATED_USER = Convert.ToString(HttpContext.Current.Session["UserID"]); /* ดึงจาก Session*/ rsLog.CREATED_SOL = Convert.ToString(HttpContext.Current.Session["SolID"]); /* ดึงจาก Session*/ using (OracleContext db = new OracleContext()) { db.AddToANYID_LOGS(rsLog); db.SaveChanges(); return(true); } } catch (Exception e) { log.Error(CommonHelper.ErrMsg(e)); return(false); } }
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")); } }