public string AddItem([FromBody] Models.Items item)
{
var status = "Adding item failed";
try
{
var iter = new EFModels.Items
{
Itemid = item.Itemid,
Name = item.Name,
Description = item.Description,
Subdescription = item.Subdescription,
Foranimal = item.Foranimal,
Category = item.Category,
Subcategory = item.Subcategory,
Price = item.Price,
Saleprice = item.Saleprice,
Sku = item.Sku,
Quantity = item.Quantity,
Moa = item.Moa,
Addedby = item.Addedby,
Photo = item.Photo,
Length = item.Length,
Breadth = item.Breadth,
Height = item.Height,
Weight = item.Weight,
Shippingclass = item.Shippingclass,
Processingtime = item.Processingtime,
Mililitres = item.Mililitres,
Packsizeingrams = item.Packsizeingrams,
Unitcount = item.Unitcount,
Upsells = item.Upsells,
Crosssells = item.Crosssells,
Policylabel = item.Policylabel,
Shippingpolicy = item.Shippingpolicy,
Refundpolicy = item.Refundpolicy,
Cancelationpolicy = item.Cancelationpolicy,
Exchangepolicy = item.Exchangepolicy,
Storename = item.Storename,
Commissionfor = item.Commissionfor,
Commissionmode = item.Commissionmode,
Authorizedby = item.Authorizedby,
Authorizedstatus = item.Authorizedstatus,
Deletedstatus = item.Deletedstatus
};
status = _AdminFacade.AddItem(iter);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
status = "Adding items failed";
throw e;
}
return(status);
}
/// <summary>
/// Update the items in order
/// </summary>
/// <param name="orderId"></param>
/// <param name="itemName"></param>
/// <param name="quantity"></param>
/// <returns></returns>
public OrderItems UpdateOrderItems(int orderId, string itemName, int quantity)
{
var custbasket = cusOrderList.SingleOrDefault(r => r.OrderId == orderId);
if (custbasket != null)
{
List <Items> ItemBasketList = custbasket.ItemBasketList;
var basketitem = ItemBasketList.SingleOrDefault(r => r.ItemName == itemName);
if (basketitem != null)
{
ItemBasketList.Remove(basketitem);
}
else
{
throw new ArgumentNullException("Item Not exists");
}
Items item = new Models.Items();
item.ItemName = itemName;
item.ItemQuantity = quantity;
ItemBasketList.Add(item);
custbasket.ItemBasketList = ItemBasketList;
}
return(custbasket);
}
public IHttpActionResult PostItems(Models.Items items)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Items.Add(items);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (ItemsExists(items.ItemId))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = items.ItemId }, items));
}
public IHttpActionResult PutItems(string id, Models.Items items)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != items.ItemId)
{
return(BadRequest());
}
db.Entry(items).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!ItemsExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult GetItems(string id)
{
Models.Items items = db.Items.Find(id);
if (items == null)
{
return(NotFound());
}
return(Ok(items));
}
public IHttpActionResult DeleteItems(string id)
{
Models.Items items = db.Items.Find(id);
if (items == null)
{
return(NotFound());
}
db.Items.Remove(items);
db.SaveChanges();
return(Ok(items));
}
public ActionResult home(doiTuong.Items item, string testSelect)
{
getViewBag();
Login.insert(item.Name.ToString(), item.Img);
ViewBag.home = testSelect;
Models.Items l = new Models.Items();
l.List = Login.getData();
doiTuong.Items[] pets = l.List.ToArray();
IEnumerable <doiTuong.Items> query = pets.OrderBy(pet => pet.Id);
Home h = new Home();
h.List = query.ToPagedList(1, 5);
return(View(h));
}
/// <summary>
/// Add new items for the order
/// </summary>
/// <param name="orderId"></param>
/// <param name="itemName"></param>
/// <param name="quantity"></param>
/// <returns></returns>
public OrderItems AddOrderItems(int orderId, string itemName, int quantity)
{
var custBasket = cusOrderList.SingleOrDefault(r => r.OrderId == orderId);
if (custBasket != null)
{
List <Items> ItemBasketList = custBasket.ItemBasketList;
var basketitem = ItemBasketList.SingleOrDefault(r => r.ItemName == itemName);
if (basketitem != null)
{
throw new Exception("Item already exists");
}
Items item = new Models.Items();
item.ItemName = itemName;
item.ItemQuantity = quantity;
ItemBasketList.Add(item);
custBasket.ItemBasketList = ItemBasketList;
}
return(custBasket);
}
public ActionResult SaveItem(Models.Items ISobj)
{
picAddress = ISobj.I_Pic1;
string[] seprator = { "," };
string[] picAddressList = picAddress.Split(seprator, StringSplitOptions.RemoveEmptyEntries);
using (SqlConnection con = new SqlConnection(cs))
{
// //Authorization
string query = "Insert into [Items](I_tag_no, I_status, I_type_id, I_Eprice, I_Pprice, I_Karigar_id, I_Pic1, I_Pic2, I_Pic3, I_Pic4, I_Pic5) VALUES ('" + ISobj.I_tag_no + "','" + ISobj.I_status + "','" + ISobj.I_type_id + "','" + ISobj.I_Eprice + "','" + ISobj.I_Pprice + "','" + ISobj.I_Karigar_id + "','" + picAddressList[0] + "','" + picAddressList[1] + "','" + picAddressList[2] + "','" + picAddressList[3] + "','" + picAddressList[4] + "')";
using (SqlCommand cmd = new SqlCommand(query))
{
cmd.Connection = con;
// opening connection
con.Open();
cs = con.State.ToString();
cmd.ExecuteNonQuery();
}
return(RedirectToAction("AllItems"));
}
}
public ActionResult home(int?page, string testSelect)
{
getViewBag();
Models.Items l = new Models.Items();
l.List = Login.getData();
ViewBag.home = "đây là trang home" + testSelect;
if (page == null)
{
page = 1;
}
int pageSize = 5;
int pageNumber = (page ?? 1);
//IEnumerable<Object.Items> list = l.OrderBy();
doiTuong.Items[] pets = l.List.ToArray();
IEnumerable <doiTuong.Items> query = pets.OrderByDescending(pet => pet.Id);
Home h = new Home();
h.List = query.ToPagedList(pageNumber, pageSize);
return(View(h));
}
public List <Models.Items> GetAllVendorItemsByVendorId(string vendorid)
{
var returnlist = new List <Models.Items>();
try
{
var replist = _AdminFacade.GetVendoritemsByVendorId(vendorid);
foreach (var item in replist)
{
var iter = new Models.Items
{
Itemid = item.Itemid,
Name = item.Name,
Description = item.Description,
Subdescription = item.Subdescription,
Foranimal = item.Foranimal,
Category = item.Category,
Subcategory = item.Subcategory,
Price = item.Price,
Saleprice = item.Saleprice,
Sku = item.Sku,
Quantity = item.Quantity,
Moa = item.Moa,
Addedby = item.Addedby,
Photo = item.Photo,
Length = item.Length,
Breadth = item.Breadth,
Height = item.Height,
Weight = item.Weight,
Shippingclass = item.Shippingclass,
Processingtime = item.Processingtime,
Mililitres = item.Mililitres,
Packsizeingrams = item.Packsizeingrams,
Unitcount = item.Unitcount,
Upsells = item.Upsells,
Crosssells = item.Crosssells,
Policylabel = item.Policylabel,
Shippingpolicy = item.Shippingpolicy,
Refundpolicy = item.Refundpolicy,
Cancelationpolicy = item.Cancelationpolicy,
Exchangepolicy = item.Exchangepolicy,
Storename = item.Storename,
Commissionfor = item.Commissionfor,
Commissionmode = item.Commissionmode,
Authorizedby = item.Authorizedby,
Authorizedstatus = item.Authorizedstatus,
Deletedstatus = item.Deletedstatus
};
returnlist.Add(iter);
}
}
catch (Exception e)
{
returnlist = null;
throw e;
}
return(returnlist);
}
public List <Models.Items> GetItems(string itemid, string foranimal, string category, string subcategory, string name)
{
List <Models.Items> retobj = new List <Models.Items>();
try
{
var repobj = _AdminFacade.GetItems(itemid, foranimal, category, subcategory, name);
if (repobj != null)
{
foreach (var item in repobj)
{
var iter = new Models.Items
{
Itemid = item.Itemid,
Name = item.Name,
Description = item.Description,
Subdescription = item.Subdescription,
Foranimal = item.Foranimal,
Category = item.Category,
Subcategory = item.Subcategory,
Price = item.Price,
Saleprice = item.Saleprice,
Sku = item.Sku,
Quantity = item.Quantity,
Moa = item.Moa,
Addedby = item.Addedby,
Photo = item.Photo,
Length = item.Length,
Breadth = item.Breadth,
Height = item.Height,
Weight = item.Weight,
Shippingclass = item.Shippingclass,
Processingtime = item.Processingtime,
Mililitres = item.Mililitres,
Packsizeingrams = item.Packsizeingrams,
Unitcount = item.Unitcount,
Upsells = item.Upsells,
Crosssells = item.Crosssells,
Policylabel = item.Policylabel,
Shippingpolicy = item.Shippingpolicy,
Refundpolicy = item.Refundpolicy,
Cancelationpolicy = item.Cancelationpolicy,
Exchangepolicy = item.Exchangepolicy,
Storename = item.Storename,
Commissionfor = item.Commissionfor,
Commissionmode = item.Commissionmode,
Authorizedby = item.Authorizedby,
Authorizedstatus = item.Authorizedstatus,
Deletedstatus = item.Deletedstatus
};
retobj.Add(iter);
}
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
retobj = null;
throw e;
}
return(retobj);
}
public ActionResult Post([FromBody] Models.Items item)
{
_db.Items.Add(item);
_db.SaveChanges();
return(Ok(item));
}
