public ActionResult InventoryAdjustment(long?id, int?inventoryType, int?consumptionStatus, string type) { InventoryAdjustmentModel inventoryAdjustmentModel = new InventoryAdjustmentModel(); if (UserRolePermissionForPage.Add == true || UserRolePermissionForPage.Edit == true || UserRolePermissionForPage.View == true) { if (id > 0) { ViewBag.ActionType = type; long purchaseId = Convert.ToInt64(id); inventoryAdjustmentModel = _inventoryAdjustmentService.GetInventoryAdjustmentById(purchaseId); } else { inventoryAdjustmentModel.Date = DateTime.UtcNow.AddMinutes(LoginInfo.Timeoffset); inventoryAdjustmentModel.ReferenceNo = _inventoryAdjustmentService.ReferenceNumber().ToString(); inventoryAdjustmentModel.InventoryType = Convert.ToInt32(inventoryType); inventoryAdjustmentModel.ConsumptionStatus = Convert.ToInt32(consumptionStatus); } inventoryAdjustmentModel.StoreList = _iDropDownService.GetStoreList(); ViewBag.SelectedStore = inventoryAdjustmentModel.StoreList.Where(x => x.Selected == true).Select(x => x.Value).SingleOrDefault(); inventoryAdjustmentModel.EmployeeList = _iDropDownService.GetEmployeeList(); inventoryAdjustmentModel.IngredientList = _iDropDownService.GetIngredientList(); inventoryAdjustmentModel.AssetItemList = _iDropDownService.GetAssetItemList(); inventoryAdjustmentModel.FoodMenuList = _iDropDownService.GetFoodMenuListByFoodmenuType(-1); return(View(inventoryAdjustmentModel)); } else { return(RedirectToAction("NotFound", "Error")); } }
public ActionResult GetOrderById(long Id) { InventoryAdjustmentModel inventoryAdjustmentModel = new InventoryAdjustmentModel(); inventoryAdjustmentModel = _inventoryAdjustmentService.GetInventoryAdjustmentById(Id); return(View(inventoryAdjustmentModel)); }
public ActionResult View(long?id) { InventoryAdjustmentModel inventoryAdjustmentModel = new InventoryAdjustmentModel(); long purchaseId = Convert.ToInt64(id); inventoryAdjustmentModel = _inventoryAdjustmentService.GetViewInventoryAdjustmentById(purchaseId); return(View(inventoryAdjustmentModel)); }
public ActionResult InventoryAdjustment(InventoryAdjustmentModel inventoryAdjustmentModel) { inventoryAdjustmentModel.StoreList = _iDropDownService.GetStoreList(); inventoryAdjustmentModel.EmployeeList = _iDropDownService.GetEmployeeList(); inventoryAdjustmentModel.IngredientList = _iDropDownService.GetIngredientList(); inventoryAdjustmentModel.FoodMenuList = _iDropDownService.GetFoodMenuListByFoodmenuType(-1); string purchaseMessage = string.Empty; if (!ModelState.IsValid) { string errorString = this.ValidationInveotryAdjustment(inventoryAdjustmentModel); if (!string.IsNullOrEmpty(errorString)) { return(Json(new { error = true, message = errorString, status = 201 })); } } if (inventoryAdjustmentModel.InventoryAdjustmentDetail != null) { if (inventoryAdjustmentModel.InventoryAdjustmentDetail.Count > 0) { if (inventoryAdjustmentModel.Id > 0) { int result = _inventoryAdjustmentService.UpdateInventoryAdjustment(inventoryAdjustmentModel); if (result > 0) { purchaseMessage = _locService.GetLocalizedHtmlString("EditSuccss"); } } else { //inventoryAdjustmentModel.Date = DateTime.UtcNow.AddMinutes(LoginInfo.Timeoffset); int result = _inventoryAdjustmentService.InsertInventoryAdjustment(inventoryAdjustmentModel); if (result > 0) { purchaseMessage = _locService.GetLocalizedHtmlString("SaveSuccess");// + " Number is: " + result.ToString(); } } } else { purchaseMessage = _locService.GetLocalizedHtmlString("ValidPurchaseDetails"); return(Json(new { error = true, message = purchaseMessage, status = 201 })); } } else { purchaseMessage = _locService.GetLocalizedHtmlString("ValidPurchaseDetails"); return(Json(new { error = true, message = purchaseMessage, status = 201 })); } // return View(purchaseModel); return(Json(new { error = false, message = purchaseMessage, status = 200 })); //return View(); }
protected void Reject_Click(object sender, EventArgs e) { InventoryAdjustmentModel invModel = (InventoryAdjustmentModel)Session["ConfirmAdj"]; Inventory_Adjustment inventoryAdjustment = context.Inventory_Adjustment.Where(x => x.voucher_id == invModel.VoucherID).ToList().First(); inventoryAdjustment.status = "Rejected"; inventoryAdjustment.status_date = DateTime.Today; context.SaveChanges(); Response.Redirect("~/Views/DepartmentHead/HeadDashboard.aspx"); }
//InventoryAdjustmentModel model; protected void Page_Load(object sender, EventArgs e) { context = new SSISEntities(); if (!IsPostBack) { List <Inventory_Adjustment> invAdjList = context.Inventory_Adjustment.Where(x => x.deleted == "N" & x.status == "Pending").ToList(); List <InventoryAdjustmentModel> invModelList = new List <InventoryAdjustmentModel>(); foreach (Inventory_Adjustment i in invAdjList) { InventoryAdjustmentModel model = new InventoryAdjustmentModel(i); //model = new InventoryAdjustmentModel(i); if (User.IsInRole("Manager")) { foreach (AdjustmentModel j in model.AdjModel) { if (j.Above250()) { invModelList.Add(model); break; } } } else if (User.IsInRole("Supervisor")) { foreach (AdjustmentModel j in model.AdjModel) { if (!j.Above250()) { invModelList.Add(model); break; } } } } Session["ViewAdj"] = invModelList; ViewAdjustmentGV.DataSource = invModelList; ViewAdjustmentGV.DataBind(); //invModelList.Add(model); //GridView1.DataSource = invModelList; //GridView1.DataBind(); } //List<Adjustment_Details> adjList = context.Adjustment_Details.ToList(); //List<AdjustmentModel> detailList = new List<AdjustmentModel>(); //foreach (Adjustment_Details i in adjList) //{ // AdjustmentModel model = new AdjustmentModel(i); // detailList.Add(model); //} //Session["ViewAdj"] = detailList; }
protected void detailBtn_Click(object sender, EventArgs e) { GridViewRow gridViewRow = (GridViewRow)(sender as Control).Parent.Parent; Label rowIndex = (Label)gridViewRow.FindControl("rowIndex"); int index = int.Parse(rowIndex.Text) - 1; List <InventoryAdjustmentModel> invModelList = (List <InventoryAdjustmentModel>)Session["ViewAdj"]; InventoryAdjustmentModel model = invModelList[index]; Session["ConfirmAdj"] = model; Response.Redirect("AdjustmentDetail.aspx"); }
protected void Page_Load(object sender, EventArgs e) { context = new SSISEntities(); InventoryAdjustmentModel invModel = (InventoryAdjustmentModel)Session["ConfirmAdj"]; //List<InventoryAdjustmentModel> invModelList = new List<InventoryAdjustmentModel>(); //invModelList.Add(invModel); //GridView2.DataSource = invModelList; //GridView2.DataBind(); List <AdjustmentModel> adjList = invModel.AdjModel; GridView1.DataSource = adjList; GridView1.DataBind(); }
private string ValidationInveotryAdjustment(InventoryAdjustmentModel inventoryAdjustmentModel) { string ErrorString = string.Empty; if (string.IsNullOrEmpty(inventoryAdjustmentModel.StoreId.ToString()) || inventoryAdjustmentModel.StoreId == 0) { ErrorString = _locService.GetLocalizedHtmlString("ValidStoreName"); return(ErrorString); } if (inventoryAdjustmentModel.InventoryAdjustmentDetail == null || inventoryAdjustmentModel.InventoryAdjustmentDetail.Count < 1) { ErrorString = _locService.GetLocalizedHtmlString("ValidPurchaseDetails"); return(ErrorString); } return(ErrorString); }
public List <WCFInventoryAdjustmentModel> GetAllAdjustmentList(string role) { List <WCFInventoryAdjustmentModel> rd = new List <WCFInventoryAdjustmentModel>(); List <InventoryAdjustmentModel> invModelList = new List <InventoryAdjustmentModel>(); List <Inventory_Adjustment> invAdjList = work.GetAdjustmentList(); foreach (Inventory_Adjustment i in invAdjList) { InventoryAdjustmentModel s = new InventoryAdjustmentModel(i); if (role.Equals("DeptHead")) { foreach (AdjustmentModel j in s.AdjModel) { if (j.Above250()) { invModelList.Add(s); break; } } } else if (role.Equals("Supervisor")) { foreach (AdjustmentModel j in s.AdjModel) { if (!j.Above250()) { invModelList.Add(s); break; } } } } foreach (InventoryAdjustmentModel s in invModelList) { WCFInventoryAdjustmentModel item = new WCFInventoryAdjustmentModel(s.VoucherID.ToString(), s.Clerk, s.Status, s.Date.ToString(), s.HighestCost.ToString()); rd.Add(item); } return(rd); }
public int UpdateInventoryAdjustment(InventoryAdjustmentModel inventoryAdjustmentModel) { return(_inventoryAdjustmentRepository.UpdateInventoryAdjustment(inventoryAdjustmentModel)); }
public int InsertInventoryAdjustment(InventoryAdjustmentModel inventoryAdjustmentModel) { return(_inventoryAdjustmentRepository.InsertInventoryAdjustment(inventoryAdjustmentModel)); }
public int UpdateInventoryAdjustment(InventoryAdjustmentModel inventoryAdjustmentModel) { int result = 0; string foodMenuId = "NULL", ingredientId = "NULL", assetItemId = "NULL"; using (SqlConnection con = new SqlConnection(_ConnectionString.Value.ConnectionString)) { con.Open(); SqlTransaction sqltrans = con.BeginTransaction(); var query = "Update InventoryAdjustment SET StoreId=@StoreId,EntryDate=@Date, ReferenceNumber=@ReferenceNo,EmployeeId=@EmployeeId,Notes = @Notes" + ",[UserIdUpdated] = " + LoginInfo.Userid + ", [DateUpdated] = GetUtcDate() where id= " + inventoryAdjustmentModel.Id + ";"; result = con.Execute(query, inventoryAdjustmentModel, sqltrans, 0, System.Data.CommandType.Text); if (result > 0) { int detailResult = 0; if (inventoryAdjustmentModel.DeletedId != null) { foreach (var item in inventoryAdjustmentModel.DeletedId) { var deleteQuery = $"update InventoryAdjustmentDetail set IsDeleted = 1, UserIdDeleted = " + LoginInfo.Userid + ", DateDeleted = GetutcDate() where id = " + item + ";"; result = con.Execute(deleteQuery, null, sqltrans, 0, System.Data.CommandType.Text); } } foreach (var item in inventoryAdjustmentModel.InventoryAdjustmentDetail) { var queryDetails = string.Empty; /* * int consumptionId = 0; * if (item.ConsumpationStatus.Value.ToString() == "StockIN") * { * consumptionId = 1; * } * else * { * consumptionId = 2; * } */ if (item.AssetItemId == 0) { assetItemId = "NULL"; } else { assetItemId = item.AssetItemId.ToString(); } if (item.IngredientId == 0) { ingredientId = "NULL"; } else { ingredientId = item.IngredientId.ToString(); } if (item.FoodMenuId == 0) { foodMenuId = "NULL"; } else { foodMenuId = item.FoodMenuId.ToString(); var FoodmenuPurchaePriceUpdate = "" + " update foodmenu set PurchasePrice = " + item.Price + " Where id = " + item.FoodMenuId; con.Execute(FoodmenuPurchaePriceUpdate, null, sqltrans, 0, System.Data.CommandType.Text); } if (item.InventoryAdjustmentId > 0) { queryDetails = "Update InventoryAdjustmentDetail SET " + " IngredientId = " + ingredientId + " ,FoodMenuId = " + foodMenuId + " ,AssetItemId = " + assetItemId + " ,Qty = " + item.Quantity + " ,Price = " + item.Price + " ,Total = " + item.TotalAmount + ",ConsumptionStatus= " + inventoryAdjustmentModel.ConsumptionStatus + ",UserIdUpdated = " + LoginInfo.Userid + ", DateUpdated = GetUtcDate()" + " WHERE Id = " + item.InventoryAdjustmentId + ";"; } else { queryDetails = "INSERT INTO InventoryAdjustmentDetail" + " (InventoryAdjustmentId, IngredientId,FoodMenuId,AssetItemId,Qty,Price,Total,ConsumptionStatus,UserIdInserted,DateInserted,IsDeleted) " + "VALUES " + "(" + inventoryAdjustmentModel.Id + "," + "" + ingredientId + "," + "" + foodMenuId + "," + "" + assetItemId + "," + "" + item.Quantity + "," + "" + item.Price + "," + "" + item.TotalAmount + "," + "" + inventoryAdjustmentModel.ConsumptionStatus + "," + LoginInfo.Userid + ",GetUTCDate(),0)"; } detailResult = con.Execute(queryDetails, null, sqltrans, 0, System.Data.CommandType.Text); } if (detailResult > 0) { sqltrans.Commit(); } else { sqltrans.Rollback(); } } else { sqltrans.Rollback(); } } return(result); }
public int InsertInventoryAdjustment(InventoryAdjustmentModel inventoryAdjustmentModel) { int result = 0; int detailResult = 0; string foodMenuId = "NULL", ingredientId = "NULL", assetItemId = "NULL"; using (SqlConnection con = new SqlConnection(_ConnectionString.Value.ConnectionString)) { if (LoginInfo.Userid == 0) { LoginInfo.Userid = 1; } con.Open(); SqlTransaction sqltrans = con.BeginTransaction(); var query = "INSERT INTO InventoryAdjustment " + " ( StoreId, ReferenceNumber,InventoryType,ConsumptionStatus,EntryDate,EmployeeId,Notes,UserIdInserted,DateInserted,IsDeleted ) " + " VALUES " + " ( @StoreId, @ReferenceNo,@InventoryType,@ConsumptionStatus, @Date,@EmployeeId,@Notes," + LoginInfo.Userid + ",GetUTCDate(),0); " + " SELECT CAST(Scope_Identity() as int); "; result = con.ExecuteScalar <int>(query, inventoryAdjustmentModel, sqltrans, 0, System.Data.CommandType.Text); if (result > 0) { foreach (var item in inventoryAdjustmentModel.InventoryAdjustmentDetail) { if (item.AssetItemId == 0) { assetItemId = "NULL"; } else { assetItemId = item.AssetItemId.ToString(); } if (item.IngredientId == 0) { ingredientId = "NULL"; } else { ingredientId = item.IngredientId.ToString(); } if (item.FoodMenuId == 0) { foodMenuId = "NULL"; } else { foodMenuId = item.FoodMenuId.ToString(); var FoodmenuPurchaePriceUpdate = "" + " update foodmenu set PurchasePrice = " + item.Price + " Where id = " + item.FoodMenuId; } var queryDetails = "INSERT INTO InventoryAdjustmentDetail" + " (InventoryAdjustmentId,IngredientId,FoodMenuId,AssetItemId,Qty,Price,Total ,ConsumptionStatus,UserIdInserted,DateInserted,IsDeleted) " + "VALUES " + "(" + result + "," + "" + ingredientId + "," + "" + foodMenuId + "," + "" + assetItemId + "," + "" + item.Quantity + "," + "" + item.Price + "," + "" + item.TotalAmount + "," + "" + inventoryAdjustmentModel.ConsumptionStatus + "," + "" + LoginInfo.Userid + ",GetUtcDate(),0); " + " SELECT CAST(ReferenceNumber as INT) from InventoryAdjustment where id = " + result + "; "; detailResult = con.ExecuteScalar <int>(queryDetails, null, sqltrans, 0, System.Data.CommandType.Text); } if (detailResult > 0) { sqltrans.Commit(); if (inventoryAdjustmentModel.ConsumptionStatus == 1) { CommonRepository commonRepository = new CommonRepository(_ConnectionString); string sResult = commonRepository.InventoryPush("IA", result); } if (inventoryAdjustmentModel.ConsumptionStatus == 2) { CommonRepository commonRepository = new CommonRepository(_ConnectionString); string sResult = commonRepository.InventoryPush("IA-Out", result); } } else { sqltrans.Rollback(); } } else { sqltrans.Rollback(); } } return(detailResult); }