// GET: api/ShoppingItems?itemId=5
/// <summary>
/// Gets the shopping item by it's ID
/// </summary>
/// <param name="itemId"></param>
/// <returns></returns>
public Models.ShoppingItem Get(int itemId)
{
var it = new Models.ShoppingItem();
using (var db = new EntiTreesEntities())
{
var query = db.SelectShoppingItems(null, itemId);
foreach (var item in query)
{
it = new Models.ShoppingItem
{
id = item.Id,
description = item.Description,
discount = item.Discount,
lastUpdated = item.LastModified,
price = item.Price,
quantity = item.Quantity,
src = item.ImageSrc,
title = item.Title,
categoryId = item.CategoryId
};
}
}
return(it);
}
public void Put([FromBody] Models.ShoppingItem item)
{
using (var db = new EntiTreesEntities())
{
db.UpdateShopItem(item.id, item.title, item.description, item.price, item.discount, item.src, item.quantity, item.categoryId);
}
}
// GET: api/Categories/5
public List <Models.Category> Get()
{
var categories = new List <Models.Category>();
using (var db = new EntiTreesEntities())
{
var query = db.SelectCategories();
foreach (var item in query)
{
categories.Add(new Models.Category
{
id = item.Id,
name = item.Name,
description = item.Description,
imageSrc = item.ImgSrc,
src = item.Src,
itemsCount = item.ItemsCount,
systemName = item.SystemName
});
}
}
return(categories);
}
public void Put(int id, bool isCompleted, string answer)
{
using (var db = new EntiTreesEntities())
{
db.UpdateContact(id, isCompleted, answer);
}
}
public List <Models.Contact> Get()
{
var contacts = new List <Models.Contact>();
using (var db = new EntiTreesEntities())
{
var query = db.SelectContacts();
foreach (var item in query)
{
contacts.Add(new Models.Contact
{
contactId = item.Id,
email = item.Email,
name = item.Name,
phone = item.Phone,
isCompleted = item.IsCompleted.HasValue ? item.IsCompleted.Value : false,
date = item.Date,
message = item.Message,
dateCompleted = item.DateCompleted,
answer = item.Answer
});
}
}
return(contacts);
}
// POST: api/Order
//Content-Type: application/json
public Models.ReturnValue <string> Post(Models.Order order)
{
string inXml = Utils.ObjectToXML(order);
using (var db = new EntiTreesEntities())
{
try
{
foreach (Models.OrderItem item in order.shoppingCart)
{
if (item.quantity > item.item.quantity)
{
return(new Models.ReturnValue <string>(Models.Codes.NotEnoughQty, "There is not enough quantity for this item " + item.item.title));
}
}
var result = db.InsertNewOrder(inXml);
Models.ReturnValue <string> returnVal;
foreach (var item in result)
{
//if the order is successfull
Models.Codes code = (Models.Codes)Enum.Parse(typeof(Models.Codes), item.Result);
returnVal = new Models.ReturnValue <string>(code, item.ResultMessage);
Utils.SendMail("ПОТВЪРДЕНА ПОРЪЧКА #" + item.OrderID.ToString() + ": Нова поръчка е изпратена успешно!", GenerateOrderEmailBody(order, item.OrderID.ToString()), order.customer.email, order.customer.name);
return(returnVal);
}
return(new Models.ReturnValue <string>(Models.Codes.DBError, "There is something wrong with the DB"));
}
catch (Exception ex)
{
return(new Models.ReturnValue <string>(Models.Codes.Error, ex.Message));
}
}
}
public List <Models.Orders> Get()
{
var orders = new List <Models.Orders>();
using (var db = new EntiTreesEntities())
{
var query = db.SelectOrders();
foreach (var item in query)
{
orders.Add(new Models.Orders
{
orderId = item.Id,
customerId = item.CustomerId,
shoppingCartId = item.ShoppingCartId,
orderDate = item.Date,
isCompleted = item.IsCompleted,
itemsCount = item.Quantity == null ? 0 : item.Quantity.Value,
message = item.Message,
totalPrice = item.TotalPrice == null ? 0 : item.TotalPrice.Value,
orderCompletedDate = item.DateCompleted
});
}
}
return(orders);
}
public void Delete(int id)
{
using (var db = new EntiTreesEntities())
{
try
{
var result = db.DeleteShopItem(id);
}
catch (Exception ex)
{
}
}
}
// POST: api/Contact
//Content-Type: application/json
public Models.ReturnValue <string> Post(Models.Contact contact)
{
using (var db = new EntiTreesEntities())
{
try
{
db.InsertContact(contact.name, contact.email, contact.phone, contact.message);
return(new Models.ReturnValue <string>(Models.Codes.Created, "The contact message inserted successfully."));
}
catch (Exception ex)
{
return(new Models.ReturnValue <string>(Models.Codes.DBError, ex.Message));
}
}
}
public Models.ReturnValue <string> Put(int id, string email, string name, string message)
{
using (var db = new EntiTreesEntities())
{
try
{
Utils.SendMail("Отговор на запитване от Енти Трийс", message, email, name);
db.UpdateContact(id, true, message);
return(new Models.ReturnValue <string>(Models.Codes.OK, "Successfully send message back to contact."));
}
catch (Exception ex)
{
db.UpdateContact(id, false, "");
return(new Models.ReturnValue <string>(Models.Codes.Error, ex.Message));
}
}
}
public Models.OrderDetails Get(int orderId)
{
var order = new Models.OrderDetails();
using (var db = new EntiTreesEntities())
{
var query = db.SelectOrderByID(orderId);
foreach (var item in query)
{
order.orderId = item.OrderId;
order.shoppingCartId = item.ShoppingCartId;
order.customerId = item.CustomerId;
order.orderDate = item.Date;
order.isCompleted = item.IsCompleted;
order.orderCompletedDate = item.DateCompleted;
order.customer = new Models.Customer
{
message = item.Message,
name = item.Name,
phone = item.Phone,
email = item.Email,
address = item.Address
};
}
var query2 = db.SelectOrderItemsByOrderID(orderId);
order.items = new List <Models.OrderDetails.OrderItem>();
foreach (var item in query2)
{
order.items.Add(new Models.OrderDetails.OrderItem
{
shoppingItemId = item.ShoppingItemId,
categoryName = item.Name,
discount = item.Discount == null ? 0 : item.Discount.Value,
imageSrc = item.ImageSrc,
itemPrice = item.SinglePrice == null ? 0 : item.SinglePrice.Value,
quantity = item.Quantity,
sellPrice = item.Price,
title = item.Title
});
}
}
return(order);
}
public Models.ReturnValue <string> Put([FromUri] bool isCompleted, [FromBody] Models.OrderDetails order)
{
using (var db = new EntiTreesEntities())
{
try
{
db.UpdateOrder(order.orderId, isCompleted);
if (isCompleted)
{
Utils.SendMail("ИЗПРАТЕНА ПОРЪЧКА #" + order.orderId.ToString() + ": Вашата поръчка пътува към вас!", GenerateOrderSendEmailBody(order), order.customer.email, order.customer.name);
}
return(new Models.ReturnValue <string>(Models.Codes.OK, "Order send successfully"));
}
catch (Exception ex)
{
return(new Models.ReturnValue <string>(Models.Codes.Error, ex.Message));
}
}
}
public Models.Notifications Get()
{
Models.Notifications notifications;
using (var db = new EntiTreesEntities())
{
var query = db.SelectAdminHomeNotifications().FirstOrDefault();
notifications = new Models.Notifications
{
activeItems = query.ActiveItems.HasValue ? query.ActiveItems.Value : 0,
allItems = query.AllItems.HasValue ? query.AllItems.Value : 0,
allContacts = query.AllContacts.HasValue ? query.AllContacts.Value : 0,
openContacts = query.OpenContacts.HasValue ? query.OpenContacts.Value : 0,
openOrders = query.OpenOrders.HasValue ? query.OpenOrders.Value : 0,
allOrders = query.AllOrders.HasValue ? query.AllOrders.Value : 0,
customersCount = query.CustomersCount.HasValue ? query.CustomersCount.Value : 0
};
return(notifications);
}
}
public List <Models.Customer> Get()
{
var customers = new List <Models.Customer>();
using (var db = new EntiTreesEntities())
{
var query = db.SelectCustomers();
foreach (var item in query)
{
customers.Add(new Models.Customer
{
id = item.Id,
name = item.Name,
email = item.Email,
phone = item.Phone,
address = item.Address,
ordersCount = item.OrdersCount
});
}
}
return(customers);
}
