public async Task <HttpResponseMessage> GetAllByIdAsync(PageSettingModel _params)
{
var Res = Request.CreateResponse();
var Result = new Res();
try
{
var data = await Task.Run(() => _pageSettingService.GetById(_params));
if (data != null)
{
Result.Data = data;
Result.Status = true;
Result.Message = "Call API Success";
Result.StatusCode = HttpStatusCode.OK;
}
else
{
Result.Data = null;
Result.Status = false;
Result.Message = "Không tìm thấy dữ liệu";
Result.StatusCode = HttpStatusCode.InternalServerError;
}
Res.Content = new StringContent(JsonConvert.SerializeObject(Result));
return(Res);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public async Task <HttpResponseMessage> DeleteAsync(PageSettingModel _param)
{
var Res = Request.CreateResponse();
var Result = new Res();
try
{
if (_param != null)
{
await Task.Run(() => _pageSettingService.Delete(_param));
Result.Status = true;
Result.Message = "Xóa thành công";
Result.StatusCode = HttpStatusCode.OK;
}
else
{
Result.Status = false;
Result.Message = "Xóa thất bại";
Result.StatusCode = HttpStatusCode.BadRequest;
}
Res.Content = new StringContent(JsonConvert.SerializeObject(Result));
return(Res);
}
catch (Exception ex)
{
Result.Status = false;
Result.Message = "Có lỗi xảy ra trong quá trình xóa " + ex.Message;
Result.StatusCode = HttpStatusCode.BadRequest;
throw new Exception(ex.Message);
}
}
/*===Get All By Id*/
public PageSettingModel GetById(PageSettingModel _params)
{
var data = _uow.PageSettingRepo.SQLQuery <PageSettingModel>("sp_PageSetting_GetAllById " +
"@PageSetting_ID",
new SqlParameter("PageSetting_ID", SqlDbType.Int)
{
Value = _params.PageSetting_ID
}).FirstOrDefault();
return(data);
}
/*===Delete===*/
public void Delete(PageSettingModel _params)
{
try
{
_uow.PageSettingRepo.ExcQuery("exec sp_PageSetting_Delete " +
"@PageSetting_ID"
,
new SqlParameter("PageSetting_ID", SqlDbType.Int)
{
Value = _params.PageSetting_ID
}
);
}
catch (Exception ex)
{
throw new Exception("Có lỗi xảy ra trong quá trình xóa" + ex.Message);
}
}
/*===Insert===*/
public void Insert(PageSettingModel _params)
{
try
{
_uow.PageSettingRepo.ExcQuery("exec sp_PageSetting_Insert " +
"@PageSetting_NameVN," +
"@PageSetting_NameEN, " +
"@PageSetting_UrlOut," +
"@PageSetting_Rewrite," +
"@PageSetting_SearchVN," +
"@PageSetting_SearchEN," +
"@PageSetting_Img," +
"@Img_Width," +
"@Img_Unit_Width," +
"@Img_Height," +
"@Img_Unit_Height," +
"@Keyword_Titile," +
"@Keyword_Content," +
"@Keyword_Description," +
"@CreateDate," +
"@CreateBy," +
"@UpdateDate," +
"@UpdateBy," +
"@Lock," +
"@Is_Active," +
"@Is_TopPage," +
"@Is_LeftPage," +
"@Is_RightPage," +
"@Is_BottomPage," +
"@Display_Order"
,
new SqlParameter("PageSetting_NameVN", SqlDbType.NVarChar, (50))
{
Value = _params.PageSetting_NameVN
},
new SqlParameter("PageSetting_NameEN", SqlDbType.NVarChar, (50))
{
Value = _params.PageSetting_NameEN
},
new SqlParameter("PageSetting_UrlOut", SqlDbType.NVarChar, (255))
{
Value = _params.PageSetting_UrlOut ?? DBNull.Value.ToString()
},
new SqlParameter("PageSetting_Rewrite", SqlDbType.NVarChar, (255))
{
Value = _params.PageSetting_Rewrite
},
new SqlParameter("PageSetting_SearchVN", SqlDbType.VarChar, (50))
{
Value = _params.PageSetting_SearchVN ?? DBNull.Value.ToString()
},
new SqlParameter("PageSetting_SearchEN", SqlDbType.VarChar, (50))
{
Value = _params.PageSetting_SearchEN ?? DBNull.Value.ToString()
},
new SqlParameter("PageSetting_Img", SqlDbType.VarChar)
{
Value = _params.PageSetting_Img ?? DBNull.Value.ToString()
},
new SqlParameter("Img_Width", SqlDbType.Int)
{
Value = _params.Img_Width ?? 0
},
new SqlParameter("Img_Unit_Width", SqlDbType.VarChar, (10))
{
Value = _params.Img_Unit_Width ?? DBNull.Value.ToString()
},
new SqlParameter("Img_Height", SqlDbType.Int)
{
Value = _params.Img_Height ?? 0
},
new SqlParameter("Img_Unit_Height", SqlDbType.VarChar, (10))
{
Value = _params.Img_Unit_Height ?? DBNull.Value.ToString()
},
new SqlParameter("Keyword_Titile", SqlDbType.NVarChar, (50))
{
Value = _params.Keyword_Titile ?? DBNull.Value.ToString()
},
new SqlParameter("Keyword_Content", SqlDbType.NVarChar)
{
Value = _params.Keyword_Content ?? DBNull.Value.ToString()
},
new SqlParameter("Keyword_Description", SqlDbType.NVarChar)
{
Value = _params.Keyword_Description ?? DBNull.Value.ToString()
},
new SqlParameter("CreateDate", SqlDbType.Date)
{
Value = _params.CreateDate == null ? DateTime.Now : _params.CreateDate
},
new SqlParameter("CreateBy", SqlDbType.Int)
{
Value = _params.CreateBy == null ? 1 : _params.CreateBy
},
new SqlParameter("UpdateDate", SqlDbType.Date)
{
Value = _params.UpdateDate == null ? DateTime.Now : _params.UpdateDate
},
new SqlParameter("UpdateBy", SqlDbType.Int)
{
Value = _params.UpdateBy == null ? 1 : _params.UpdateBy
},
new SqlParameter("Lock", SqlDbType.Int)
{
Value = _params.Lock ?? 0
},
new SqlParameter("Is_Active", SqlDbType.Bit)
{
Value = _params.Is_Active == null ? true : _params.Is_Active
},
new SqlParameter("Is_TopPage", SqlDbType.Bit)
{
Value = _params.Is_TopPage == null ? true : _params.Is_TopPage
},
new SqlParameter("Is_BottomPage", SqlDbType.Bit)
{
Value = _params.Is_BottomPage == null ? true : _params.Is_BottomPage
},
new SqlParameter("Is_LeftPage", SqlDbType.Bit)
{
Value = _params.Is_LeftPage == null ? false : _params.Is_LeftPage
},
new SqlParameter("Is_RightPage", SqlDbType.Bit)
{
Value = _params.Is_RightPage == null ? false : _params.Is_RightPage
},
new SqlParameter("Display_Order", SqlDbType.Int)
{
Value = _params.Display_Order == null ? 1 : _params.Display_Order
}
);
}
catch (Exception ex)
{
throw new Exception("Có lỗi xảy ra trong quá trình thêm mới" + ex.Message);
}
}
public async Task <HttpResponseMessage> UpdateAsync(PageSettingModel _params)
{
var Res = Request.CreateResponse();
var Result = new Res();
var query = _pageSettingService.GetById(_params);
var StatusUpload = false;
var MessageUpload = string.Empty;
var OutputFile = string.Empty;
try
{
if (_params != null)
{
if (string.IsNullOrEmpty(_params.PageSetting_NameVN))
{
Result.Status = false;
Result.Message = "Tiêu đề tiếng việt không được trống " + _params.PageSetting_NameVN;
Result.StatusCode = HttpStatusCode.BadRequest;
}
else if (string.IsNullOrEmpty(_params.PageSetting_NameEN))
{
Result.Status = false;
Result.Message = "Tên tiêu đề tiếng anh không được trống " + _params.PageSetting_NameEN;
Result.StatusCode = HttpStatusCode.BadRequest;
}
else if (string.IsNullOrEmpty(_params.PageSetting_Rewrite))
{
Result.Status = false;
Result.Message = "Đường dẫn thân thiện không được trống " + _params.PageSetting_Rewrite;
Result.StatusCode = HttpStatusCode.BadRequest;
}
else
{
if (string.IsNullOrEmpty(_params.ImageBase64))
{
_params.PageSetting_Img = query.PageSetting_Img;
await Task.Run(() => _pageSettingService.Update(_params));
Result.Status = true;
Result.Message = "Cập nhập thành công";
Result.StatusCode = HttpStatusCode.OK;
}
else
{
//Viet ham upload vao day
UploadImageWithOutResize("YouNameSystem", _params.ImageBase64, "admin", out StatusUpload, out MessageUpload, out OutputFile);
if (StatusUpload)
{
_params.PageSetting_Img = OutputFile;//Đường dẫn ảnh khi đã được xử lý thành ảnh
await Task.Run(() => _pageSettingService.Update(_params));
Result.Status = true;
Result.Message = "Cập nhập thành công có ảnh";
Result.StatusCode = HttpStatusCode.OK;
}
}
}
}
else
{
Result.Status = false;
Result.Message = "Cập nhập thất bại";
Result.StatusCode = HttpStatusCode.BadRequest;
}
Res.Content = new StringContent(JsonConvert.SerializeObject(Result));
return(Res);
}
catch (Exception ex)
{
Result.Status = false;
Result.Message = "Có lỗi xảy ra trong quá trình cập nhập " + ex.Message;
Result.StatusCode = HttpStatusCode.BadRequest;
throw new Exception(ex.Message);
}
}
