public void UpdateInitialInventory(St_Header ObjUpdate)
{
var ObjToUpdate = _context.St_Headers.SingleOrDefault(m => m.CompanyID == ObjUpdate.CompanyID && m.TransactionKindNo == 517);
if (ObjToUpdate != null)
{
ObjToUpdate.DueDate = ObjUpdate.DueDate;
ObjToUpdate.InsDateTime = ObjUpdate.InsDateTime;
ObjToUpdate.InsUserID = ObjUpdate.InsUserID;
}
}
public void DeleteHeader(St_Header ObjToDelete)
{
var ObjDelete = _context.St_Headers.FirstOrDefault(m => m.CompanyID == ObjToDelete.CompanyID &&
m.CompanyTransactionKindNo == ObjToDelete.CompanyTransactionKindNo && m.StockCode == ObjToDelete.StockCode &&
m.VoucherNumber == ObjToDelete.VoucherNumber && m.CompanyYear == ObjToDelete.CompanyYear);
if (ObjDelete != null)
{
_context.St_Headers.Remove(ObjDelete);
}
}
private IHeader ReadHeader(BinaryReader br)
{
St_Header header = new St_Header();
if (!header.Read(br))
{
string errorMessage = "Failed to read header of file {0}. Corrupt or invalid header?";
MessageBox.Show(errorMessage, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
Environment.Exit(1);
}
return(header);
}
public void UpdateToExportAndUnExport(St_Header ObjToUpdate)
{
if (ObjToUpdate.TransactionKindNo == 507)
{
var ObjUpdate = _context.St_Headers.FirstOrDefault(m => m.CompanyID == ObjToUpdate.CompanyID &&
m.CompanyTransactionKindNo == ObjToUpdate.CompanyTransactionKindNo && m.TransactionKindNo == ObjToUpdate.TransactionKindNo &&
m.VoucherNumber == ObjToUpdate.VoucherNumber && m.CompanyYear == ObjToUpdate.CompanyYear);
if (ObjUpdate != null)
{
ObjUpdate.Exported = ObjToUpdate.Exported;
}
}
else
{
var ObjUpdate = _context.St_Headers.FirstOrDefault(m => m.CompanyID == ObjToUpdate.CompanyID &&
m.CompanyTransactionKindNo == ObjToUpdate.CompanyTransactionKindNo && m.TransactionKindNo == ObjToUpdate.TransactionKindNo &&
m.VoucherNumber == ObjToUpdate.VoucherNumber && m.CompanyYear == ObjToUpdate.CompanyYear && m.StockCode == ObjToUpdate.StockCode);
if (ObjUpdate != null)
{
ObjUpdate.Exported = ObjToUpdate.Exported;
}
}
}
public JsonResult SaveInitialInventory(St_ItemCardVM ObjSave)
{
MsgUnit Msg = new MsgUnit();
try
{
var userId = User.Identity.GetUserId();
var UserInfo = _unitOfWork.User.GetMyInfo(userId);
int year = (DateTime.Now.Year) - 1;
var CheckIfInitialInventoryExsitInHeader = _unitOfWork.St_Header.CheckIfInitialInventoryExsitInHeader(UserInfo.fCompanyId);
if (CheckIfInitialInventoryExsitInHeader == null)
{
var ObjSaveSt_Header = new St_Header();
ObjSaveSt_Header.CompanyID = UserInfo.fCompanyId;
ObjSaveSt_Header.CompanyYear = UserInfo.CurrYear;
ObjSaveSt_Header.CompanyTransactionKindNo = 1;
ObjSaveSt_Header.TransactionKindNo = 517;
ObjSaveSt_Header.StockCode = "*";
ObjSaveSt_Header.VoucherNumber = "0";
ObjSaveSt_Header.VHI = 0;
ObjSaveSt_Header.VoucherDate = new DateTime(year, 12, 31);
ObjSaveSt_Header.AccountNumber = "";
ObjSaveSt_Header.SaleID = 0;
ObjSaveSt_Header.NetTotalLocalBeforDiscount = 0;
ObjSaveSt_Header.NetTotalForeignBeforDiscount = 0;
ObjSaveSt_Header.NetTotalLineDiscountLocal = 0;
ObjSaveSt_Header.NetTotalLineDiscountForeign = 0;
ObjSaveSt_Header.NetTotalLocalAfterLineDiscount = 0;
ObjSaveSt_Header.NetTotalForeignAfterLineDiscount = 0;
ObjSaveSt_Header.NetTotalTaxAfterLineDiscountLocal = 0;
ObjSaveSt_Header.NetTotalTaxAfterLineDiscounForeign = 0;
ObjSaveSt_Header.NetTotalAfterLineDiscountBeforDiscountAllLocal = 0;
ObjSaveSt_Header.NetTotalAfterLineDiscountBeforDiscountAllForeign = 0;
ObjSaveSt_Header.NetTotalDiscountLocal = 0;
ObjSaveSt_Header.NetTotalDiscountForeign = 0;
ObjSaveSt_Header.DiscountPercentage = 0;
ObjSaveSt_Header.NetTotalLocalAfterDiscount = 0;
ObjSaveSt_Header.NetTotalForeignAfterDiscount = 0;
ObjSaveSt_Header.TaxType = 3;
ObjSaveSt_Header.NetTotalTaxLocal = 0;
ObjSaveSt_Header.NetTotalTaxForeign = 0;
ObjSaveSt_Header.NetTotalLocal = 0;
ObjSaveSt_Header.NetTotalForeign = 0;
if (Resources.Resource.CurLang == "Arb")
{
ObjSaveSt_Header.Remark = "جرد اولي";
ObjSaveSt_Header.Hint = "جرد اولي";
}
else
{
ObjSaveSt_Header.Remark = "Initial Inventory";
ObjSaveSt_Header.Hint = "Initial Inventory";
}
ObjSaveSt_Header.Exported = 0;
ObjSaveSt_Header.CurrencyID = 1;
ObjSaveSt_Header.ConversionFactor = 1;
ObjSaveSt_Header.ConversionFactorAfterExpenses = 0;
ObjSaveSt_Header.VoucherCase = 0;
ObjSaveSt_Header.CashLocal = 0;
ObjSaveSt_Header.CreditCardType1 = 0;
ObjSaveSt_Header.CreditCardLocal1 = 0;
ObjSaveSt_Header.CreditCardType2 = 0;
ObjSaveSt_Header.CreditCardLocal2 = 0;
ObjSaveSt_Header.ChequeLocal = 0;
ObjSaveSt_Header.CreditLocal = 0;
ObjSaveSt_Header.CashForeign = 0;
ObjSaveSt_Header.CreditCardForeign1 = 0;
ObjSaveSt_Header.CreditCardForeign2 = 0;
ObjSaveSt_Header.ChequeForeign = 0;
ObjSaveSt_Header.CreditForeign = 0;
ObjSaveSt_Header.DueDate = DateTime.Now;
ObjSaveSt_Header.OfferNumber = "";
ObjSaveSt_Header.OrderNumber = "";
ObjSaveSt_Header.LocalCost = 0;
ObjSaveSt_Header.ForeignCost = 0;
ObjSaveSt_Header.DriverID = 0;
ObjSaveSt_Header.OriginalVoucherNumber = "0";
ObjSaveSt_Header.ShippingValueLocal = 0;
ObjSaveSt_Header.ShippingValueForeign = 0;
ObjSaveSt_Header.ShippingAccountNumber = "";
ObjSaveSt_Header.ShippingCostCenter = "";
ObjSaveSt_Header.OtherExpensesValueLocal = 0;
ObjSaveSt_Header.OtherExpensesValueForeign = 0;
ObjSaveSt_Header.OtherExpensesAccountNumber = "";
ObjSaveSt_Header.OtherExpensesCostCenter = "";
ObjSaveSt_Header.NetTotalOfGoodsLocal = 0;
ObjSaveSt_Header.NetTotalOfGoodsForeign = 0;
ObjSaveSt_Header.ExtraExpensesLocal1 = 0;
ObjSaveSt_Header.ExtraExpensesLocal2 = 0;
ObjSaveSt_Header.ExtraExpensesLocal3 = 0;
ObjSaveSt_Header.ExtraExpensesLocal4 = 0;
ObjSaveSt_Header.ExtraExpensesLocal5 = 0;
ObjSaveSt_Header.ExtraExpensesLocal6 = 0;
ObjSaveSt_Header.ExtraExpensesLocal7 = 0;
ObjSaveSt_Header.ExtraExpensesLocal8 = 0;
ObjSaveSt_Header.ExtraExpensesLocal9 = 0;
ObjSaveSt_Header.ExtraExpensesLocal10 = 0;
ObjSaveSt_Header.ExtraExpensesLocal11 = 0;
ObjSaveSt_Header.ExtraExpensesLocal12 = 0;
ObjSaveSt_Header.ExtraExpensesLocal13 = 0;
ObjSaveSt_Header.ExtraExpensesLocal14 = 0;
ObjSaveSt_Header.ExtraExpensesLocal15 = 0;
ObjSaveSt_Header.ExtraExpensesLocal16 = 0;
ObjSaveSt_Header.ExtraExpensesLocal17 = 0;
ObjSaveSt_Header.ExtraExpensesLocal18 = 0;
ObjSaveSt_Header.ExtraExpensesLocal19 = 0;
ObjSaveSt_Header.ExtraExpensesLocal20 = 0;
ObjSaveSt_Header.ExtraExpensesForeign1 = 0;
ObjSaveSt_Header.ExtraExpensesForeign2 = 0;
ObjSaveSt_Header.ExtraExpensesForeign3 = 0;
ObjSaveSt_Header.ExtraExpensesForeign4 = 0;
ObjSaveSt_Header.ExtraExpensesForeign5 = 0;
ObjSaveSt_Header.ExtraExpensesForeign6 = 0;
ObjSaveSt_Header.ExtraExpensesForeign7 = 0;
ObjSaveSt_Header.ExtraExpensesForeign8 = 0;
ObjSaveSt_Header.ExtraExpensesForeign9 = 0;
ObjSaveSt_Header.ExtraExpensesForeign10 = 0;
ObjSaveSt_Header.ExtraExpensesForeign11 = 0;
ObjSaveSt_Header.ExtraExpensesForeign12 = 0;
ObjSaveSt_Header.ExtraExpensesForeign13 = 0;
ObjSaveSt_Header.ExtraExpensesForeign14 = 0;
ObjSaveSt_Header.ExtraExpensesForeign15 = 0;
ObjSaveSt_Header.ExtraExpensesForeign16 = 0;
ObjSaveSt_Header.ExtraExpensesForeign17 = 0;
ObjSaveSt_Header.ExtraExpensesForeign18 = 0;
ObjSaveSt_Header.ExtraExpensesForeign19 = 0;
ObjSaveSt_Header.ExtraExpensesForeign20 = 0;
ObjSaveSt_Header.InsDateTime = DateTime.Now;
ObjSaveSt_Header.InsUserID = userId;
ObjSaveSt_Header.RowCount = _unitOfWork.St_Header.GetMaxRowNumberInitialInventory(UserInfo.fCompanyId);
var ObjSaveSt_Transaction = new St_Transaction();
ObjSaveSt_Transaction.CompanyID = ObjSaveSt_Header.CompanyID;
ObjSaveSt_Transaction.CompanyYear = ObjSaveSt_Header.CompanyYear;
ObjSaveSt_Transaction.CompanyTransactionKindNo = ObjSaveSt_Header.CompanyTransactionKindNo;
ObjSaveSt_Transaction.TransactionKindNo = ObjSaveSt_Header.TransactionKindNo;
ObjSaveSt_Transaction.StockCode = ObjSave.StockCode;
ObjSaveSt_Transaction.VoucherNumber = ObjSaveSt_Header.VoucherNumber;
ObjSaveSt_Transaction.RowNumber = _unitOfWork.St_Header.GetMaxRowNumberInitialInventory(UserInfo.fCompanyId);
ObjSaveSt_Transaction.IsDeleted = 0;
ObjSaveSt_Transaction.VHI = ObjSaveSt_Header.VHI;
ObjSaveSt_Transaction.VoucherDate = ObjSaveSt_Header.VoucherDate;
ObjSaveSt_Transaction.ItemCode = ObjSave.UpdateItemCode;
ObjSaveSt_Transaction.SimilarItemCode = ObjSave.UpdateItemCode;
ObjSaveSt_Transaction.Quantity = ObjSave.Quantity;
ObjSaveSt_Transaction.Bonus = 0;
ObjSaveSt_Transaction.QuantityInputOutput = ObjSave.Quantity;
ObjSaveSt_Transaction.BonusInputOutput = 0;
ObjSaveSt_Transaction.TotalLocalBeforDiscount = (ObjSave.Quantity * ObjSave.CostRate);
ObjSaveSt_Transaction.TotalForeignBeforDiscount = 0;
ObjSaveSt_Transaction.TotalLineDiscountLocal = 0;
ObjSaveSt_Transaction.TotalLineDiscountForeign = 0;
ObjSaveSt_Transaction.TotalLocalAfterLineDiscount = 0;
ObjSaveSt_Transaction.TotalForeignAfterLineDiscount = 0;
ObjSaveSt_Transaction.LineDiscountPercentage = 0;
ObjSaveSt_Transaction.TotalTaxAfterLineDiscountLocal = 0;
ObjSaveSt_Transaction.TotalTaxAfterLineDiscounForeign = 0;
ObjSaveSt_Transaction.TotalAfterLineDiscountBeforDiscountAllLocal = 0;
ObjSaveSt_Transaction.TotalAfterLineDiscountBeforDiscountAllForeign = 0;
ObjSaveSt_Transaction.TotalDiscountLocal = 0;
ObjSaveSt_Transaction.TotalDiscountForeign = 0;
ObjSaveSt_Transaction.DiscountPercentage = 0;
ObjSaveSt_Transaction.TotalLocalAfterDiscount = (ObjSave.Quantity * ObjSave.CostRate);
ObjSaveSt_Transaction.TotalForeignAfterDiscount = 0;
ObjSaveSt_Transaction.TaxRate = 0;
ObjSaveSt_Transaction.TaxType = 0;
ObjSaveSt_Transaction.TotalTaxLocal = 0;
ObjSaveSt_Transaction.TotalTaxForeign = 0;
ObjSaveSt_Transaction.TotalLocal = (ObjSave.Quantity * ObjSave.CostRate);
ObjSaveSt_Transaction.TotalForeign = 0;
ObjSaveSt_Transaction.TotalCostLocal = (ObjSave.Quantity * ObjSave.CostRate);
ObjSaveSt_Transaction.TotalCostForeign = 0;
if (ObjSave.Quantity <= 0)
{
ObjSaveSt_Transaction.PricePieceLocalBeforDiscount = 0;
}
else
{
ObjSaveSt_Transaction.PricePieceLocalBeforDiscount = ObjSave.CostRate;
}
ObjSaveSt_Transaction.PricePieceForeignBeforDiscount = 0;
ObjSaveSt_Transaction.PricePieceLineDiscountLocal = 0;
ObjSaveSt_Transaction.PricePieceLineDiscountForeign = 0;
ObjSaveSt_Transaction.PricePieceLocalAfterLineDiscount = 0;
ObjSaveSt_Transaction.PricePieceForeignAfterLineDiscount = 0;
ObjSaveSt_Transaction.PricePieceTaxAfterLineDiscountLocal = 0;
ObjSaveSt_Transaction.PricePieceTaxAfterLineDiscounForeign = 0;
ObjSaveSt_Transaction.PricePieceAfterLineDiscountBeforDiscountAllLocal = 0;
ObjSaveSt_Transaction.PricePieceAfterLineDiscountBeforDiscountAllForeign = 0;
ObjSaveSt_Transaction.PricePieceDiscountLocal = 0;
ObjSaveSt_Transaction.PricePieceDiscountForeign = 0;
if (ObjSave.Quantity <= 0)
{
ObjSaveSt_Transaction.PricePieceLocalAfterDiscount = 0;
}
else
{
ObjSaveSt_Transaction.PricePieceLocalAfterDiscount = ObjSave.CostRate;
}
ObjSaveSt_Transaction.PricePieceForeignAfterDiscount = 0;
ObjSaveSt_Transaction.PricePieceTaxLocal = 0;
ObjSaveSt_Transaction.PricePieceTaxForeign = 0;
if (ObjSave.Quantity <= 0)
{
ObjSaveSt_Transaction.PricePieceTotalLocal = 0;
}
else
{
ObjSaveSt_Transaction.PricePieceTotalLocal = ObjSave.CostRate;
}
ObjSaveSt_Transaction.PricePieceTotalForeign = 0;
if (ObjSave.Quantity <= 0)
{
ObjSaveSt_Transaction.CostPieceLocal = 0;
}
else
{
ObjSaveSt_Transaction.CostPieceLocal = ObjSave.CostRate;
}
ObjSaveSt_Transaction.CostPieceForeign = 0;
if (Resources.Resource.CurLang == "Arb")
{
ObjSaveSt_Transaction.Remark = "جرد اولي";
ObjSaveSt_Transaction.Hint = "جرد اولي";
}
else
{
ObjSaveSt_Transaction.Remark = "Initial Inventory";
ObjSaveSt_Transaction.Hint = "Initial Inventory";
}
ObjSaveSt_Transaction.ExpierDate = DateTime.Now;
ObjSaveSt_Transaction.BatchNumber = "";
ObjSaveSt_Transaction.InsDateTime = DateTime.Now;
ObjSaveSt_Transaction.InsUserID = userId;
if (!ModelState.IsValid)
{
string Err = " ";
var errors = ModelState.Values.SelectMany(v => v.Errors);
foreach (ModelError error in errors)
{
Err = Err + error.ErrorMessage + " * ";
}
Msg.Msg = Resources.Resource.SomthingWentWrong + " : " + Err;
Msg.Code = 0;
return(Json(Msg, JsonRequestBehavior.AllowGet));
}
_unitOfWork.St_Header.AddHeader(ObjSaveSt_Header);
_unitOfWork.St_Header.AddTransaction(ObjSaveSt_Transaction);
_unitOfWork.Complete();
}
else
{
var CheckIfInitialInventoryExsitInTransaction = _unitOfWork.St_Header.CheckIfInitialInventoryExsitInTransaction(UserInfo.fCompanyId, ObjSave.UpdateItemCode, ObjSave.StockCode);
if (CheckIfInitialInventoryExsitInTransaction == null)
{
var ObjUpdateSt_Header = new St_Header();
ObjUpdateSt_Header.CompanyID = UserInfo.fCompanyId;
ObjUpdateSt_Header.RowCount = _unitOfWork.St_Header.GetMaxRowNumberInitialInventory(UserInfo.fCompanyId);
ObjUpdateSt_Header.DueDate = DateTime.Now;
ObjUpdateSt_Header.InsDateTime = DateTime.Now;
ObjUpdateSt_Header.InsUserID = userId;
var ObjSaveSt_Transaction = new St_Transaction();
ObjSaveSt_Transaction.CompanyID = UserInfo.fCompanyId;
ObjSaveSt_Transaction.CompanyYear = UserInfo.CurrYear;
ObjSaveSt_Transaction.CompanyTransactionKindNo = 1;
ObjSaveSt_Transaction.TransactionKindNo = 517;
ObjSaveSt_Transaction.StockCode = ObjSave.StockCode;
ObjSaveSt_Transaction.RowNumber = _unitOfWork.St_Header.GetMaxRowNumberInitialInventory(UserInfo.fCompanyId);
ObjSaveSt_Transaction.IsDeleted = 0;
ObjSaveSt_Transaction.VoucherNumber = "0";
ObjSaveSt_Transaction.VHI = 0;
ObjSaveSt_Transaction.VoucherDate = new DateTime(year, 12, 31);
ObjSaveSt_Transaction.ItemCode = ObjSave.UpdateItemCode;
ObjSaveSt_Transaction.SimilarItemCode = ObjSave.UpdateItemCode;
ObjSaveSt_Transaction.Quantity = ObjSave.Quantity;
ObjSaveSt_Transaction.Bonus = 0;
ObjSaveSt_Transaction.QuantityInputOutput = ObjSave.Quantity;
ObjSaveSt_Transaction.BonusInputOutput = 0;
ObjSaveSt_Transaction.TotalLocalBeforDiscount = (ObjSave.Quantity * ObjSave.CostRate);
ObjSaveSt_Transaction.TotalForeignBeforDiscount = 0;
ObjSaveSt_Transaction.TotalLineDiscountLocal = 0;
ObjSaveSt_Transaction.TotalLineDiscountForeign = 0;
ObjSaveSt_Transaction.TotalLocalAfterLineDiscount = 0;
ObjSaveSt_Transaction.TotalForeignAfterLineDiscount = 0;
ObjSaveSt_Transaction.LineDiscountPercentage = 0;
ObjSaveSt_Transaction.TotalTaxAfterLineDiscountLocal = 0;
ObjSaveSt_Transaction.TotalTaxAfterLineDiscounForeign = 0;
ObjSaveSt_Transaction.TotalAfterLineDiscountBeforDiscountAllLocal = 0;
ObjSaveSt_Transaction.TotalAfterLineDiscountBeforDiscountAllForeign = 0;
ObjSaveSt_Transaction.TotalDiscountLocal = 0;
ObjSaveSt_Transaction.TotalDiscountForeign = 0;
ObjSaveSt_Transaction.DiscountPercentage = 0;
ObjSaveSt_Transaction.TotalLocalAfterDiscount = (ObjSave.Quantity * ObjSave.CostRate);
ObjSaveSt_Transaction.TotalForeignAfterDiscount = 0;
ObjSaveSt_Transaction.TaxRate = 0;
ObjSaveSt_Transaction.TaxType = 0;
ObjSaveSt_Transaction.TotalTaxLocal = 0;
ObjSaveSt_Transaction.TotalTaxForeign = 0;
ObjSaveSt_Transaction.TotalLocal = (ObjSave.Quantity * ObjSave.CostRate);
ObjSaveSt_Transaction.TotalForeign = 0;
ObjSaveSt_Transaction.TotalCostLocal = (ObjSave.Quantity * ObjSave.CostRate);
ObjSaveSt_Transaction.TotalCostForeign = 0;
if (ObjSave.Quantity <= 0)
{
ObjSaveSt_Transaction.PricePieceLocalBeforDiscount = 0;
}
else
{
ObjSaveSt_Transaction.PricePieceLocalBeforDiscount = ObjSave.CostRate;
}
ObjSaveSt_Transaction.PricePieceForeignBeforDiscount = 0;
ObjSaveSt_Transaction.PricePieceLineDiscountLocal = 0;
ObjSaveSt_Transaction.PricePieceLineDiscountForeign = 0;
ObjSaveSt_Transaction.PricePieceLocalAfterLineDiscount = 0;
ObjSaveSt_Transaction.PricePieceForeignAfterLineDiscount = 0;
ObjSaveSt_Transaction.PricePieceTaxAfterLineDiscountLocal = 0;
ObjSaveSt_Transaction.PricePieceTaxAfterLineDiscounForeign = 0;
ObjSaveSt_Transaction.PricePieceAfterLineDiscountBeforDiscountAllLocal = 0;
ObjSaveSt_Transaction.PricePieceAfterLineDiscountBeforDiscountAllForeign = 0;
ObjSaveSt_Transaction.PricePieceDiscountLocal = 0;
ObjSaveSt_Transaction.PricePieceDiscountForeign = 0;
if (ObjSave.Quantity <= 0)
{
ObjSaveSt_Transaction.PricePieceLocalAfterDiscount = 0;
}
else
{
ObjSaveSt_Transaction.PricePieceLocalAfterDiscount = ObjSave.CostRate;
}
ObjSaveSt_Transaction.PricePieceForeignAfterDiscount = 0;
ObjSaveSt_Transaction.PricePieceTaxLocal = 0;
ObjSaveSt_Transaction.PricePieceTaxForeign = 0;
if (ObjSave.Quantity <= 0)
{
ObjSaveSt_Transaction.PricePieceTotalLocal = 0;
}
else
{
ObjSaveSt_Transaction.PricePieceTotalLocal = ObjSave.CostRate;
}
ObjSaveSt_Transaction.PricePieceTotalForeign = 0;
if (ObjSave.Quantity <= 0)
{
ObjSaveSt_Transaction.CostPieceLocal = 0;
}
else
{
ObjSaveSt_Transaction.CostPieceLocal = ObjSave.CostRate;
}
ObjSaveSt_Transaction.CostPieceForeign = 0;
if (Resources.Resource.CurLang == "Arb")
{
ObjSaveSt_Transaction.Remark = "جرد اولي";
ObjSaveSt_Transaction.Hint = "جرد اولي";
}
else
{
ObjSaveSt_Transaction.Remark = "Initial Inventory";
ObjSaveSt_Transaction.Hint = "Initial Inventory";
}
ObjSaveSt_Transaction.ExpierDate = DateTime.Now;
ObjSaveSt_Transaction.BatchNumber = "";
ObjSaveSt_Transaction.InsDateTime = DateTime.Now;
ObjSaveSt_Transaction.InsUserID = userId;
if (!ModelState.IsValid)
{
string Err = " ";
var errors = ModelState.Values.SelectMany(v => v.Errors);
foreach (ModelError error in errors)
{
Err = Err + error.ErrorMessage + " * ";
}
Msg.Msg = Resources.Resource.SomthingWentWrong + " : " + Err;
Msg.Code = 0;
return(Json(Msg, JsonRequestBehavior.AllowGet));
}
_unitOfWork.St_Header.UpdateRowCountInitialInventory(ObjUpdateSt_Header);
_unitOfWork.St_Header.AddTransaction(ObjSaveSt_Transaction);
_unitOfWork.Complete();
}
else
{
var ObjUpdateSt_Header = new St_Header();
ObjUpdateSt_Header.CompanyID = UserInfo.fCompanyId;
ObjUpdateSt_Header.DueDate = DateTime.Now;
ObjUpdateSt_Header.InsDateTime = DateTime.Now;
ObjUpdateSt_Header.InsUserID = userId;
var ObjUpdateSt_Transaction = new St_Transaction();
ObjUpdateSt_Transaction.CompanyID = UserInfo.fCompanyId;
ObjUpdateSt_Transaction.StockCode = ObjSave.StockCode;
ObjUpdateSt_Transaction.ItemCode = ObjSave.UpdateItemCode;
ObjUpdateSt_Transaction.Quantity = ObjSave.Quantity;
ObjUpdateSt_Transaction.QuantityInputOutput = ObjSave.Quantity;
ObjUpdateSt_Transaction.TotalLocalBeforDiscount = (ObjSave.Quantity * ObjSave.CostRate);
ObjUpdateSt_Transaction.TotalLocalAfterDiscount = (ObjSave.Quantity * ObjSave.CostRate);
ObjUpdateSt_Transaction.TotalLocal = (ObjSave.Quantity * ObjSave.CostRate);
ObjUpdateSt_Transaction.TotalCostLocal = (ObjSave.Quantity * ObjSave.CostRate);
if (ObjSave.Quantity <= 0)
{
ObjUpdateSt_Transaction.PricePieceLocalBeforDiscount = 0;
ObjUpdateSt_Transaction.PricePieceLocalAfterDiscount = 0;
ObjUpdateSt_Transaction.PricePieceTotalLocal = 0;
ObjUpdateSt_Transaction.CostPieceLocal = 0;
}
else
{
ObjUpdateSt_Transaction.PricePieceLocalBeforDiscount = ObjSave.CostRate;
ObjUpdateSt_Transaction.PricePieceLocalAfterDiscount = ObjSave.CostRate;
ObjUpdateSt_Transaction.PricePieceTotalLocal = ObjSave.CostRate;
ObjUpdateSt_Transaction.CostPieceLocal = ObjSave.CostRate;
}
ObjUpdateSt_Transaction.InsDateTime = DateTime.Now;
ObjUpdateSt_Transaction.InsUserID = userId;
if (!ModelState.IsValid)
{
string Err = " ";
var errors = ModelState.Values.SelectMany(v => v.Errors);
foreach (ModelError error in errors)
{
Err = Err + error.ErrorMessage + " * ";
}
Msg.Msg = Resources.Resource.SomthingWentWrong + " : " + Err;
Msg.Code = 0;
return(Json(Msg, JsonRequestBehavior.AllowGet));
}
_unitOfWork.St_Header.UpdateInitialInventory(ObjUpdateSt_Header);
_unitOfWork.St_Header.UpdateInitialInventoryInTransaction(ObjUpdateSt_Transaction);
_unitOfWork.Complete();
}
}
Msg.Code = 1;
Msg.Msg = Resources.Resource.AddedSuccessfully;
return(Json(Msg, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
Msg.Msg = Resources.Resource.SomthingWentWrong + " : " + ex.Message.ToString();
Msg.Code = 0;
return(Json(Msg, JsonRequestBehavior.AllowGet));
}
}
public void AddHeader(St_Header ObjSave)
{
_context.St_Headers.Add(ObjSave);
}
public JumpTableInterface()
{
header = new St_Header();
footer = new St_Footer();
jumpTableEntries = new List <JumpTableEntry>();
}