public async Task <ActionResult> Put(TempOrder model)
{
var user = await _context.Users.FirstOrDefaultAsync(x => x.Email == User.Identity.Name);
var order = await _context.Orders
.FirstOrDefaultAsync(x => x.UserId == user.Id && !x.IsBought);
var products = await _context.OrderProducts
.Where(x => x.OrderId == order.Id && !x.IsBought)
.ToListAsync();
for (int i = 0; i < products.Count; i++)
{
products[i].IsBought = true;
_context.OrderProducts.Update(products[i]);
}
order = await _context.Orders
.FirstOrDefaultAsync(x => x.UserId == user.Id && !x.IsBought);
order.IsBought = true;
order.OrderCreated = DateTime.Now;
order.Oplata = model.Oplata;
order.Dostavka = model.Dostavka;
order.Address = model.Address;
order.Phone = model.Phone;
_context.Orders.Update(order);
await _context.SaveChangesAsync();
return(Ok(new
{
message = "Товар успешно куплен!"
}));
}
public void SaveTempOrer(TempOrder aOrder)
{
try
{
DBManager maneageManager = new DBManager();
SqlConnection connection1 = maneageManager.Connection();
string query = "Insert into Temp_Order_Hold values(@serial,@customerName,@mobile,@bookName,@writerName,@edition,@type,@print,@quantity,@unitPrice,@total,@advance,@due,@supplydate,@memoNumber)";
SqlCommand command = new SqlCommand(query, connection1);
command.Parameters.Clear();
command.Parameters.AddWithValue("@serial", aOrder.SerialNo);
command.Parameters.AddWithValue("@customerName", aOrder.CustomerName);
command.Parameters.AddWithValue("@mobile", aOrder.MobileNo);
command.Parameters.AddWithValue("@bookName", aOrder.BookName);
command.Parameters.AddWithValue("@writerName", aOrder.WriterName);
command.Parameters.AddWithValue("@edition", aOrder.Edition);
command.Parameters.AddWithValue("@type", aOrder.Type);
command.Parameters.AddWithValue("@print", aOrder.Print);
command.Parameters.AddWithValue("@quantity", aOrder.Quantity);
command.Parameters.AddWithValue("@unitPrice", aOrder.Unitprice);
command.Parameters.AddWithValue("@total", aOrder.Total);
command.Parameters.AddWithValue("@advance", aOrder.Advance);
command.Parameters.AddWithValue("@due", aOrder.Due);
command.Parameters.AddWithValue("@supplydate", aOrder.SupplyDate);
command.Parameters.AddWithValue("@memoNumber", aOrder.MemoNumber);
connection1.Open();
command.ExecuteNonQuery();
MessageBox.Show("Saved", "Save Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception exception)
{
MessageBox.Show(exception.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public ActionResult Deleteorder(int id)
{
TempOrderProduct temporderProduct = temporderProductRepository.Get(id);
TempOrder torder = temporderrepo.Get(temporderProductRepository.Get(id).OrderID);
temporderProductRepository.Delete(temporderProductRepository.Get(id).ProductOrderID);
temporderrepo.Delete(torder.OrderID);
return(Json("success"));
}
public IHttpActionResult PostdeleteOrder(int id)
{
TempOrderProduct temporderProduct = temporderProductRepository.Get(id);
TempOrder torder = temporderrepo.Get(Convert.ToInt32(temporderProductRepository.Get(id).TempOrderId));
temporderProductRepository.Delete(temporderProductRepository.Get(id).TempOrderProductID);
temporderrepo.Delete(torder.TempOrderId);
return(Ok("success"));
}
/// <summary>
/// 根据传入的医嘱对象表创建医嘱对象集合
/// </summary>
/// <param name="table"></param>
internal OrderCollection(OrderTable table)
{
_maxSerialNo = 0;
m_Table = table;
_orderList = new List <Order>();
Order newOrder;
List <Order> newOrders = new List <Order>();
// 先处理其它状态的医嘱，将新医嘱插在医嘱表的最后
foreach (DataRow row in m_Table.OrderDataTable.Rows)
{
if (m_Table.IsTempOrder)
{
newOrder = new TempOrder(row);
}
else
{
newOrder = new LongOrder(row);
}
if (newOrder.State != OrderState.New)
{
_orderList.Add(newOrder);
}
else
{
newOrders.Add(newOrder);
}
}
foreach (Order tempOrde in newOrders)
{
_orderList.Add(tempOrde);
}
//// 先处理分组信息，然后再绑定事件
//ResetOrderGroupInfo();
foreach (Order temp in _orderList)
{
// 绑定创建输出内容的委托
temp.Content.ProcessCreateOutputeInfo =
new OrderContent.GenerateOutputInfo(CustomDrawOperation.CreateOutputeInfo);
if (temp.Content.Item != null)
{
temp.BeginInit();
temp.Content.Item.ReInitializeProperties();
temp.Content.EndInit();
temp.EndInit();
}
temp.OrderChanged += new EventHandler <OrderChangedEventArgs>(m_Table.AfterOrderChanged);
}
ResetViewList();
}
public IHttpActionResult Post(int id)
{
TempOrderProduct temporderProduct = temporderProductRepository.Get(id);
var pid = temporderProduct.ProductID;
TempOrder torder = temporderrepo.Get(Convert.ToInt32(temporderProductRepository.Get(id).TempOrderId));
temporderProductRepository.Delete(temporderProductRepository.Get(id).TempOrderProductID);
temporderrepo.Delete(Convert.ToInt32(torder.TempOrderId));
Order order = new Order();
order.date = DateTime.Now;
order.PayMentMethod = torder.PayMentMethod;
order.Quantity = torder.Quantity;
order.Size = torder.Size;
order.totalAmount = torder.totalAmount;
orderrepo.Insert(order);
OrderProduct orderProduct = new OrderProduct();
orderProduct.ProductHistoryId = producthis.GetByProductNameCategory(productrepo.Get(Convert.ToInt32(pid)).Product_name, productrepo.Get(Convert.ToInt32(pid)).MainCategoryId).ProductHistoryId;
orderProduct.CustomerID = temporderProduct.CustomerID;
orderProduct.OrderID = order.OrderID;
productorderrepo.Insert(orderProduct);
Profit profit = new Profit();
ProductHistory phis = producthis.Get(orderProduct.ProductHistoryId);
profit.OrderProductId = orderProduct.OrderProductId;
if (phis.Sale != null)
{
var p = (double)phis.UnitPrice;
var v = Convert.ToDouble(phis.Sale.Amount) / 100;
var c1 = (p - (p * v));
profit.ProfitAmount = ((decimal)c1 - phis.Cost) * order.Quantity;
}
else
{
profit.ProfitAmount = (phis.UnitPrice - phis.Cost) * order.Quantity;
}
profitrepo.Insert(profit);
return(Ok("success"));
}
public ActionResult Confirmorder(int id)
{
TempOrderProduct temporderProduct = temporderProductRepository.Get(id);
TempOrder torder = temporderrepo.Get(temporderProductRepository.Get(id).OrderID);
temporderProductRepository.Delete(temporderProductRepository.Get(id).ProductOrderID);
temporderrepo.Delete(temporderProduct.OrderID);
Order order = new Order();
order.date = DateTime.Now;
order.PayMentMethod = torder.PayMentMethod;
order.Quantity = torder.Quantity;
order.Size = torder.Size;
order.totalAmount = torder.totalAmount;
orderrepo.Insert(order);
OrderProduct orderProduct = new OrderProduct();
orderProduct.ProductID = temporderProduct.ProductID;
orderProduct.CustomerID = temporderProduct.CustomerID;
orderProduct.OrderID = order.OrderID;
productorderrepo.Insert(orderProduct);
Profit profit = new Profit();
ProductHistory phis = producthis.Get(orderProduct.ProductID);
profit.ProductOrderID = orderProduct.ProductOrderID;
if (phis.Sale != null)
{
var p = (double)phis.UnitPrice;
var v = Convert.ToDouble(phis.Sale.Amount) / 100;
var c1 = (p - (p * v));
profit.ProfitAmount = ((decimal)c1 - phis.Cost) * order.Quantity;
}
else
{
profit.ProfitAmount = (phis.UnitPrice - phis.Cost) * order.Quantity;
}
profitrepo.Insert(profit);
return(Json("success"));
}
/// <summary>
/// 生成新医嘱行
/// </summary>
/// <returns></returns>
public Order NewOrder()
{
Order newOrder;
if (IsTempOrder)
{
newOrder = new TempOrder();
}
else
{
newOrder = new LongOrder();
}
//只设置基本属性，其它属性的初始设置由外部设置
newOrder.SerialNo = Orders.MaxSerialNo + 1; // 最大序号
newOrder.GroupPosFlag = GroupPositionKind.SingleOrder;
newOrder.GroupSerialNo = newOrder.SerialNo;
return(newOrder);
}
public List <TempOrder> GetempOrders()
{
List <TempOrder> orders = new List <TempOrder>();
try
{
connection = manager.Connection();
string selectQuery = "select * from Temp_Order_Hold";
SqlCommand command = new SqlCommand(selectQuery, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
TempOrder aTempOrder = new TempOrder();
aTempOrder.SerialNo = reader[0].ToString();
aTempOrder.CustomerName = reader[1].ToString();
aTempOrder.MobileNo = reader[2].ToString();
aTempOrder.BookName = reader[3].ToString();
aTempOrder.WriterName = reader[4].ToString();
aTempOrder.Edition = reader[5].ToString();
aTempOrder.Type = reader[6].ToString();
aTempOrder.Print = reader[7].ToString();
aTempOrder.Quantity = Convert.ToInt16(reader[8]);
aTempOrder.Unitprice = Convert.ToDouble(reader[9]);
aTempOrder.Total = Convert.ToDouble(reader[10]);
aTempOrder.Advance = Convert.ToDouble(reader[11]);
aTempOrder.Due = Convert.ToDouble(reader[12]);
aTempOrder.SupplyDate = reader[13].ToString();
aTempOrder.Id = Convert.ToInt16(reader[14]);
aTempOrder.MemoNumber = Convert.ToInt16(reader[15]);
orders.Add(aTempOrder);
}
connection.Close();
}
catch (Exception exception)
{
MessageBox.Show(exception.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(orders);
}
public void SaveDeliveryReport(TempOrder aOrder)
{
try
{
connection = manager.Connection();
string query =
"Insert into Temp_Order_Delivery values(@serial,@customerName,@mobile,@bookName,@writerName,@edition,@print,@quantity,@unitPrice,@total,@advance,@due,@payingAmount,@memoNo)";
SqlCommand cmd = new SqlCommand(query, connection);
connection.Open();
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@serial", aOrder.SerialNo);
cmd.Parameters.AddWithValue("@customerName", aOrder.CustomerName);
cmd.Parameters.AddWithValue("@mobile", aOrder.MobileNo);
cmd.Parameters.AddWithValue("@bookName", aOrder.BookName);
cmd.Parameters.AddWithValue("@writerName", aOrder.WriterName);
cmd.Parameters.AddWithValue("@edition", aOrder.Edition);
cmd.Parameters.AddWithValue("@print", aOrder.Print);
cmd.Parameters.AddWithValue("@quantity", aOrder.Quantity);
cmd.Parameters.AddWithValue("@unitPrice", aOrder.Unitprice);
cmd.Parameters.AddWithValue("@total", aOrder.Total);
cmd.Parameters.AddWithValue("@advance", aOrder.Advance);
cmd.Parameters.AddWithValue("@due", aOrder.Due);
cmd.Parameters.AddWithValue("@payingAmount", aOrder.PayingAmmount);
cmd.Parameters.AddWithValue("@memoNo", aOrder.MemoNumber);
cmd.ExecuteNonQuery();
// MessageBox.Show("Saved into temp delivery report");
}
catch (Exception exception)
{
MessageBox.Show(exception.Message);
}
finally
{
connection.Close();
}
}
private void DeliveryButton(object sender, EventArgs e)
{
try
{
if (dueTextBox.Text.Equals(payingAmountTextBOX.Text))
{
double due, pay, final_Due;
int quantity, serial_No;
double unitprice, advance, BuyUnitPrice;
double a, b;
a = Convert.ToDouble(dueTextBox.Text);
b = Convert.ToDouble(payingAmountTextBOX.Text);
if (dueTextBox.Text.Equals("") && payingAmountTextBOX.Text.Equals(""))
{
MessageBox.Show("There are no order for delivery.", "Error", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
else if (a < b)
{
MessageBox.Show("Please check the paying amount.", "Message", MessageBoxButtons.OK,
MessageBoxIcon.Warning);
}
else
{
due = Convert.ToDouble(dueTextBox.Text);
pay = Convert.ToDouble(payingAmountTextBOX.Text);
final_Due = due - pay;
BuyUnitPrice = Convert.ToDouble(buyingUnitPriceTextBox.Text);
quantity = Convert.ToInt16(bookQuantityTextBOx.Text);
unitprice = Convert.ToDouble(bookUnitPriceTextBOx.Text);
advance = Convert.ToDouble(advanceTextBox.Text);
serial_No = Convert.ToInt16(serialTextBox.Text);
string print = bookPrintTextBox.Text;
DBManager manager = new DBManager();
SqlConnection connection = manager.Connection();
string insertQuery = "INSERT INTO Delivery_Report values(@serial,@cname,@phone,@bookName,@writer,@edition,@print,@quantity,@buyUnitprice,@unitpricecell,@advance,@due,@payingAmount,@finaldue,@date)";
SqlCommand command = new SqlCommand(insertQuery, connection);
connection.Open();
command.Parameters.Clear();
command.Parameters.Add("@serial", serialTextBox.Text);
command.Parameters.Add("@cname", customerNameTextBox.Text);
command.Parameters.Add("@phone", customerMobileTextBox.Text);
command.Parameters.Add("@bookName", bookNameTextBox.Text);
command.Parameters.Add("@writer", writerNameTextBox.Text);
command.Parameters.Add("@edition", bookEditionTextBox.Text);
command.Parameters.Add("@print", bookPrintTextBox.Text);
command.Parameters.Add("@quantity", quantity);
command.Parameters.Add("@buyUnitprice", Convert.ToDouble(BuyUnitPrice));
command.Parameters.Add("@unitpricecell", unitprice);
command.Parameters.Add("@advance", advance);
command.Parameters.Add("@due", due);
command.Parameters.Add("@payingAmount", pay);
command.Parameters.Add("@finaldue", final_Due);
command.Parameters.Add("@date", DateTime.Now.ToShortDateString());
command.ExecuteNonQuery();
DBManager manager6 = new DBManager();
SqlConnection connection6 = manager6.Connection();
string selectQuery6 = "insert into Due_Collection values(@pay,@empty,@payConleection,@date)";
SqlCommand cmd6 = new SqlCommand(selectQuery6, connection6);
connection6.Open()
;
cmd6.Parameters.Clear();
cmd6.Parameters.Add("@pay", "0");
cmd6.Parameters.Add("@empty", "0");
cmd6.Parameters.AddWithValue("@payConleection", pay);
cmd6.Parameters.Add("@date", DateTime.Now.ToShortDateString());
cmd6.ExecuteNonQuery();
connection.Close();
string deleteQuery = "delete from Orders where Order_No='" + serial_No + "'";
SqlCommand command1 = new SqlCommand(deleteQuery, connection);
connection.Open();
int x = command1.ExecuteNonQuery();
MessageBox.Show(customerNameTextBox.Text + " paid his/her due.", "Message",
MessageBoxButtons.OK, MessageBoxIcon.Information);
connection.Close();
//update books
string name = bookNameTextBox.Text;
string writer = writerNameTextBox.Text;
string edition = bookEditionTextBox.Text;
String selectQ = "select Quantiy,B_Unit_Price from Books where Name=@name and Edition=@edition and Writer=@writer";
SqlCommand sletCom = new SqlCommand(selectQ, connection);
connection.Open();
sletCom.Parameters.Clear();
sletCom.Parameters.AddWithValue("@name", name);
sletCom.Parameters.AddWithValue("@edition", edition);
sletCom.Parameters.AddWithValue("@writer", writer);
SqlDataReader reader = sletCom.ExecuteReader();
while (reader.Read())
{
int quantity4 = Convert.ToInt16(reader[0]);
double unitprice5 = Convert.ToDouble(reader[1]);
connection.Close();
int quantityReudceBook, final_quantity;
quantityReudceBook = Convert.ToInt16(bookQuantityTextBOx.Text);
final_quantity = quantity4 - quantityReudceBook;
double T_Price = final_quantity * unitprice5;
string updateQuery = "UPDATE Books set Quantiy=@quantity,Total_Price=@totalPrice where Name=@name and Edition=@edition and Writer=@writer";
SqlCommand upCommand = new SqlCommand(updateQuery, connection);
upCommand.Parameters.Clear();
upCommand.Parameters.AddWithValue("@quantity", final_quantity);
upCommand.Parameters.AddWithValue("@totalPrice", T_Price);
upCommand.Parameters.AddWithValue("@name", name);
upCommand.Parameters.AddWithValue("@edition", edition);
upCommand.Parameters.AddWithValue("@writer", writer);
connection.Open();
int s = upCommand.ExecuteNonQuery();
MessageBox.Show("Updated", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
//temp order delivery report save
TempOrder anOrder = new TempOrder(serialTextBox.Text, customerNameTextBox.Text, customerMobileTextBox.Text, bookNameTextBox.Text, writerNameTextBox.Text, bookEditionTextBox.Text, bookPrintTextBox.Text, Convert.ToInt16(bookQuantityTextBOx.Text), Convert.ToDouble(bookUnitPriceTextBOx.Text
), Convert.ToDouble(Convert.ToInt16(bookQuantityTextBOx.Text) * Convert.ToDouble(bookUnitPriceTextBOx.Text)), Convert.ToDouble(advanceTextBox.Text), final_Due, Convert.ToDouble(payingAmountTextBOX.Text), memoNumver);
TempOrderGateway gateway = new TempOrderGateway();
gateway.SaveDeliveryReport(anOrder);
GetAllOrders();
GetAllOrders1();
ClearAllTextBox();
connection.Close();
return;
}
}
}
else
{
double due, pay, final_Due;
int quantity, serial_No;
double unitprice, advance, BuyUnitPrice;
quan = Convert.ToInt16(bookQuantityTextBOx.Text);
double a, b;
a = Convert.ToDouble(dueTextBox.Text);
b = Convert.ToDouble(payingAmountTextBOX.Text);
if (dueTextBox.Text.Equals("0") || payingAmountTextBOX.Text.Equals("0"))
{
final_Due = 0;
}
else if (a < b)
{
MessageBox.Show("Please check the paying amount.", "Message", MessageBoxButtons.OK,
MessageBoxIcon.Warning);
}
else
{
due = Convert.ToDouble(dueTextBox.Text);
pay = Convert.ToDouble(payingAmountTextBOX.Text);
final_Due = due - pay;
BuyUnitPrice = Convert.ToDouble(buyingUnitPriceTextBox.Text);
quantity = Convert.ToInt16(bookQuantityTextBOx.Text);
unitprice = Convert.ToDouble(bookUnitPriceTextBOx.Text);
advance = Convert.ToDouble(advanceTextBox.Text);
serial_No = Convert.ToInt16(serialTextBox.Text);
DBManager manager = new DBManager();
SqlConnection connection = manager.Connection();
string insertQuery = "INSERT INTO Delivery_Report values(@serial,@cname,@phone,@bookName,@writer,@edition,@print,@quantity,@buyUnitprice,@unitpricecell,@advance,@due,@payingAmount,@finaldue,@date)";
SqlCommand command = new SqlCommand(insertQuery, connection);
connection.Open();
command.Parameters.Clear();
command.Parameters.Add("@serial", serialTextBox.Text);
command.Parameters.Add("@cname", customerNameTextBox.Text);
command.Parameters.Add("@phone", customerMobileTextBox.Text);
command.Parameters.Add("@bookName", bookNameTextBox.Text);
command.Parameters.Add("@writer", writerNameTextBox.Text);
command.Parameters.Add("@edition", bookEditionTextBox.Text);
command.Parameters.Add("@print", bookPrintTextBox.Text);
command.Parameters.Add("@quantity", quantity);
command.Parameters.Add("@buyUnitprice", Convert.ToDouble(BuyUnitPrice));
command.Parameters.Add("@unitpricecell", unitprice);
command.Parameters.Add("@advance", advance);
command.Parameters.Add("@due", due);
command.Parameters.Add("@payingAmount", pay);
command.Parameters.Add("@finaldue", final_Due);
command.Parameters.Add("@date", DateTime.Now.ToShortDateString());
command.ExecuteNonQuery();
connection.Close();
DBManager manager5 = new DBManager();
SqlConnection connection5 = manager5.Connection();
string selectQuery5 = "SELECT Quantity,Unit_Price From Orders where Order_No=@serial";
SqlCommand cmd5 = new SqlCommand(selectQuery5, connection5);
cmd5.Parameters.Clear();
cmd5.Parameters.AddWithValue("@serial", serial_No);
connection5.Open()
;
SqlDataReader reader5 = cmd5.ExecuteReader();
while (reader5.Read())
{
string q = reader5[0].ToString();
string r = reader5[1].ToString();
if (q.Equals("") && r.Equals(""))
{
qunatityOfRemaingBook = 0;
unit_Price = 0;
}
else
{
qunatityOfRemaingBook = Convert.ToInt16(q);
unit_Price = Convert.ToDouble(r);
}
}
connection.Close();
//Due Collection table Update
double s_due = Convert.ToDouble(dueTextBox.Text) - Convert.ToDouble(payingAmountTextBOX.Text);
DBManager manager6 = new DBManager();
SqlConnection connection6 = manager6.Connection();
string selectQuery6 = "insert into Due_Collection values(@pay,@s_due,@payCollection,@date)";
SqlCommand cmd6 = new SqlCommand(selectQuery6, connection6);
connection6.Open()
;
cmd6.Parameters.Clear();
cmd6.Parameters.Add("@pay", "0");
cmd6.Parameters.Add("@s_due", s_due);
cmd6.Parameters.AddWithValue("@payCollection", pay);
cmd6.Parameters.Add("@date", DateTime.Now.ToShortDateString());
cmd6.ExecuteNonQuery();
int sa = qunatityOfRemaingBook - quan;
string deleteQuery = "Update Orders set Quantity=@quantity,Total_price=@totalprice, Due=@due where Order_No=@serial";
SqlCommand command1 = new SqlCommand(deleteQuery, connection);
command1.Parameters.Clear();
command1.Parameters.AddWithValue("@quantity", sa);
command1.Parameters.AddWithValue("@totalprice", (sa * unit_Price));
command1.Parameters.AddWithValue("@due", final_Due);
command1.Parameters.AddWithValue("@serial", serial_No);
connection.Open();
int x = command1.ExecuteNonQuery();
MessageBox.Show(customerNameTextBox.Text + " Your current due is " + final_Due + ".", "Message",
MessageBoxButtons.OK, MessageBoxIcon.Information);
connection.Close();
//books update
string name = (bookNameTextBox.Text).Trim();
string writer = writerNameTextBox.Text;
string edition = bookEditionTextBox.Text;
string selectQ = "select Quantiy,B_Unit_Price from Books where Name=@name and Edition=@edition and Writer=@writer";
SqlCommand sletCom = new SqlCommand(selectQ, connection);
sletCom.Parameters.Clear();
sletCom.Parameters.AddWithValue("@name", name);
sletCom.Parameters.AddWithValue("@edition", edition);
sletCom.Parameters.AddWithValue("@writer", writer);
connection.Open();
SqlDataReader reader = sletCom.ExecuteReader();
while (reader.Read())
{
int quantity4 = Convert.ToInt16(reader[0]);
double unitprice5 = Convert.ToDouble(reader[1]);
connection.Close();
int quantityReudceBook, final_quantity;
quantityReudceBook = Convert.ToInt16(bookQuantityTextBOx.Text);
final_quantity = quantity4 - quantityReudceBook;
double T_Price = final_quantity * unitprice5;
string updateQuery = "UPDATE Books set Quantiy=@finalQuantity,Total_Price=@totalprice where Name=@name and Edition=@edition and Writer=@writer";
SqlCommand upCommand = new SqlCommand(updateQuery, connection);
upCommand.Parameters.Clear();
upCommand.Parameters.AddWithValue("@finalQuantity", final_quantity);
upCommand.Parameters.AddWithValue("@totalprice", T_Price);
upCommand.Parameters.AddWithValue("@name", name);
upCommand.Parameters.AddWithValue("@edition", edition);
upCommand.Parameters.AddWithValue("@writer", writer);
connection.Open();
upCommand.ExecuteNonQuery();
//for partial pay
TempOrder anOrder = new TempOrder(serialTextBox.Text, customerNameTextBox.Text, customerMobileTextBox.Text, bookNameTextBox.Text, writerNameTextBox.Text, bookEditionTextBox.Text, bookPrintTextBox.Text, Convert.ToInt16(bookQuantityTextBOx.Text), Convert.ToDouble(bookUnitPriceTextBOx.Text
), Convert.ToDouble(Convert.ToInt16(bookQuantityTextBOx.Text) * Convert.ToDouble(bookUnitPriceTextBOx.Text)), Convert.ToDouble(advanceTextBox.Text), final_Due, Convert.ToDouble(payingAmountTextBOX.Text), memoNumver);
TempOrderGateway gateway = new TempOrderGateway();
gateway.SaveDeliveryReport(anOrder);
GetAllOrders();
GetAllOrders1();
ClearAllTextBox();
connection.Close();
MessageBox.Show("Updated", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
}
}
}
catch (Exception formatException)
{
MessageBox.Show(formatException.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public IHttpActionResult Get(int id, string paymentmethod)
{
var x = ProductController.cartviewlist;
List <CartViewModel> cartlist = ProductController.cartviewlist;
var date = DateTime.Now;
foreach (var item in cartlist)
{
if (item.product.SizeCategory == "other")
{
Product p1 = new Product();
p1 = productrepo.Get(item.product.ProductId);
p1.OnHand -= item.count;
productrepo.Update(p1);
}
else
{
ProductSize psize = new ProductSize();
psize = productsizeModel.Get(item.size.ProductSizeID);
psize.Count = (psize.Count - item.count);
if (psize.Count == 0)
{
productsizeModel.Delete(psize.ProductSizeID);
}
else
{
productsizeModel.Update(psize);
}
}
TempOrder order = new TempOrder();
order.date = date;
order.Quantity = item.count;
if (item.product.Sale != null)
{
var p = (double)item.product.UnitPrice;
var v = Convert.ToDouble(item.product.Sale.Amount) / 100;
var c1 = (p - (p * v));
order.totalAmount = (decimal)(item.count * c1);
}
else
{
order.totalAmount = (item.count * item.product.UnitPrice);
}
if (item.product.SizeCategory != "other")
{
order.Size = item.size.SizeName;
}
order.PayMentMethod = paymentmethod;
temporderrepo.Insert(order);
TempOrderProduct orderproduct = new TempOrderProduct();
orderproduct.CustomerID = id;
orderproduct.TempOrderId = order.TempOrderId;
orderproduct.ProductID = item.product.ProductId;
temporderproductrepo.Insert(orderproduct);
/* Profit profit = new Profit();
* profit.ProductOrderID = orderproduct.ProductOrderID;
* if (item.product.Sale != null)
* {
* var p = (double)item.product.UnitPrice;
* var v = Convert.ToDouble(item.product.Sale.Amount) / 100;
* var c1 = (p - (p * v));
* profit.ProfitAmount = ((decimal)c1 - item.product.Cost) * item.count;
* }
* else
* {
* profit.ProfitAmount = (item.product.UnitPrice - item.product.Cost) * item.count;
* }
*
*
* profitrepo.Insert(profit);*/
}
ProductController.cartviewlist.Clear();
return(Ok("SuccessView"));
}
/// <summary>
/// 重置属性的值
/// </summary>
public void ResetProperties()
{
if (_orderCache == null)
{
ClearProperties();
}
else
{
_serialNo = _orderCache.SerialNo;
_groupSerialNo = _orderCache.GroupSerialNo;
_groupPosFlag = _orderCache.GroupPosFlag;
_startDate = UILogic.ConvertToDateString(_orderCache.StartDateTime);
_startTime = UILogic.ConvertToTimeString(_orderCache.StartDateTime.TimeOfDay);
// 以下信息并不一定存在
if ((_orderCache.CreateInfo != null) && (_orderCache.CreateInfo.HadInitialized))
{
_creator = _orderCache.CreateInfo.Executor.ToString();
}
if (_orderCache.Content == null)
{
_content = "";
}
else
{
_content = _orderCache.Content.ToString();
}
if ((_orderCache.AuditInfo != null) && (_orderCache.AuditInfo.HadInitialized))
{
_auditDate = UILogic.ConvertToDateString(_orderCache.AuditInfo.ExecuteTime);
_auditTime = UILogic.ConvertToTimeString(_orderCache.AuditInfo.ExecuteTime.TimeOfDay);
_auditor = _orderCache.AuditInfo.Executor.ToString();
}
if ((_orderCache.CancelInfo != null) && (_orderCache.CancelInfo.HadInitialized))
{
_cancellor = _orderCache.CancelInfo.Executor.ToString();
}
if ((_orderCache.ExecuteInfo != null) && (_orderCache.ExecuteInfo.HadInitialized))
{
_executeDate = UILogic.ConvertToDateString(_orderCache.ExecuteInfo.ExecuteTime);
_executeTime = UILogic.ConvertToTimeString(_orderCache.ExecuteInfo.ExecuteTime.TimeOfDay);
_executor = _orderCache.ExecuteInfo.Executor.ToString();
}
_state = _orderCache.State;
_hadSynch = _orderCache.HadSync;
TempOrder tempTemp = _orderCache as TempOrder;
if (tempTemp != null)
{
_applySerialNo = tempTemp.ApplySerialNo;
}
else
{
_applySerialNo = -1;
}
LongOrder tempLong = _orderCache as LongOrder;
if (tempLong != null)
{
if ((tempLong.CeaseInfo != null) && (tempLong.CeaseInfo.HadInitialized))
{
_ceaseDate = UILogic.ConvertToDateString(tempLong.CeaseInfo.ExecuteTime);
_ceaseTime = UILogic.ConvertToTimeString(tempLong.CeaseInfo.ExecuteTime.TimeOfDay);
_ceasor = tempLong.CeaseInfo.Executor.ToString();
}
if ((tempLong.CeaseAuditInfo != null) && (tempLong.CeaseAuditInfo.HadInitialized))
{
_ceaseAuditorDate = UILogic.ConvertToDateString(tempLong.CeaseAuditInfo.ExecuteTime);
_ceaseAuditorTime = UILogic.ConvertToTimeString(tempLong.CeaseAuditInfo.ExecuteTime.TimeOfDay);
_ceaseAuditor = tempLong.CeaseAuditInfo.Executor.ToString();
}
}
}
}
//save an Order
private void orderAcceptButton_Click(object sender, EventArgs e)
{
try
{
OrderGateway gateway = new OrderGateway();
Order anOrder = new Order();
anOrder.CustomerName = customerNameTextBox.Text;
anOrder.CustomerPhone = customerMobileTextBox.Text;
anOrder.BookName = bookNameTextBox.Text;
anOrder.WriterName = writerNameTextBox.Text;
anOrder.Edition = bookEditionTextBox.Text;
anOrder.TypeOfBook = typeOfBookTextBox.Text;
anOrder.BookPrint = bookPrintTextbox.Text;
anOrder.BuyUnitPrice = Convert.ToDouble(buyingUnitPriceTextBox.Text);
string quantiy = bookQuantityTextBOx.Text;
anOrder.Quantity = Convert.ToInt16(quantiy);
anOrder.UnitPrice = Convert.ToDouble(bookUnitPriceTextBOx.Text);
anOrder.Advance = Convert.ToDouble(advanceTextBox.Text);
anOrder.SupplyDate = dateTimePicker1.Text;
string st = gateway.SaveOrder(anOrder);
////InvoiceUI invoice=new InvoiceUI(serialTextBox.Text,customerNameTextBox.Text,customerMobileTextBox.Text,bookNameTextBox.Text,writerNameTextBox.Text,bookEditionTextBox.Text,typeOfBookTextBox.Text,bookPrintTextbox.Text,bookQuantityTextBOx.Text,bookUnitPriceTextBOx.Text,advanceTextBox.Text,dueTextBox.Text,dateTimePicker1.Text);
//invoice.ShowDialog();
TempOrder aOrder = new TempOrder();
aOrder.SerialNo = serialTextBox.Text;
aOrder.CustomerName = customerNameTextBox.Text;
aOrder.MobileNo = customerMobileTextBox.Text;
aOrder.BookName = bookNameTextBox.Text;
aOrder.WriterName = writerNameTextBox.Text;
aOrder.Edition = bookEditionTextBox.Text;
aOrder.Type = typeOfBookTextBox.Text;
aOrder.Print = bookPrintTextbox.Text;
aOrder.Quantity = Convert.ToInt16(bookQuantityTextBOx.Text);
aOrder.Unitprice = Convert.ToDouble(bookUnitPriceTextBOx.Text);
aOrder.Total =
(Convert.ToInt16(bookQuantityTextBOx.Text) * Convert.ToDouble(bookUnitPriceTextBOx.Text));
aOrder.Advance = Convert.ToDouble(advanceTextBox.Text);
aOrder.Due = Convert.ToDouble(dueTextBox.Text);
aOrder.SupplyDate = dateTimePicker1.Text;
aOrder.MemoNumber = memoNumver;
TempOrderGateway gateway1 = new TempOrderGateway();
gateway1.SaveTempOrer(aOrder);
MessageBox.Show(st, "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
ClearALLtextBox();
LoadAllBook();
serialTextBox.Text = LastAddedInvestlNo().ToString();
CustomerNamteSuggestion();
AtocompleteTextBox();
}
catch (Exception exception)
{
MessageBox.Show(exception.Message);
//MessageBox.Show("Please fill every fields properly.", "Error", MessageBoxButtons.OK,
// MessageBoxIcon.Error);
}
}
public ActionResult UpdateOrderInformation()
{
List <CartViewModel> cartlist = new List <CartViewModel>();
cartlist = (List <CartViewModel>)Session["cart"];
var date = DateTime.Now;
foreach (var item in cartlist)
{
if (item.product.SizeCategory == "other")
{
Product p1 = new Product();
p1 = productrepo.Get(item.product.Product_id);
p1.OnHand -= item.count;
productrepo.Update(p1);
}
else
{
ProductSize psize = new ProductSize();
psize = productsizeModel.Get(item.size.ProductSizeID);
psize.Count = (psize.Count - item.count);
if (psize.Count == 0)
{
productsizeModel.Delete(psize.ProductSizeID);
}
else
{
productsizeModel.Update(psize);
}
}
TempOrder order = new TempOrder();
order.date = date;
order.Quantity = item.count;
if (item.product.Sale != null)
{
var p = (double)item.product.UnitPrice;
var v = Convert.ToDouble(item.product.Sale.Amount) / 100;
var c1 = (p - (p * v));
order.totalAmount = (decimal)(item.count * c1);
}
else
{
order.totalAmount = (item.count * item.product.UnitPrice);
}
if (item.product.SizeCategory != "other")
{
order.Size = item.size.SizeName;
}
order.PayMentMethod = (string)Session["paymentmethod"];
temporderrepo.Insert(order);
TempOrderProduct orderproduct = new TempOrderProduct();
orderproduct.CustomerID = (int)Session["LoginID"];
orderproduct.OrderID = order.OrderID;
orderproduct.ProductID = productHistory.GetByProductNameCategory(item.product.Product_name, item.product.CategoryID).Product_id;
temporderproductrepo.Insert(orderproduct);
/* Profit profit = new Profit();
* profit.ProductOrderID = orderproduct.ProductOrderID;
* if (item.product.Sale != null)
* {
* var p = (double)item.product.UnitPrice;
* var v = Convert.ToDouble(item.product.Sale.Amount) / 100;
* var c1 = (p - (p * v));
* profit.ProfitAmount = ((decimal)c1 - item.product.Cost) * item.count;
* }
* else
* {
* profit.ProfitAmount = (item.product.UnitPrice - item.product.Cost) * item.count;
* }
*
*
* profitrepo.Insert(profit);*/
}
Session["cart"] = null;
return(RedirectToAction("SuccessView"));
}
