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