public ActionResult Edit(string id) { CDbContext dc = new CDbContext(); var depobj = dc.departments.Where(a => a.id.Equals(id)).FirstOrDefault(); if (depobj != null) { return(View(depobj)); } else { ModelState.AddModelError("", "無此部門資料"); ViewBag.error = "無此部門資料"; return(View("Error")); } //SqlHelper hp = new SqlHelper(); //DataTable tb = hp.Sql2Table("select id,cname from dep where id=" + id); //department dep = new department(); //dep.id = tb.Rows[0]["id"].ToString(); //dep.departmentName = tb.Rows[0]["cname"].ToString(); //return View(dep); }
//[Authorize(Roles = "superadmin,admin")] // authenication public ActionResult Department() { CDbContext dc = new CDbContext(); var dlist = dc.departments.ToList <department>(); return(View(dlist)); //改為從資料庫讀取部門資料,一筆一筆建立Department物件存入departmentlist //List<department> departmentlist = new List<department>(); //SqlHelper hp = new SqlHelper(); //DataTable tb = hp.Sql2Table("select id,cname from dep"); //department depobj; //foreach(DataRow r in tb.Rows) //{ // depobj = new department(); // depobj.id = r["id"].ToString(); // depobj.departmentName = r["cname"].ToString(); // departmentlist.Add(depobj); //} //return View(departmentlist); }
public ActionResult Register(CRegisterViewModel model) { if (ModelState.IsValid) { try { //throw new Exception("我自訂錯誤"); CDbContext dc = new CDbContext(); CUser u = new CUser(); u.userid = model.Username; u.pwd = model.Password; dc.users.Add(u); dc.SaveChanges(); return(RedirectToAction("Login", "CAccount")); } catch (Exception ex) { ModelState.AddModelError("", ex.Message); return(View(model)); } } return(View()); }
public ActionResult Login(CLoginViewModel model, string ReturnUrl = "") { if (!ModelState.IsValid) { return(View(model)); } //string base64Password = Convert.ToBase64String(Encoding.UTF8.GetBytes(Password)); using (CDbContext dc = new CDbContext()) { var userlist = dc.users.ToList <CUser>(); var user = dc.users.Where( a => a.userid.Equals(model.Username) && a.pwd.Equals(model.Password)).FirstOrDefault(); if (user != null) { FormsAuthentication.SetAuthCookie(user.userid, model.RememberMe); //FormsIdentity id=HttpContext.User. //FormsAuthenticationTicket ticket = new FormsAuthenticationTicket() if (Url.IsLocalUrl(ReturnUrl)) { return(Redirect(ReturnUrl)); } else { return(RedirectToAction("Index", "Home")); } } else { ModelState.AddModelError("", "無此帳號或密碼錯誤"); return(View(model)); } } ModelState.Remove("Password"); //var userstore=new users return(View()); }
public ActionResult Login(CLoginViewModel model,string ReturnUrl="") { if (!ModelState.IsValid) { return View(model); } //string base64Password = Convert.ToBase64String(Encoding.UTF8.GetBytes(Password)); using (CDbContext dc=new CDbContext()) { var userlist = dc.users.ToList<CUser>(); var user = dc.users.Where( a => a.userid.Equals(model.Username) && a.pwd.Equals(model.Password)).FirstOrDefault(); if (user!=null) { FormsAuthentication.SetAuthCookie(user.userid, model.RememberMe); //FormsIdentity id=HttpContext.User. //FormsAuthenticationTicket ticket = new FormsAuthenticationTicket() if (Url.IsLocalUrl(ReturnUrl)) { return Redirect(ReturnUrl); } else { return RedirectToAction("Index", "Home"); } } else { ModelState.AddModelError("","無此帳號或密碼錯誤"); return View(model); } } ModelState.Remove("Password"); //var userstore=new users return View(); }
public string test() { CDbContext dc = new CDbContext(); var userlist = dc.users.ToList <CUser>(); string r = ""; foreach (CUser u in userlist) { r += u.userid + "</br>"; } return(r); //CDbContext dc = new CDbContext(); //CUser u=new CUser{userid="Mary",pwd="1234"}; //dc.users.Add(u); //dc.SaveChanges(); //return u.id.ToString(); }
//[Authorize(Roles = "superadmin,admin")] // authenication public ActionResult Department() { CDbContext dc = new CDbContext(); var dlist = dc.departments.ToList<department>(); return View(dlist); //改為從資料庫讀取部門資料,一筆一筆建立Department物件存入departmentlist //List<department> departmentlist = new List<department>(); //SqlHelper hp = new SqlHelper(); //DataTable tb = hp.Sql2Table("select id,cname from dep"); //department depobj; //foreach(DataRow r in tb.Rows) //{ // depobj = new department(); // depobj.id = r["id"].ToString(); // depobj.departmentName = r["cname"].ToString(); // departmentlist.Add(depobj); //} //return View(departmentlist); }
public ActionResult Edit(string id) { CDbContext dc = new CDbContext(); var depobj=dc.departments.Where(a => a.id.Equals(id)).FirstOrDefault(); if (depobj !=null) { return View(depobj); } else { ModelState.AddModelError("", "無此部門資料"); ViewBag.error = "無此部門資料"; return View("Error"); } //SqlHelper hp = new SqlHelper(); //DataTable tb = hp.Sql2Table("select id,cname from dep where id=" + id); //department dep = new department(); //dep.id = tb.Rows[0]["id"].ToString(); //dep.departmentName = tb.Rows[0]["cname"].ToString(); //return View(dep); }
public ActionResult Register(CRegisterViewModel model) { if (ModelState.IsValid) { try { //throw new Exception("我自訂錯誤"); CDbContext dc = new CDbContext(); CUser u = new CUser(); u.userid = model.Username; u.pwd = model.Password; dc.users.Add(u); dc.SaveChanges(); return RedirectToAction("Login", "CAccount"); } catch (Exception ex) { ModelState.AddModelError("", ex.Message); return View(model); } } return View(); }
public UserLoginRepository(CDbContext context) : base(context) { _context = context; _dbSet = context.Set <TEntity>(); }
public EquipmentCategoryRepository(CDbContext context) : base(context) { _context = context; _dbSet = context.Set <TEntity>(); }
public ApproveGroupRepository(CDbContext context) : base(context) { _context = context; _dbSet = context.Set <TEntity>(); }
public GameController(CDbContext context) { this.context = context; }
public Repository(CDbContext context) { _context = context; _dbSet = context.Set <TEntity>(); }
public EmployeeRepository(CDbContext context) : base(context) { _context = context; _dbSet = context.Set <TEntity>(); }
public string test() { CDbContext dc = new CDbContext(); var userlist = dc.users.ToList<CUser>(); string r = ""; foreach(CUser u in userlist) { r += u.userid + "</br>"; } return r; //CDbContext dc = new CDbContext(); //CUser u=new CUser{userid="Mary",pwd="1234"}; //dc.users.Add(u); //dc.SaveChanges(); //return u.id.ToString(); }
public ContractorRepository(CDbContext context) : base(context) { _context = context; _dbSet = context.Set <TEntity>(); }
public RequestHeaderRepository(CDbContext context) : base(context) { _context = context; _dbSet = context.Set <TEntity>(); }
public AddressRepository(CDbContext context) : base(context) { _context = context; _dbSet = context.Set <TEntity>(); }