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));
}
}
