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));
}
