/// <summary>
/// Delete Sub Category
/// </summary>
/// <param name="objViewSubCategoryModel"></param>
/// <returns></returns>
public ViewSubCategoryModel DeleteSubCategory(ViewSubCategoryModel objViewSubCategoryModel)
{
try
{
SqlParameter pErrorCode = new SqlParameter("@ErrorCode", objViewSubCategoryModel.ErrorCode);
pErrorCode.Direction = ParameterDirection.Output;
SqlParameter pErrorMessage = new SqlParameter("@ErrorMessage", objViewSubCategoryModel.Message);
pErrorMessage.Direction = ParameterDirection.Output;
SqlParameter[] parmList =
{
new SqlParameter("@SubCategoryID", objViewSubCategoryModel.DeletedSubCategoryID)
, new SqlParameter("@CreatedBy", objViewSubCategoryModel.DeletedBy)
, pErrorCode
, pErrorMessage
};
//Call delete stored procedure to delete category
SQLHelper.ExecuteNonQuery(SQLHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, DBConstants.Admin_DeleteSubCategory, parmList);
//set output parameter error code and error message
objViewSubCategoryModel.ErrorCode = Convert.ToInt32(pErrorCode.Value);
objViewSubCategoryModel.Message = Convert.ToString(pErrorMessage.Value);
return(objViewSubCategoryModel);
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult ViewSubCategory()
{
ViewSubCategoryModel ObjViewSubCategoryModel = new ViewSubCategoryModel();
try
{
//initial set of current page, pageSize , Total pages
ObjViewSubCategoryModel.CurrentPage = 1;
ObjViewSubCategoryModel.PageSize = CommonUtils.PageSize;
ObjViewSubCategoryModel.TotalPages = 0;
//Get SubCategory List
serviceResponse = objUtilityWeb.PostAsJsonAsync(WebApiURL.SubCategory + "/GetSubCategoryList", ObjViewSubCategoryModel);
ObjViewSubCategoryModel = serviceResponse.StatusCode == HttpStatusCode.OK ? serviceResponse.Content.ReadAsAsync <ViewSubCategoryModel>().Result : null;
//ObjViewSubCategoryModel = objBLSubCategory.GetSubCategoryList(ObjViewSubCategoryModel);
//Set Success Message if comes from save page after click on save button
if (!String.IsNullOrEmpty(Convert.ToString(TempData["SucessMessage"])))
{
ObjViewSubCategoryModel.Message = Convert.ToString(TempData["SucessMessage"]);
ObjViewSubCategoryModel.MessageType = CommonUtils.MessageType.Success.ToString().ToLower();
TempData["SucessMessage"] = null;
}
CaegoryDropDown(ObjViewSubCategoryModel.FilterCategoryId);
// EmailTyepDropDown(ObjViewSubCategoryModel.FilterCategoryId);
GroupDropDown(ObjViewSubCategoryModel.FilterGroupID);
}
catch (Exception ex)
{
ErrorLog(ex, "SubCategory", "View GET");
}
return(View("ViewSubCategory", ObjViewSubCategoryModel));
}
/// <summary>
/// Get SubCategory List with paging, sorting and searching parameter
/// </summary>
/// <param name="objViewSubCategoryModel">object of Model ViewSubCategoryModel </param>
/// <returns></returns>
public DataTable GetSubCategoryList(ViewSubCategoryModel objViewSubCategoryModel)
{
try
{
SqlParameter[] parmList =
{
new SqlParameter("@SubCategoryName", objViewSubCategoryModel.FilterSubCatName)
, new SqlParameter("@CategoryId", objViewSubCategoryModel.FilterCategoryId)
, new SqlParameter("@CurrentPage", objViewSubCategoryModel.CurrentPage)
, new SqlParameter("@PageSize", objViewSubCategoryModel.PageSize)
, new SqlParameter("@SortBy", objViewSubCategoryModel.SortBy)
, new SqlParameter("@SortOrder", objViewSubCategoryModel.SortOrder)
};
DataSet ds = SQLHelper.ExecuteDataset(SQLHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, DBConstants.Admin_GetSubCategoryList, parmList);
if (ds != null && ds.Tables.Count > 0)
{
return(ds.Tables[0]);
}
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Get SubCategory List based on paging, searching and sorting parameter
/// </summary>
/// <param name="objViewSubCategoryModel">object of Model ViewSubCategoryModel</param>
/// <returns></returns>
public ViewSubCategoryModel GetSubCategoryList(ViewSubCategoryModel objViewSubCategoryModel)
{
List <SubCategoryModel> lstSubCategoryModel = new List <SubCategoryModel>();
//if FilterSubCategoryName is NULL than set to empty
objViewSubCategoryModel.FilterSubCatName = objViewSubCategoryModel.FilterSubCatName ?? String.Empty;
//if SortBy is NULL than set to empty
objViewSubCategoryModel.SortBy = objViewSubCategoryModel.SortBy ?? String.Empty;
//call GetSubCategoryList Method which will retrun datatable of SubCategory
DataTable dtSubCategory = objDLSubCategory.GetSubCategoryList(objViewSubCategoryModel);
//fetch each row of datable
foreach (DataRow dr in dtSubCategory.Rows)
{
//Convert datarow into Model object and set Model object property
SubCategoryModel itemSubCategoryModel = GetDataRowToEntity <SubCategoryModel>(dr);
//Add SubCategory in List
lstSubCategoryModel.Add(itemSubCategoryModel);
}
//set SubCategory List of Model ViewSubCategoryModel
objViewSubCategoryModel.SubCategoryList = lstSubCategoryModel;
//if SubCategory List count is not null and greater than 0 Than set Total Pages for Paging.
if (objViewSubCategoryModel != null && objViewSubCategoryModel.SubCategoryList != null && objViewSubCategoryModel.SubCategoryList.Count > 0)
{
objViewSubCategoryModel.CurrentPage = objViewSubCategoryModel.SubCategoryList[0].CurrentPage;
int totalRecord = objViewSubCategoryModel.SubCategoryList[0].TotalCount;
if (decimal.Remainder(totalRecord, objViewSubCategoryModel.PageSize) > 0)
{
objViewSubCategoryModel.TotalPages = (totalRecord / objViewSubCategoryModel.PageSize + 1);
}
else
{
objViewSubCategoryModel.TotalPages = totalRecord / objViewSubCategoryModel.PageSize;
}
}
else
{
objViewSubCategoryModel.TotalPages = 0;
objViewSubCategoryModel.CurrentPage = 1;
}
return(objViewSubCategoryModel);
}
public ActionResult ViewSubCategory(ViewSubCategoryModel objViewSubCategoryModel)
{
try
{
int ErrorCode = 0;
String ErrorMessage = "";
objViewSubCategoryModel.Message = objViewSubCategoryModel.MessageType = String.Empty;
if (objViewSubCategoryModel.ActionType == "delete")
{
//delete
serviceResponse = objUtilityWeb.PostAsJsonAsync(WebApiURL.SubCategory + "/DeleteSubCategory", objViewSubCategoryModel);
objViewSubCategoryModel = serviceResponse.StatusCode == HttpStatusCode.OK ? serviceResponse.Content.ReadAsAsync <ViewSubCategoryModel>().Result : null;
if (Convert.ToInt32(ErrorCode).Equals(0))
{
//if error code 0 means delete successfully than set Delete success message.
objViewSubCategoryModel.Message = "SubCategory Deleted Successfully";
objViewSubCategoryModel.MessageType = CommonUtils.MessageType.Success.ToString().ToLower();
}
else
{
//if error code is not 0 means delete error than set Delete error message.
objViewSubCategoryModel.Message = "Error while deleting record";
objViewSubCategoryModel.MessageType = CommonUtils.MessageType.Error.ToString().ToLower();;
}
}
//Get SubCategory List based on searching , sorting and paging parameter.
serviceResponse = objUtilityWeb.PostAsJsonAsync(WebApiURL.SubCategory + "/GetSubCategoryList", objViewSubCategoryModel);
objViewSubCategoryModel = serviceResponse.StatusCode == HttpStatusCode.OK ? serviceResponse.Content.ReadAsAsync <ViewSubCategoryModel>().Result : null;
CaegoryDropDown(objViewSubCategoryModel.FilterCategoryId);
GroupDropDown(objViewSubCategoryModel.FilterGroupID);
}
catch (Exception ex)
{
ErrorLog(ex, "SubCategory", "View POST");
}
return(PartialView("_SubCategoryList", objViewSubCategoryModel));
}
public HomeLayOutModel GetLayOutData()
{
HomeLayOutModel objHomeLayOutModel = new HomeLayOutModel();
BLCategory objBLCategory = new BLCategory();
BLDocument objBLDocument = new BLDocument();
BLSubCategory objBLSubCategory = new BLSubCategory();
ViewCategoryModel objViewCategoryModel = new ViewCategoryModel();
objViewCategoryModel.CurrentPage = 1;
objViewCategoryModel.PageSize = int.MaxValue - 1;
objHomeLayOutModel.objViewCategoryModel = new ViewCategoryModel();
objHomeLayOutModel.objViewCategoryModel = objBLCategory.GetCategoryList(objViewCategoryModel);
if (objHomeLayOutModel != null && objHomeLayOutModel.objViewCategoryModel != null && objHomeLayOutModel.objViewCategoryModel.CategoryList != null && objHomeLayOutModel.objViewCategoryModel.CategoryList.Count > 0)
{
for (int i = 0; i < objHomeLayOutModel.objViewCategoryModel.CategoryList.Count; i++)
{
//string[] DocumentIds = objHomeLayOutModel.objViewCategoryModel.CategoryList[i].QuickLinks.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries);
//if (DocumentIds != null && DocumentIds.Length > 0)
//{
// objHomeLayOutModel.objViewCategoryModel.CategoryList[i].objDocumentList = new List<DocumentModel>();
// for (int j = 0; j < DocumentIds.Length; j++)
// {
// objHomeLayOutModel.objViewCategoryModel.CategoryList[i].objDocumentList.Add(objBLDocument.GetDocumentById(Convert.ToInt32(DocumentIds[j])));
// }
//}
}
}
ViewSubCategoryModel objViewSubCategoryModel = new ViewSubCategoryModel();
objViewSubCategoryModel.CurrentPage = 1;
objViewSubCategoryModel.PageSize = int.MaxValue - 1;
objHomeLayOutModel.objSubViewCategoryModel = new ViewSubCategoryModel();
objHomeLayOutModel.objSubViewCategoryModel = objBLSubCategory.GetSubCategoryList(objViewSubCategoryModel);
return(objHomeLayOutModel);
}
/// <summary>
/// Delete SubCategory by SubCategory ID
/// </summary>
/// <param name="objViewSubCategoryModel"></param>
/// <param name="createdBy"></param>
/// <param name="errorCode"></param>
/// <param name="errorMessage"></param>
public ViewSubCategoryModel DeleteSubCategory(ViewSubCategoryModel objViewSubCategoryModel)
{
return(objDLSubCategory.DeleteSubCategory(objViewSubCategoryModel));
}
public ViewSubCategoryModel GetSubCategoryList(ViewSubCategoryModel objViewSubCategoryModel)
{
return(objBLSubCategory.GetSubCategoryList(objViewSubCategoryModel));
}
