public JsonResult ProductUseInProductionHouse(List <VM_Product> productList)
{
try
{
foreach (var product in productList)
{
tblProductTransfer productTransfer = new tblProductTransfer();
productTransfer.DateTime = DateTime.Now;
productTransfer.CreatedBy = SessionManger.LoggedInUser(Session);
productTransfer.EditedBy = null;
productTransfer.RestaurantId =
Int32.Parse(SessionManger.RestaurantOfLoggedInUser(Session).ToString());
productTransfer.CreatedDateTime = DateTime.Now;
productTransfer.StoreId = product.StoreId;
productTransfer.SupplierId = null;
productTransfer.ProductId = product.ProductId;
productTransfer.Quantity = product.Quantity;
productTransfer.TransferDate = DateTime.Now;
productTransfer.isOut = true;
productTransfer.Unit = product.Unit;
unitOfWork.ProductTransferRepository.Insert(productTransfer);
}
unitOfWork.Save();
return(Json(new { success = true, successMesseage = "Raw Metarial Taken From ProductionHouse Successfully" },
JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { success = false, errorMessage = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult SaveProductToProductionHouse(int StoreId, List <VM_ProductToStore> productList)
{
try
{
foreach (VM_ProductToStore aProduct in productList)
{
tblProductTransfer aProductTransfer = new tblProductTransfer();
aProductTransfer.StoreId = StoreId;
aProductTransfer.TransferDate = DateTime.Now;
aProductTransfer.SupplierId = null;
aProductTransfer.ProductId = aProduct.ProductId;
aProductTransfer.Quantity = aProduct.Quantity;
aProductTransfer.Unit = aProduct.Unit;
aProductTransfer.UnitPrice = (decimal?)aProduct.UnitPrice;
aProductTransfer.isIn = true;
aProductTransfer.isOut = false;
aProductTransfer.DateTime = DateTime.Now;
aProductTransfer.RestaurantId = Int32.Parse(SessionManger.RestaurantOfLoggedInUser(Session).ToString());
aProductTransfer.CreatedBy = SessionManger.LoggedInUser(Session);
aProductTransfer.CreatedDateTime = DateTime.Now;
aProductTransfer.EditedBy = null;
aProductTransfer.EditedDateTime = null;
unitOfWork.ProductTransferRepository.Insert(aProductTransfer);
// MAY BE, DATA INSERTION IN TABLE tblProductEntryToProductionHouse SHOULD BE IMPLEMENTED HERE.
}
unitOfWork.Save();
return(Json(new { success = true, successMessage = "Product Added Successfully" }));
}
catch (Exception ex)
{
return(Json(new { success = false, errorMessage = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult AddProductToProductionHouse(List <Vm_ProductTransfetToProductionHouse> ProductList)
{
try
{
tblStoreInformation mainStore = null;
tblProductTransfer productTransfer = null;
foreach (var productTransfetToProductionHouse in ProductList)
{
if (productTransfetToProductionHouse.Quantity != null)
{
productTransfer = new tblProductTransfer();
productTransfer.DateTime = DateTime.Now;
productTransfer.CreatedBy = SessionManger.LoggedInUser(Session);
productTransfer.EditedBy = null;
productTransfer.RestaurantId =
Int32.Parse(SessionManger.RestaurantOfLoggedInUser(Session).ToString());
productTransfer.CreatedDateTime = DateTime.Now;
productTransfer.StoreId = productTransfetToProductionHouse.StoreId;
productTransfer.SupplierId = null;
productTransfer.ProductId = productTransfetToProductionHouse.ProductId;
productTransfer.Quantity = productTransfetToProductionHouse.Quantity;
productTransfer.TransferDate = DateTime.Now;
productTransfer.isIn = true;
productTransfer.Unit = productTransfetToProductionHouse.Unit;
unitOfWork.ProductTransferRepository.Insert(productTransfer);
unitOfWork.Save();
//--------- Get Main Store of --> Own Store---------------
mainStore = unitOfWork.StoreRepository.GetByID(productTransfer.StoreId);
//----------------- Out Product to Main Store ------------
tblProductTransfer productTransfer2 = new tblProductTransfer();
productTransfer2.StoreId = mainStore.ParentStoreId;
productTransfer2.SupplierId = null;
productTransfer2.ProductId = productTransfetToProductionHouse.ProductId;
productTransfer2.Quantity = productTransfetToProductionHouse.Quantity;
productTransfer2.TransferDate = DateTime.Now;
productTransfer2.Unit = productTransfetToProductionHouse.Unit;
productTransfer2.isOut = true;
productTransfer2.CreatedDateTime = DateTime.Now;
unitOfWork.ProductTransferRepository.Insert(productTransfer2);
productTransfer2.DateTime = DateTime.Now;
productTransfer2.CreatedBy = SessionManger.LoggedInUser(Session);
productTransfer2.EditedBy = null;
productTransfer2.RestaurantId =
Int32.Parse(SessionManger.RestaurantOfLoggedInUser(Session).ToString());
unitOfWork.Save();
}
}
ProductToProductionHouseReport(Convert.ToInt32(mainStore.ParentStoreId), Convert.ToInt32(productTransfer.StoreId), ProductList);
//----------- In a Product to Own Store------------------
return(Json(new { success = true, successMessage = "Product Transfer to Product House Successfully" }));
}
catch (Exception ex)
{
return(Json(new { success = false, errorMessage = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult OpeningProductBalanceInStore(int StoreId, List <VM_ProductToStore> productList, DateTime fromDate)
{
if (ModelState.IsValid)
{
try
{
if (unitOfWork.StoreRepository.GetByID(StoreId).is_mainStore == true)
{
foreach (VM_ProductToStore aProduct in productList)
{
tblProductTransfer aProductTransfer = new tblProductTransfer();
aProductTransfer.StoreId = StoreId;
aProductTransfer.TransferDate = fromDate;
aProductTransfer.SupplierId = null;
aProductTransfer.ProductId = aProduct.ProductId;
aProductTransfer.Quantity = (decimal?)aProduct.OpeningBalance;
aProductTransfer.Unit = aProduct.Unit;
aProductTransfer.UnitPrice = null;
aProductTransfer.isIn = true;
aProductTransfer.isOut = false;
aProductTransfer.DateTime = DateTime.Now;
aProductTransfer.RestaurantId =
Int32.Parse(SessionManger.RestaurantOfLoggedInUser(Session).ToString());
aProductTransfer.CreatedBy = SessionManger.LoggedInUser(Session);
aProductTransfer.CreatedDateTime = DateTime.Now;
aProductTransfer.EditedBy = null;
aProductTransfer.EditedDateTime = null;
unitOfWork.ProductTransferRepository.Insert(aProductTransfer);
}
unitOfWork.Save();
return(Json(new { success = true, successMessage = "Opening Product Balance Added Successfully" }, JsonRequestBehavior.AllowGet));
}
if (unitOfWork.StoreRepository.GetByID(StoreId).isProductionHouseStore == true)
{
foreach (VM_ProductToStore aProduct in productList)
{
tblProductTransfer product1 = new tblProductTransfer();
product1.StoreId = StoreId;
product1.TransferDate = fromDate;
product1.ProductId = aProduct.ProductId;
product1.Quantity = (decimal?)aProduct.OpeningBalance;
product1.Unit = aProduct.Unit;
product1.isIn = true;
product1.isOut = false;
product1.DateTime = DateTime.Now;
product1.RestaurantId = int.Parse(SessionManger.RestaurantOfLoggedInUser(Session).ToString());
product1.CreatedBy = SessionManger.LoggedInUser(Session);
product1.CreatedDateTime = DateTime.Now;
product1.EditedBy = null;
product1.EditedDateTime = null;
unitOfWork.ProductTransferRepository.Insert(product1);
}
unitOfWork.Save();
return(Json(new { success = true, successMessage = "Opening Product Balance Added Successfully" }, JsonRequestBehavior.AllowGet));
}
if (unitOfWork.StoreRepository.GetByID(StoreId).IsSellsPointStore == true)
{
//var SellsPoint = unitOfWork.SellsPointRepository.Get().Where(x => x.SellsPointStoreId == StoreId).First();
foreach (VM_ProductToStore aProduct in productList)
{
//tblPHtoSPProductTransfer product = new tblPHtoSPProductTransfer();
//product.SellsPointId = SellsPoint.SellsPointId;
//product.ProductionHouseId = null;
//product.ProductId = aProduct.ProductId;
//product.Quantity = (decimal?)aProduct.OpeningBalance;
//product.Unit = aProduct.Unit;
//product.isIn = true;
//product.isOut = false;
//product.RestaurantId = int.Parse(SessionManger.RestaurantOfLoggedInUser(Session).ToString());
//product.CreatedBy = SessionManger.LoggedInUser(Session);
//product.CreatedDateTime = DateTime.Now;
//product.EditedBy = null;
//product.EditedDateTime = null;
//unitOfWork.PHToSPProductTransferRepository.Insert(product);
//unitOfWork.Save();
tblProductTransfer product2 = new tblProductTransfer();
product2.StoreId = StoreId;
product2.TransferDate = fromDate;
product2.ProductId = aProduct.ProductId;
product2.Quantity = (decimal?)aProduct.OpeningBalance;
product2.Unit = aProduct.Unit;
product2.isIn = true;
product2.isOut = false;
product2.DateTime = DateTime.Now;
product2.RestaurantId = int.Parse(SessionManger.RestaurantOfLoggedInUser(Session).ToString());
product2.CreatedBy = SessionManger.LoggedInUser(Session);
product2.CreatedDateTime = DateTime.Now;
product2.EditedBy = null;
product2.EditedDateTime = null;
unitOfWork.ProductTransferRepository.Insert(product2);
}
unitOfWork.Save();
return(Json(new { success = true, successMessage = "Opening Product Balance Added Successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false, errorMessage = "Opening Product Balance not Save" }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
return(Json(new { success = false, errorMessage = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json(new { success = false, errorMessage = "Model is not Valid" }, JsonRequestBehavior.AllowGet));
}
}
//public JsonResult SaveProductToSellPoint(int SellsPointId, int ProductionHouseStoreId,int shiftId,DateTime fromDate, List<VM_PHtoSPProductTransfer> productList)
public JsonResult SaveProductToSellPoint(int SellsPointId, int ProductionHouseStoreId, int shiftId, List <VM_PHtoSPProductTransfer> productList)
{
try
{
var productionHouse = unitOfWork.ProductionHouseInformationRepository.Get().Where(x => x.OwnStore == ProductionHouseStoreId).FirstOrDefault();
//var mainStore = unitOfWork.StoreRepository.Get().Where(x => x.is_mainStore == true && x.store_id == ProductionHouseStoreId && x.store_id!=2).First();
var SellsPoint = unitOfWork.SellsPointRepository.Get().Where(x => x.SellsPointStoreId == SellsPointId).FirstOrDefault();
if (productionHouse != null)
{
foreach (VM_PHtoSPProductTransfer vmProduct in productList)
{
using (TransactionScope scope = new TransactionScope())
{
tblPHtoSPProductTransfer aProduct = new tblPHtoSPProductTransfer();
aProduct.SellsPointId = SellsPoint.SellsPointId;
aProduct.ProductionHouseId = productionHouse.ProductionHouseId;
//aProduct.GroupId = groupId;
aProduct.ShiftId = shiftId;
//aProduct.TransferDate = fromDate;
aProduct.TransferDate = DateTime.Now;
aProduct.ProductId = vmProduct.ProductId;
aProduct.Quantity = (decimal)vmProduct.Quantity;
aProduct.Unit = vmProduct.Unit;
aProduct.isIn = true;
aProduct.RestaurantId = int.Parse(SessionManger.RestaurantOfLoggedInUser(Session).ToString());
aProduct.CreatedBy = SessionManger.LoggedInUser(Session);
aProduct.CreatedDateTime = DateTime.Now;
aProduct.EditedBy = null;
aProduct.EditedDateTime = null;
unitOfWork.PHToSPProductTransferRepository.Insert(aProduct);
unitOfWork.Save();
tblProductTransfer product = new tblProductTransfer();
product.StoreId = ProductionHouseStoreId;
//product.GroupId = groupId;
product.ShiftId = shiftId;
//product.TransferDate = fromDate;
product.TransferDate = DateTime.Now;
product.ProductId = vmProduct.ProductId;
product.Quantity = (decimal)vmProduct.Quantity;
product.Unit = vmProduct.Unit;
product.isOut = true;
product.CreatedBy = SessionManger.LoggedInUser(Session);
product.CreatedDateTime = DateTime.Now;
product.EditedBy = null;
product.EditedDateTime = null;
unitOfWork.ProductTransferRepository.Insert(product);
unitOfWork.Save();
tblProductTransfer product2 = new tblProductTransfer();
product2.StoreId = SellsPointId;
//product2.GroupId = groupId;
product2.ShiftId = shiftId;
//product2.TransferDate = fromDate;
product2.TransferDate = DateTime.Now;
product2.ProductId = vmProduct.ProductId;
product2.Quantity = (decimal)vmProduct.Quantity;
product2.Unit = vmProduct.Unit;
product2.isIn = true;
product2.CreatedBy = SessionManger.LoggedInUser(Session);
product2.CreatedDateTime = DateTime.Now;
product2.EditedBy = null;
product2.EditedDateTime = null;
unitOfWork.ProductTransferRepository.Insert(product2);
unitOfWork.Save();
scope.Complete();
}
}
}
else
{
foreach (VM_PHtoSPProductTransfer vmProduct in productList)
{
using (TransactionScope scope = new TransactionScope())
{
tblPHtoSPProductTransfer aProduct = new tblPHtoSPProductTransfer();
aProduct.SellsPointId = SellsPoint.SellsPointId;
aProduct.ProductionHouseId = null;
//aProduct.GroupId = groupId;
aProduct.ShiftId = shiftId;
//aProduct.TransferDate = fromDate;
aProduct.TransferDate = DateTime.Now;
aProduct.ProductId = vmProduct.ProductId;
aProduct.Quantity = (decimal)vmProduct.Quantity;
aProduct.Unit = vmProduct.Unit;
aProduct.isIn = true;
aProduct.RestaurantId = int.Parse(SessionManger.RestaurantOfLoggedInUser(Session).ToString());
aProduct.CreatedBy = SessionManger.LoggedInUser(Session);
aProduct.CreatedDateTime = DateTime.Now;
aProduct.EditedBy = null;
aProduct.EditedDateTime = null;
unitOfWork.PHToSPProductTransferRepository.Insert(aProduct);
unitOfWork.Save();
tblProductTransfer product = new tblProductTransfer();
product.StoreId = ProductionHouseStoreId;
//product.GroupId = groupId;
product.ShiftId = shiftId;
//product.TransferDate = fromDate;
product.TransferDate = DateTime.Now;
product.ProductId = vmProduct.ProductId;
product.Quantity = (decimal)vmProduct.Quantity;
product.Unit = vmProduct.Unit;
product.isOut = true;
product.CreatedBy = SessionManger.LoggedInUser(Session);
product.CreatedDateTime = DateTime.Now;
product.EditedBy = null;
product.EditedDateTime = null;
unitOfWork.ProductTransferRepository.Insert(product);
unitOfWork.Save();
tblProductTransfer product2 = new tblProductTransfer();
product2.StoreId = SellsPointId;
//product2.GroupId = groupId;
product2.ShiftId = shiftId;
//product2.TransferDate = fromDate;
product2.TransferDate = DateTime.Now;
product2.ProductId = vmProduct.ProductId;
product2.Quantity = (decimal)vmProduct.Quantity;
product2.Unit = vmProduct.Unit;
product2.isIn = true;
product2.CreatedBy = SessionManger.LoggedInUser(Session);
product2.CreatedDateTime = DateTime.Now;
product2.EditedBy = null;
product2.EditedDateTime = null;
unitOfWork.ProductTransferRepository.Insert(product2);
unitOfWork.Save();
scope.Complete();
}
}
}
this.ProductionHouseToSellsPointReport(Convert.ToInt32(SellsPointId), Convert.ToInt32(ProductionHouseStoreId), productList);
//unitOfWork.Save();
return(Json(new { success = true, successMessage = " Successfully Added" }, JsonRequestBehavior.AllowGet));
}
catch (Exception exception)
{
return(Json(new { success = false, errorMessage = exception.Message }, JsonRequestBehavior.AllowGet));
}
}
//public JsonResult AddSoldProductInfoToProductTransfer(int storeId, int shiftId, DateTime fromDate, List<VM_ProductSold> productsoldList)
public JsonResult AddSoldProductInfoToProductTransfer(int storeId, int shiftId, List <VM_ProductSold> productsoldList)
{
try
{
foreach (var productsold in productsoldList)
{
using (TransactionScope scope = new TransactionScope())
{
tblProductTransfer productTransfer = new tblProductTransfer();
productTransfer.StoreId = storeId;
//productTransfer.GroupId = groupId;
productTransfer.ShiftId = shiftId;
//productTransfer.TransferDate = fromDate;
productTransfer.TransferDate = DateTime.Now;
productTransfer.ProductId = productsold.ProductId;
productTransfer.Quantity = productsold.Quantity;
productTransfer.Unit = unitOfWork.ProductRepository.GetByID(productsold.ProductId).Unit;
productTransfer.UnitPrice = unitOfWork.ProductRepository.GetByID(productsold.ProductId).UnitPrice;
productTransfer.isOut = true;
productTransfer.DateTime = DateTime.Now;
productTransfer.CreatedBy = SessionManger.LoggedInUser(Session);
productTransfer.EditedBy = null;
productTransfer.RestaurantId = Int32.Parse(SessionManger.RestaurantOfLoggedInUser(Session).ToString());
productTransfer.CreatedDateTime = DateTime.Now;
unitOfWork.ProductTransferRepository.Insert(productTransfer);
unitOfWork.Save();
//add product to productSold table
tblProductSold productSold = new tblProductSold();
productSold.StoreId = storeId;
//productSold.GroupId = groupId;
productSold.ShiftId = shiftId;
//productSold.TransferDate = fromDate;
productSold.TransferDate = DateTime.Now;
productSold.ProductId = productsold.ProductId;
productSold.Quantity = productsold.Quantity;
productSold.Unit = unitOfWork.ProductRepository.GetByID(productsold.ProductId).Unit;
productSold.UnitPrice = unitOfWork.ProductRepository.GetByID(productsold.ProductId).UnitPrice;
productSold.DateTime = DateTime.Now;
productSold.CreatedBy = SessionManger.LoggedInUser(Session);
productSold.EditedBy = null;
productSold.RestaurantId = Int32.Parse(SessionManger.RestaurantOfLoggedInUser(Session).ToString());
productSold.CreatedDateTime = DateTime.Now;
unitOfWork.ProductSoldRepository.Insert(productSold);
unitOfWork.Save();
if (shiftId == 1)
{
unitOfWork.CustomRepository.sp_InsertTotalAmountDailyByShiftWise();
}
else
{
unitOfWork.CustomRepository.sp_InsertTotalAmountDailyForNightShift();
}
scope.Complete();
}
}
return(Json(new { success = true, successMessage = "Product Sold" }));
}
catch (Exception ex)
{
return(Json(new { success = false, errorMessage = ex.Message }, JsonRequestBehavior.AllowGet));
}
//return Json(new { success = true, successMessage = "Product Sold" });
}
