public HttpResponseMessage GetCategoryById(int Id)
{
ResponseMessage <CategoryModel> objResponseData = new ResponseMessage <CategoryModel>();
try
{
Category category = new Category();
category.CategoryId = Id;
CategoryModel categoryModel = new CategoryModel();
if (objCategoryDAL.GetAllCategories().ToList().Any(cat => cat.CategoryId == Id))
{
Category categoryDetails = objCategoryDAL.GetCategoryDetails(category);
//mapping
categoryModel = Mapper.Map <Category, CategoryModel>(categoryDetails, categoryModel);
objResponseData = ResponseHandler <CategoryModel> .CreateResponse(objResponseData, "Category details", categoryModel, HttpStatusCode.OK);
}
else //category is not available
{
//mapping
categoryModel = Mapper.Map <Category, CategoryModel>(category, categoryModel);
objResponseData = ResponseHandler <CategoryModel> .CreateResponse(objResponseData, "This category is not available.", categoryModel, HttpStatusCode.Conflict);
}
}
catch (System.Exception ex)
{
objErrorLogger.ErrorLog(ex);
objResponseData = ResponseHandler <CategoryModel> .CreateErrorResponse(objResponseData);
}
return(Request.CreateResponse(objResponseData.StatusCode, objResponseData));
}
public HttpResponseMessage AddProduct(Product product)
{
ResponseMessage <Product> objResponseData = new ResponseMessage <Product>();
try
{
DataTable tempProductImages = new DataTable();
DataColumn dc = new DataColumn("TempId", typeof(int)); //creating first column of datatable
tempProductImages.Columns.Add(dc);
dc = new DataColumn("ImageUrl", typeof(String)); //creating second column of datatable
tempProductImages.Columns.Add(dc);
int result = objProductDAL.AddProduct(product, tempProductImages);
if (result != 0)
{
objResponseData = ResponseHandler <Product> .CreateResponse(objResponseData, "Successfully Added A New Product.", product, HttpStatusCode.OK);
}
else
{
objResponseData = ResponseHandler <Product> .CreateResponse(objResponseData, "Can't Add This Product.", HttpStatusCode.Conflict);
}
}
catch (System.Exception ex)
{
objErrorLogger.ErrorLog(ex);
objResponseData = ResponseHandler <Product> .CreateErrorResponse(objResponseData);
}
return(Request.CreateResponse(objResponseData.StatusCode, objResponseData));
}
public HttpResponseMessage GetCategories()
{
ResponseMessage <List <CategoryModel> > objResponseData = new ResponseMessage <List <CategoryModel> >();
try
{
List <CategoryModel> categoryModelList = new List <CategoryModel>();
List <Category> categories = objCategoryDAL.GetAllCategories().ToList();
if (categories.Count > 0)
{
foreach (Category cat in categories)
{
CategoryModel categoryModel = new CategoryModel();
categoryModel = Mapper.Map <Category, CategoryModel>(cat, categoryModel);
categoryModelList.Add(categoryModel);
}
objResponseData = ResponseHandler <CategoryModel> .CreateResponse(objResponseData, "List Of Available Product Categories", categoryModelList, HttpStatusCode.OK);
}
else //categories are not available
{
objResponseData = ResponseHandler <CategoryModel> .CreateResponse(objResponseData, "No categories area available.", HttpStatusCode.NoContent);
}
}
catch (System.Exception ex)
{
objErrorLogger.ErrorLog(ex);
objResponseData = ResponseHandler <CategoryModel> .CreateErrorResponse(objResponseData);
}
return(Request.CreateResponse(objResponseData.StatusCode, objResponseData));
}
public HttpResponseMessage UpdateProduct(Product product)
{
ResponseMessage <STP_ProductDetails_Result> objResponseData = new ResponseMessage <STP_ProductDetails_Result>();
try
{
DataTable tempProductImages = new DataTable();
DataColumn dc = new DataColumn("TempId", typeof(int)); //creating first column of datatable
tempProductImages.Columns.Add(dc);
dc = new DataColumn("ImageUrl", typeof(String)); //creating second column of datatable
tempProductImages.Columns.Add(dc);
int isSucceeded = objProductDAL.UpdateProduct(product, tempProductImages);
if (isSucceeded > 0)
{
STP_ProductDetails_Result updatedProduct = objProductDAL.GetProductDetails(product);
objResponseData = ResponseHandler <STP_ProductDetails_Result> .CreateResponse(objResponseData, "Product Has Been Updated Successfully.", updatedProduct, HttpStatusCode.OK);
}
else
{
objResponseData = ResponseHandler <STP_ProductDetails_Result> .CreateResponse(objResponseData, "Can't Update Product.", HttpStatusCode.Conflict);
}
}
catch (System.Exception ex)
{
objErrorLogger.ErrorLog(ex);
objResponseData = ResponseHandler <STP_ProductDetails_Result> .CreateErrorResponse(objResponseData);
}
return(Request.CreateResponse(objResponseData.StatusCode, objResponseData));
}
public HttpResponseMessage GetUserById(int Id)
{
ResponseMessage <STP_GetUserDetails_Result> objResponseData = new ResponseMessage <STP_GetUserDetails_Result>();
try
{
UserMaster user = new UserMaster();
user.UserId = Id;
STP_GetUserDetails_Result userDetail = objUserDAL.GetUserById(user);
if (userDetail != null)
{
objResponseData = ResponseHandler <STP_GetUserDetails_Result> .CreateResponse(objResponseData, "Detail Of Users", userDetail, HttpStatusCode.OK);
}
else
{
objResponseData = ResponseHandler <STP_GetUserDetails_Result> .CreateResponse(objResponseData, "No Users Available", userDetail, HttpStatusCode.NoContent);
}
}
catch (System.Exception ex)
{
objErrorLogger.ErrorLog(ex);
objResponseData = ResponseHandler <STP_GetUserDetails_Result> .CreateErrorResponse(objResponseData);
}
return(Request.CreateResponse(objResponseData.StatusCode, objResponseData));
}
public HttpResponseMessage GetProductList()
{
ResponseMessage <List <STP_ShowAllProductList_Result> > objResponseData = new ResponseMessage <List <STP_ShowAllProductList_Result> >();
try
{
List <STP_ShowAllProductList_Result> products = objProductDAL.GetProductList().ToList();
objResponseData = ResponseHandler <STP_ShowAllProductList_Result> .CreateResponse(objResponseData, "List Of Available Product", products, HttpStatusCode.OK);
}
catch (System.Exception ex)
{
objErrorLogger.ErrorLog(ex);
objResponseData = ResponseHandler <STP_ShowAllProductList_Result> .CreateErrorResponse(objResponseData);
}
return(Request.CreateResponse(objResponseData.StatusCode, objResponseData));
}
public HttpResponseMessage GetSubCategoryById(int SubCategoryId)
{
ResponseMessage <STP_GetSubCategoryDetails_Result> objResponseData = new ResponseMessage <STP_GetSubCategoryDetails_Result>();
try
{
var categoryDetails = objCategoryDAL.GetSubCategoryDetails(SubCategoryId);
objResponseData = ResponseHandler <STP_GetSubCategoryDetails_Result> .CreateResponse(objResponseData, "Category details", categoryDetails, HttpStatusCode.OK);
}
catch (System.Exception ex)
{
objErrorLogger.ErrorLog(ex);
objResponseData = ResponseHandler <STP_GetSubCategoryDetails_Result> .CreateErrorResponse(objResponseData);
}
return(Request.CreateResponse(objResponseData.StatusCode, objResponseData));
}
public HttpResponseMessage GetProductById(int Id)
{
ResponseMessage <STP_ProductDetails_Result> objResponseData = new ResponseMessage <STP_ProductDetails_Result>();
try
{
Product product = new Product();
product.ProductId = Id;
STP_ProductDetails_Result productDetails = objProductDAL.GetProductDetails(product);
objResponseData = ResponseHandler <STP_ProductDetails_Result> .CreateResponse(objResponseData, "Product details", productDetails, HttpStatusCode.OK);
}
catch (System.Exception ex)
{
objErrorLogger.ErrorLog(ex);
objResponseData = ResponseHandler <STP_ProductDetails_Result> .CreateErrorResponse(objResponseData);
}
return(Request.CreateResponse(objResponseData.StatusCode, objResponseData));
}
public HttpResponseMessage GetSubCategories()
{
ResponseMessage <List <STP_GetAllSubCategories_Result> > objResponseData = new ResponseMessage <List <STP_GetAllSubCategories_Result> >();
try
{
List <STP_GetAllSubCategories_Result> categories = objCategoryDAL.GetAllSubCategories().ToList();
objResponseData = ResponseHandler <STP_GetAllSubCategories_Result> .CreateResponse(objResponseData, "List Of Available Product Categories", categories, HttpStatusCode.OK);
}
catch (System.Exception ex)
{
objErrorLogger.ErrorLog(ex);
objResponseData = ResponseHandler <STP_GetAllSubCategories_Result> .CreateErrorResponse(objResponseData);
}
return(Request.CreateResponse(objResponseData.StatusCode, objResponseData));
}
public HttpResponseMessage UpdateCategory(Category category)
{
ResponseMessage <CategoryModel> objResponseData = new ResponseMessage <CategoryModel>();
try
{
CategoryModel categoryModel = new CategoryModel();
var AllCategories = objCategoryDAL.GetAllCategories().ToList();
if (AllCategories.Any(cat => cat.CategoryId == category.CategoryId))
{
Category updatedCategory = new Category();
//set created date & time
category.CreatedBy = AllCategories.Where(cat => cat.CategoryId == category.CategoryId).FirstOrDefault().CreatedBy;
category.CreatedOn = AllCategories.Where(cat => cat.CategoryId == category.CategoryId).FirstOrDefault().CreatedOn;
int isSucceeded = objCategoryDAL.UpdateCategory(category);
if (isSucceeded > 0)
{
updatedCategory = objCategoryDAL.GetCategoryDetails(category);
//mapping
categoryModel = Mapper.Map <Category, CategoryModel>(updatedCategory, categoryModel);
objResponseData = ResponseHandler <CategoryModel> .CreateResponse(objResponseData, "Category Has Been Updated Successfully.", categoryModel, HttpStatusCode.OK);
}
else
{
//mapping
categoryModel = Mapper.Map <Category, CategoryModel>(category, categoryModel);
objResponseData = ResponseHandler <CategoryModel> .CreateResponse(objResponseData, "Can't Update Category.", categoryModel, HttpStatusCode.Conflict);
}
}
else //category is not available
{
//mapping
categoryModel = Mapper.Map <Category, CategoryModel>(category, categoryModel);
objResponseData = ResponseHandler <CategoryModel> .CreateResponse(objResponseData, "This category is not available.", categoryModel, HttpStatusCode.Conflict);
}
}
catch (System.Exception ex)
{
objErrorLogger.ErrorLog(ex);
objResponseData = ResponseHandler <CategoryModel> .CreateErrorResponse(objResponseData);
}
return(Request.CreateResponse(objResponseData.StatusCode, objResponseData));
}
public HttpResponseMessage AddSubCategory(SubCategory category)
{
ResponseMessage <int> objResponseData = new ResponseMessage <int>();
try
{
var newCategory = objCategoryDAL.AddSubCategory(category);
if (newCategory > 0)
{
objResponseData = ResponseHandler <int> .CreateResponse(objResponseData, "Successfully Added A New Category.", newCategory, HttpStatusCode.OK);
}
else
{
objResponseData = ResponseHandler <int> .CreateResponse(objResponseData, "Can't Add This Category.", HttpStatusCode.Conflict);
}
}
catch (System.Exception ex)
{
objErrorLogger.ErrorLog(ex);
objResponseData = ResponseHandler <int> .CreateErrorResponse(objResponseData);
}
return(Request.CreateResponse(objResponseData.StatusCode, objResponseData));
}
public HttpResponseMessage GetUserList()
{
ResponseMessage <List <STP_GetUsers_Result> > objResponseData = new ResponseMessage <List <STP_GetUsers_Result> >();
try
{
List <STP_GetUsers_Result> userList = objUserDAL.GetUserList().Where(com => com.IsActive == true).ToList();
if (userList.Count > 0)
{
objResponseData = ResponseHandler <STP_GetUsers_Result> .CreateResponse(objResponseData, "List Of Users", userList, HttpStatusCode.OK);
}
else
{
objResponseData = ResponseHandler <STP_GetUsers_Result> .CreateResponse(objResponseData, "No Users Available", userList, HttpStatusCode.NoContent);
}
}
catch (System.Exception ex)
{
objErrorLogger.ErrorLog(ex);
objResponseData = ResponseHandler <STP_GetUsers_Result> .CreateErrorResponse(objResponseData);
}
return(Request.CreateResponse(objResponseData.StatusCode, objResponseData));
}
public HttpResponseMessage AddCategory(Category category)
{
ResponseMessage <CategoryModel> objResponseData = new ResponseMessage <CategoryModel>();
try
{
CategoryModel categoryModel = new CategoryModel();
if (objCategoryDAL.GetAllCategories().ToList().Any(cat => cat.CategoryName != category.CategoryName))
{
Category newCategory = objCategoryDAL.AddCategory(category);
if (newCategory.CategoryId > 0)
{
//mapping
categoryModel = Mapper.Map <Category, CategoryModel>(newCategory, categoryModel);
objResponseData = ResponseHandler <CategoryModel> .CreateResponse(objResponseData, "Successfully Added A New Category.", categoryModel, HttpStatusCode.OK);
}
else
{
//mapping
categoryModel = Mapper.Map <Category, CategoryModel>(category, categoryModel);
objResponseData = ResponseHandler <CategoryModel> .CreateResponse(objResponseData, "Can't Add This Category.", HttpStatusCode.Conflict);
}
}
else // category name is already present
{
//mapping
categoryModel = Mapper.Map <Category, CategoryModel>(category, categoryModel);
objResponseData = ResponseHandler <CategoryModel> .CreateResponse(objResponseData, "This category is already available.", categoryModel, HttpStatusCode.Conflict);
}
}
catch (System.Exception ex)
{
objErrorLogger.ErrorLog(ex);
objResponseData = ResponseHandler <CategoryModel> .CreateErrorResponse(objResponseData);
}
return(Request.CreateResponse(objResponseData.StatusCode, objResponseData));
}
public HttpResponseMessage DeleteProduct(Product product)
{
ResponseMessage <Product> objResponseData = new ResponseMessage <Product>();
try
{
int isDeleted = objProductDAL.DeleteProduct(product);
if (isDeleted > 0)
{
objResponseData = ResponseHandler <Product> .CreateResponse(objResponseData, "Product Has Been Deleted.", HttpStatusCode.OK);
}
else
{
objResponseData = ResponseHandler <Product> .CreateResponse(objResponseData, "Can't Delete Product", HttpStatusCode.NoContent);
}
}
catch (System.Exception ex)
{
objErrorLogger.ErrorLog(ex);
objResponseData = ResponseHandler <Product> .CreateErrorResponse(objResponseData);
}
return(Request.CreateResponse(objResponseData.StatusCode, objResponseData));
}
public HttpResponseMessage DeleteSubCategory(int SubCategoryId)
{
ResponseMessage <int> objResponseData = new ResponseMessage <int>();
try
{
int isDeleted = objCategoryDAL.DeleteSubCategory(SubCategoryId);
if (isDeleted > 0)
{
objResponseData = ResponseHandler <int> .CreateResponse(objResponseData, "Category Has Been Deleted.", isDeleted, HttpStatusCode.OK);
}
else
{
objResponseData = ResponseHandler <int> .CreateResponse(objResponseData, "Can't Delete Category", HttpStatusCode.NoContent);
}
}
catch (System.Exception ex)
{
objErrorLogger.ErrorLog(ex);
objResponseData = ResponseHandler <int> .CreateErrorResponse(objResponseData);
}
return(Request.CreateResponse(objResponseData.StatusCode, objResponseData));
}
public HttpResponseMessage UpdateSubCategory(SubCategory category)
{
ResponseMessage <int> objResponseData = new ResponseMessage <int>();
try
{
SubCategory updatedCategory = new SubCategory();
int isSucceeded = objCategoryDAL.UpdateSubCategory(category);
if (isSucceeded > 0)
{
objResponseData = ResponseHandler <int> .CreateResponse(objResponseData, "Category Has Been Updated Successfully.", isSucceeded, HttpStatusCode.OK);
}
else
{
objResponseData = ResponseHandler <int> .CreateResponse(objResponseData, "Can't Update Category.", isSucceeded, HttpStatusCode.Conflict);
}
}
catch (System.Exception ex)
{
objErrorLogger.ErrorLog(ex);
objResponseData = ResponseHandler <int> .CreateErrorResponse(objResponseData);
}
return(Request.CreateResponse(objResponseData.StatusCode, objResponseData));
}