public async Task <IHttpActionResult> PutOrder(int id, Containers.Models.EasyInputs.EasyOrder order)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
DB.Order orderDb = order.ToDBOrder();
orderDb.Id = id;
db.Entry(orderDb).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!OrderExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult IncomingOrdersCreate(DB.Order order)
{
var o = db.Orders.FirstOrDefault(x => x.Id == order.Id);
if (o == null)
{
if (order.OrderType_Id % 2 == 0)
{
var start_year = new DateTime(DateTime.Today.Year, 1, 1);
order.DocNumber = (db.Orders.Where(x => x.DocDate >= start_year && x.OrderType_Id == order.OrderType_Id).Count() > 0 ? db.Orders.Where(x => x.DocDate >= start_year && x.OrderType_Id == order.OrderType_Id).Select(x => x.DocNumber).ToList().Select(x => int.Parse(x)).Max() + 1 : 1).ToString();
order.DocDate = DateTime.Today;
order.isDeleted = false;
order.isPaid = false;
}
db.Orders.Add(order);
}
else
{
o.OperDate = order.OperDate;
o.Partner_Id = order.Partner_Id;
o.Organisation_Id = order.Organisation_Id;
o.DocNumber = order.DocNumber;
o.DocDate = order.DocDate;
o.Contract_Id = order.Contract_Id;
o.OrderType_Id = order.OrderType_Id;
}
db.SaveChanges();
return(RedirectToAction("IncomingOrder", new { id = order.Id }));
}
public DB.Order ToDBOrder()
{
DB.Order order = new DB.Order();
order.CustomerFirstName = CustomerFirstName;
order.CustomerLastName = CustomerLastName;
order.CustomerAdress = CustomerAdress;
order.CustomerZIP = CustomerZIP;
order.CustomerEmail = CustomerEmail;
order.CustomerPhoneNumber = CustomerPhoneNumber;
order.Id_City = Id_City;
return(order);
}
public async Task <IHttpActionResult> PostOrder(Containers.Models.EasyInputs.EasyOrder order)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
DB.Order outputOrder = new DB.Order();
outputOrder = order.ToDBOrder();
db.Order.Add(order.ToDBOrder());
await db.SaveChangesAsync();
return(CreatedAtRoute("DefaultApi", new { id = outputOrder.Id }, outputOrder));
}
public ActionResult OutgoingOrdersCreate(DB.Order order)
{
var o = db.Orders.FirstOrDefault(x => x.Id == order.Id);
if (o == null)
{
db.Orders.Add(order);
}
else
{
o.OperDate = order.OperDate;
o.Partner_Id = order.Partner_Id;
o.Organisation_Id = order.Organisation_Id;
o.DocNumber = order.DocNumber;
o.DocDate = order.DocDate;
o.Contract_Id = order.Contract_Id;
o.OrderType_Id = order.OrderType_Id;
}
db.SaveChanges();
return(RedirectToAction("OutgoingOrders"));
}
public int Save(Models.MOrders model)
{
Common.Logger l = new Common.Logger();
string ClassName = "COrders";
try
{
DB.Order bs = new DB.Order();
//bs.id = Convert.ToInt32(model.id);
bs.OrderNo = model.OrdersNo;
bs.OrderName = model.OrderName;
bs.OrderDescription = model.OrderDescription;
bs.OrderDate = Convert.ToDateTime(model.Orderdate);
bs.deliveryDate = Convert.ToDateTime(model.deliverydate);
bs.TotalCost = model.TotalCost;
bs.OrderType = model.OrderType;
bs.ClientId = Convert.ToInt32(model.ClientId);
bs.VendorId = Convert.ToInt32(model.venorld);
bs.FiscalYearId = Convert.ToInt32(model.FiscalYearld);
bs.eDate = Convert.ToDateTime(model.eDate);
bs.WareHouseId = Convert.ToInt32(model.WareHouseId);
bs.Installments = model.Installments;
bs.InstallmentDueDate = model.InstallmentDueDate;
bs.ModeOfPayment = model.ModeOfPayment;
bs.GrantorName = model.GrantorName;
l.Print(ClassName, Common.LogPointer.Info.ToString(), "Model Values id[" + model.id + "] OrderNo[" + model.OrdersNo + "] OrderName[" + model.OrderName + "] Orderdescription[" + model.OrderDescription + "] OrderDate[ " + model.Orderdate + " ] DeliveryDate[ " + model.deliverydate + " ] TotalCost [ " + model.TotalCost + " ] OrdersType [ " + model.ClientId + "] VendoeId [ " + model.venorld + " ] FiscalId [ " + model.FiscalYearld + "] eDate [ " + model.eDate + " ]");
obj.Orders.InsertOnSubmit(bs);
obj.SubmitChanges();
l.Print(ClassName, Common.LogPointer.Info.ToString(), "Record Inserted Successfully");
return(1);
}
catch (Exception ex)
{
l.Print(ClassName, Common.LogPointer.Error.ToString(), ex.ToString());
return(-1);
}
}
