public void DeleteById(int id)
{
ORDERS obj = new ORDERS()
{
ID = id
};
Delete(obj);
}
public bool Delete(OrdersVM entity)
{
ORDERS ord = new ORDERS
{
ORDER_ID = entity.ORDER_ID
};
ordersRepo.Delete(ord, entity.ORDER_ID);
return(true);
}
public ORDERS GetOrderById(int id)
{
var order = new ORDERS();
using (OrderGraberDBEntities dbContext = new OrderGraberDBEntities())
{
order = dbContext.ORDERS.FirstOrDefault(x => x.order_id == id);
}
return(order);
}
private void OutputDocPdf(ORDERS Order)
{
using (var memoryF = BL.PDF.PdfGenerator.DocPDF(Order))
{
Response.Clear();
Response.ContentType = "application/pdf";
Response.OutputStream.Write(memoryF.GetBuffer(), 0, memoryF.GetBuffer().Length);
Response.OutputStream.Close();
HttpContext.Current.ApplicationInstance.CompleteRequest();
}
}
public ActionResult GuncelleOrders(int id, string durum, string aciklama)
{
using (sayazilimEntities db = new sayazilimEntities())
{
ORDERS emp = db.ORDERS.Where(x => x.ID == id).FirstOrDefault <ORDERS>();
emp.Durumu = durum;
// emp.IptalAciklama = aciklama;
db.SaveChanges();
return(Json(new { success = true, message = "Durum Güncellendi" }, JsonRequestBehavior.AllowGet));
}
}
///<summary>
///ORDERS
/// </summary>
public static void insert2Order(ORDERS newOrder)
{
string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString();
ECMSDataContext db = new ECMSDataContext(connectString);
//Add new ORDERS to database
db.ORDERS.InsertOnSubmit(newOrder);
//Save changes to Database.
db.SubmitChanges();
}
protected bool orderExist(ORDERS numOrdre, int id)
{
foreach (ArrayList ordrePresent in listOrder(numOrdre))
{
if ((int)ordrePresent[1] == id)
{
return(true);
}
}
return(false);
}
public List <ORDERS> Search(ORDERS Order, int PageSize, int PageIndex, out int TotalRecords, string OrderExp, SortDirection SortDirection)
{
var result = Context.ORDERS.Include("CUSTOMER").Include("D_ORDER_STATUS").AsQueryable();
if (Order != null)
{
if (!String.IsNullOrWhiteSpace(Order.CustomerName))
{
result = result.Where(o => (o.CUSTOMER.Name + " " + o.CUSTOMER.Surname).Contains(Order.CustomerName));
}
if (Order.ID != 0)
{
result = result.Where(o => o.ID == Order.ID);
}
if (Order.SearchStartDate.HasValue)
{
result = result.Where(o => o.DateCreated >= Order.SearchStartDate.Value);
}
if (Order.SearchEndDate.HasValue)
{
result = result.Where(o => o.DateCreated <= Order.SearchEndDate.Value);
}
if (Order.Status.HasValue)
{
result = result.Where(o => o.Status == Order.Status.Value);
}
}
TotalRecords = result.Count();
if (!String.IsNullOrEmpty(OrderExp) && OrderExp.Equals("CustomerName"))
{
if (SortDirection == SortDirection.Ascending)
{
result = result.OrderBy(c => c.CUSTOMER.Name).ThenBy(c => c.CUSTOMER.Surname);
}
else
{
result = result.OrderByDescending(c => c.CUSTOMER.Name).ThenBy(c => c.CUSTOMER.Surname);
}
}
else
{
GenericSorterCaller <ORDERS> sorter = new GenericSorterCaller <ORDERS>();
result = sorter.Sort(result, String.IsNullOrEmpty(OrderExp) ? "ID" : OrderExp, SortDirection);
}
// pagination
return(result.Skip(PageIndex * PageSize).Take(PageSize).ToList());
}
public Task <bool> DeleteAsync(OrdersVM entity)
{
return(Task.Run <bool>(() =>
{
ORDERS ord = new ORDERS
{
ORDER_ID = entity.ORDER_ID
};
ordersRepo.Delete(ord, entity.ORDER_ID);
return true;
}));
}
public bool DeleteOrder(int id)
{
ORDERS order = db.ORDERS.Find(id);
if (order == null)
{
return(false);
}
db.ORDERS.Remove(order);
db.SaveChanges();
return(true);
}
private void AddOrderToDB(decimal orderPrice, int orderID)
{
ORDERS myOrder = new ORDERS()
{
ClientID = (int)_session.CurrentClientID, OrderPrice = orderPrice
};
_uOW.ORDERs.Add(myOrder);
_uOW.Complete();
UpdateOrderTracker(orderID);
}
private void setBonus(ORDERS order, int bonusID, decimal BonusUsed)
{
BONUS bonus = new BONUS()
{
ID = bonusID
};
ORDER_BONUS ordBonus = new ORDER_BONUS()
{
OrderID = order.ID, BonusID = bonusID, Value = BonusUsed, ORDERS = order, BONUS = bonus
};
order.BonusUsed = BonusUsed;
order.ORDER_BONUS.Add(ordBonus);
}
private void popolateReturn(ORDERS singleOrder)
{
litNumber.Text = String.Format(FashionZone.BL.Configuration.OrderNrFormatting, singleOrder.ID);
chkCompleted.Checked = singleOrder.Completed;
chkVerified.Checked = singleOrder.Verified;
txtAmount.Text = singleOrder.TotalAmount.ToString("N2");
if (singleOrder.Status.HasValue)
{
ddlStatus.SelectedValue = singleOrder.Status.Value.ToString();
}
repOrderDett.DataSource = singleOrder.ORDER_DETAIL;
repOrderDett.DataBind();
}
public static void updatePrecription(string str_id, ORDERS updateOrder)
{
string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString();
ECMSDataContext db = new ECMSDataContext(connectString);
//Get ORDERS for update
ORDERS oldOrder = db.ORDERS.FirstOrDefault(e => e.id.Equals(str_id));
oldOrder = updateOrder;
//Save changes to Database.
db.SubmitChanges();
}
public bool UpdateOrder(ORDERS editOrder)
{
bool result = false;
using (OrderGraberDBEntities dbContext = new OrderGraberDBEntities())
{
var recordToEdit = dbContext.ORDERS.FirstOrDefault(x => x.order_id == editOrder.order_id);
recordToEdit.client_id = editOrder.client_id;
recordToEdit.order_date = editOrder.order_date;
recordToEdit.total_order = editOrder.total_order;
recordToEdit.state = editOrder.state;
}
return(result);
}
protected ArrayList listOrder(ORDERS numOrdre)
{
ArrayList retour = new ArrayList();
foreach (ArrayList ordre in _listeOrdres)
{
if (((int)ordre[0] == (int)numOrdre))
{
retour.Add(ordre);
}
}
return(retour);
}
//提交订单
public void check(int addrId)
{
int book_numbers = Convert.ToInt32(Session["select_book_number"]);//Get the size of selected book list
int user_id = Convert.ToInt32(Session["user_id"]);
List <CARTLIST> order_list = new List <CARTLIST>();
for (int i = 0; i < book_numbers; i++)
{
order_list.Add(db.Database.SqlQuery <CARTLIST>("select * from CARTLIST where USER_ID=" + user_id.ToString() + " and BOOK_ID =" + Session["select_book" + i.ToString()]).FirstOrDefault());
}
CART cart = db.CART.Find(user_id);//购物车项
//var cartlist = db.CARTLIST.SqlQuery("select * from CARTLIST where USER_ID=" + user_id.ToString()).ToList();//购物车清单
//int count = db.Database.SqlQuery<int>("select QUANTITY from CARTLIST where USER_ID=" + user_id.ToString()).FirstOrDefault();//项数
int amout = 0;
int total_price = 0;
for (int i = 0; i < book_numbers; i++)
{
total_price += Convert.ToInt32(order_list[i].TOTAL_PRICE);
amout += Convert.ToInt32(order_list[i].QUANTITY);
}
ORDERS new2 = new ORDERS();
int max = db.Database.SqlQuery <int>("select max(ID) from ORDERS").FirstOrDefault(); //找到ID的最大值
max++; //作为新ID
int post_cost = 15 - 3 * amout;
if (post_cost < 0)
{
post_cost = 0;
}
new2.ID = max; new2.USER_ID = user_id; new2.ADDRESS_ID = addrId; new2.QUANTITY = book_numbers; new2.PRICE = total_price;
new2.TIME_START = DateTime.Now.ToString(); new2.STATUS = "NO"; new2.POST_COST = post_cost;
db.ORDERS.Add(new2);
for (int i = 0; i < book_numbers; i++)
{
ORDER_INCLUDE temp = new ORDER_INCLUDE();
temp.ORDER_ID = max;
temp.BOOK_ID = order_list[i].BOOK_ID;
temp.QUANTITY = order_list[i].QUANTITY;
temp.TOTAL_PRICE = order_list[i].TOTAL_PRICE;
db.ORDER_INCLUDE.Add(temp);
}
for (int i = 0; i < book_numbers; i++)
{
removeCart(Convert.ToInt32(Session["select_book" + i.ToString()]), user_id);
}
db.SaveChanges();
}
public static void deleteOrder(string str_id)
{
string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString();
ECMSDataContext db = new ECMSDataContext(connectString);
//Get ORDERS to Delete
ORDERS deleteOrder = db.ORDERS.FirstOrDefault(e => e.id.Equals(str_id));
//Delete ORDERS
db.ORDERS.DeleteOnSubmit(deleteOrder);
//Save changes to Database.
db.SubmitChanges();
}
protected ArrayList getOrder(ORDERS numOrdre, int complement)
{
foreach (ArrayList ordre in _listeOrdres)
{
if (((int)ordre[0] == (int)numOrdre))
{
if (((complement == 0) || ((int)ordre[1] == complement)))
{
return(ordre);
}
}
}
return(createOrder(numOrdre));
}
private int GetOrderID()
{
List <ORDERS> myOrders = _uOW.ORDERs.GetAllOrders().Cast <ORDERS>().ToList();
if (myOrders.Count == 0)
{
return(1);
}
else
{
ORDERS lastOrder = myOrders.Last();
return(lastOrder.OrderID + 1);
}
}
protected void Page_Load(object sender, EventArgs e)
{
servCommfac = new ServiceCommon(base.factoryConnectionString);
if (Request["type"] == "GetBatch")
{
string batchOrderID = Request["BatchOrderID"];
string batchSerialID = Request["BatchSerialID"];
string batchProductID = Request["BatchProductID"];
string zBatchNodes = "";
ccWhere.Clear();
ccWhere.AddComponent("Order_ID", batchOrderID, SearchComponent.Equals, SearchPad.And);
ccWhere.AddComponent("serial", batchSerialID, SearchComponent.Equals, SearchPad.And);
ccWhere.AddComponent("Productid", batchProductID, SearchComponent.Equals, SearchPad.And);
DataTable dt = servCommfac.GetListTop(0, "isnull(Name,'') as Name,isnull(Maker,'') as Maker,isnull(batchNo,'') as batchNo", "OrdersElement", ccWhere);
foreach (DataRow dr in dt.Rows)
{
zBatchNodes = zBatchNodes + "{" + "\"ElementName\":" + "\"" + dr["Name"].ToString() + "\"" + ",\"ElementMaker\":" + "\"" + dr["Maker"].ToString() + "\"" + ",\"BatchNo\":" + "\"" + dr["batchNo"].ToString() + "\"},";
}
zBatchNodes = zBatchNodes.Trim(',');
if (zBatchNodes == "")
{
zBatchNodes = "{}";
}
else
{
zBatchNodes = "[" + zBatchNodes + "]";
}
Response.Write(zBatchNodes);
Response.End();
}
else
{
orderID = Request["orderID"];
serialID = Request["serial"];
ccWhere.Clear();
ccWhere.AddComponent("Order_ID", orderID, SearchComponent.Equals, SearchPad.NULL);
ccWhere.AddComponent("serial", serialID, SearchComponent.Equals, SearchPad.And);
IList <ORDERS> listOrder = servCommfac.GetListTop <ORDERS>(0, "hospital,doctor,Patient,Order_ID,indate,preoutDate,OutDate,Sex,Age", "orders", ccWhere);
if (listOrder.Count > 0)
{
orderModel = listOrder[0];
}
GetProcedureList(orderID, serialID);
}
}
public static List <ORDERS> GetOrders(int CustID)
{
ORDERS order = null;
List <ORDERS> orders = new List <ORDERS>();
try
{
using (OracleConnection con = new OracleConnection(conlink))
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
string query = "SELECT * FROM ORDERS WHERE CUSTID =" + CustID;
OracleCommand cmd = new OracleCommand(query, con);
OracleDataReader reader = cmd.ExecuteReader();
if (reader != null)
{
if (reader.HasRows)
{
while (reader.Read())
{
order = new ORDERS()
{
CUSTID = int.Parse(reader["CUSTID"].ToString()),
ORDERNUM = int.Parse(reader["ORDERNUM"].ToString()),
ORDERTOTAL = int.Parse(reader["ORDERTOTAL"].ToString()),
OREDERDATE = DateTime.Parse(reader["OREDERDATE"].ToString()),
DELIVERYDATE = DateTime.Parse(reader["DELIVERYDATE"].ToString())
};
orders.Add(order);
}
reader.Close();
}
}
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
catch (Exception ex)
{
throw ex;
}
return(orders);
}
public async Task <MessageModel <string> > Post([FromBody] ORDERS request)
{
var data = new MessageModel <string>();
var id = await _ORDERSServices.Add(request);
data.success = id > 0;
if (data.success)
{
data.response = id.ObjToString();
data.msg = "添加成功";
}
return(data);
}
public async Task <MessageModel <string> > Put([FromBody] ORDERS request)
{
var data = new MessageModel <string>();
if (request.ORIGREC > 0)
{
data.success = await _ORDERSServices.Update(request);
if (data.success)
{
data.msg = "更新成功";
data.response = request?.ORIGREC.ObjToString();
}
}
return(data);
}
public void CancelOrderById(int OrderId)
{
ORDERS order = _orderDAO.GetById(OrderId);
PRODUCT_ATTRIBUTE prodAttr;
// put back to the warehouse each product that was in the order
// version is not needed as the availability is incremented, so no risk
foreach (ORDER_DETAIL item in order.ORDER_DETAIL)
{
prodAttr = null;
prodAttr = _productDAO.GetProductAttributeById(item.ProdAttrID);
prodAttr.Availability += item.Quantity;
_productDAO.UpdateProductAttribute(prodAttr, false);
}
order.Canceled = true;
order.Completed = false;
order.Status = 6;
_orderDAO.Update(order, false);
// TODO Revert BONUS
if (order.BonusUsed.HasValue && order.BonusUsed.Value > 0)
{
decimal usedValue = 0;
foreach (ORDER_BONUS b in order.ORDER_BONUS)
{
usedValue += b.Value.Value;
}
DateTime validity = order.ORDER_BONUS.Max(b => b.BONUS.Validity).Value;
BONUS bon = new BONUS()
{
CustomerID = order.CustomerID,
DateAssigned = DateTime.Today,
Validity = validity,
Description = "Per anullim porosie",
Value = usedValue,
ValueRemainder = usedValue
};
_bonusDAO.Insert(bon);
}
Context.SaveChanges();
}
private void setBonus(ORDERS order)
{
int bonusID = 0;
if (Int32.TryParse(ddlBonus.SelectedValue, out bonusID) && bonusID != -1)
{
BONUS bonus = new BONUS()
{
ID = bonusID, Version = Version.Where(b => b.Key == bonusID).FirstOrDefault().Value
};
ORDER_BONUS ordBonus = new ORDER_BONUS()
{
OrderID = order.ID, BonusID = bonusID, Value = BonusUsed, ORDERS = order, BONUS = bonus
};
order.BonusUsed = BonusUsed;
order.ORDER_BONUS.Add(ordBonus);
}
}
public bool SaveOrder(_Order o)
{
try
{
if (o.IsNew)
{
db.ORDERS.Add(new ORDERS()
{
UserName = o.UserName,
StartDate = o.StartDate,
EndDate = o.EndDate,
ActualDate = o.ActualDate,
Number = o.Number,
Payed = o.Payed
});
var curr = db.CARS.Where(a => a.Number == o.Number).FirstOrDefault();
curr.IsFree = false;
}
else
{
ORDERS order = db.ORDERS.Find(o.OrderId);
if (order == null)
{
return(false);
}
order.UserName = o.UserName;
order.StartDate = o.StartDate;
order.EndDate = o.EndDate;
order.ActualDate = o.ActualDate;
order.Number = o.Number;
order.Payed = o.Payed;
}
db.SaveChanges();
}
catch
{
return(false);
}
return(true);
}
public void Update(ORDERS Order, bool Attach = true)
{
if (Attach)
{
Context.ORDERS.Attach(Order);
}
var entry = Context.ObjectStateManager.GetObjectStateEntry(Order);
// excluding datecreated from the updatable fields
entry.SetModifiedProperty("DateShipped");
entry.SetModifiedProperty("Verified");
entry.SetModifiedProperty("Completed");
entry.SetModifiedProperty("Canceled");
entry.SetModifiedProperty("Comments");
entry.SetModifiedProperty("ShippingID");
entry.SetModifiedProperty("ShippingAddress");
entry.SetModifiedProperty("BillingAddress");
entry.SetModifiedProperty("Status");
entry.SetModifiedProperty("ShippingDetails");
entry.SetModifiedProperty("TrackingNumber");
entry.SetModifiedProperty("DateDelivered");
}
/// <summary>
/// Writes the info order.
/// </summary>
/// <param name="order">The order.</param>
/// <param name="phOrd">The ph ord.</param>
/// <param name="miniTitlesFontStyleIns">The mini titles font style ins.</param>
private static void WriteInfoOrder(ORDERS order, ref Phrase phOrd, Font miniTitlesFontStyleIns)
{
string paymentOrder = String.Empty;
decimal paid = 0;
switch (order.PAYMENT.Type)
{
case (int)PaymentType.CA:
paymentOrder = "Cash";
paid = order.PAYMENT.CASH_PAYMENT.Amount.Value;
break;
case (int)PaymentType.PP:
paymentOrder = "PayPal";
paid = order.PAYMENT.PAYPAL_PAYMENT.Amount.Value;
break;
case (int)PaymentType.EP:
paymentOrder = "EasyPay";
paid = order.PAYMENT.EASYPAY_PAYMENT.Amount;
break;
}
if (order != null)
{
string addSh = string.Format(
@"Fatura nr: {0}
Data faturës: {1}
Tipi i pagimit: {2}
Paguar: {3}
Blerësi:{4}
{5}
Kodi: {6}",
String.Format(FashionZone.BL.Configuration.OrderNrFormatting, order.ID),
order.DateCreated.ToString("dd/MM/yyyy hh:mm"),
paymentOrder, paid.ToString("N2") + (order.PAYMENT.Type == (int)PaymentType.EP ? " Lek" : " €"), order.CustomerName, order.CUSTOMER.Email,
order.VerificationNumber);
phOrd = new Phrase(addSh, miniTitlesFontStyleIns);
}
}
public string Update(ORDERS Order, bool Attach = true)
{
string retString = String.Empty;
CUSTOMER customer = _customerDAO.GetById(Order.CustomerID.Value);
// first buy of this customer & invited by someone
if ((!customer.FirstBuy.HasValue || !customer.FirstBuy.Value) && Order.PAYMENT.Type == (int)PaymentType.CA && Order.Completed)
{
if (customer.InvitedFrom.HasValue)
{
insertCustomerBonus(customer);
retString = "Bonus added to inviter " + customer.CUSTOMER2.Email;
Util.Mailer.SendBonus(customer, customer.CUSTOMER2.Email, Configuration.BonusValue + " € bonus per ju ne FZone");
}
customer.FirstBuy = true;
_customerDAO.Update(customer, true, false);
}
_orderDAO.Update(Order, Attach);
// payment
if (Order.PAYMENT != null)
{
if (Order.PAYMENT.Type == (int)PaymentType.CA)
{
var entry = Context.ObjectStateManager.GetObjectStateEntry(Order.PAYMENT.CASH_PAYMENT);
entry.SetModifiedProperty("Receiver");
entry.SetModifiedProperty("Comments");
entry.SetModifiedProperty("PaidOn");
}
else if (Order.PAYMENT.Type == (int)PaymentType.PP)
{
//TODO
}
}
Context.SaveChanges();
return(retString);
}
