public NewMultiStockViewModel()
{
if (DesignerProperties.GetIsInDesignMode(new System.Windows.DependencyObject()))
{
return;
}
try
{
StockDetails = new skStock();
PurchaseDetails = new skPurchase();
_AddStock = new Command(Add);
_RemoveStock = new Command(Remove, false);
_ClearStock = new Command(Clear);
_SubmitNewStockItem = new Command(SubmitData);
VendorList = new ObservableCollection <skvendors>(skvendors.VendorList());
CategoryList = new ObservableCollection <skCategory>(skCategory.CategoryList());
ValueBandList = new ObservableCollection <skValueBands>(skValueBands.ValueBandList());
StockToAdd = new ObservableCollection <skStock>();
Notification = new Notification();
PurchaseDetails.Amount = 0;
}
catch (Exception E)
{
ExepionLogger.Logger.LogException(E);
ExepionLogger.Logger.Show(E);
}
}
public static void Load(this skPurchase Object)
{
ObjectMessenger OM = new ObjectMessenger();
OM.Send("TRANOBJ", Object);
UI.Enviroment.LoadNewTab("PurchaseDetailsView", Object.Title);
}
public SaleDetailViewModel()
{
_Salesobj = new skSales();
_Purchaseobj = new skPurchase();
Data = new DataFunctions();
Salesobj = Data.GetSalesDetails(StaticDataReposityory.SelectedSaleID);
if (Salesobj.AddressId != null)
{
Addressobj = Data.GetAddressObject(Convert.ToInt32(Salesobj.AddressId));
// Personobj = Data.GetPersonObject(Convert.ToInt32(Addressobj.PersonID));
}
}
public PurchaseDetailsViewModel()
{
if (DesignerProperties.GetIsInDesignMode(new System.Windows.DependencyObject()))
{
return;
}
Data = new DataFunctions();
_PurchaseObj = Data.GetPurchaseDetails(StaticDataReposityory.SelectedSaleID);
if (_PurchaseObj.VendorId != null)
{
_VendorObj = Data.GetVendorDetails(Convert.ToInt32(_PurchaseObj.VendorId));
_Addressobj = Data.GetAddressObject(Convert.ToInt32(_VendorObj.AddresseID));
}
}
public void AddNewPurchase(skPurchase PurchaseOb, int UserID)
{
dtPurchese newpurchase = new dtPurchese
{
ItemTitle = PurchaseOb.Title,
ItemDescription = PurchaseOb.Description,
PurchesedValue = PurchaseOb.Amount,
ShippingCosts = PurchaseOb.Postage,
InvoiceID = PurchaseOb.Invoice,
Purchesed_Date = PurchaseOb.PurchaseDate,
AddedBy = UserID,
VendorID = PurchaseOb.VendorObject.VendorID,
IsExpense = PurchaseOb.IsExpense,
Created = DateTime.Now,
Updated = DateTime.Now
};
DB.dtPurcheses.InsertOnSubmit(newpurchase);
DB.SubmitChanges();
decimal pVALUE = System.Math.Abs(Convert.ToDecimal(PurchaseOb.Amount)) * (-1);
decimal pPOSTAGE = System.Math.Abs(PurchaseOb.Postage) * (-1);
int pID = TopPurchase();
dtTransactionLedger newpurchaseledger = new dtTransactionLedger
{
PurchaseID = pID,
TransactionType = "Purchase",
TotelAmount = pVALUE,
SaleID = null,
TransactionDateTime = Convert.ToDateTime(PurchaseOb.PurchaseDate)
};
dtTransactionLedger newshippingledger = new dtTransactionLedger
{
PurchaseID = pID,
TransactionType = "Shipping",
TotelAmount = pPOSTAGE,
SaleID = null,
TransactionDateTime = Convert.ToDateTime(PurchaseOb.PurchaseDate)
};
DB.dtTransactionLedgers.InsertOnSubmit(newpurchaseledger);
DB.dtTransactionLedgers.InsertOnSubmit(newshippingledger);
DB.SubmitChanges();
}
public NewPurchaseViewModel()
{
if (DesignerProperties.GetIsInDesignMode(new System.Windows.DependencyObject()))
{
return;
}
try
{
PurchaseDetails = new skPurchase();
_SubmitPurchase = new Command(submitpurchase);
VendorList = new ObservableCollection <skvendors>(skvendors.VendorList());
}
catch (Exception E)
{
ExepionLogger.Logger.LogException(E);
ExepionLogger.Logger.Show(E);
}
}
public void UpdatePurchase(skPurchase PurchaseObject)
{
dtPurchese PurchaseToUpdate = DB.dtPurcheses.Single(x => x.pID == PurchaseObject.ID);
if (PurchaseToUpdate != null)
{
PurchaseToUpdate.ItemTitle = PurchaseObject.Title;
PurchaseToUpdate.ItemDescription = PurchaseObject.Description;
PurchaseToUpdate.ShippingCosts = PurchaseObject.Postage;
PurchaseToUpdate.Purchesed_Date = PurchaseObject.PurchaseDate;
PurchaseToUpdate.Updated = DateTime.Now;
DB.SubmitChanges();
}
else
{
throw new Exception("Purchase record doesnt exist within the Database.");
}
}
public void AddNewStockItem(skStock StockOb, skPurchase PurchaseOb, int UserID)
{
dtPurchese newpurchase = new dtPurchese
{
ItemTitle = StockOb.Name,
ItemDescription = StockOb.Description,
PurchesedValue = PurchaseOb.Amount,
ShippingCosts = PurchaseOb.Postage,
InvoiceID = PurchaseOb.Invoice,
Purchesed_Date = PurchaseOb.PurchaseDate,
AddedBy = UserID,
VendorID = PurchaseOb.VendorObject.VendorID,
IsExpense = false,
Created = DateTime.Now,
Updated = DateTime.Now
};
dtStock newstock = new dtStock
{
CategoryID = StockOb.CategoryObject.StockTypeID,
ItemDesc = StockOb.Description,
ItemTitle = StockOb.Name,
ValueBandID = StockOb.ValueBandObject.ID,
Batch = 0,
Sold = false,
CreatedBy = UserID,
Created = DateTime.Now,
dtPurchese = newpurchase
};
dtStockDetail newdetails = new dtStockDetail
{
PurchaseValue = StockOb.purchasedvalue
};
newstock.dtStockDetails.Add(newdetails);
DB.dtStocks.InsertOnSubmit(newstock);
DB.SubmitChanges();
decimal pVALUE = System.Math.Abs(Convert.ToDecimal(PurchaseOb.Amount)) * (-1);
decimal pPOSTAGE = System.Math.Abs(PurchaseOb.Postage) * (-1);
int pID = TopPurchase();
int? stockID = GetTop1MostrecentSid();
dtStockHistory newstatus = new dtStockHistory
{
StoockID = stockID,
Status = "Stock Created",
Value = StockOb.purchasedvalue,
UserID = UserID,
Created = DateTime.Now,
StatusID = 0
};
dtTransactionLedger newpurchaseledger = new dtTransactionLedger
{
PurchaseID = pID,
TransactionType = "Purchase",
TotelAmount = pVALUE,
SaleID = null,
TransactionDateTime = Convert.ToDateTime(PurchaseOb.PurchaseDate)
};
dtTransactionLedger newshippingledger = new dtTransactionLedger
{
PurchaseID = pID,
TransactionType = "Shipping",
TotelAmount = pPOSTAGE,
SaleID = null,
TransactionDateTime = Convert.ToDateTime(PurchaseOb.PurchaseDate)
};
DB.dtStockHistories.InsertOnSubmit(newstatus);
DB.dtTransactionLedgers.InsertOnSubmit(newpurchaseledger);
DB.dtTransactionLedgers.InsertOnSubmit(newshippingledger);
DB.SubmitChanges();
}
public void AddNewStockItem(List <skStock> StockList, skPurchase PurchaseObject, int UserID)
{
dtPurchese newpurchase = new dtPurchese
{
ItemTitle = PurchaseObject.Title,
ItemDescription = PurchaseObject.Description,
PurchesedValue = PurchaseObject.Amount,
ShippingCosts = PurchaseObject.Postage,
InvoiceID = PurchaseObject.Invoice,
Purchesed_Date = PurchaseObject.PurchaseDate,
AddedBy = UserID,
VendorID = PurchaseObject.VendorObject.VendorID,
IsExpense = false,
Created = DateTime.Now,
Updated = DateTime.Now
};
DB.dtPurcheses.InsertOnSubmit(newpurchase);
DB.SubmitChanges();
int ID = (from s in DB.dtPurcheses
orderby s.pID descending
select new { ID = s.pID }).Take(1).FirstOrDefault().ID;
foreach (skStock s in StockList)
{
dtStock newstock = new dtStock
{
CategoryID = s.CategoryObject.StockTypeID,
ItemDesc = s.Description,
ItemTitle = s.Name,
ValueBandID = s.ValueBandObject.ID,
Batch = 0,
Sold = false,
CreatedBy = UserID,
Created = DateTime.Now,
PurchaseID = ID
};
dtStockDetail newdetails = new dtStockDetail
{
PurchaseValue = s.purchasedvalue
};
dtStockHistory newstatus = new dtStockHistory
{
Status = "Stock Created",
Value = s.purchasedvalue,
UserID = UserID,
Created = DateTime.Now,
StatusID = 0
};
newstock.dtStockHistories.Add(newstatus);
newstock.dtStockDetails.Add(newdetails);
DB.dtStocks.InsertOnSubmit(newstock);
}
DB.SubmitChanges();
}
public void AddNewStock(List <skStock> StockList, skPurchase PurchaseObject, int UserID)
{
StockRepo.AddNewStockItem(StockList, PurchaseObject, UserID);
}
public void AddNewStock(skStock StockOb, skPurchase PurchaseOb, int UserID)
{
StockRepo.AddNewStockItem(StockOb, PurchaseOb, UserID);
}
public void AddNewPurchase(skPurchase PurchaseObject, int UserID)
{
TransactionRepo.AddNewPurchase(PurchaseObject, UserID);
}
public void AddNewStock(skStock StockOb, skPurchase PurchaseOb, int UserID)
{
base.Channel.AddNewStock(StockOb, PurchaseOb, UserID);
}
public void AddNewPurchase(skPurchase PurchaseObject, int UserID)
{
base.Channel.AddNewPurchase(PurchaseObject, UserID);
}
public void AddNewStock(List <skStock> StockList, skPurchase PurchaseObject, int UserID)
{
base.Channel.AddNewStock(StockList, PurchaseObject, UserID);
}
public void UpdatePurchase(skPurchase PurchaseObject)
{
base.Channel.UpdatePurchase(PurchaseObject);
}
public void UpdatePurchase(skPurchase PurchaseObject)
{
TransactionRepo.UpdatePurchase(PurchaseObject);
}
public bool IsRecordDirty(object RecordToCheck)
{
Type typetocheck = RecordToCheck.GetType();
switch (typetocheck.Name)
{
case "skStock":
skStock StockOBJ = (skStock)RecordToCheck;
var newstockdate = (from S in DB.dtStocks
where S.sID == StockOBJ.Stockid
select new skStock
{
Updated = S.Updated
}).SingleOrDefault().Updated;
return(newstockdate > StockOBJ.Updated ? true : false);
case "skSales":
skSales SalesOBJ = (skSales)RecordToCheck;
var newsaledate = (from S in DB.dtSales
where S.tID == SalesOBJ.ID
select new skSales
{
Updated = S.Updated
}).SingleOrDefault().Updated;
return(newsaledate > SalesOBJ.Updated ? true : false);
case "skPurchase":
skPurchase PurchaseOBJ = (skPurchase)RecordToCheck;
var newpurchasedate = (from P in DB.dtPurcheses
where P.pID == PurchaseOBJ.ID
select new skPurchase
{
Updated = P.Updated
}).SingleOrDefault().Updated;
return(newpurchasedate > PurchaseOBJ.Updated ? true : false);
default:
throw new Exception("Object is not a valid record");
case "skRefund":
skRefund RefundOBJ = (skRefund)RecordToCheck;
var newrefunddate = (from R in DB.dtRefunds
where R.rID == RefundOBJ.ID
select new skRefund
{
Updated = R.Updated
}).SingleOrDefault().Updated;
return(newrefunddate > RefundOBJ.Updated ? true : false);
}
}
