public ActionResult DeleteConfirmed(int id)
{
Entities.Admin admin = db.Admin.Find(id);
db.Admin.Remove(admin);
db.SaveChanges();
return(RedirectToAction("Index"));
}
/// <summary>
/// 添加管理员
/// </summary>
/// <param name="usr"></param>
/// <returns></returns>
public static bool AddAdmin(Entities.Admin usr)
{
if (!CheckAdminExist(usr.PhoneNumber))
{
string cmdline = @"INSERT INTO [dbo].[Admin]
([Id]
,[Active]
,[UserName]
,[PhoneNumber]
,[PasswordHash]
,[RoleId]
,[CreateTime])
VALUES
(@id,@status,@username,@phone,@password,@roleid,@createtime)";
SqlParameter[] parameters =
{
new SqlParameter("@id", usr.Id),
new SqlParameter("@status", usr.Active),
new SqlParameter("@username", usr.UserName),
new SqlParameter("@phone", usr.PhoneNumber),
new SqlParameter("@password", usr.PasswordHash),
new SqlParameter("@roleid", usr.RoleId),
new SqlParameter("@createtime", usr.CreateTime),
};
return(SqlHelper.ExecuteNonQuery(cmdline, parameters));
}
return(false);
}
public ActionResult Edit(Entities.Admin admin)
{
if (ModelState.IsValid)
{
db.Entry(admin).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(admin));
}
public ActionResult Create(Entities.Admin admin)
{
if (ModelState.IsValid)
{
admin.EklenmeTarihi = DateTime.Now;
db.Admin.Add(admin);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(admin));
}
public ActionResult Login(Entities.Admin admin)
{
if (ModelState.IsValid)
{
var yonetici = db.Admin.FirstOrDefault(s => s.Mail == admin.Mail && s.Sifre == admin.Sifre);
if (yonetici != null)
{
Session["yonetici"] = yonetici;
return(Redirect("/Admin"));
}
}
return(View(admin));
}
// GET: Admin/Yonetici/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Entities.Admin admin = db.Admin.Find(id);
if (admin == null)
{
return(HttpNotFound());
}
return(View(admin));
}
/// <summary>
/// 更新管理员账户信息
/// </summary>
/// <param name="usr"></param>
/// <returns></returns>
public static bool UpdateAdminProfile(Entities.Admin usr)
{
string cmdline = @"UPDATE [dbo].[Admin]
SET [UserName] = @username
,[PhoneNumber] = @phone
,[RoleId] = @roleid
WHERE [Id] = @id";
SqlParameter[] parameters =
{
new SqlParameter("@username", usr.UserName),
new SqlParameter("@phone", usr.PhoneNumber),
new SqlParameter("@roleid", usr.RoleId),
new SqlParameter("@id", usr.Id)
};
return(SqlHelper.ExecuteNonQuery(cmdline, parameters));
}
public void UpdateSingle(Entities.Admin admin)
{
throw new NotImplementedException();
}
public bool UpdateAdminProfile([FromBody] Entities.Admin usr)
{
return(AdminHandler.UpdateAdminProfile(usr));
}
public bool AddAdmin([FromBody] Entities.Admin usr)
{
return(AdminHandler.AddAdmin(usr));
}
