public Employee GetList(int id) { Employee objEmployee = new Employee(); try { tempdbEntities objdb = new tempdbEntities(); var empData = objdb.Emps.Where(x => x.Id == id).FirstOrDefault(); if (empData != null) { objEmployee.City = empData.City; objEmployee.Name = empData.Name; objEmployee.mesage = "Done"; objEmployee.Status = true; } else { objEmployee.mesage = "Bad Request"; objEmployee.Status = false; } } catch (Exception ex) { objEmployee.mesage = "Exception!"; objEmployee.Status = false; } return(objEmployee); }
public Employee AddUpdate(Employee objEmp) { Employee Result = new Employee(); if (objEmp.Id != 0) { try { tempdbEntities objdb = new tempdbEntities(); var empData = objdb.Emps.Where(x => x.Id == objEmp.Id).FirstOrDefault(); if (empData != null) { empData.Name = objEmp.Name; empData.City = objEmp.City; objdb.SaveChanges(); objdb.Dispose(); Result.Status = true; Result.mesage = "success"; } else { Result.Status = false; Result.mesage = "no record found"; } } catch (Exception) { Result.Status = true; Result.mesage = "success"; } } else { try { tempdbEntities objdb = new tempdbEntities(); Emp objemployee = new Emp(); objemployee.Name = objEmp.Name; objemployee.City = objEmp.City; objdb.Emps.Add(objemployee); objdb.SaveChanges(); objdb.Dispose(); Result.Status = true; Result.mesage = "success"; } catch (Exception) { Result.Status = false; Result.mesage = "Falied"; } } return(Result); }
public List <Employee> GetAllList() { List <Employee> EmpList = new List <Employee>(); try { tempdbEntities a = new tempdbEntities(); EmpList = a.Emps.ToList().ConvertAll(o => new Employee { Id = o.Id, Name = o.Name, City = o.City }); } catch (Exception) {} return(EmpList); }
public Employee Delete(int id) { Employee Result = new Employee(); try { if (id > 0) { tempdbEntities objdb = new tempdbEntities(); var empdata = objdb.Emps.Where(x => x.Id == id).FirstOrDefault(); if (empdata != null) { objdb.Emps.Remove(empdata); objdb.SaveChanges(); Result.Status = true; Result.mesage = "Done!"; } else { Result.Status = false; Result.mesage = "Record Not Found!"; } } else { Result.Status = false; Result.mesage = "Invalid Id!"; } } catch (Exception) { Result.Status = false; Result.mesage = "Exception"; } return(Result); }