public ActionResult AddOrEdit(Emloyee emp) { try { if (emp.ImageUpload != null) { string fileName = Path.GetFileNameWithoutExtension(emp.ImageUpload.FileName); string extension = Path.GetExtension(emp.ImageUpload.FileName); fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension; emp.ImagePath = "~/AppFiles/Images/" + fileName; emp.ImageUpload.SaveAs(Path.Combine(Server.MapPath("~/AppFiles/Images/"), fileName)); } using (MvcProject_SayedEntities db = new MvcProject_SayedEntities()) { if (emp.EmloyeeID == 0) { db.Emloyees.Add(emp); db.SaveChanges(); } else { db.Entry(emp).State = EntityState.Modified; db.SaveChanges(); } } return(Json(new { success = true, html = GlobalClass.RenderRazorViewToString(this, "ViewAll", GetAllEmployee()), message = "Submitted Successfully" }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet)); } }
public JsonResult Put(Emloyee emp) { string query = @" update dbo.Employee set EmployeeName = '" + emp.EmployeeName + @"' ,Department = '" + emp.Department + @"' ,DateOfJoining = '" + emp.DateOfJoining + @"' where EmployeeId = " + emp.EmployeeId + @" "; DataTable table = new DataTable(); string sqlDataSource = _configuration.GetConnectionString("DefaultConnection"); SqlDataReader myReader; using (SqlConnection myCon = new SqlConnection(sqlDataSource)) { myCon.Open(); using (SqlCommand myCommand = new SqlCommand(query, myCon)) { myReader = myCommand.ExecuteReader(); table.Load(myReader);; myReader.Close(); myCon.Close(); } } return(new JsonResult("Updated Successfully")); }
public JsonResult Post(Emloyee emp) { string query = @" insert into dbo.Employee (EmployeeName,Department,DateOfJoining,PhotoFileName) values ( '" + emp.EmployeeName + @"' ,'" + emp.Department + @"' ,'" + emp.DateOfJoining + @"' ,'" + emp.PhotoFileName + @"' ) "; DataTable table = new DataTable(); string sqlDataSource = _configuration.GetConnectionString("DefaultConnection"); SqlDataReader myReader; using (SqlConnection myCon = new SqlConnection(sqlDataSource)) { myCon.Open(); using (SqlCommand myCommand = new SqlCommand(query, myCon)) { myReader = myCommand.ExecuteReader(); table.Load(myReader);; myReader.Close(); myCon.Close(); } } return(new JsonResult("Added Successfully")); }
public void DeleteEmployee(Emloyee emloyee) { if (emloyee == null) { throw new ArgumentNullException(nameof(emloyee)); } _context.Employees.Remove(emloyee); }
public ActionResult AddOrEdit(int id = 0) { Emloyee emp = new Emloyee(); if (id != 0) { using (MvcProject_SayedEntities db = new MvcProject_SayedEntities()) { emp = db.Emloyees.Where(x => x.EmloyeeID == id).FirstOrDefault <Emloyee>(); } } return(View(emp)); }
public ActionResult AddOrEdit(int id = 0) { Emloyee emp = new Emloyee(); if (id != 0) { using (ApplicationDbContext db = new ApplicationDbContext()) { emp = db.Emloyees.Where(x => x.EmloyeeID == id).FirstOrDefault <Emloyee>(); } } return(View(emp)); }
public void AddEmployee(Emloyee emloyee, Guid comanuId) { if (emloyee == null) { throw new ArgumentNullException(nameof(emloyee)); } if (comanuId == Guid.Empty) { throw new ArgumentNullException(nameof(comanuId)); } emloyee.CompanyId = comanuId; _context.Employees.Add(emloyee); }
public ActionResult Delete(int id) { try { using (MvcProject_SayedEntities db = new MvcProject_SayedEntities()) { Emloyee emp = db.Emloyees.Where(x => x.EmloyeeID == id).FirstOrDefault <Emloyee>(); db.Emloyees.Remove(emp); db.SaveChanges(); } return(Json(new { success = true, html = GlobalClass.RenderRazorViewToString(this, "ViewAll", GetAllEmployee()), message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet)); } }
public void UpdataEmloyee(Emloyee emloyee) { // throw new NotImplementedException(); }