public ActionResult AddInvertoryExpenses(InventoryExpenses invertoryExpenses, string name, string _year) { invertoryExpenses.Year = Convert.ToDateTime(_year); var requestResult = inventoryLogic.AddInventoryExpenses(invertoryExpenses); InvertoryViewModel = new InvertoryViewModel(); InvertoryViewModel.InvertoryExpenses = new InventoryExpenses(); InvertoryViewModel.InventoryModel = new Model.InventoryModel(); InvertoryViewModel.InventoryModel.Name = name; InvertoryViewModel.InvertoryExpenses.EndUserMessage = requestResult.EndUserMessage; return(View(InvertoryViewModel)); }
public ResponseStatus AddInvertoryExpenses(InventoryExpenses invertoryExpenses) { string query = "INSERT INTO [dbo].[InventoryExpenses]([InventoryIncome],[InventoryTax],[Year],[InventoryOutcome]" + ",[InventoryId])VALUES('" + invertoryExpenses.InvertoryIncome + "','" + invertoryExpenses.Tax + "','" + invertoryExpenses.Year.ToString() + "','" + invertoryExpenses.Outcome + "','" + invertoryExpenses.InvertoryId + "')"; SqlCommand queryCommand = new SqlCommand(query, DBConnection); queryCommand.ExecuteNonQuery(); DBConnection.Close(); return(ResponseStatus.Success); }
public BaseResponse AddInventoryExpenses(InventoryExpenses inventoryExpenses) { try { return(new BaseResponse() { Status = inventoryRepository.AddInvertoryExpenses(inventoryExpenses), EndUserMessage = "با موفقیت اضافه شد" }); } catch (Exception ex) { return(new BaseResponse() { Status = ResponseStatus.InternalError, EndUserMessage = "یک مشکل پیش آماده است" }); } }