コード例 #1
0
 public JsonResult Get_EmployeeById(string Id)
 {
     using (angularCrudEntities Obj = new angularCrudEntities())
     {
         int EmpId = int.Parse(Id);
         return(Json(Obj.Employees.Find(EmpId), JsonRequestBehavior.AllowGet));
     }
 }
コード例 #2
0
 public JsonResult Get_AllEmployee()
 {
     using (angularCrudEntities Obj = new angularCrudEntities())
     {
         List <Employee> Emp = Obj.Employees.ToList();
         return(Json(Emp, JsonRequestBehavior.AllowGet));
     }
 }
コード例 #3
0
 public string Insert_Employee(Employee Employe)
 {
     if (Employe != null)
     {
         using (angularCrudEntities Obj = new angularCrudEntities())
         {
             Obj.Employees.Add(Employe);
             Obj.SaveChanges();
             return("Employee Added Successfully");
         }
     }
     else
     {
         return("Employee Not Inserted! Try Again");
     }
 }
コード例 #4
0
 public string Update_Employee(Employee Emp)
 {
     if (Emp != null)
     {
         using (angularCrudEntities Obj = new angularCrudEntities())
         {
             var      Emp_   = Obj.Entry(Emp);
             Employee EmpObj = Obj.Employees.Where(x => x.Emp_Id == Emp.Emp_Id).FirstOrDefault();
             EmpObj.Emp_Age  = Emp.Emp_Age;
             EmpObj.Emp_City = Emp.Emp_City;
             EmpObj.Emp_Name = Emp.Emp_Name;
             Obj.SaveChanges();
             return("Employee Updated Successfully");
         }
     }
     else
     {
         return("Employee Not Updated! Try Again");
     }
 }
コード例 #5
0
 public string Delete_Employee(Employee Emp)
 {
     if (Emp != null)
     {
         using (angularCrudEntities Obj = new angularCrudEntities())
         {
             var Emp_ = Obj.Entry(Emp);
             if (Emp_.State == System.Data.Entity.EntityState.Detached)
             {
                 Obj.Employees.Attach(Emp);
                 Obj.Employees.Remove(Emp);
             }
             Obj.SaveChanges();
             return("Employee Deleted Successfully");
         }
     }
     else
     {
         return("Employee Not Deleted! Try Again");
     }
 }