public static bool Login(string user, string password) { using (TharEntities con = new TharEntities()) { return(con.Users.Any(x => x.User1.Equals(user, StringComparison.OrdinalIgnoreCase) && x.Password == password)); } }
public HttpResponseMessage UpdateBird(int id, [FromBody] Bird pakshi) { using (TharEntities te = new TharEntities()) { Bird birddetails = te.Birds.FirstOrDefault(x => x.ID == id); birddetails.BirdName = pakshi.BirdName; birddetails.ScientificName = birddetails.ScientificName; birddetails.TypeOfBird = birddetails.TypeOfBird; te.SaveChanges(); } return(Request.CreateResponse(HttpStatusCode.OK, "Row updated")); }
public HttpResponseMessage GetAllBird() { try { using (TharEntities con = new TharEntities()) { return(Request.CreateResponse(HttpStatusCode.OK, con.Birds.ToList())); } } catch (Exception e) { return(Request.CreateResponse(HttpStatusCode.NotFound, e)); } }
public HttpResponseMessage GetEmployee(String desig) { string designation = Thread.CurrentPrincipal.Identity.Name; using (TharEntities con = new TharEntities()) { switch (designation.ToLower()) { case "accountant": return(Request.CreateResponse(HttpStatusCode.OK, con.Employees.Where(x => x.Designation == "accountant").ToList())); default: return(Request.CreateResponse(HttpStatusCode.BadRequest)); } } }
public HttpResponseMessage InsertBird([FromBody] IEnumerable <Bird> det) { using (TharEntities insertbird = new TharEntities()) { if (det != null) { foreach (var item in det) { insertbird.Birds.Add(item); } insertbird.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, "Added " + insertbird.Birds.Select(x => x.BirdName))); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotModified, "Unable to add row")); } } }
public HttpResponseMessage GetBirdByName(int id) { try { using (TharEntities con = new TharEntities()) { Bird bird = con.Birds.FirstOrDefault(x => x.ID == id); if (bird != null) { return(Request.CreateResponse(HttpStatusCode.OK, bird)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, id.ToString() + " No Bird Found")); } } } catch (Exception e) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, e)); } }