// GET: Waste/Create public ActionResult Waste(long?id, string type) { WasteModel wasteModel = new WasteModel(); if (UserRolePermissionForPage.Add == true || UserRolePermissionForPage.Edit == true || UserRolePermissionForPage.View == true) { if (id > 0) { long wasteId = Convert.ToInt64(id); wasteModel = _iWasteService.GetWasteById(wasteId); ViewBag.ActionType = type; } else { wasteModel.WasteDateTime = DateTime.UtcNow.AddMinutes(LoginInfo.Timeoffset); wasteModel.ReferenceNumber = _iWasteService.ReferenceNumber().ToString(); } wasteModel.StoreList = _iDropDownService.GetStoreList(); wasteModel.FoodMenuList = _iDropDownService.GetFoodMenuListByFoodmenuType(-1); wasteModel.IngredientList = _iDropDownService.GetIngredientList(); wasteModel.FoodMenuListForLostAmount = _iWasteService.FoodMenuListForLostAmount(); wasteModel.IngredientListForLostAmount = _iWasteService.IngredientListForLostAmount(); return(View(wasteModel)); } else { return(RedirectToAction("NotFound", "Error")); } }
public ActionResult Waste(WasteModel model) { if (ModelState.IsValid) { int recordsCreated = CreateWaste(model.TypeName); return(RedirectToAction("Waste")); } return(View()); }
public ActionResult Waste(WasteModel wasteModel) { //wasteModel.FoodMenuList = _iDropDownService.GetFoodMenuList(); //wasteModel.IngredientList = _iDropDownService.GetIngredientList(); //wasteModel.EmployeeList = _iDropDownService.GetEmployeeList(); //wasteModel.StoreList = _iDropDownService.GetStoreList(); string wasteMessage = string.Empty; if (!ModelState.IsValid) { string errorString = this.ValidationWaste(wasteModel); if (!string.IsNullOrEmpty(errorString)) { return(Json(new { error = true, message = errorString, status = 201 })); } } if (wasteModel.WasteDetail != null) { if (wasteModel.WasteDetail.Count > 0) { if (wasteModel.Id > 0) { int result = _iWasteService.UpdateWaste(wasteModel); if (result > 0) { wasteMessage = _locService.GetLocalizedHtmlString("EditSuccss"); } } else { int result = _iWasteService.InsertWaste(wasteModel); if (result > 0) { wasteMessage = _locService.GetLocalizedHtmlString("SaveSuccess") + " Reference No is: " + result.ToString(); } } } else { wasteMessage = _locService.GetLocalizedHtmlString("ValidWasteDetails"); return(Json(new { error = true, message = wasteMessage, status = 201 })); } } else { wasteMessage = _locService.GetLocalizedHtmlString("ValidWasteDetails"); return(Json(new { error = true, message = wasteMessage, status = 201 })); } // return View(wasteModel); return(Json(new { error = false, message = wasteMessage, status = 200 })); //return View(); }
public WasteModel GetWasteById(long wasteId) { List <WasteModel> wasteModel = new List <WasteModel>(); WasteModel model = new WasteModel(); model = _iWasteRepository.GetWasteById(wasteId).ToList().SingleOrDefault(); if (model != null) { model.WasteDetail = _iWasteRepository.GetWasteDetails(wasteId); } return(model); }
public static int CreateWaste(string TypeName) { WasteModel data = new WasteModel { TypeName = TypeName, }; string sql = @"insert into dbo.Waste (TypeName) values (@TypeName);"; return(SqlDataAccess.SaveData(sql, data)); }
public ActionResult View(long?id) { WasteModel wasteModel = new WasteModel(); if (UserRolePermissionForPage.View == true) { long wasteId = Convert.ToInt64(id); wasteModel = _iWasteService.GetViewWasteById(wasteId); return(View(wasteModel)); } else { return(RedirectToAction("NotFound", "Error")); } }
public ActionResult GetOrderById(long wasteId) { WasteModel wasteModel = new WasteModel() { StoreList = _iDropDownService.GetStoreList(), FoodMenuList = _iDropDownService.GetFoodMenuList(), IngredientList = _iDropDownService.GetIngredientList(), //EmployeeList = _iDropDownService.GetEmployeeList(), FoodMenuListForLostAmount = _iWasteService.FoodMenuListForLostAmount(), IngredientListForLostAmount = _iWasteService.IngredientListForLostAmount(), }; wasteModel = _iWasteService.GetWasteById(wasteId); return(View(wasteModel)); }
private string ValidationWaste(WasteModel wasteModel) { string ErrorString = string.Empty; //if (string.IsNullOrEmpty(wasteModel.EmployeeId.ToString()) || wasteModel.EmployeeId == 0) //{ // ErrorString = _locService.GetLocalizedHtmlString("ValidEmployee"); // return ErrorString; //} if (string.IsNullOrEmpty(wasteModel.StoreId.ToString()) || wasteModel.StoreId == 0) { ErrorString = _locService.GetLocalizedHtmlString("ValidStore"); return(ErrorString); } if (wasteModel.WasteDetail == null || wasteModel.WasteDetail.Count < 1) { ErrorString = _locService.GetLocalizedHtmlString("ValidWasteDetails"); return(ErrorString); } return(ErrorString); }
public int UpdateWaste(WasteModel wasteModel) { return(_iWasteRepository.UpdateWaste(wasteModel)); }
public int InsertWaste(WasteModel wasteModel) { return(_iWasteRepository.InsertWaste(wasteModel)); }
private void Minus_Click(object sender, RoutedEventArgs e) { WasteModel Waste = new WasteModel(); MainContent.DataContext = Waste; }
public int InsertWaste(WasteModel wasteModel) { int result = 0; int detailResult = 0; using (SqlConnection con = new SqlConnection(_ConnectionString.Value.ConnectionString)) { con.Open(); SqlTransaction sqltrans = con.BeginTransaction(); var query = "INSERT INTO Waste " + "(StoreId, " + "ReferenceNumber, " + "WasteDateTime, " + "EmployeeId, " + "TotalLossAmount, " + "ReasonForWaste, " + "WasteStatus," + "UserIdInserted ," + "[DateInserted], " + "CreatedUserId ," + "[CreatedDatetime], " + "[IsDeleted]) " + " VALUES " + " (@StoreId, " + "@ReferenceNumber, " + "@WasteDateTime, " + "@EmployeeId, " + "@TotalLossAmount, " + "@ReasonForWaste, " + "@WasteStatus, " + "" + LoginInfo.Userid + "," + "GetUtcDate(), " + "" + LoginInfo.Userid + "," + "GetUtcDate(), " + "0); SELECT CAST(SCOPE_IDENTITY() as int); "; result = con.ExecuteScalar <int>(query, wasteModel, sqltrans, 0, System.Data.CommandType.Text); if (result > 0) { var queryDetails = string.Empty; foreach (var item in wasteModel.WasteDetail) { if (item.FoodMenuId == 0) { queryDetails = "INSERT INTO WasteIngredient ([WasteId],FoodMenuId,[IngredientId] ,IngredientQty, LossAmount, [UserIdInserted],DateInserted,[IsDeleted]) " + "VALUES " + "(" + result + ",NULL," + item.IngredientId + "," + item.Qty + "," + item.LossAmount + "," + LoginInfo.Userid + "," + "GetUtcDate(),0);" + " SELECT CAST(ReferenceNumber as INT) from waste where id = " + result + "; "; } else { queryDetails = "INSERT INTO WasteIngredient ([WasteId],FoodMenuId,[IngredientId] ,IngredientQty, LossAmount, [UserIdInserted],DateInserted,[IsDeleted]) " + "VALUES " + "(" + result + "," + item.FoodMenuId + ",NULL," + item.Qty + "," + item.LossAmount + "," + LoginInfo.Userid + "," + "GetUtcDate(),0);" + " SELECT CAST(ReferenceNumber as INT) from waste where id = " + result + "; "; } detailResult = con.ExecuteScalar <int>(queryDetails, null, sqltrans, 0, System.Data.CommandType.Text); } if (detailResult > 0) { sqltrans.Commit(); if ((int)wasteModel.WasteStatus == 2) { CommonRepository commonRepository = new CommonRepository(_ConnectionString); string sResult = commonRepository.InventoryPush("Waste", result); } } else { sqltrans.Rollback(); } } else { sqltrans.Rollback(); } } return(detailResult); }
public int UpdateWaste(WasteModel wasteModel) { int result = 0; using (SqlConnection con = new SqlConnection(_ConnectionString.Value.ConnectionString)) { con.Open(); SqlTransaction sqltrans = con.BeginTransaction(); var query = "Update Waste set " + "StoreId=@StoreId, ReferenceNumber=@ReferenceNumber, WasteDateTime=@WasteDateTime, EmployeeId=@EmployeeId, " + " TotalLossAmount=@TotalLossAmount, ReasonForWaste=@ReasonForWaste, WasteStatus=@WasteStatus "; if ((int)wasteModel.WasteStatus == 2) { query += ",ApprovedUserId = " + LoginInfo.Userid + ",ApprovedDateTime=GetUtcDate()"; } query += " ,UserIdUpdated = " + LoginInfo.Userid + ",DateUpdated = GetUtcDate() where id= " + wasteModel.Id + ";"; result = con.Execute(query, wasteModel, sqltrans, 0, System.Data.CommandType.Text); if (result > 0) { int detailResult = 0; if (wasteModel.DeletedId != null) { foreach (var item in wasteModel.DeletedId) { var obj = item.Split('|'); var deleteQuery = string.Empty; if (Convert.ToInt32(obj[2]) == 0) { deleteQuery = $"update WasteIngredient set IsDeleted = 1, UserIdDeleted = " + LoginInfo.Userid + ", DateDeleted = GetutcDate() where wasteid = " + Convert.ToInt32(obj[0]) + " and FoodMenuId = " + Convert.ToInt32(obj[1]) + " ;"; } else { deleteQuery = $"update WasteIngredient set IsDeleted = 1, UserIdDeleted = " + LoginInfo.Userid + ", DateDeleted = GetutcDate() where wasteid = " + Convert.ToInt32(obj[0]) + " and " + " IngredientId=" + Convert.ToInt32(obj[2]) + " and FoodMenuId = 0;"; } result = con.Execute(deleteQuery, null, sqltrans, 0, System.Data.CommandType.Text); } } foreach (var item in wasteModel.WasteDetail) { var queryDetails = string.Empty; if (item.WasteIngredientId > 0) { if (item.FoodMenuId > 0) { queryDetails = "Update [dbo].[WasteIngredient] set " + " [IngredientQty] = " + item.Qty + "," + " [LossAmount] = " + item.LossAmount + "," + " UserIdUpdated = " + LoginInfo.Userid + "," + " DateUpdated = GetUtcDate()" + " where Id = " + item.WasteIngredientId + ";"; } else if (item.IngredientId > 0) { queryDetails = "Update [dbo].[WasteIngredient] set " + " [IngredientQty] = " + item.Qty + "," + " [LossAmount] = " + item.LossAmount + "," + " UserIdUpdated = " + LoginInfo.Userid + "," + " DateUpdated = GetUtcDate()" + " where Id = " + item.WasteIngredientId + ";"; } } else { if (item.FoodMenuId == 0) { queryDetails = "INSERT INTO WasteIngredient ([WasteId],FoodMenuId,[IngredientId] ,IngredientQty, LossAmount, [UserIdInserted],DateInserted,[IsDeleted]) " + "VALUES " + "(" + wasteModel.Id + ",NULL," + item.IngredientId + "," + item.Qty + "," + item.LossAmount + "," + LoginInfo.Userid + "," + "GetUtcDate(),0);" + " SELECT CAST(ReferenceNumber as INT) from waste where id = " + result + "; "; } else { queryDetails = "INSERT INTO WasteIngredient ([WasteId],FoodMenuId,[IngredientId] ,IngredientQty, LossAmount, [UserIdInserted],DateInserted,[IsDeleted]) " + "VALUES " + "(" + wasteModel.Id + "," + item.FoodMenuId + ",NULL," + item.Qty + "," + item.LossAmount + "," + LoginInfo.Userid + "," + "GetUtcDate(),0);" + " SELECT CAST(ReferenceNumber as INT) from waste where id = " + result + "; "; } } detailResult = con.Execute(queryDetails, null, sqltrans, 0, System.Data.CommandType.Text); } if (detailResult > 0) { sqltrans.Commit(); if ((int)wasteModel.WasteStatus == 2) { CommonRepository commonRepository = new CommonRepository(_ConnectionString); string sResult = commonRepository.InventoryPush("Waste", wasteModel.Id); } } else { sqltrans.Rollback(); } } else { sqltrans.Rollback(); } } return(result); }