public ActionResult Create(ModelEmployeeMvc emp) { try { if (ModelState.IsValid) { using (db) { DynamicParameters param = new DynamicParameters(); param.Add("@firstName", emp.FirstName); param.Add("@lastName", emp.LastName); param.Add("@contactNumber", emp.ContactNumber); param.Add("@email", emp.Email); param.Add("@address", emp.Address); db.Open(); db.Execute("AddNewEmployee", param, commandType: CommandType.StoredProcedure); AppLogger.Info("Insert new employee. From: Employees using Dapper"); db.Close(); return(RedirectToAction("Index")); } } return(View()); } catch (Exception ex) { AppLogger.Error("Insert new employee error. From: Employees using Dapper"); return(View(ex)); } }
public ActionResult AddOrEdit(ModelEmployeeMvc emp) { if (emp.Id == 0) { HttpResponseMessage response = GlobalHttpClient.httpClient.PostAsJsonAsync("Employees", emp).Result; return(Json(new { success = true, message = "Saved successfully", JsonRequestBehavior.AllowGet })); } else { HttpResponseMessage response = GlobalHttpClient.httpClient.PutAsJsonAsync("Employees/" + emp.Id, emp).Result; return(Json(new { success = true, message = "Updated successfully", JsonRequestBehavior.AllowGet })); } }
public ActionResult Details(int id) { ModelEmployeeMvc Employees = new ModelEmployeeMvc(); using (db) { db.Open(); DynamicParameters param = new DynamicParameters(); param.Add("@empId", id); Employees = db.Query <ModelEmployeeMvc>("GetEmployeeDetails", param, commandType: CommandType.StoredProcedure).SingleOrDefault(); db.Close(); AppLogger.Info("Employee details successful. From: Employees using Dapper"); return(View(Employees)); } }
public ActionResult Edit(int id, ModelEmployeeMvc emp) { try { if (ModelState.IsValid) { using (db) { DynamicParameters param = new DynamicParameters(); param.Add("@empId", id); param.Add("@firstName", emp.FirstName); param.Add("@lastName", emp.LastName); param.Add("@contactNumber", emp.ContactNumber); param.Add("@email", emp.Email); param.Add("@address", emp.Address); db.Open(); db.Execute("UpdateEmployee", param, commandType: CommandType.StoredProcedure); db.Close(); AppLogger.Info("Edit employee successful. From: Employees using Dapper"); return(RedirectToAction("Index")); } } using (db) { db.Open(); DynamicParameters param = new DynamicParameters(); param.Add("@empId", id); emp = db.Query <ModelEmployeeMvc>("GetEmployeeDetails", param, commandType: CommandType.StoredProcedure).SingleOrDefault(); db.Close(); AppLogger.Info("Edit employee unsuccessful. From: Employees using Dapper"); return(View(emp)); } } catch (Exception ex) { AppLogger.Error("Edit employee error. From: Employees using Dapper"); return(View(ex)); } }