public ActionResult DeleteConfirmed(int id)
{
CustumerOrder custumerOrder = db.CustumerOrders.Find(id);
db.CustumerOrders.Remove(custumerOrder);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Make2(int id)
{//, int count
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
//int testas = count;
Inventory inventory = db.Inventories.Find(id);
if (inventory == null)
{
return(HttpNotFound());
}
//Naujas produktas, kuris bus priskiriamas uzsakymui.
OrderProduct order = new OrderProduct();
var obj = db.OrderProducts.ToList().Last();
int idcount = obj.id_OrderProduct + 1;
string LoggedInId = Session["ID"].ToString();
int xd = Int32.Parse(LoggedInId);
Userr userr = db.Userrs.Find(xd);
//CustumerOrder custumerOrder1 = db.CustumerOrders.Find(xd);
//if (custumerOrder1 == null)
//{
// CustumerOrder custumerOrder2 = new CustumerOrder();
// custumerOrder2.fk_UserID = xd;
//}
//else
//{
// custumerOrder2 = custumerOrder1();
//}
CustumerOrder custumerOrder = db.CustumerOrders.Find(xd);
order.amount = inventory.product_count;
order.id_OrderProduct = idcount;
order.name = inventory.productName;
order.fk_Inventoryproduct_numer = id;
order.fk_CustumerOrderorderNumer = custumerOrder.orderNumer;
custumerOrder.fk_UserID = xd;
db.OrderProducts.Add(order);
db.SaveChanges();
return(View());
}
public ActionResult MyOrders()
{
Inventory inv = new Inventory();
OrderProduct ord = new OrderProduct();
CustumerOrder cus = new CustumerOrder();
string LoggedInId = Session["ID"].ToString();
int xd = Int32.Parse(LoggedInId);
List <CustumerOrder> custumerOrders = cus.SelectByLoggedInID(xd);
return(View(custumerOrders));
}
public ActionResult Edit([Bind(Include = "orderNumer,date,confirm,status,fk_UserID")] CustumerOrder custumerOrder)
{
if (ModelState.IsValid)
{
db.Entry(custumerOrder).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.confirm = new SelectList(db.OrderConfirms, "id_OrderConfirm", "name", custumerOrder.confirm);
ViewBag.status = new SelectList(db.Status, "id_Status", "name", custumerOrder.status);
ViewBag.fk_UserID = new SelectList(db.Userrs, "ID", "name", custumerOrder.fk_UserID);
return(View(custumerOrder));
}
public ActionResult AppointJobsAndWorkers(Merged merged)
{
int joborderid;
int k = 0;
int siaip;
int succes;
int successor;
CustumerOrder CO = new CustumerOrder();
Userr us = new Userr();
JobWorker jbWorker = new JobWorker();
Job jbs = new Job();
OrderJob ordjooobs = new OrderJob();
List <Job> jobs = jbs.SelectJobList();
foreach (var jooob in jobs)
{
var obj = db.OrderJobs.Where(a => a.fk_CustumerOrderorderNumer.Equals(merged.id) && a.fk_JobworkNumer.Equals(jooob.workNumer)).FirstOrDefault();
if (obj == null)
{
joborderid = ordjooobs.InsertOrderJob(jooob.workNumer, merged.id);
if (k == 0)
{
siaip = jbWorker.InsertJobWorker(joborderid, merged.first); succes = us.UpdateWorkerStarus(merged.first);
}
else if (k == 1)
{
siaip = jbWorker.InsertJobWorker(joborderid, merged.second); succes = us.UpdateWorkerStarus(merged.second);
}
else if (k == 2)
{
siaip = jbWorker.InsertJobWorker(joborderid, merged.third); succes = us.UpdateWorkerStarus(merged.third);
}
else if (k == 3)
{
siaip = jbWorker.InsertJobWorker(joborderid, merged.fourth); succes = us.UpdateWorkerStarus(merged.fourth);
}
else if (k == 4)
{
siaip = jbWorker.InsertJobWorker(joborderid, merged.fifth); succes = us.UpdateWorkerStarus(merged.fifth);
}
else if (k == 5)
{
siaip = jbWorker.InsertJobWorker(joborderid, merged.six); succes = us.UpdateWorkerStarus(merged.six);
}
}
k++;
}
successor = CO.UpdateOrderStatus(merged.id);
return(RedirectToAction("Index", "CustumerOrders", new { area = "Index" }));
}
// GET: CustumerOrders/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CustumerOrder custumerOrder = db.CustumerOrders.Find(id);
if (custumerOrder == null)
{
return(HttpNotFound());
}
return(View(custumerOrder));
}
// GET: CustumerOrders/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CustumerOrder custumerOrder = db.CustumerOrders.Find(id);
if (custumerOrder == null)
{
return(HttpNotFound());
}
ViewBag.confirm = new SelectList(db.OrderConfirms, "id_OrderConfirm", "name", custumerOrder.confirm);
ViewBag.status = new SelectList(db.Status, "id_Status", "name", custumerOrder.status);
ViewBag.fk_UserID = new SelectList(db.Userrs, "ID", "name", custumerOrder.fk_UserID);
return(View(custumerOrder));
}
public async Task <ActionResult> Details(int?id)
{
//id => CustumerOrder
CustumerOrder order = this.serviceCustumerOrder.Find(id);
//List<string[]> ordersItemsValues = new List<string[]>();
//if (order.CustumerOrderItems.Count() >= 1)
//{
// int columnsCount = 4;
// foreach (CustumerOrderItem custumerOrderItem in order.CustumerOrderItems)
// {
// string[] values = new string[columnsCount];
// values[0] = custumerOrderItem.ID.ToString();
// values[1] = custumerOrderItem.Item.AttributeValues[0].Value;
// values[2] = custumerOrderItem.Quantity.ToString();
// values[3] = custumerOrderItem.DesiredDateDelivery.ToString();
// ordersItemsValues.Add(values);
// }
//}
User user = this.serviceUser.Find(order.CustumerInfo.User.ID);
CustumerInfo custumerInfo = this.serviceCustumerInfo.GetByUser(user);
this.ViewBag.CustumerOrder = order;
return(View(order.CustumerOrderItems));
}
public async Task <ActionResult> Create(int id, string Name, string Description)
{
//id => User
User user = this.serviceUser.Find(id);
CustumerInfo custumerInfo = this.serviceCustumerInfo.GetByUser(user);
CustumerOrder order = new CustumerOrder()
{
Name = Name,
Description = Description,
CustumerInfo = custumerInfo
};
this.serviceCustumerOrder.Insert(order);
this.unitOfWorkAsync.SaveChanges();
////a.
//this.ViewBag.CustumerInfoID = custumerInfo.ID;
//Redirect To AddItems
return(RedirectToAction("Orders", new { id = user.ID }));
}
public async Task <ActionResult> Relates(int id, int?page, int?idItemType, int?pageSize, FormCollection collection)
{
//id => CustumerOrder
var listItemTypes = await this.serviceItemType.Queryable().ToListAsync();
if (!pageSize.HasValue)
{
pageSize = 100;
}
//http://stackoverflow.com/questions/8107439/why-is-contains-slow-most-efficient-way-to-get-multiple-entities-by-primary-ke
var listTotalIens = this.serviceItem.Queryable().ToList();
this.ViewBag.SelectListPageSize = BuildSelectListPageSize(pageSize.Value);
this.ViewBag.CustumerID = id;
this.ViewBag.ItemTypeID = null;
this.ViewBag.PageSize = pageSize;
int pageNumber = (page ?? 1);
List <TemplateItem> listTemplateItems = null;
if (this.Request.Form["ddItemTypes"] != null || idItemType != null)
{
CustumerOrder custumerOrder = this.serviceCustumerOrder.Find(id);
#region relate
var listItemToRelate = new List <Item>();
foreach (var item in collection)
{
if (item.ToString().Contains("item_"))
{
int itemID = Convert.ToInt32(item.ToString().Replace("item_", ""));
listItemToRelate.Add(listTotalIens.Where(i => i.ID == itemID).FirstOrDefault());
}
}
if (listItemToRelate.Count() >= 1)
{
var listOrdersToInsert = new List <CustumerOrderItem>();
foreach (var itemToRelate in listItemToRelate)
{
CustumerOrderItem orderItem = new CustumerOrderItem()
{
Item = itemToRelate,
DesiredDateDelivery = DateTime.Today,
Quantity = 0,
CustumerOrder = custumerOrder
};
listOrdersToInsert.Add(orderItem);
}
this.serviceCustumerOrderItem.InsertRange(listOrdersToInsert);
this.unitOfWorkAsync.SaveChanges();
}
#endregion
int itemTypeID = 0;
if (this.Request.Form["ddItemTypes"] != null)
{
itemTypeID = Convert.ToInt32(this.Request.Form["ddItemTypes"]);
}
else
{
itemTypeID = idItemType.Value;
}
this.ViewBag.ItemTypeID = itemTypeID;
this.ViewBag.IDItemType = itemTypeID;
ItemType itemType = this.serviceItemType.Find(itemTypeID);
listTemplateItems = this.serviceTemplateItem.Queryable().Where(o => o.ItemType.ID == itemType.ID).ToList();
var listHeader = listTemplateItems[0].TemplateAttributeOrdered.Select(o => o.Name).ToList();
listHeader.Insert(0, "UNSPSC");
listHeader.Insert(0, "Description");
var listItems = listTotalIens.Where(o => o.Template.ItemType.ID == itemType.ID).ToList();
custumerOrder = this.serviceCustumerOrder.Find(id);
var listOrderItem = custumerOrder.CustumerOrderItems;
// var listItemsByOffers = listOffers.Select(o => o.Item).ToList();
var listItemsByOrders = listOrderItem.Where(o => o.Item.ItemType.ID == itemType.ID).Select(j => j.Item).ToList();
var listItensFiltered = listItems.Except(listItemsByOrders);
int i1 = listItems.Count();
int i2 = listItensFiltered.Count();
//List<string[]> listOfListAttributeValues = new List<string[]>();
//foreach (var item in listItensFiltered)
//{
// string[] values = new string[listHeader.Count + 1];
// values[0] = item.ID.ToString();
// for (int i = 0; i < item.AttributeValues.Count; i++)
// {
// values[1 + i] = item.AttributeValues[i].Value;
// }
// listOfListAttributeValues.Add(values);
//}
//IEnumerable<string[]> listPaged = listOfListAttributeValues.ToPagedList(pageNumber, pageSize.Value);
IEnumerable <Item> listPaged = listItensFiltered.ToPagedList(pageNumber, pageSize.Value);
this.ViewBag.ListOfListAttributeValues = listPaged;
this.ViewBag.ListHeader = listHeader;
SelectList selectListItemTypes = new SelectList(listItemTypes, "ID", "Name", itemTypeID);
this.ViewBag.SelectListItemTypes = selectListItemTypes;
return(View(listPaged));
}
else
{
//this.ViewBag.ListHeader = new List<string>();
//List<string[]> listOfListAttributeValues = new List<string[]>();
//IEnumerable<string[]> listPaged = listOfListAttributeValues.ToPagedList(pageNumber, 50);
//SelectList selectListItemTypes = new SelectList(listItemTypes, "ID", "Name");
//this.ViewBag.SelectListItemTypes = selectListItemTypes;
this.ViewBag.ListHeader = new List <string>();
List <Item> listOfListAttributeValues = new List <Item>();
IEnumerable <Item> listPaged = listOfListAttributeValues.ToPagedList(pageNumber, 50);
SelectList selectListItemTypes = new SelectList(listItemTypes, "ID", "Name");
this.ViewBag.SelectListItemTypes = selectListItemTypes;
return(View(listPaged));
}
}
