public dynamic GetProfile(string card_track) { card_track = card_track.Replace("%", "").Replace("?", ""); card_track = Regex.Replace(card_track, "[^0-9A-Za-z]+", ""); try { CMSDBDataContext db2 = new CMSDBDataContext(); CardTrace trace = new CardTrace(); trace.CardTrace1 = card_track; trace.CustomerFullName = "TELLER 01"; trace.CardNumber = "1234679"; db2.CardTraces.InsertOnSubmit(trace); db2.SubmitChanges(); } catch { } var user = (from e in db.Users where e.CardID.Equals(card_track) select e).SingleOrDefault(); if (user == null) { //card_track = "00187"; //user = (from e in db.Users where e.CardID.Equals(card_track) select e).SingleOrDefault(); return(null); } var profile_info = new { Id = user.UserId, FullName = user.FullName, Counter = "Counter 1", CardId = card_track }; return(profile_info); }
public JsonResult CashIn(string card_id, string profile_id, long amount, string note) { dynamic balance = Helper.GetAccountInfo(card_id); dynamic result = Helper.CashIn(profile_id, amount); CardActionLog log = new CardActionLog(); log.ActionAt = "backend"; log.ActionBy = User.Identity.Name; log.ActionCode = "CASHIN"; log.ActionTime = DateTime.Now; log.Amount = amount; log.CardId = profile_id; log.StartBalance = balance.available_balance; log.Note = note; if (result.error_code.ToString() == "00") { balance = Helper.GetAccountInfo(card_id); log.EndBalance = balance.available_balance; CMSDBDataContext db = new CMSDBDataContext(); Card card = (from c in db.Cards where c.CustomerCIF.Equals(card_id) select c).Single(); card.Balance = decimal.Parse("0" + log.EndBalance.ToString()); db.CardActionLogs.InsertOnSubmit(log); db.SubmitChanges(); } return(Json(new { error_code = result.error_code, error_message = result.error_message }, JsonRequestBehavior.AllowGet)); }
public dynamic[] GetLogActions(string card_id, int last_number) { try { CMSDBDataContext db = new CMSDBDataContext(); var list = (from e in db.CardActionLogs orderby e.ActionTime descending select(new { ActionTime = e.ActionTime, ActionCode = e.ActionCode, ActionBy = e.ActionBy, Note = e.Note, CardId = e.CardId, CardNumber = e.Card.CardNumber, StartBalance = e.StartBalance, EndBalance = e.EndBalance, Amount = e.Amount })).Take(last_number).ToArray(); return(list); } catch { return(null); } }
public eWalletController() { if (db == null) { db = new CMSDBDataContext(); } }
public string GetLogAction(string card_id, string start_balance, string end_balance, string reference_id, string amount, string action_code, string action_by, string action_at, string note) { try { using (CMSDBDataContext db = new CMSDBDataContext()) { CardActionLog log = new CardActionLog(); log.ActionBy = action_by; log.ActionCode = action_code; log.ActionTime = DateTime.Now; log.CardId = card_id; log.Note = note; log.ActionAt = action_at; log.StartBalance = long.Parse("0" + start_balance); log.EndBalance = long.Parse("0" + end_balance); log.Amount = long.Parse("0" + amount); log.ReferenceID = reference_id; db.CardActionLogs.InsertOnSubmit(log); try { Card card = (from c in db.Cards where c.CardId.Equals(card_id) select c).Single(); card.Balance = decimal.Parse("0" + end_balance); } catch { } db.SubmitChanges(); return("OK"); } } catch { return(String.Empty); } }
public ActionResult ChangeLock(string card_id) { //var id = new ObjectId(_id); dynamic user = Helper.DataHelper.Get("users", Query.EQ("UserName", card_id)); ViewBag.Action = (user.Status == "LOCKED") ? "Mở khóa" : "Khóa"; user.Status = (user.Status == "LOCKED") ? "ACTIVED" : "LOCKED"; CMSDBDataContext db = new CMSDBDataContext(); var card = (from element in db.Cards where element.CardId.Equals(card_id) select element).SingleOrDefault(); if (card != null) { card.IsLockout = (user.Status == "LOCKED") ? true : false; db.SubmitChanges(); db.Dispose(); } Helper.DataHelper.SaveUpdate("users", user); return(View()); }
public string GetActive(string card_id, string full_name, string customer_cif) { using (CMSDBDataContext db = new CMSDBDataContext()) { var card_info = (from e in db.Cards where e.CardId.Equals(card_id) select e).Single(); if (card_info == null) { return(String.Empty); } card_info.CardOwnerName = full_name; card_info.CustomerCIF = customer_cif; card_info.ActivedDate = DateTime.Now; card_info.Valid = card_info.ActivedDate; card_info.Expire = ((DateTime)card_info.ActivedDate).AddMonths(6); card_info.IsActived = true; db.SubmitChanges(); return("OK"); } }
public JsonResult UpdateProfile(string profile_id, string full_name, string mobile, string email, string address, string physical_id) { try { dynamic profile_info = Helper.DataHelper.Get("profile", Query.EQ("_id", long.Parse(profile_id))); profile_info.full_name = full_name; profile_info.mobile = mobile; profile_info.email = email; profile_info.address = address; profile_info.personal_id = physical_id; Helper.DataHelper.Save("profile", profile_info); CMSDBDataContext db = new CMSDBDataContext(); Card card = (from e in db.Cards where e.CustomerCIF.Equals(profile_id) select e).SingleOrDefault(); card.CardOwnerName = full_name; db.SubmitChanges(); return(Json(new { error_code = "00", error_message = "Cập nhật thành công" }, JsonRequestBehavior.AllowGet)); } catch { return(Json(new { error_code = "96", error_message = "Cập nhật không thành công" }, JsonRequestBehavior.AllowGet)); } }
public string GetUpdateProfile(string profile_id, string full_name, string mobile, string email, string address, string physical_id, int Pin) { try { dynamic profile_info = Helper.DataHelper.Get("profile", Query.EQ("_id", long.Parse(profile_id))); profile_info.full_name = full_name; profile_info.mobile = mobile; profile_info.email = email; profile_info.address = address; profile_info.personal_id = physical_id; Helper.DataHelper.Save("profile", profile_info); CMSDBDataContext db = new CMSDBDataContext(); Card card = (from e in db.Cards where e.CustomerCIF.Equals(profile_id) select e).SingleOrDefault(); card.CardOwnerName = full_name; db.SubmitChanges(); return("OK"); } catch { return(String.Empty); } }