public void AddNewRefund(skRefund RefundObject, int UserID)
{
dtRefund NewRefund = new dtRefund
{
Reason = RefundObject.Description,
Amount = Convert.ToDecimal(RefundObject.Amount),
Postage = RefundObject.SHippingCosts,
Refunded = DateTime.Now,
RefundedBy = UserID,
StockID = Convert.ToInt32(RefundObject.StockItem.Stockid),
Created = DateTime.Now,
Updated = DateTime.Now
};
DB.dtRefunds.InsertOnSubmit(NewRefund);
DB.SubmitChanges();
dtTransactionLedger NewRefundLedger = new dtTransactionLedger
{
RefundID = getlastrefund(),
TransactionType = "Refund",
TotelAmount = Maths.GetNegativeValue(Convert.ToDecimal(RefundObject.Amount)),
TransactionDateTime = DateTime.Now
};
dtStockHistory NewStatus = new dtStockHistory
{
StoockID = Convert.ToInt32(RefundObject.StockItem.Stockid),
Status = "Return",
Value = RefundObject.Amount,
UserID = UserID,
Created = DateTime.Now,
StatusID = 0
};
DB.dtTransactionLedgers.InsertOnSubmit(NewRefundLedger);
DB.dtStockHistories.InsertOnSubmit(NewStatus);
DB.SubmitChanges();
dtStock stock = DB.dtStocks.Single(s => s.sID == RefundObject.StockItem.Stockid);
stock.Sold = false;
DB.SubmitChanges();
}
public RefundViewModel()
{
if (DesignerProperties.GetIsInDesignMode(new System.Windows.DependencyObject()))
{
return;
}
try
{
_RefundObject = new skRefund();
_RefundObject.StockItem = ObjectMessenger.FindObject("STOCKITEM");
_SubmitRefund = new Command(submitRefund);
Notification = new Notification();
RefundObject.RefundCreated += Notification.OnNotificationReceived;
}
catch (Exception E)
{
ExepionLogger.Logger.LogException(E);
ExepionLogger.Logger.Show(E);
}
}
public void AddNewRefund(skRefund RefundObject, bool ReturnStock, int UserID)
{
dtRefund NewRefund = new dtRefund
{
Reason = RefundObject.Description,
Amount = Convert.ToDecimal(RefundObject.Amount),
Postage = RefundObject.SHippingCosts,
Refunded = DateTime.Now,
RefundedBy = UserID,
StockID = Convert.ToInt32(RefundObject.StockItem.Stockid),
Created = DateTime.Now,
Updated = DateTime.Now,
};
dtStockHistory NewStatus = new dtStockHistory
{
StoockID = Convert.ToInt32(RefundObject.StockItem.Stockid),
Status = "Return",
Value = RefundObject.Amount,
UserID = UserID,
Created = DateTime.Now,
StatusID = 0
};
if (ReturnStock == true)
{
dtStockDetail details = DB.dtStockDetails.Single(s => s.StockID == RefundObject.StockItem.Stockid);
dtStock stock = DB.dtStocks.Single(s => s.sID == RefundObject.StockItem.Stockid);
stock.Sold = false;
stock.SaleID = null;
details.SaleValue = null;
}
DB.dtRefunds.InsertOnSubmit(NewRefund);
DB.dtStockHistories.InsertOnSubmit(NewStatus);
DB.SubmitChanges();
}
public void AddNewRefund(skRefund RefundObject, bool ReturnStock, int UserID)
{
TransactionRepo.AddNewRefund(RefundObject, ReturnStock, UserID);
}
public void AddNewRefund(skRefund RefundObject, int UserID)
{
TransactionRepo.AddNewRefund(RefundObject, UserID);
}
public void AddNewRefund(skRefund RefundObject, bool ReturnStock, int UserID)
{
base.Channel.AddNewRefund(RefundObject, ReturnStock, UserID);
}
public void AddNewRefund(skRefund RefundObject, int UserID)
{
base.Channel.AddNewRefund(RefundObject, UserID);
}
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);
}
}
