public void RecordAverageCostAndSellingPrice(int userID)
{
MyGeneration.dOOdads.TransactionMgr transaction = MyGeneration.dOOdads.TransactionMgr.ThreadTransactionMgr();
try
{
transaction.BeginTransaction();
DataTable ReceiveDocDetails;
IList <CostElement> costElements = new List <CostElement>();
foreach (DataRowView drv in GRVSoundDetail.DefaultView as DataView)
{
double NewUnitCost, NewSellingPrice;
if (drv["AverageCost"] != DBNull.Value && drv["SellingPrice"] != DBNull.Value)
{
CostElement costElement = new CostElement();
costElement.ItemID = Convert.ToInt32(drv["ItemID"]);
costElement.ItemUnitID = Convert.ToInt32(drv["ItemUnitID"]);
costElement.MovingAverageID = Convert.ToInt32(drv["MovingAverageID"]);
costElement.ManufacturerID = Convert.ToInt32(drv["ManufacturerID"]);
costElement.AverageCost = costElement.SellingPrice = Math.Round(Convert.ToDouble(drv["SellingPrice"]), Settings.NoOfDigitsAfterTheDecimalPoint);
costElement.Margin = drv["Margin"] != DBNull.Value ? Convert.ToDouble(drv["Margin"]) : 0;
ReceiveDocDetails =
ReceiveDoc.GetRelatedReceiveForUnitCostAndSellingPrice(ReceiptID, costElement);
foreach (DataRowView Cursor in ReceiveDocDetails.AsDataView())
{
int ID = Convert.ToInt32(Cursor["ID"]);
ReceiveDoc.SetAverageCostByReceiveDoc(ID, costElement.AverageCost, userID);
ReceiveDoc.SetSellingPriceByReceiveDoc(ID, costElement.SellingPrice, userID);
}
costElements.Add(costElement);
}
}
try
{
CostingService.SavePriceChange(costElements.AsEnumerable(), userID, ChangeMode.Recieve, ReceiptID.ToString());
}
catch (Exception)
{
//Until Cost Tier Implementation
}
transaction.CommitTransaction();
}
catch (Exception ex)
{
transaction.RollbackTransaction();
throw ex;
}
}
private void OnConfirmClicked(object sender, EventArgs e)
{
printDialog = new PrintDialog();
if (printDialog.ShowDialog() != System.Windows.Forms.DialogResult.OK)
{
XtraMessageBox.Show("Print has been Canceled By User");
return;
}
if (BLL.Settings.IsCenter)
{
GRV = new CenterCostCalculator();
GRV.LoadGRV(ReceiptID);
GRV.CalculateFinalCost();
}
else
{
GRV = new CostCalculator();
GRV.LoadGRV(ReceiptID);
(GRV as CostCalculator).LoadGRVPreviousStock();
GRV.CalculateFinalCost();
}
if (!SetSellingPrice(GRV))
{
return;
}
HCMIS.Desktop.Reports.ReceiptConfirmationPrintout printout = new HCMIS.Desktop.Reports.ReceiptConfirmationPrintout(CurrentContext.LoggedInUserName);
MyGeneration.dOOdads.TransactionMgr transaction = MyGeneration.dOOdads.TransactionMgr.ThreadTransactionMgr();
try
{
transaction.BeginTransaction();
// This is where we set the Price for the previous Stock
foreach (CostElement costElement in GRV.CostElements)
{
costElement.PreviousCostDetials.Confirm(CurrentContext.UserId);
}
printout = PrintConfirmation(null);
CostingService.ConfirmPriceChange(GRV.CostElements, CurrentContext.UserId, ChangeMode.Recieve, ReceiptID.ToString());
GRV.SetFinalCostlog(CurrentContext.UserId);
transaction.CommitTransaction();
}
catch (Exception ex)
{
transaction.RollbackTransaction();
XtraMessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
throw;
}
printout.Print(printDialog.PrinterSettings.PrinterName);
}
private void OnConfirmClicked(object sender, EventArgs e)
{
if (BLL.Settings.IsCenter)
{
GRV = new CenterCostCalculator();
GRV.LoadGRV(ReceiptID);
GRV.CalculateFinalCost();
}
else
{
GRV = new CostCalculator();
GRV.LoadGRV(ReceiptID);
(GRV as CostCalculator).LoadGRVPreviousStock();
GRV.CalculateFinalCost();
}
if (!SetSellingPrice(GRV))
{
return;
}
TransactionMgr transaction = TransactionMgr.ThreadTransactionMgr();
try
{
transaction.BeginTransaction();
// This is where we set the Price for the previous Stock
foreach (CostElement costElement in GRV.CostElements)
{
costElement.PreviousCostDetials.Confirm(CurrentContext.UserId);
}
PrintConfirmation(null);
try
{
CostingService.ConfirmPriceChange(GRV.CostElements, CurrentContext.UserId, ChangeMode.Recieve, ReceiptID.ToString());
}
catch (Exception exception)
{
XtraMessageBox.Show(exception.Message);
throw exception;
}
transaction.CommitTransaction();
this.LogActivity("Print-SRM", ReceiptID);
}
catch (Exception ex)
{
transaction.RollbackTransaction();
XtraMessageBox.Show(ex.Message);
}
}
public static DataTable GetPreviousStockforCostAnalysisPrintout(int ReceiptID)
{
Receipt receipt = new Receipt();
string query = HCMIS.Repository.Queries.Receipt.SelectGetPreviousStockforCostAnalysisPrintout(ReceiptID);
receipt.LoadFromRawSql(query);
if (BLL.Settings.UseCostTier)
{
query = HCMIS.Repository.Queries.Receipt.SelectGetPreviousStockforCostAnalysisPrintoutUseCostTier(ReceiptID);
receipt.LoadFromRawSql(query);
return(CostingService.SetPrice(receipt.DataTable));
}
return(receipt.DataTable);
}
public AppService(AppDbContext db)
{
Phone = new PhoneService(db, this);
Company = new CompanyService(db, this);
CallRecord = new CallRecordService(db, this);
State = new StateService(db, this);
SystemSetting = new SystemSettingService(db, this);
CostingTemplate = new CostingTemplateService(db, this);
QuoteTemplate = new QuoteTemplateService(db, this);
Quote = new QuoteService(db, this);
Costing = new CostingService(db, this);
CallScript = new CallScriptService(db, this);
CallQuestion = new CallQuestionService(db, this);
CallAnswer = new CallAnswerService(db, this);
_appDbContext = db;
}
