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);
}