public JsonResult Search(int EmpId)
{
DBmodel Dataconnection = new DBmodel();
SqlConnection connection = Dataconnection.DBConnection();
connection.Open();
string select = "SELECT * from Employee WHERE EmpId='" + EmpId + "'";
SqlCommand comd = new SqlCommand(select, connection);
List <Employeemodel> SearchItem = new List <Employeemodel>();
Employeemodel Searchresult = new Employeemodel();
using (SqlDataReader read = comd.ExecuteReader())
{
while (read.Read())
{
Searchresult.EmpId = int.Parse(read["EmpId"].ToString());
Searchresult.Name = read["Name"].ToString();
Searchresult.Age = int.Parse(read["Age"].ToString());
Searchresult.Designation = read["Designation"].ToString();
Searchresult.ExpYears = int.Parse(read["ExpYears"].ToString());
SearchItem.Add(Searchresult);
}
}
connection.Close();
return(Json(SearchItem, JsonRequestBehavior.AllowGet));
}
public JsonResult Display()
{
DBmodel Dataconnection = new DBmodel();
SqlConnection connection = Dataconnection.DBConnection();
connection.Open();
SqlCommand comd = new SqlCommand("SELECT * from Employee", connection);
List <Employeemodel> DisplayList = new List <Employeemodel>();
Employeemodel DBlist;
using (SqlDataReader read = comd.ExecuteReader())
{
while (read.Read())
{
DBlist = new Employeemodel();
DBlist.EmpId = int.Parse(read["EmpId"].ToString());
DBlist.Name = read["Name"].ToString();
DBlist.Age = int.Parse(read["Age"].ToString());
DBlist.Designation = read["Designation"].ToString();
DBlist.ExpYears = int.Parse(read["ExpYears"].ToString());
DisplayList.Add(DBlist);
}
}
return(Json(DisplayList, JsonRequestBehavior.AllowGet));
}
public static Employeemodel getEmp()
{
Employeemodel emp = new Employeemodel();
emp.ID = 1;
emp.EMPCODE = "001";
return(emp);
}
public ActionResult Edit(Employeemodel model)
{
if (ModelState.IsValid)
{
reposistory.UpdateEmployee(model.Id, model);
return(RedirectToAction("GetAllRecords"));
}
return(View());
}
static void Main(string[] args)
{
string getdata = Class1.ok;
string result = Class1.test() + getdata;
Console.WriteLine(result);
Employeemodel getEmployee = Class1.getEmp();
Console.WriteLine(getEmployee.EMPCODE);
}
public ActionResult Create(Employeemodel model)
{
if (ModelState.IsValid)
{
int id = reposistory.AddEmployee(model);
if (id > 0)
{
ModelState.Clear();
ViewBag.Issuccess = "Data Added";
}
}
return(View());
}
public int AddEmployee(Employeemodel model)
{
using (var context = new EmployeedbEntities())
{
Employee emp = new Employee()
{
FirstName = model.FirstName,
LastName = model.LastName,
Email = model.Email,
Code = model.Code
};
context.Employee.Add(emp);
context.SaveChanges();
return(emp.Id);
}
}
IList <EmployeeModel> IEmployeeService.UpdateEmployee(EmployeeModel employee)
{
var emp = GetEmployeeContext().SingleOrDefault(e => e.EmployeeId == employee.EmployeeId);
if (emp != null)
{
return(new List <EmployeeModel>());
}
emp.DOB = employee.DOB;
emp.Email = employee.Email;
emp.Phone = employee.Phone;
emp.Country = employee.Country;
emp.LastName = employee.LastName;
emp.FirstName = employee.FirstName;
emp.Department = employee.Department;
emp.ProfileUrl = employee.ProfileUrl;
emp.EmployeeId = employee.EmployeeId;
Employeemodel.Add(emp);
return(Employeemodel);
}
public bool UpdateEmployee(int id, Employeemodel model)
{
using (var context = new EmployeedbEntities())
{
//var employee = context.Employee.FirstOrDefault(x => x.Id == id);
var employee = new Employee();
if (employee != null)
{
employee.Id = model.Id;
employee.FirstName = model.FirstName;
employee.LastName = model.LastName;
employee.Email = model.Email;
employee.Code = model.Code;
employee.Addressid = model.Addressid;
}
context.Entry(employee).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
return(true);
}
}
IList <EmployeeModel> IEmployeeService.CreateEmployee(EmployeeModel employee)
{
try
{
var emp = new EmployeeModel
{
DOB = employee.DOB,
Email = employee.Email,
Phone = employee.Phone,
Country = employee.Country,
LastName = employee.LastName,
FirstName = employee.FirstName,
Department = employee.Department,
ProfileUrl = employee.ProfileUrl,
EmployeeId = employee.EmployeeId
};
Employeemodel.Add(emp);
return(Employeemodel);
}
catch (Exception e)
{
throw e.InnerException;
}
}
