public async Task <string> AddUpdateDetailOrder(DetailOrderDomainModel detailOrder)
{
string status = "";
if (detailOrder.detailOrder_id > 0)
{
tblDetailOrder detailOrderToUpdate = await detailOrderRepository.SingleOrDefault(s => s.order_id == detailOrder.order_id);
if (detailOrderToUpdate != null)
{
detailOrderToUpdate.detailOrder_id = detailOrder.detailOrder_id;
detailOrderToUpdate.barcode = detailOrder.barcode;
detailOrderToUpdate.quantity = detailOrder.quantity;
detailOrderToUpdate.purchasePrice = detailOrder.purchasePrice;
detailOrderToUpdate.order_id = detailOrder.order_id;
detailOrderToUpdate.pro_id = detailOrder.pro_id;
await detailOrderRepository.Update(detailOrderToUpdate);
status = "updated";
}
}
else
{
tblDetailOrder detailOrderToAdd = new tblDetailOrder();
detailOrderToAdd.detailOrder_id = detailOrder.detailOrder_id;
detailOrderToAdd.barcode = detailOrder.barcode;
detailOrderToAdd.quantity = detailOrder.quantity;
detailOrderToAdd.purchasePrice = detailOrder.purchasePrice;
detailOrderToAdd.order_id = detailOrder.order_id;
detailOrderToAdd.pro_id = detailOrder.pro_id;
await detailOrderRepository.Insert(detailOrderToAdd);
status = "added";
}
return(status);
}
public async Task <string> AddUpdatePurchaseOrder(PurchaseOrderDomainModel purchaseOrder)
{
string status = "";
if (purchaseOrder.order_id > 0)
{
tblPurchaseOrder purchaseOrderToUpdate = await purchaseOrderRepository.SingleOrDefault(s => s.order_id == purchaseOrder.order_id);
if (purchaseOrderToUpdate != null)
{
await purchaseOrderRepository.Update(purchaseOrderToUpdate);
status = "updated";
}
}
else
{
List <DetailOrderDomainModel> detailOrder = new List <DetailOrderDomainModel>();
detailOrder = purchaseOrder.orderDetails;
string strVchNo = "";
string strOrderDesc = "";
int vrNo = 0;
tblPurchaseOrder purchaseOrderToAdd = new tblPurchaseOrder();
int lastOrderId = 0;
using (abuhamzapetstoreEntities db = new abuhamzapetstoreEntities())
{
try
{
vrNo = (from c in db.tblvches
orderby c.vch_id descending
select c.vch_id).Take(1).SingleOrDefault();
strVchNo = "0000" + (vrNo + 1);
strOrderDesc = purchaseOrder.description;
if (purchaseOrder.description == null)
{
strOrderDesc = "";
}
var result = db.stpPurchaseOrder(1, purchaseOrder.totalAmount, purchaseOrder.paidAmount,
strOrderDesc, purchaseOrder.supplier, purchaseOrder.paidAmount, strVchNo, 1, purchaseOrder.creditorAcc_Id);
lastOrderId = (from c in db.tblPurchaseOrders
orderby c.order_id descending
select c.order_id).Take(1).SingleOrDefault();
tblDetailOrder detailOrderToAdd = new tblDetailOrder();
foreach (DetailOrderDomainModel singleDetail in detailOrder)
{
result = db.stpDetailOrder(lastOrderId, singleDetail.quantity, singleDetail.barcode,
singleDetail.purchasePrice, strVchNo);
}
}
catch (Exception ex)
{
status = ex.Message;
}
}
status = "added";
}
return(status);
}