public ActionResult SaveInitialInventory(string id, string id2) { try { if (id != "") { var userId = User.Identity.GetUserId(); var UserInfo = _unitOfWork.User.GetUserByID(userId); var Company = _unitOfWork.Company.GetMyCompany(UserInfo.fCompanyId); if (UserInfo == null) { RedirectToAction("", ""); } var Obj = _unitOfWork.NativeSql.GetSt_InitialInventoryByItemAndStock(UserInfo.fCompanyId, id, id2); var St_ItemCardVM = new St_ItemCardVM { }; St_ItemCardVM.UpdateItemCode = Obj.ItemCode; St_ItemCardVM.StockCode = Obj.StockCode; St_ItemCardVM.ItemName = Obj.ItemName; St_ItemCardVM.StockName = Obj.StockName; St_ItemCardVM.CostRate = Obj.CostRate; St_ItemCardVM.Quantity = Obj.Quantity; return(PartialView("SaveInitialInventory", St_ItemCardVM)); } return(PartialView("SaveInitialInventory", new St_ItemCardVM())); } catch (Exception ex) { ViewBag.Error = ex.Message.ToString(); return(View("Error")); } }
public JsonResult UpdateAllDetermineWarehouseQuantities(St_ItemCardVM ObjUpdate) { MsgUnit Msg = new MsgUnit(); try { var userId = User.Identity.GetUserId(); var UserInfo = _unitOfWork.User.GetMyInfo(userId); foreach (var ObjUpdateSt_ItemWarehouse in ObjUpdate.St_ItemWarehouse) { ObjUpdateSt_ItemWarehouse.CompanyID = UserInfo.fCompanyId; ObjUpdateSt_ItemWarehouse.StockCode = ObjUpdate.StockCode; ObjUpdateSt_ItemWarehouse.ItemCode = ObjUpdateSt_ItemWarehouse.ItemCode; ObjUpdateSt_ItemWarehouse.StockMinimumItemNo = ObjUpdate.StockMinimumItemNo; ObjUpdateSt_ItemWarehouse.StockMaximumItemNo = ObjUpdate.StockMaximumItemNo; _unitOfWork.St_ItemCard.UpdateItemWarehous(ObjUpdateSt_ItemWarehouse); _unitOfWork.Complete(); } Msg.Code = 1; Msg.Msg = Resources.Resource.ExportSuccessfully; 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 ActionResult UpdateDetermineWarehouseQuantities(string id, string id2) { try { if (id != "") { var userId = User.Identity.GetUserId(); var UserInfo = _unitOfWork.User.GetUserByID(userId); var Company = _unitOfWork.Company.GetMyCompany(UserInfo.fCompanyId); if (UserInfo == null) { RedirectToAction("", ""); } var Obj = _unitOfWork.NativeSql.GetSt_ItemWarehouseByItemAndStock(UserInfo.fCompanyId, id, id2); var St_ItemCardVM = new St_ItemCardVM { }; St_ItemCardVM.UpdateItemCode = Obj.ItemCode; St_ItemCardVM.StockCode = Obj.StockCode; St_ItemCardVM.ItemName = Obj.ItemName; St_ItemCardVM.StockName = Obj.StockName; St_ItemCardVM.StockMaximumItemNo = Obj.StockMaximumItemNo; St_ItemCardVM.StockMinimumItemNo = Obj.StockMinimumItemNo; return(PartialView("UpdateDetermineWarehouseQuantities", St_ItemCardVM)); } return(PartialView("UpdateDetermineWarehouseQuantities", new St_ItemCardVM())); } catch (Exception ex) { ViewBag.Error = ex.Message.ToString(); return(View("Error")); } }
public ActionResult UpdateAllDetermineWarehouseQuantities() { var userId = User.Identity.GetUserId(); var UserInfo = _unitOfWork.User.GetMyInfo(userId); var Company = _unitOfWork.Company.GetMyCompany(UserInfo.fCompanyId); St_ItemCardVM Obj = new St_ItemCardVM(); return(PartialView(Obj)); }
public JsonResult SaveSt_ItemWarehouse(St_ItemCardVM ObjToSave) { MsgUnit Msg = new MsgUnit(); try { var userId = User.Identity.GetUserId(); var UserInfo = _unitOfWork.User.GetMyInfo(userId); _unitOfWork.NativeSql.DeleteSt_ItemWarehouseByStockCode(UserInfo.fCompanyId, ObjToSave.StockCode); var iRow = 0; if (ObjToSave.St_ItemWarehouse != null) { foreach (var SaveItemWarehouse in ObjToSave.St_ItemWarehouse) { iRow = iRow + 1; SaveItemWarehouse.CompanyID = UserInfo.fCompanyId; SaveItemWarehouse.ItemCode = SaveItemWarehouse.ItemCode; SaveItemWarehouse.StockCode = ObjToSave.StockCode; SaveItemWarehouse.StockMinimumItemNo = SaveItemWarehouse.StockMinimumItemNo; SaveItemWarehouse.StockMaximumItemNo = SaveItemWarehouse.StockMaximumItemNo; SaveItemWarehouse.RowNumber = iRow; _unitOfWork.St_ItemCard.AddItemWarehous(SaveItemWarehouse); } } 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.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 ActionResult Index() { var userId = User.Identity.GetUserId(); var UserInfo = _unitOfWork.User.GetMyInfo(userId); var Company = _unitOfWork.Company.GetMyCompany(UserInfo.fCompanyId); var St_ItemWarehouseObj = new St_ItemCardVM { St_ItemUnit = _unitOfWork.St_ItemUnit.GetAllItemUnit(UserInfo.fCompanyId), St_CountryOfOrigin = _unitOfWork.St_CountryOfOrigin.GetAllSt_CountryOfOrigin(UserInfo.fCompanyId), St_ManufacturerCompany = _unitOfWork.St_ManufacturerCompany.GetAllSt_ManufacturerCompany(UserInfo.fCompanyId), St_Warehouse = _unitOfWork.St_Warehouse.GetAllSt_Warehouse(UserInfo.fCompanyId), St_DescriptionDetail1 = _unitOfWork.St_DescriptionDetail.GetSt_DescriptionDetailBySt_Description(UserInfo.fCompanyId, 1), St_DescriptionDetail2 = _unitOfWork.St_DescriptionDetail.GetSt_DescriptionDetailBySt_Description(UserInfo.fCompanyId, 2), St_DescriptionDetail3 = _unitOfWork.St_DescriptionDetail.GetSt_DescriptionDetailBySt_Description(UserInfo.fCompanyId, 3), St_DescriptionDetail4 = _unitOfWork.St_DescriptionDetail.GetSt_DescriptionDetailBySt_Description(UserInfo.fCompanyId, 4), St_DescriptionDetail5 = _unitOfWork.St_DescriptionDetail.GetSt_DescriptionDetailBySt_Description(UserInfo.fCompanyId, 5), St_DescriptionDetail6 = _unitOfWork.St_DescriptionDetail.GetSt_DescriptionDetailBySt_Description(UserInfo.fCompanyId, 6), St_DescriptionDetail7 = _unitOfWork.St_DescriptionDetail.GetSt_DescriptionDetailBySt_Description(UserInfo.fCompanyId, 7), St_DescriptionDetail8 = _unitOfWork.St_DescriptionDetail.GetSt_DescriptionDetailBySt_Description(UserInfo.fCompanyId, 8), St_DescriptionDetail9 = _unitOfWork.St_DescriptionDetail.GetSt_DescriptionDetailBySt_Description(UserInfo.fCompanyId, 9), St_DescriptionDetail10 = _unitOfWork.St_DescriptionDetail.GetSt_DescriptionDetailBySt_Description(UserInfo.fCompanyId, 10), St_DescriptionDetail11 = _unitOfWork.St_DescriptionDetail.GetSt_DescriptionDetailBySt_Description(UserInfo.fCompanyId, 11), St_DescriptionDetail12 = _unitOfWork.St_DescriptionDetail.GetSt_DescriptionDetailBySt_Description(UserInfo.fCompanyId, 12), St_DescriptionDetail13 = _unitOfWork.St_DescriptionDetail.GetSt_DescriptionDetailBySt_Description(UserInfo.fCompanyId, 13), St_DescriptionDetail14 = _unitOfWork.St_DescriptionDetail.GetSt_DescriptionDetailBySt_Description(UserInfo.fCompanyId, 14), St_DescriptionDetail15 = _unitOfWork.St_DescriptionDetail.GetSt_DescriptionDetailBySt_Description(UserInfo.fCompanyId, 15), Categorie_1Name = _unitOfWork.St_Description.GetSt_DescriptionNameByID(UserInfo.fCompanyId, 1), Categorie_2Name = _unitOfWork.St_Description.GetSt_DescriptionNameByID(UserInfo.fCompanyId, 2), Categorie_3Name = _unitOfWork.St_Description.GetSt_DescriptionNameByID(UserInfo.fCompanyId, 3), Categorie_4Name = _unitOfWork.St_Description.GetSt_DescriptionNameByID(UserInfo.fCompanyId, 4), Categorie_5Name = _unitOfWork.St_Description.GetSt_DescriptionNameByID(UserInfo.fCompanyId, 5), Categorie_6Name = _unitOfWork.St_Description.GetSt_DescriptionNameByID(UserInfo.fCompanyId, 6), Categorie_7Name = _unitOfWork.St_Description.GetSt_DescriptionNameByID(UserInfo.fCompanyId, 7), Categorie_8Name = _unitOfWork.St_Description.GetSt_DescriptionNameByID(UserInfo.fCompanyId, 8), Categorie_9Name = _unitOfWork.St_Description.GetSt_DescriptionNameByID(UserInfo.fCompanyId, 9), Categorie_10Name = _unitOfWork.St_Description.GetSt_DescriptionNameByID(UserInfo.fCompanyId, 10), Categorie_11Name = _unitOfWork.St_Description.GetSt_DescriptionNameByID(UserInfo.fCompanyId, 11), Categorie_12Name = _unitOfWork.St_Description.GetSt_DescriptionNameByID(UserInfo.fCompanyId, 12), Categorie_13Name = _unitOfWork.St_Description.GetSt_DescriptionNameByID(UserInfo.fCompanyId, 13), Categorie_14Name = _unitOfWork.St_Description.GetSt_DescriptionNameByID(UserInfo.fCompanyId, 14), Categorie_15Name = _unitOfWork.St_Description.GetSt_DescriptionNameByID(UserInfo.fCompanyId, 15), TheDecimalPointForTheLocalCurrency = Company.TheDecimalPointForTheLocalCurrency }; return(View(St_ItemWarehouseObj)); }
public JsonResult UpdateDetermineWarehouseQuantities(St_ItemCardVM ObjUpdate) { MsgUnit Msg = new MsgUnit(); try { var userId = User.Identity.GetUserId(); var UserInfo = _unitOfWork.User.GetMyInfo(userId); var ObjUpdateSt_ItemWarehouse = new St_ItemWarehouse(); ObjUpdateSt_ItemWarehouse.CompanyID = UserInfo.fCompanyId; ObjUpdateSt_ItemWarehouse.StockCode = ObjUpdate.StockCode; ObjUpdateSt_ItemWarehouse.ItemCode = ObjUpdate.UpdateItemCode; ObjUpdateSt_ItemWarehouse.StockMinimumItemNo = ObjUpdate.StockMinimumItemNo; ObjUpdateSt_ItemWarehouse.StockMaximumItemNo = ObjUpdate.StockMaximumItemNo; 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_ItemCard.UpdateItemWarehous(ObjUpdateSt_ItemWarehouse); _unitOfWork.Complete(); Msg.Code = 1; Msg.Msg = Resources.Resource.UpdatedSuccessfully; 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 JsonResult GetAllSt_ItemCardFilterByWarehouseToInitialInventory(St_ItemCardVM Obj) { try { var userId = User.Identity.GetUserId(); var UserInfo = _unitOfWork.User.GetMyInfo(userId); var AllSt_ItemCard = _unitOfWork.NativeSql.GetAllSt_ItemCardFilterByWarehouseToInitialInventory(UserInfo.fCompanyId, Obj.ItemCode, Obj.StockCode); if (AllSt_ItemCard == null) { return(Json(new List <St_ItemCardVM>(), JsonRequestBehavior.AllowGet)); } if (!String.IsNullOrEmpty(Obj.ItemName)) { AllSt_ItemCard = AllSt_ItemCard.Where(m => m.ItemName.Contains(Obj.ItemName)).ToList(); } if (!String.IsNullOrEmpty(Obj.SupplierAccountNumber)) { AllSt_ItemCard = AllSt_ItemCard.Where(m => m.SupplierAccountNumber == Obj.SupplierAccountNumber).ToList(); } if (Obj.ItemUnitNo != 0) { AllSt_ItemCard = AllSt_ItemCard.Where(m => m.ItemUnitNo == Obj.ItemUnitNo).ToList(); } if (Obj.CountryOfOriginNo != 0) { AllSt_ItemCard = AllSt_ItemCard.Where(m => m.CountryOfOriginNo == Obj.CountryOfOriginNo).ToList(); } if (Obj.ManufacturerCompanyNo != 0) { AllSt_ItemCard = AllSt_ItemCard.Where(m => m.ManufacturerCompanyNo == Obj.ManufacturerCompanyNo).ToList(); } if (Obj.ItemCaseInt != 0) { AllSt_ItemCard = AllSt_ItemCard.Where(m => m.StopItem == Convert.ToBoolean(Obj.ItemCaseInt - 1)).ToList(); } if (Obj.ItemNatureNo != 0) { AllSt_ItemCard = AllSt_ItemCard.Where(m => m.ItemNatureNo == Obj.ItemNatureNo).ToList(); } if (Obj.Categorie_1 != 0) { AllSt_ItemCard = AllSt_ItemCard.Where(m => m.Categorie_1 == Obj.Categorie_1).ToList(); } if (Obj.Categorie_2 != 0) { AllSt_ItemCard = AllSt_ItemCard.Where(m => m.Categorie_2 == Obj.Categorie_2).ToList(); } if (Obj.Categorie_3 != 0) { AllSt_ItemCard = AllSt_ItemCard.Where(m => m.Categorie_3 == Obj.Categorie_3).ToList(); } if (Obj.Categorie_4 != 0) { AllSt_ItemCard = AllSt_ItemCard.Where(m => m.Categorie_4 == Obj.Categorie_4).ToList(); } if (Obj.Categorie_5 != 0) { AllSt_ItemCard = AllSt_ItemCard.Where(m => m.Categorie_5 == Obj.Categorie_5).ToList(); } if (Obj.Categorie_6 != 0) { AllSt_ItemCard = AllSt_ItemCard.Where(m => m.Categorie_6 == Obj.Categorie_6).ToList(); } if (Obj.Categorie_7 != 0) { AllSt_ItemCard = AllSt_ItemCard.Where(m => m.Categorie_7 == Obj.Categorie_7).ToList(); } if (Obj.Categorie_8 != 0) { AllSt_ItemCard = AllSt_ItemCard.Where(m => m.Categorie_8 == Obj.Categorie_8).ToList(); } if (Obj.Categorie_9 != 0) { AllSt_ItemCard = AllSt_ItemCard.Where(m => m.Categorie_9 == Obj.Categorie_9).ToList(); } if (Obj.Categorie_10 != 0) { AllSt_ItemCard = AllSt_ItemCard.Where(m => m.Categorie_10 == Obj.Categorie_10).ToList(); } if (Obj.Categorie_11 != 0) { AllSt_ItemCard = AllSt_ItemCard.Where(m => m.Categorie_11 == Obj.Categorie_11).ToList(); } if (Obj.Categorie_12 != 0) { AllSt_ItemCard = AllSt_ItemCard.Where(m => m.Categorie_12 == Obj.Categorie_12).ToList(); } if (Obj.Categorie_13 != 0) { AllSt_ItemCard = AllSt_ItemCard.Where(m => m.Categorie_13 == Obj.Categorie_13).ToList(); } if (Obj.Categorie_14 != 0) { AllSt_ItemCard = AllSt_ItemCard.Where(m => m.Categorie_14 == Obj.Categorie_14).ToList(); } if (Obj.Categorie_15 != 0) { AllSt_ItemCard = AllSt_ItemCard.Where(m => m.Categorie_15 == Obj.Categorie_15).ToList(); } return(Json(AllSt_ItemCard, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { ViewBag.Error = ex.Message.ToString(); return(Json(new List <St_ItemCardVM>(), JsonRequestBehavior.AllowGet)); } }
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)); } }