public int UpdateFoodMenuCatagory(FoodMenuCatagoryModel foodCategoryModel)
{
int result = 0;
using (SqlConnection con = new SqlConnection(_ConnectionString.Value.ConnectionString))
{
CommonRepository commonRepository = new CommonRepository(_ConnectionString);
result = commonRepository.GetValidateUnique("FoodMenuCategory", "FoodMenuCategoryName", foodCategoryModel.FoodMenuCategoryName, foodCategoryModel.Id.ToString());
if (result > 0)
{
return(-1);
}
con.Open();
SqlTransaction sqltrans = con.BeginTransaction();
var query = "UPDATE FoodMenuCategory SET FoodMenuCategoryName =@FoodMenuCategoryName," +
"Notes = @Notes, " +
"IsActive = @IsActive " +
"WHERE Id = @Id;";
result = con.Execute(query, foodCategoryModel, sqltrans, 0, System.Data.CommandType.Text);
if (result > 0)
{
sqltrans.Commit();
string output = commonRepository.SyncTableStatus("FoodMenuCategory");
}
else
{
sqltrans.Rollback();
}
}
return(result);
}
public ActionResult FoodMenuCategory(FoodMenuCatagoryModel foodMenuCategoryModel, string submitButton)
{
if (!ModelState.IsValid)
{
string errorString = this.ValidationFoodMenuCategory(foodMenuCategoryModel);
if (!string.IsNullOrEmpty(errorString))
{
ViewBag.Validate = errorString;
return(View(foodMenuCategoryModel));
}
}
if (foodMenuCategoryModel.Id > 0)
{
var result = _ifoodMenuCatagoryService.UpdateFoodMenuCatagory(foodMenuCategoryModel);
if (result == -1)
{
ModelState.AddModelError("FoodMenuCategoryName", "Category already exists");
return(View(foodMenuCategoryModel));
}
ViewBag.Result = _locService.GetLocalizedHtmlString("EditSuccss");
}
else
{
var result = _ifoodMenuCatagoryService.InsertFoodMenuCatagory(foodMenuCategoryModel);
if (result == -1)
{
ModelState.AddModelError("FoodMenuCategoryName", "Category already exists");
return(View(foodMenuCategoryModel));
}
ViewBag.Result = _locService.GetLocalizedHtmlString("SaveSuccess");
}
return(RedirectToAction("Index", "FoodMenuCategory"));
}
private string ValidationFoodMenuCategory(FoodMenuCatagoryModel foodMenuCategoryModel)
{
string ErrorString = string.Empty;
if (string.IsNullOrEmpty(foodMenuCategoryModel.FoodMenuCategoryName))
{
ErrorString = _locService.GetLocalizedHtmlString("ValidAddOnesName");
return(ErrorString);
}
//if (string.IsNullOrEmpty(foodMenuCategoryModel.Price.ToString()) || foodMenuCategoryModel.Price == 0)
//{
// ErrorString = _locService.GetLocalizedHtmlString("ValidPrice");
// return ErrorString;
//}
return(ErrorString);
}
public ActionResult FoodMenuCategory(int?id)
{
FoodMenuCatagoryModel foodMenuCategoryModel = new FoodMenuCatagoryModel();
if (UserRolePermissionForPage.Add == true || UserRolePermissionForPage.Edit == true)
{
if (id > 0)
{
int foodMenuiCateGoryId = Convert.ToInt32(id);
foodMenuCategoryModel = _ifoodMenuCatagoryService.GetFoodCategoryById(foodMenuiCateGoryId);
}
return(View(foodMenuCategoryModel));
}
else
{
return(RedirectToAction("NotFound", "Error"));
}
}
public int InsertFoodMenuCatagory(FoodMenuCatagoryModel foodCategoryModel)
{
int result = 0;
using (SqlConnection con = new SqlConnection(_ConnectionString.Value.ConnectionString))
{
CommonRepository commonRepository = new CommonRepository(_ConnectionString);
result = commonRepository.GetValidateUnique("FoodMenuCategory", "FoodMenuCategoryName", foodCategoryModel.FoodMenuCategoryName, foodCategoryModel.Id.ToString());
if (result > 0)
{
return(-1);
}
int MaxId = commonRepository.GetMaxId("FoodMenuCategory");
con.Open();
SqlTransaction sqltrans = con.BeginTransaction();
var query = "INSERT INTO FoodMenuCategory (Id,FoodMenuCategoryName," +
"Notes, " +
"IsActive)" +
"VALUES (" + MaxId + ",@FoodMenuCategoryName," +
"@Notes," +
"@IsActive); SELECT CAST(SCOPE_IDENTITY() as INT);";
result = con.Execute(query, foodCategoryModel, sqltrans, 0, System.Data.CommandType.Text);
if (result > 0)
{
sqltrans.Commit();
string output = commonRepository.SyncTableStatus("FoodMenuCategory");
}
else
{
sqltrans.Rollback();
}
return(result);
}
}
public int UpdateFoodMenuCatagory(FoodMenuCatagoryModel foodCategoryModel)
{
return(iFoodMenuCatagoryRepository.UpdateFoodMenuCatagory(foodCategoryModel));
}
public int InsertFoodMenuCatagory(FoodMenuCatagoryModel foodCategoryModel)
{
return(iFoodMenuCatagoryRepository.InsertFoodMenuCatagory(foodCategoryModel));
}
