public int AddAddress(ADDRESSES address, int uid)
{
//var address = new ADDRESSES();
address.UserId = uid;
db.ADDRESSES.Add(address);
db.SaveChanges();
return(2002);
}
public int AddAddress(ADDRESSES address)
{
if (address == null)
{
return(4004);
}
else
{
db.ADDRESSES.Add(address);
db.SaveChanges();
return(2002);
}
}
public int ModifyAddress(ADDRESSES address)
{
if (address == null)
{
return(0);
}
else
{
db.Entry(address).State = EntityState.Modified;
db.SaveChanges();
return(1);
}
}
/// <summary>
/// Gets next API address (until the end of list).
/// </summary>
/// <param name="address">Address</param>
/// <returns>Next API address</returns>
public static ApiAddress GetNextAddress(string address)
{
ApiAddress apiAddress = ADDRESSES.Find(item => item.Address == address);
if (apiAddress == null)
{
throw new APICommunicationException("Connection error (and no backup server available for " + address + ")");
}
// Remove the broken address
ADDRESSES.Remove(apiAddress);
// If there are anymore else take the first
if (ADDRESSES.Count > 0)
{
return(ADDRESSES[0]);
}
throw new APICommunicationException("Connection error (and no more backup servers available)");
}
public int Put(ADDRESSES address)
{
return(bl.ModifyAddress(address));
}
public int Post(ADDRESSES address)
{
return(bl.AddAddress(address));
}
public int PlaceOrder(int uid, ADDRESSES address)
{
string addresssave = "State: " + address.State + " City: " + address.City + " Address Line: " + address.AddressLine + " Pin Code: " + address.PostalCode;
var cartdataOBJs = from c in db.CARTs
where c.UserId == uid
join p in db.PRODUCTS on c.ProductId equals p.ProductId
join u in db.USERS on c.UserId equals u.UserId
select new
{
u.UserId,
c.ProductId,
p.Price,
c.ItemQuantity
};
var cartdata = cartdataOBJs.ToList();
ORDERPLACED PerOrder = new ORDERPLACED();
if (cartdata.Count() != 0)
{
var oplace = db.ORDERPLACED.Where(op => op.UserId == uid).OrderByDescending(op => op.OrderNo).FirstOrDefault();
var Orderplace = db.ORDERSHISTORY.Where(op => op.UserId == uid).FirstOrDefault();
if (Orderplace == null)
{
if (oplace == null)
{
PerOrder.OrderNo = 1;
}
else
{
PerOrder.OrderNo = oplace.OrderNo + 1;
}
}
else
{
if (oplace == null)
{
var CkOrdrNo = db.ORDERSHISTORY.Where(op => op.UserId == uid).OrderByDescending(op => op.OrderNo).FirstOrDefault();
PerOrder.OrderNo = CkOrdrNo.OrderNo + 1;
}
else
{
PerOrder.OrderNo = oplace.OrderNo + 1;
}
}
foreach (var item in cartdata)
{
ORDERPLACED orderplaced = new ORDERPLACED();
orderplaced.OrderNo = PerOrder.OrderNo;
orderplaced.UserId = uid;
orderplaced.ProductId = item.ProductId;
orderplaced.Price = item.Price;
orderplaced.OrderDate = DateTime.Now;
orderplaced.OrderedQuantity = item.ItemQuantity;
orderplaced.TotalAmount = orderplaced.Price * orderplaced.OrderedQuantity;
orderplaced.OrderStatus = "Pending";
orderplaced.ModeOfPayment = "cod";
orderplaced.Address = addresssave;
db.ORDERPLACED.Add(orderplaced);
db.SaveChanges();
}
var cartD = db.CARTs.Where(c => c.UserId == uid).Select(c => c).ToList();
foreach (var item in cartD)
{
db.CARTs.Remove(item);
db.SaveChanges();
}
return(2002);
}
else
{
return(4004);
}
}
public int PlaceOrder(int uid, ADDRESSES address)
{
return(bl.PlaceOrder(uid, address));
}
public int EditAddress(ADDRESSES address)
{
return(bl.EditAddress(address));
}
public int AddAddress(ADDRESSES address, int uid)
{
return(bl.AddAddress(address, uid));
}
public void AddAddresses(TGeoAddress a)
{
ADDRESSES.Add(a);
}
public int EditAddress(ADDRESSES address)
{
db.Entry(address).State = EntityState.Modified;
db.SaveChanges();
return(2002);
}
