public ActionResult LoggedIn(RecordEntityModel mod) { ;; HttpContext.Response.Cookies.Add(new System.Web.HttpCookie("LoginCookie", mod.Fname + " " + " " + mod.Lname)); HttpContext.Response.Cookies.Get("LoginCookie").Expires.AddDays(3); return(View(mod)); }
public ActionResult Register(RecordEntityModel model) { if (ModelState.IsValid) { RecordManager.CreateDBEntry(model.Fname, model.Lname, model.Phone); return(RedirectToAction("Users")); } return(View()); }
public ActionResult Update(RecordEntityModel model) { var saveResult = RecordManager.UpdateRecordInDB(model); return(RedirectToRoute(RouteNames.RecordUsers)); /* ViewBag.ErrorMessage = saveResult.Message; * return View(model);*/ }
public ResultModel <RecordEntityModel> SaveRecord(RecordEntityModel model) { var result = new ResultModel <RecordEntityModel> { value = model }; try { if (string.IsNullOrEmpty(model.Fname)) { result.Message = "Field First name cannot be left empty!"; throw new Exception(); } if (string.IsNullOrEmpty(model.Lname)) { result.Message = "Field Last name cannot be left empty!"; throw new Exception(); } if (string.IsNullOrEmpty(model.Phone)) { result.Message = "Field Phone cannot be left empty!"; throw new Exception(); } if (string.IsNullOrEmpty(model.Password)) { result.Message = ""; throw new Exception("Field Password cannot be left empty!"); } if (!string.IsNullOrEmpty(model.Phone)) { if (RecordManager.LoadRecords().Any(i => i.Phone == model.Phone)) { var findRecordModel = RecordList.Mlist.FirstOrDefault(x => x.Phone == model.Phone); findRecordModel.Fname = model.Fname; findRecordModel.Lname = model.Lname; findRecordModel.Phone = model.Phone; findRecordModel.Password = model.Password; } else { result.Message = "User with specified phone number doesn't exist"; throw new Exception(); } } else { RecordList.Mlist.Add(model); } result.isSuccess = true; } catch (Exception ex) { result.Message = ex.Message; } return(result); }
static public ResultModel <RecordEntityModel> UpdateRecordInDB(RecordEntityModel model) { ResultModel <RecordEntityModel> result = new ResultModel <RecordEntityModel>(); string sql = @"UPDATE dbo.Table1 SET Fname='" + model.Fname + "', Lname = '" + model.Lname + "', Phone = '" + model.Phone + "' WHERE Phone = cast(" + model.Phone + "as BIGINT)"; SqlDataAccess.SaveData <RecordEntityModel>(sql, null); return(new ResultModel <RecordEntityModel> { isSuccess = true }); }
public ActionResult Login(RecordEntityModel model) { var result = RecordManager.GetRecordFromDB(model.Phone); if (result.isSuccess) { return(RedirectToAction("LoggedIn", result.value)); } else { return(RedirectToAction("Login")); } }
public static int CreateDBEntry(string fn, string ln, string ph) { RecordEntityModel data = new RecordEntityModel { Fname = fn, Lname = ln, Phone = ph }; string sql = @"insert into dbo.Table1(Fname,Lname,Phone) values(@Fname,@Lname,@Phone);"; return(SqlDataAccess.SaveData(sql, data)); }
public ResultModel <RecordEntityModel> AddRecord(RecordEntityModel rem) { ResultModel <RecordEntityModel> result = new ResultModel <RecordEntityModel> { value = rem }; try { if (string.IsNullOrEmpty(rem.Fname)) { result.Message = "Field First name cannot be left empty!"; throw new Exception(); } if (string.IsNullOrEmpty(rem.Lname)) { result.Message = "Field Last name cannot be left empty!"; throw new Exception(); } if (string.IsNullOrEmpty(rem.Phone)) { result.Message = "Field Phone cannot be left empty!"; throw new Exception(); } if (string.IsNullOrEmpty(rem.Password)) { result.Message = "Field Password cannot be left empty!"; throw new Exception(); } if (RecordList.Mlist.Any(i => i.Phone == rem.Phone)) { result.Message = "The user with that Phone number exists already!"; throw new Exception(); } RecordList.Mlist.Add(rem); result.isSuccess = true; } catch (Exception) { } return(result); }