//===================================== Delete Category =====================================//
public static SportModels.DALOutput Api_Sport_Category_Delete_DAL(SportModels.CategoryModel CM)
{
DataSet ds = new DataSet();
try
{
SqlParameter[] arrParams = new SqlParameter[1];
// input params
arrParams[0] = new SqlParameter("categoryID", SqlDbType.Int);
arrParams[0].Direction = ParameterDirection.Input;
arrParams[0].Value = CM.CategoryID;
// exec
ds = SqlHelper.ExecuteDataset(CConfigDS.CONNECTION_STRING_SQL_SPORT_SHOP, CommandType.StoredProcedure, CConfigDS.SPORT_SHOP_SQL_SP_CATEGORY_DELETE, arrParams);
// return (neu sp ko tra error code,msg thi tu gan default)
return(new SportModels.DALOutput()
{
ErrorCode = CConfigDS.RESPONSE_CODE_SUCCESS, ErrorMessage = CConfigDS.RESPONSE_MSG_SUCCESS, SqlData = ds
});
}
catch (Exception ex)
{
// log error
CLog.LogError(CBase.GetDeepCaller(), CBase.GetDetailError(ex));
// error => return null
return(new SportModels.DALOutput()
{
ErrorCode = CBase.GetLayerErrorCode(CBase.LAYER.DAL), ErrorMessage = ex.Message, SqlData = null
});
}
}
//===================================== Delete Category =====================================//
static public SportModels.ResponseModel Api_Sport_Category_Delete_BLL(SportModels.CategoryModel CM)
{
SportModels.ResponseModel RM = new SportModels.ResponseModel();
try
{
//lay du lieu tu DAL, return
SportModels.DALOutput DALO = new SportModels.DALOutput();
DALO = CSqlSport.Api_Sport_Category_Delete_DAL(CM);
// response info (success)
RM.Code = DALO.ErrorCode;
RM.Message = DALO.ErrorMessage;
RM.Data = DALO.SqlData;
}
catch (Exception ex)
{
// log error
CLog.LogError(CBase.GetDeepCaller(), CBase.GetDetailError(ex));
// response info (error)
RM.Code = CBase.GetLayerErrorCode(CBase.LAYER.BLL);
RM.Message = ex.Message;
RM.Data = null;
}
// return
return(RM);
}
public HttpResponseMessage Api_Sport_Category_Search( )
{
SportModels.ResponseModel RM = new SportModels.ResponseModel();
SportModels.CategoryModel CM = new SportModels.CategoryModel();
try
{
// ?categoryName={CategoryName}&createdDate={CreatedDate}
var varUrlKeyValues = ControllerContext.Request.GetQueryNameValuePairs();
// lay cac value can thiet tu queryString
CM.CategoryName = varUrlKeyValues.LastOrDefault(x => x.Key == "categoryName").Value;
CM.CreatedDate = Convert.ToDateTime(varUrlKeyValues.LastOrDefault(x => x.Key == "createdDate").Value);
// 1. get data
RM = CSport.Api_Sport_Category_Search_BLL(CM);
// 2. return response (code 200)
return(CreateJsonResponse(RM));
}
catch (Exception ex)
{
// log error
CLog.LogError(CBase.GetDeepCaller(), CBase.GetDetailError(ex));
// return error code
return(Request.CreateResponse(HttpStatusCode.InternalServerError));
}
}
public HttpResponseMessage Api_Sport_Category_Update(SportModels.CategoryModel CM)
{
SportModels.ResponseModel RM = new SportModels.ResponseModel();
try
{
// 1. get data
RM = CSport.Api_Sport_Category_Update_BLL(CM);
// 2. return response (code 200)
return(CreateJsonResponse(RM));
}
catch (Exception ex)
{
// log error
CLog.LogError(CBase.GetDeepCaller(), CBase.GetDetailError(ex));
// return error code
return(Request.CreateResponse(HttpStatusCode.InternalServerError));
}
}
