public async Task <ActionResult> DeleteConfirmed(string id)
{
EMPLOYEES_COFFEE eMPLOYEES_COFFEE = await db.EMPLOYEES_COFFEE.FindAsync(id);
db.EMPLOYEES_COFFEE.Remove(eMPLOYEES_COFFEE);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public async Task <ActionResult> Edit([Bind(Include = "EMP_ID,EMP_FIRSTNAME,EMP_LASTNAME,ADDRESS,SALARY,HIRE_DATE,END_DATE,EMP_USERNAME,EMP_PASSWORD,DEPT_ID")] EMPLOYEES_COFFEE eMPLOYEES_COFFEE)
{
if (ModelState.IsValid)
{
db.Entry(eMPLOYEES_COFFEE).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.DEPT_ID = new SelectList(db.DEPARTMENTS, "DEP_ID", "DEP_NAME", eMPLOYEES_COFFEE.DEPT_ID);
ViewBag.EMP_ID = new SelectList(db.EMP_HISTORY, "EMP_ID", "EMP_START_TIME", eMPLOYEES_COFFEE.EMP_ID);
return(View(eMPLOYEES_COFFEE));
}
// GET: EMPLOYEES_COFFEE/Details/5
public async Task <ActionResult> Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EMPLOYEES_COFFEE eMPLOYEES_COFFEE = await db.EMPLOYEES_COFFEE.FindAsync(id);
if (eMPLOYEES_COFFEE == null)
{
return(HttpNotFound());
}
return(View(eMPLOYEES_COFFEE));
}
public ActionResult Login(EMPLOYEES_COFFEE objUser)
{
using (Entities1 db = new Entities1())
{
var obj = db.EMPLOYEES_COFFEE.Where(a => a.EMP_USERNAME.Equals(objUser.EMP_USERNAME) && a.EMP_PASSWORD.Equals(objUser.EMP_PASSWORD)).FirstOrDefault();
if (obj != null)
{
Session["UserID"] = obj.EMP_ID.ToString();
Session["UserName"] = obj.EMP_USERNAME.ToString();
return(RedirectToAction("Dash"));
}
ModelState.AddModelError("", "Username or Password is wrong!");
}
return(View(objUser));
}
// GET: EMPLOYEES_COFFEE/Edit/5
public async Task <ActionResult> Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EMPLOYEES_COFFEE eMPLOYEES_COFFEE = await db.EMPLOYEES_COFFEE.FindAsync(id);
if (eMPLOYEES_COFFEE == null)
{
return(HttpNotFound());
}
ViewBag.DEPT_ID = new SelectList(db.DEPARTMENTS, "DEP_ID", "DEP_NAME", eMPLOYEES_COFFEE.DEPT_ID);
ViewBag.EMP_ID = new SelectList(db.EMP_HISTORY, "EMP_ID", "EMP_START_TIME", eMPLOYEES_COFFEE.EMP_ID);
return(View(eMPLOYEES_COFFEE));
}
