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