partial void DeleteInvoice(Invoice instance);
partial void InsertInvoice(Invoice instance);
partial void UpdateInvoice(Invoice instance);
public int Insert(DeliveryModel.OrdersModel item)
{
s26webDataContext db = new s26webDataContext();
try
{
Orders orders = new Orders
{
VolunteersId = item.VolunteersId,
Osid = DateTime.UtcNow.AddHours(8).ToString("yyyyMMddHHmm"),
ProductId = item.ProductId,
Order_Quantity = item.Order_Quantity,
TotalPrice = item.TotalPrice,
Name = item.Name,
Mobile = item.Mobile,
CityId = item.CityId,
AreaId = item.AreaId,
Address = item.Address,
SharePoint= true,
Remarks = item.Remarks,
OrdersStates = 22,
OrdersTime = DateTime.UtcNow,
ReciveTimeChoice = 15,
OrdersFrom = 0,
};
db.Orders.InsertOnSubmit(orders);
db.SubmitChanges();
Invoice invoice = new Invoice
{
OrdersId = db.Orders.OrderByDescending(o => o.Id).FirstOrDefault(f => f.Id != null).Id,
InvoiceCategory = item.InvoiceCategory
};
if (item.InvoiceCategory == db.Category.FirstOrDefault(w => w.Fun_Id == 5 && w.Memo.Equals("Invoice")).Id)
{
invoice.InvoiceName = item.InvoiceName;
invoice.InvoiceNo = item.InvoiceNo;
}
db.Invoice.InsertOnSubmit(invoice);
db.SubmitChanges();
db.Connection.Close();
return orders.Id;
}
catch
{
return -1;
}
}