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>();
}
