コード例 #1
0
 public JsonResult getempDetails()
 {
     using (var db = new RathnaEntities())
     {
         var q = db.tbl_Employee.ToList();
         return(Json(q, JsonRequestBehavior.AllowGet));
     }
 }
コード例 #2
0
        public JsonResult GetBookById(string rathna)
        {
            int id = Convert.ToInt32(rathna);

            using (var db = new RathnaEntities())
            {
                var q = (from s in db.tbl_Employee
                         where s.Eid.Equals((id))
                         select s).SingleOrDefault();
                return(Json(q, JsonRequestBehavior.AllowGet));
            }
        }
コード例 #3
0
 public string AddEmp(tbl_Employee tbl)
 {
     if (tbl != null)
     {
         using (var db = new RathnaEntities())
         {
             db.tbl_Employee.Add(tbl);
             db.SaveChanges();
             return("Employee Add Sucessfully");
         }
     }
     else
     {
         return("Invalid Emp Details");
     }
 }
コード例 #4
0
 public string DeleteEmp(tbl_Employee tbl)
 {
     if (tbl != null)
     {
         using (var db = new RathnaEntities())
         {
             int no           = Convert.ToInt32(tbl.Eid);
             var employeeList = db.tbl_Employee.Where(x => x.Eid == no).FirstOrDefault();
             db.tbl_Employee.Remove(employeeList);
             db.SaveChanges();
             return("Employee Deleted");
         }
     }
     else
     {
         return("records not available");
     }
 }
コード例 #5
0
 public string UpdateEmp(tbl_Employee tbl)
 {
     if (tbl != null)
     {
         using (var db = new RathnaEntities())
         {
             int id = Convert.ToInt32(tbl.Eid);
             var q  = (from s in db.tbl_Employee
                       where s.Eid.Equals(id)
                       select s).ToList();
             q[0].Ename         = tbl.Ename;
             q[0].Eorganisation = tbl.Eorganisation;
             q[0].Edepartment   = tbl.Edepartment;
             q[0].ESalary       = tbl.ESalary;
             db.SaveChanges();
             return("Employee Updated");
         }
     }
     else
     {
         return("Employee not Updated");
     }
 }
コード例 #6
0
 public string loginEmp(THF_User tbl)
 {
     if (tbl != null)
     {
         using (var db = new RathnaEntities())
         {
             var q = (from s in db.THF_User
                      where s.UserEmail.Equals(tbl.UserEmail) && s.UserPassword.Equals(tbl.UserPassword)
                      select s).ToList();
             if (q.Count != 0)
             {
                 return("login sucess fully");
             }
             else
             {
                 return("username & password wrong");
             }
         }
     }
     else
     {
         return("username & password wrong");
     }
 }