//
// CountDetails
public static string CountDetails(TimelyDepotContext db, int DetailId, string szItemId, string szDescription)
{
bool bStatus = false;
int nIdSubItem = 0;
string szHas = "0";
UserQuotationDetail userquotationdetail = null;
SUB_ITEM subitem = null;
TimelyDepotContext db02 = new TimelyDepotContext();
IQueryable<SUB_ITEM> qrySubItem = null;
IQueryable<UserQuotationDetail> qryUsrDet = db.UserQuotationDetails.Where(usdt => usdt.DetailId == DetailId);
if (qryUsrDet.Count() > 0)
{
szHas = qryUsrDet.Count().ToString();
foreach (var item in qryUsrDet)
{
userquotationdetail = db.UserQuotationDetails.Find(item.Id);
if (userquotationdetail != null)
{
qrySubItem = db02.SUB_ITEM.Where(sbit => sbit.ItemID == szItemId && sbit.Description == userquotationdetail.ProductType);
if (qrySubItem.Count() > 0)
{
subitem = qrySubItem.FirstOrDefault<SUB_ITEM>();
if (subitem != null)
{
nIdSubItem = subitem.Id;
}
}
else
{
nIdSubItem = 0;
}
if (string.IsNullOrEmpty(userquotationdetail.ItemID))
{
userquotationdetail.ItemID = nIdSubItem.ToString();
bStatus = true;
}
}
}
if (bStatus)
{
db.SaveChanges();
}
}
return szHas;
}
private void DeleteSalesOrderDetails(int id)
{
int nCustomerID = 0;
int nUserID = 0;
int nQuoteId = 0;
string szItemID = "";
string szEmail = "";
//IQueryable<UserQuotation> qryQuoteUsr = null;
IQueryable<UserQuotationDetail> qryQuoteDetails = null;
UserQuotation userquotation = null;
CustomersContactAddress customercontactaddress = null;
TimelyDepotContext db01 = new TimelyDepotContext();
//SalesOrderDetail salesorderdetails = null;
//Get customer email
SalesOrder salesorder = db.SalesOrders.Find(id);
if (salesorder != null)
{
customercontactaddress = db01.CustomersContactAddresses.Where(cuad => cuad.CustomerId == salesorder.CustomerId).FirstOrDefault<CustomersContactAddress>();
if (customercontactaddress != null)
{
szEmail = customercontactaddress.Email;
}
}
IQueryable<SalesOrderDetail> qryalesorderdetails = db.SalesOrderDetails.Where(sodt => sodt.SalesOrderId == id);
if (qryalesorderdetails.Count() > 0)
{
foreach (var item in qryalesorderdetails)
{
if (string.IsNullOrEmpty(szItemID))
{
szItemID = item.ItemID;
}
db.SalesOrderDetails.Remove(item);
}
//Restore Quotation Details
//qryQuoteUsr = db.UserQuotations.Where(qtus => qtus.ProductId == szItemID);
var qryQuoteUsr = db01.UserQuotations.Join(db01.UserRegistrations, usqt => usqt.UserId, usrg => usrg.RId, (usqt, usrg)
=> new { usqt, usrg }).Where(uqus => uqus.usqt.ProductId == szItemID && uqus.usrg.UserName == szEmail);
if (qryQuoteUsr.Count() > 0)
{
//userquotation = qryQuoteUsr.FirstOrDefault<UserQuotation>();
//if (userquotation != null)
//{
// nQuoteId = userquotation.Id;
//}
foreach (var item in qryQuoteUsr)
{
//Get the quoteid
if (nQuoteId == 0)
{
nQuoteId = item.usqt.Id;
}
}
}
if (nQuoteId > 0)
{
qryQuoteDetails = db.UserQuotationDetails.Where(qtdt => qtdt.DetailId == nQuoteId);
if (qryQuoteDetails.Count() > 0)
{
foreach (var item in qryQuoteDetails)
{
item.ShippedQuantity = null;
item.BOQuantity = null;
item.Status = 0;
db.Entry(item).State = EntityState.Modified;
}
}
}
db01.SaveChanges();
}
}
private void UpdateInventory(string[] szHeaders, string[] szRow, TimelyDepotContext db, ITEM item, int nPos, ref string szError)
{
//Asume
// 0 = ItemId
// 1 = PROD_CD
// 2 = UnitperCase
// 3 = CaseWeight
// 4 = UnitWeight
// 5 = CaseDimensionL
// 6 = CaseDimensionW
// 7 = CaseDimensionH
string szItemId = "";
szError = "";
try
{
szItemId = szRow[0];
item = db.ITEMs.Where(itm => itm.ItemID == szItemId).FirstOrDefault<ITEM>();
if (item != null)
{
item.UnitPerCase = szRow[2];
item.CaseWeight = szRow[3];
item.UnitWeight = szRow[4];
item.CaseDimensionL = szRow[5];
item.CaseDimensionW = szRow[6];
item.CaseDimensionH = szRow[7];
db.Entry(item).State = EntityState.Modified;
db.SaveChanges();
}
}
catch (Exception err)
{
szError = string.Format("Row {0}: {1} {2}", nPos, err.Message, err.StackTrace);
}
}
//
// GET: /PurchaseOrder/ReceivePurchaseOrder
public ActionResult ReceivePurchaseOrder(int id)
{
double dPO_Dr = 0;
DateTime dDate = DateTime.Now;
TimelyDepotContext db01 = new TimelyDepotContext();
SUB_ITEM subitem = null;
IQueryable<PurchasOrderDetail> qrypodetails = null;
PurchaseOrders purchaseorders = db.PurchaseOrders.Find(id);
if (string.IsNullOrEmpty(purchaseorders.ReceiveStatus))
{
//Upate inventory
qrypodetails = db.PurchasOrderDetails.Where(podt => podt.PurchaseOrderId == id);
if (qrypodetails.Count() > 0)
{
foreach (var item in qrypodetails)
{
if (!string.IsNullOrEmpty(item.ItemID))
{
subitem = db01.SUB_ITEM.Where(sbit => sbit.ItemID == item.ItemID && sbit.Sub_ItemID == item.Sub_ItemID).FirstOrDefault<SUB_ITEM>();
if (subitem != null)
{
dPO_Dr = Convert.ToDouble(item.Quantity);
subitem.OpenPO_Db = subitem.OpenPO_Db + dPO_Dr;
db01.Entry(subitem).State = EntityState.Modified;
}
}
}
db01.SaveChanges();
}
purchaseorders.ReceiveStatus = string.Format("Received on {0}", dDate.ToString("MMM/dd/yyyy"));
db.Entry(purchaseorders).State = EntityState.Modified;
db.SaveChanges();
}
return RedirectToAction("Index");
}
private void DeleteUnusedVendorItem(int nVendoritemId, string szItemId)
{
TimelyDepotContext db01 = new TimelyDepotContext();
VendorItem vendoritem = null;
IQueryable<VendorItem> qryVendorItem = db.VendorItems.Where(vdit => vdit.ItemId == szItemId && vdit.Id != nVendoritemId);
if (qryVendorItem.Count() > 0)
{
foreach (var item in qryVendorItem)
{
vendoritem = db01.VendorItems.Find(item.Id);
if (vendoritem != null)
{
db01.VendorItems.Remove(vendoritem);
}
}
db01.SaveChanges();
}
}
private void DeleteSalesOrderDetails(int id)
{
TimelyDepotContext db01 = new TimelyDepotContext();
//SalesOrderDetail salesorderdetails = null;
IQueryable<SalesOrderDetail> qryalesorderdetails = db.SalesOrderDetails.Where(sodt => sodt.SalesOrderId == id);
if (qryalesorderdetails.Count() > 0)
{
foreach (var item in qryalesorderdetails)
{
db.SalesOrderDetails.Remove(item);
}
db01.SaveChanges();
}
}