public int RemoveOrder(int oid)
{
var po = db.ORDERPLACED.Where(op => op.OderId == oid).FirstOrDefault();
db.ORDERPLACED.Remove(po);
db.SaveChanges();
return(2000);
}
public int AddAddress(ADDRESSES address, int uid)
{
//var address = new ADDRESSES();
address.UserId = uid;
db.ADDRESSES.Add(address);
db.SaveChanges();
return(2002);
}
public int ModifyProduct(int oid)
{
var dataO = from o in db.ORDERPLACED
where o.OderId == oid
join p in db.PRODUCTS on o.ProductId equals p.ProductId
join u in db.USERS on o.UserId equals u.UserId
select new
{
p.ProductName,
p.Price,
p.Path,
u.FirstName,
u.LastName,
o.UserId,
o.TotalAmount,
o.OrderedQuantity,
o.OrderDate,
o.Address,
o.ModeOfPayment,
o.ProductId,
o.OrderNo,
};
var data = dataO.FirstOrDefault();
if (data != null)
{
ORDERSHISTORY oh = new ORDERSHISTORY();
oh.ProductName = data.ProductName;
oh.Price = data.Price;
oh.UserId = data.UserId;
oh.CustomerName = data.FirstName + " " + data.LastName;
oh.TotalAmount = data.TotalAmount;
oh.Quantity = data.OrderedQuantity;
oh.OrderDate = data.OrderDate;
oh.DiliveryAddress = data.Address;
oh.ModeOfPayment = data.ModeOfPayment;
oh.ProductId = data.ProductId;
oh.DeliveryDate = DateTime.Now;
oh.OrderNo = data.OrderNo;
oh.OrderStatus = "Delivered";
oh.Path = data.Path;
db.ORDERSHISTORY.Add(oh);
db.SaveChanges();
var dataD = db.ORDERPLACED.Find(oid);
db.ORDERPLACED.Remove(dataD);
db.SaveChanges();
return(1);
}
return(0);
}
public int AddAddress(ADDRESSES address)
{
if (address == null)
{
return(4004);
}
else
{
db.ADDRESSES.Add(address);
db.SaveChanges();
return(2002);
}
}
public int AddProduct(PRODUCTS product)
{
if (product == null)
{
return(0);
}
else
{
product.Status = "Active";
db.PRODUCTS.Add(product);
db.SaveChanges();
return(1);
}
}
public int AddToCart(int pid, int uid)
{
if (uid == -1)
{
return(-1);
}
PRODUCTS product = db.PRODUCTS.Find(pid);
if (product == null)
{
return(4004);
}
CART chk = db.CARTs.Where(c => c.UserId == uid && c.ProductId == pid).FirstOrDefault();
CART cartobj = new CART();
if (chk == null)
{
cartobj.UserId = uid;
cartobj.ProductId = product.ProductId;
cartobj.ItemQuantity = 1;
db.CARTs.Add(cartobj);
db.SaveChanges();
return(2000);
}
else
{
chk.ItemQuantity += 1;
db.Entry(chk).State = EntityState.Modified;
db.SaveChanges();
return(2001);
}
}
public int ModifyUser(int uid)
{
var data = db.ORDERPLACED.Find(uid);
if (data.OrderStatus == "Active")
{
data.OrderStatus = "Deactive";
}
else
{
data.OrderStatus = "Active";
}
db.Entry(data).State = EntityState.Modified;
db.SaveChanges();
return(1);
}
public int Register(USERS user)
{
var data = db.USERS.Where(u => u.EmailId == user.EmailId).FirstOrDefault();
if (data != null)
{
return(4000);
}
if (user != null)
{
user.Role = "customer";
user.TimeStamp = DateTime.Now;
user.Password = Hash.Hashing(user.Password);
db.USERS.Add(user);
db.SaveChanges();
return(2000);
}
return(4004);
}