Exemplo n.º 1
0
 public IEnumerable <Customers> Get()
 {
     using (MaryKayCustomersEntities number = new MaryKayCustomersEntities())
     {
         return(number.Customers.ToList());
     }
 }
Exemplo n.º 2
0
        public HttpResponseMessage POST(int id_customers, [FromBody] Customers customers)
        //public HttpResponseMessage Update_Customres(int id_customers)
        {
            try
            {
                using (MaryKayCustomersEntities entities = new MaryKayCustomersEntities())
                {
                    var entity = entities.Customers.FirstOrDefault(e => e.id_Customers == id_customers);

                    if (entity == null)
                    {
                        return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Klientka od danym identyfikatorze=" + id_customers.ToString() + " nie figuruje w bazie"));
                    }
                    else
                    {
                        entity.Name         = customers.Name;
                        entity.Address      = customers.Address;
                        entity.phone        = customers.phone;
                        entity.husbentphone = customers.husbentphone;
                        entity.email        = customers.email;
                        entity.dateofbirth  = customers.dateofbirth;
                        entity.product      = customers.product;
                        entity.buydate      = customers.buydate;

                        entities.SaveChanges();
                        return(Request.CreateResponse(HttpStatusCode.OK, entity));
                    }
                }
            }
            catch (Exception ex)
            {
                return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
            }
        }
Exemplo n.º 3
0
 public HttpResponseMessage Delete_Customres(int id_customers)
 {
     try
     {
         using (MaryKayCustomersEntities entities = new MaryKayCustomersEntities())
         {
             var entity = entities.Customers.FirstOrDefault(d => d.id_Customers == id_customers);
             if (entity == null)
             {
                 return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Klientki o indetyfikatorze" + " " + id_customers.ToString() + "nie ma w bazie"));
             }
             else
             {
                 entities.Customers.Remove(entity);
                 entities.SaveChanges();
                 return(Request.CreateResponse(HttpStatusCode.OK));
             }
         }
     }
     catch (Exception ex)
     {
         return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
     }
 }