public int UpdateExpsenseCategory(ExpsenseCategoryModel expenseCAtegoryModel) { int result = 0; using (SqlConnection con = new SqlConnection(_ConnectionString.Value.ConnectionString)) { con.Open(); SqlTransaction sqltrans = con.BeginTransaction(); var query = "UPDATE ExpenseCategory SET ExpenseCategory =@ExpenseCategory," + "Notes = @Notes, " + "IsActive = @IsActive " + "WHERE Id = @Id;"; result = con.Execute(query, expenseCAtegoryModel, sqltrans, 0, System.Data.CommandType.Text); if (result > 0) { sqltrans.Commit(); } else { sqltrans.Rollback(); } } return(result); }
public ActionResult ExpenseCategory(ExpsenseCategoryModel expenseCategoryModel, string submitButton) { if (!ModelState.IsValid) { string errorString = this.ValidationExpenseCategory(expenseCategoryModel); if (!string.IsNullOrEmpty(errorString)) { ViewBag.Validate = errorString; return(View(expenseCategoryModel)); } } if (expenseCategoryModel.Id > 0) { var result = _iexpsenseCategoryService.UpdateExpsenseCategory(expenseCategoryModel); ViewBag.Result = _locService.GetLocalizedHtmlString("EditSuccss"); } else { var result = _iexpsenseCategoryService.InsertExpsenseCategory(expenseCategoryModel); ViewBag.Result = _locService.GetLocalizedHtmlString("SaveSuccess"); } return(RedirectToAction("Index", "ExpenseCategory")); }
public int InsertExpsenseCategory(ExpsenseCategoryModel expenseCAtegoryModel) { int result = 0; using (SqlConnection con = new SqlConnection(_ConnectionString.Value.ConnectionString)) { con.Open(); SqlTransaction sqltrans = con.BeginTransaction(); var query = "INSERT INTO ExpenseCategory (ExpenseCategory," + "Notes, " + "IsActive)" + "VALUES (@ExpenseCategory," + "@Notes," + "@IsActive); SELECT CAST(SCOPE_IDENTITY() as INT);"; result = con.Execute(query, expenseCAtegoryModel, sqltrans, 0, System.Data.CommandType.Text); if (result > 0) { sqltrans.Commit(); } else { sqltrans.Rollback(); } return(result); } }
private string ValidationExpenseCategory(ExpsenseCategoryModel expenseCategoryModel) { string ErrorString = string.Empty; if (string.IsNullOrEmpty(expenseCategoryModel.ExpenseCategory)) { ErrorString = _locService.GetLocalizedHtmlString("ValidAddOnesName"); return(ErrorString); } //if (string.IsNullOrEmpty(expenseCategoryModel.Price.ToString()) || expenseCategoryModel.Price == 0) //{ // ErrorString = _locService.GetLocalizedHtmlString("ValidPrice"); // return ErrorString; //} return(ErrorString); }
public ActionResult ExpenseCategory(int?id) { ExpsenseCategoryModel expenseCategoryModel = new ExpsenseCategoryModel(); if (UserRolePermissionForPage.Add == true || UserRolePermissionForPage.Edit == true) { if (id > 0) { int expenseCAtegoryId = Convert.ToInt32(id); expenseCategoryModel = _iexpsenseCategoryService.GetExpsenseCategoryById(expenseCAtegoryId); } return(View(expenseCategoryModel)); } else { return(RedirectToAction("NotFound", "Error")); } }
public int UpdateExpsenseCategory(ExpsenseCategoryModel expenseCategoryModel) { return(_iExpenseCategoryReportsitory.UpdateExpsenseCategory(expenseCategoryModel)); }
public int InsertExpsenseCategory(ExpsenseCategoryModel expenseCategoryModel) { return(_iExpenseCategoryReportsitory.InsertExpsenseCategory(expenseCategoryModel)); }