public SubcategoryViewModel() { SubcategoryInfo = new SubcategoryInfo(); FriendlyMessage = new List <FriendlyMessage>(); SubcategoryList = new List <SubcategoryInfo>(); CategoryList = new List <Category>(); Pager = new PaginationInfo(); }
public List <SqlParameter> SetValuesInSubcategory(SubcategoryInfo subcategoryInfo) { List <SqlParameter> sqlParam = new List <SqlParameter>(); if (subcategoryInfo.Id != 0) { sqlParam.Add(new SqlParameter("@SubcategoryId", subcategoryInfo.Id)); } else { sqlParam.Add(new SqlParameter("@CreatedBy", subcategoryInfo.CreatedBy)); } sqlParam.Add(new SqlParameter("@CategoryId", subcategoryInfo.CategoryId)); sqlParam.Add(new SqlParameter("@Name", subcategoryInfo.SubCategoryName)); sqlParam.Add(new SqlParameter("@IsActive", subcategoryInfo.Active)); sqlParam.Add(new SqlParameter("UpdatedBy", subcategoryInfo.UpdatedBy)); return(sqlParam); }
public void Update_Subcategory(SubcategoryInfo _subcategoryInfo) { _subcategoryRepo.Update_Subcategory(_subcategoryInfo); }
public int Insert_Subcategory(SubcategoryInfo _subcategoryInfo) { return(_subcategoryRepo.Insert(_subcategoryInfo)); }
public void Update_Subcategory(SubcategoryInfo subcategory) { _sqlHelper.ExecuteNonQuery(SetValuesInSubcategory(subcategory), StoredProcedureEnum.sp_Update_Subcategory.ToString(), CommandType.StoredProcedure); }
public int Insert(SubcategoryInfo subcategory) { return(Convert.ToInt32(_sqlHelper.ExecuteScalerObj(SetValuesInSubcategory(subcategory), StoredProcedureEnum.sp_Insert_Subcategory.ToString(), CommandType.StoredProcedure))); }