public Response PostCampaignUpdate(Campaign model) { var response = new Response(); OMSModel objContext = new OMSModel(); try { var campaign = objContext.Campaign.Where(p => p.idCampaign == model.idCampaign).SingleOrDefault(); if (campaign != null) { objContext.Entry(campaign).CurrentValues.SetValues(model); var res = objContext.SaveChanges(); response.Code = res; response.Description = "Campaña modificada"; } } catch (Exception ext) { response.Code = 515; response.Description = ext.Message; return(response); } return(response); }
public IHttpActionResult GetAll() { OMSModel model = new OMSModel(); var campaing = model.Campaign.ToList(); return(Ok(campaing)); }
public Response DeleteCustomer(long Idproduct) { var response = new Response(); OMSModel objContext = new OMSModel(); try { var products = objContext.Customer.Where(p => p.idCustomer == Idproduct).SingleOrDefault(); if (products != null) { objContext.Customer.Remove(products); var res = objContext.SaveChanges(); response.Code = res; response.Description = "Producto Eliminado"; } } catch (Exception ext) { response.Code = 515; response.Description = ext.Message; return(response); } return(response); }
public Response CustomerUpdate(Customer model) { var response = new Response(); OMSModel objContext = new OMSModel(); try { var products = objContext.Customer.Where(p => p.idCustomer == model.idCustomer).SingleOrDefault(); if (products != null) { objContext.Entry(products).CurrentValues.SetValues(model); var res = objContext.SaveChanges(); response.Code = res; response.Description = "Producto modificado"; } } catch (Exception ext) { response.Code = 515; response.Description = ext.Message; return(response); } return(response); }
public IList <Campaign> GetAllCampaing() { OMSModel model = new OMSModel(); var campaing = model.Campaign.ToList(); return(campaing); }
public Response DeleteCampaign(long Idcampaign) { var response = new Response(); OMSModel objContext = new OMSModel(); try { var campaign = objContext.Campaign.Where(p => p.idCampaign == Idcampaign).SingleOrDefault(); if (campaign != null) { objContext.Campaign.Remove(campaign); var res = objContext.SaveChanges(); response.Code = res; response.Description = "Campaña Eliminada"; } } catch (Exception ext) { response.Code = 515; response.Description = ext.Message; return(response); } return(response); }
public Customer GetNumberDoc(string NumberDoc) { OMSModel objContext = new OMSModel(); var customer = new Customer(); try { customer = objContext.Customer.First(p => p.numberDoc == NumberDoc); } catch (Exception ext) { throw ext; } return(customer); }
public Customer GetCustomerId(long IdCustomer) { OMSModel objContext = new OMSModel(); var customer = new Customer(); try { customer = objContext.Customer.First(p => p.idCustomer == IdCustomer); } catch (Exception ext) { throw ext; } return(customer); }
//public List<Product> GetAllProduct() //{ // OMSModel objContext = new OMSModel(); // var products = new List<Product>(); // try // { // products = objContext.Product.ToList(); // } // catch (Exception ext) // { // throw ext; // } // return products; //} public Product GetProductId(long IdProduct) { OMSModel objContext = new OMSModel(); var product = new Product(); try { product = objContext.Product.First(p => p.idProduct == IdProduct); } catch (Exception ext) { throw ext; } return(product); }
public Campaign GetCampaignId(long IdCampaign) { OMSModel objContext = new OMSModel(); var campaign = new Campaign(); try { campaign = objContext.Campaign.First(p => p.idCampaign == IdCampaign); } catch (Exception ext) { throw ext; } return(campaign); }
public int Pagination() { OMSModel objContext = new OMSModel(); int pages = Convert.ToInt32(ConfigurationManager.AppSettings["PAGES"]); try { int count = objContext.Customer.Count(); return(count / pages); } catch (Exception ext) { throw ext; } }
public Order GetOrderId(long IdOrder) { OMSModel objContext = new OMSModel(); var Order = new Order(); try { if (objContext.Order.Count(p => p.idOrder == IdOrder) > 0) { Order = objContext.Order.First(p => p.idOrder == IdOrder); } } catch (Exception ext) { throw ext; } return(Order); }
public bool LoginUser(LoginRequest alogin) { OMSModel model = new OMSModel(); foreach (var userOMS in model.User) { if (userOMS.userName == alogin.Username && userOMS.pass == alogin.Password) { return(true); } else { return(false); } } //var usuario = model.User.Select( user.userName); return(false); }
public Response CustomerCreate(Customer product) { var response = new Response(); OMSModel objContext = new OMSModel(); try { objContext.Customer.Add(product); var res = objContext.SaveChanges(); response.Code = res; response.Description = "Cliente Creado"; } catch (Exception ext) { response.Code = 515; response.Description = ext.Message; return(response); } return(response); }
public Response PostCampaignCreate(Campaign campaign) { var response = new Response(); OMSModel objContext = new OMSModel(); try { objContext.Campaign.Add(campaign); var res = objContext.SaveChanges(); response.Code = res; response.Description = "Campaña Creada"; } catch (Exception ext) { response.Code = 515; response.Description = ext.Message; return(response); } return(response); }
//public IList<Product> GetProductName(string name) //{ // OMSModel objContext = new OMSModel(); // var products = new List<Product>(); // try // { // name = name.Replace("%", ""); // name = name.Replace("*", ""); // products = objContext.Product.Where(p => p.name.Contains(name)).ToList(); // } // catch (Exception ext) // { // throw ext; // } // return products; //} //public IList<Product> GetProductDescription(string description) //{ // OMSModel objContext = new OMSModel(); // var products = new List<Product>(); // try // { // description = description.Replace("%", ""); // description = description.Replace("*", ""); // products = objContext.Product.Where(p => p.description.Contains(description)).ToList(); // } // catch (Exception ext) // { // throw ext; // } // return products; //} public Response PostProductCreate(Product product) { var response = new Response(); OMSModel objContext = new OMSModel(); try { objContext.Product.Add(product); var res = objContext.SaveChanges(); response.Code = res; response.Description = "Producto Creado"; } catch (Exception ext) { response.Code = 515; response.Description = ext.Message; return(response); } return(response); }
public Response OrderCancel(long IdOrder) { var response = new Response(); OMSModel objContext = new OMSModel(); try { var order = objContext.Order.Where(p => p.idOrder == IdOrder).SingleOrDefault(); if (order != null) { order.idStateOrder = 5; objContext.Entry(order).CurrentValues.SetValues(order); var res = objContext.SaveChanges(); response.Code = res; response.Description = "Orden Cancelada"; } } catch (Exception ext) { throw ext; } return(response); }