public int UpdateVarient(VarientModel varientModel) { int result = 0; using (SqlConnection con = new SqlConnection(_ConnectionString.Value.ConnectionString)) { CommonRepository commonRepository = new CommonRepository(_ConnectionString); con.Open(); SqlTransaction sqltrans = con.BeginTransaction(); var query = "UPDATE Varient SET VarientName =@VarientName,FoodMenuId=@FoodMenuId," + "Price = @Price, " + "IsActive = @IsActive " + "WHERE Id = @Id;"; result = con.Execute(query, varientModel, sqltrans, 0, System.Data.CommandType.Text); if (result > 0) { sqltrans.Commit(); string output = commonRepository.SyncTableStatus("Varient"); } else { sqltrans.Rollback(); } } return(result); }
public ActionResult Varient(VarientModel varientModel, string submitButton) { varientModel.FoodMenuList = _iDropDownService.GetFoodMenuList(); if (!ModelState.IsValid) { string errorString = this.ValidationVarient(varientModel); if (!string.IsNullOrEmpty(errorString)) { ViewBag.Validate = errorString; return(View(varientModel)); } } if (varientModel.Id > 0) { var result = _iVarientService.UpdateVarient(varientModel); ViewBag.Result = _locService.GetLocalizedHtmlString("EditSuccss"); } else { var result = _iVarientService.InsertVarient(varientModel); ViewBag.Result = _locService.GetLocalizedHtmlString("SaveSuccess"); } return(RedirectToAction("Index", "Varient")); }
public int InsertVarient(VarientModel varientModel) { CommonRepository commonRepository = new CommonRepository(_ConnectionString); int MaxId = commonRepository.GetMaxId("Varient"); int result = 0; using (SqlConnection con = new SqlConnection(_ConnectionString.Value.ConnectionString)) { con.Open(); SqlTransaction sqltrans = con.BeginTransaction(); var query = "INSERT INTO Varient (Id,VarientName,FoodMenuId," + "Price, " + "IsActive)" + "VALUES (" + MaxId + ",@VarientName,@FoodMenuId," + "@Price," + "@IsActive); SELECT CAST(SCOPE_IDENTITY() as INT);"; result = con.Execute(query, varientModel, sqltrans, 0, System.Data.CommandType.Text); if (result > 0) { sqltrans.Commit(); string output = commonRepository.SyncTableStatus("Varient"); } else { sqltrans.Rollback(); } } return(result); }
private string ValidationVarient(VarientModel varientModel) { string ErrorString = string.Empty; if (string.IsNullOrEmpty(varientModel.VarientName)) { ErrorString = _locService.GetLocalizedHtmlString("ValidAddOnesName"); return(ErrorString); } //if (string.IsNullOrEmpty(varientModel.Price.ToString()) || varientModel.Price == 0) //{ // ErrorString = _locService.GetLocalizedHtmlString("ValidPrice"); // return ErrorString; //} return(ErrorString); }
public ActionResult Varient(int?id) { VarientModel varientModel = new VarientModel(); if (UserRolePermissionForPage.Add == true || UserRolePermissionForPage.Edit == true) { if (id > 0) { int varientId = Convert.ToInt32(id); varientModel = _iVarientService.GetAddonesById(varientId); } varientModel.FoodMenuList = _iDropDownService.GetFoodMenuList(); return(View(varientModel)); } else { return(RedirectToAction("NotFound", "Error")); } }
public int UpdateVarient(VarientModel VarientModel) { return(_IVarientReportsitory.UpdateVarient(VarientModel)); }
public int InsertVarient(VarientModel VarientModel) { return(_IVarientReportsitory.InsertVarient(VarientModel)); }