public ActionResult Edit(EmpModels model) { if (ModelState.IsValid) { emp.UpdateEmploye(model.Id, model); return(RedirectToAction("GetAllRecords")); } return(View()); }
public ActionResult Create(EmpModels model) { if (ModelState.IsValid) { int id = emp.AddEmploye(model); if (id > 0) { ModelState.Clear(); ViewBag.Issuccess = "Data Added"; } } return(View()); }
public bool UpdateEmploye(int id, EmpModels model) { using (var context = new DXCEntities()) { var empl = context.Db_approach.FirstOrDefault(x => x.Id == id); if (empl != null) { empl.FirstName = model.FirstName; empl.LastName = model.LastName; empl.Email = model.Email; empl.Code = model.Code; } context.SaveChanges(); return(true); } }
public int AddEmploye(EmpModels model) { using (var context = new DXCEntities()) { Db_approach ee = new Db_approach() { FirstName = model.FirstName, LastName = model.LastName, Email = model.Email, Code = model.Code }; context.Db_approach.Add(ee); context.SaveChanges(); return(ee.Id); } }
public EmpModels GetCon() { OracleConnection con = new OracleConnection(connectString); con.Open(); string sql = "select id from test"; OracleCommand cmd = new OracleCommand(sql, con); OracleDataReader dta = cmd.ExecuteReader(); if (dta.Read()) { EmpModels emp = new EmpModels() { EmpNO = dta["id"].ToString() }; return(emp); } else { return(null); } }