//--------------//
public void Sel_ByCodeAlbum_ByIDLang(HttpContext context)
{
String jSonString = "";
AlbumsBO albumBO = new AlbumsBO();
int IDLang = string.IsNullOrEmpty(context.Request.QueryString["IDLang"]) ? CORE_Language.sys_CUR_LANG : int.Parse(context.Request.QueryString["IDLang"]);
string CodeAlbum = string.IsNullOrEmpty(context.Request.QueryString["CodeAlbum"]) ? "000" : context.Request.QueryString["CodeAlbum"].ToString();
List<Albums> obj = albumBO.Sel_ByCodeAlbum_ByIDLang(CodeAlbum,IDLang).ToList();
if (obj != null)
{
_converter.DateTimeFormat = "dd/MM/yyyy";
jSonString = JsonConvert.SerializeObject(obj, _converter);
}
jSonString = "{\"data\":" + jSonString + "}";
context.Response.Write(jSonString);
}
private void Upd_Status_ByCode_ByIDLang(HttpContext context)
{
String jSonString = "";
try {
AlbumsBO albumsBO = new AlbumsBO();
string code = Convert.ToString(context.Request.QueryString["Code"]);
int idLang = Convert.ToInt32(context.Request.QueryString["IDLang"]);
int status = Convert.ToInt32(context.Request.QueryString["Status"]);
int ret = albumsBO.Upd_Status_ByCode_ByIDLang(code, idLang, status);
if (ret == 0) jSonString = "{\"status\":\"error|" + ret + "\"}";
if (ret != 0) jSonString = "{\"status\": \"success\"}";
}
catch (Exception ex) {
jSonString = "{\"status\":\"error\" ,\"message\":\"" + ex.Message + "\"}";
}
finally {
context.Response.Write(jSonString);
}
}
private void Upd_Type_ByID(HttpContext context)
{
String jSonString = "";
try {
AlbumsBO albumsBO = new AlbumsBO();
int id = Convert.ToInt32(context.Request.QueryString["ID"]);
int type = Convert.ToInt32(context.Request.QueryString["Type"]);
int ret = albumsBO.Upd_Type_ByID(id, type);
if (ret == 0) jSonString = "{\"status\":\"error|" + ret + "\"}";
if (ret != 0) jSonString = "{\"status\": \"success\"}";
}
catch (Exception ex) {
jSonString = "{\"status\":\"error\" ,\"message\":\"" + ex.Message + "\"}";
}
finally {
context.Response.Write(jSonString);
}
}
private void Upd_ByID(HttpContext context)
{
string jSonString = string.Empty;
try {
AlbumsBO albumsBO = new AlbumsBO();
int id = Convert.ToInt32(context.Request.Form["txtID"]);
Albums albums = albumsBO.Sel_ByID(id);
albums.ID = albums.ID;
albums.Title = !String.IsNullOrEmpty(context.Request.Form["txtTitle_Lang"])
? Convert.ToString(context.Request.Form["txtTitle_Lang"])
: albums.Title;
albums.Info = !String.IsNullOrEmpty(context.Request.Form["txtInfo_Lang"])
? Convert.ToString(HttpUtility.HtmlDecode(context.Request.Form["txtInfo_Lang"]))
: albums.Info;
albums.Intro = !String.IsNullOrEmpty(context.Request.Form["txtIntro_Lang"])
? Convert.ToString(context.Request.Form["txtIntro_Lang"])
: albums.Intro;
albums.Status = !String.IsNullOrEmpty(context.Request.Form["cbbStatus"])
? Convert.ToInt32(context.Request.Form["cbbStatus"])
: albums.Status;
albums.Disable = !String.IsNullOrEmpty(context.Request.Form["cbbDisable"])
? Convert.ToBoolean(context.Request.Form["txt_Disable"])
: albums.Disable;
albums.CreateDate = !String.IsNullOrEmpty(context.Request.Form["dtpPublishDate"])
? DateTime.ParseExact(context.Request.Form["dtpPublishDate"], "dd/MM/yyyy", _culture)
: albums.CreateDate;
albums.CreateByIDUser = currentSystemUsers.ID;
albums.Image = !String.IsNullOrEmpty(context.Request.Form["txtImage_1"])
? Convert.ToString(context.Request.Form["txtImage_1"])
: albums.Image;
albums.Image1 = !String.IsNullOrEmpty(context.Request.Form["txtImage_2"])
? Convert.ToString(context.Request.Form["txtImage_2"])
: albums.Image1;
albums.Image2 = !String.IsNullOrEmpty(context.Request.Form["txtImage_3"])
? Convert.ToString(context.Request.Form["txtImage_3"])
: albums.Image2;
albums.Image3 = !String.IsNullOrEmpty(context.Request.Form["txtImage_4"])
? Convert.ToString(context.Request.Form["txtImage_4"])
: albums.Image3;
albums.Type = !String.IsNullOrEmpty(context.Request.Form["cbbType"])
? Convert.ToInt32(context.Request.Form["cbbType"])
: albums.Type;
albums.IDLang = !String.IsNullOrEmpty(context.Request.Form["IDLang_"])
? Convert.ToInt32(context.Request.Form["IDLang_"])
: albums.IDLang;
albums.ViewCount = !String.IsNullOrEmpty(context.Request.Form["txtViewCount"])
? Convert.ToInt64(context.Request.Form["txtViewCount"])
: albums.ViewCount;
albums.DownloadCount = !String.IsNullOrEmpty(context.Request.Form["txtDownloadCount"])
? Convert.ToInt64(context.Request.Form["txtDownloadCount"])
: albums.DownloadCount;
var ret = albumsBO.Upd_Albums(albums);
if (ret == 0) jSonString = "{\"status\":\"error|" + ret + "\"}";
else if (ret != 0) jSonString = "{\"status\": \"success\"}";
}
catch (Exception ex) {
jSonString = "{\"status\":\"error\" ,\"message\":\"" + ex.Message + "\"}";
}
finally {
context.Response.Write(jSonString);
}
}
private void Upd_Disable_ByCode(HttpContext context)
{
String jSonString = "";
try {
AlbumsBO albumsBO = new AlbumsBO();
string code = Convert.ToString(context.Request.QueryString["Code"]);
bool disable = Convert.ToBoolean(context.Request.QueryString["Disable"]);
int ret = albumsBO.Upd_Disable_ByCode(code, disable);
if (ret == 0) jSonString = "{\"status\":\"error|" + ret + "\"}";
if (ret != 0) jSonString = "{\"status\": \"success\"}";
}
catch (Exception ex) {
jSonString = "{\"status\":\"error\" ,\"message\":\"" + ex.Message + "\"}";
}
finally {
context.Response.Write(jSonString);
}
}
private void Sel_ByType_ByStatus_ByIDLang(HttpContext context)
{
String jSonString = string.Empty;
AlbumsBO albumsBO = new AlbumsBO();
int idLang = string.IsNullOrEmpty(context.Request.QueryString["IDLang"])
? CORE_Language.sys_CUR_LANG
: int.Parse(context.Request.QueryString["IDLang"]);
int type = Convert.ToInt32(context.Request.QueryString["Type"]);
int status = Convert.ToInt32(context.Request.QueryString["Status"]);
bool disable = !String.IsNullOrEmpty(context.Request.QueryString["Disable"])
? Convert.ToBoolean(context.Request.QueryString["Disable"])
: false;
List<Albums> listAlbums =
String.IsNullOrEmpty(Convert.ToString(context.Request.QueryString["Disable"]))
? albumsBO.Sel_ByType_ByStatus_ByIDLang(type, status, idLang)
: albumsBO.Sel_ByType_ByStatus_ByIDLang(type, status, idLang, disable);
if (listAlbums.Any()) {
_converter.DateTimeFormat = "dd/MM/yyyy";
jSonString = JsonConvert.SerializeObject(listAlbums, _converter);
}
jSonString = "{\"data\":" + jSonString + "}";
context.Response.Write(jSonString);
}
private void Upd_ByCode(HttpContext context, int NUM_LANG)
{
int ret = -1;
string jSonString = string.Empty;
try {
if (NUM_LANG < 1)
NUM_LANG = 1;
AlbumsBO albumsBO = new AlbumsBO();
String Code = context.Request.Form["txtCode"];
List<Albums> listAlbums = albumsBO.Sel_ByCode(Code);
if (listAlbums.Count <= NUM_LANG) {
int LoopUpdate = listAlbums.Count;
for (int i = 0; i < LoopUpdate; i++) {
listAlbums[i].ID = listAlbums[i].ID;
listAlbums[i].Title = !String.IsNullOrEmpty(context.Request.Form["txtTitle_Lang" + (i + 1)])
? Convert.ToString(context.Request.Form["txtTitle_Lang" + (i + 1)])
: listAlbums[i].Title;
listAlbums[i].Info = !String.IsNullOrEmpty(context.Request.Form["txtInfo_Lang" + (i + 1)])
? Convert.ToString(HttpUtility.HtmlDecode(context.Request.Form["txtInfo_Lang" + (i + 1)]))
: listAlbums[i].Info;
listAlbums[i].Intro = !String.IsNullOrEmpty(context.Request.Form["txtIntro_Lang" + (i + 1)])
? Convert.ToString(context.Request.Form["txtIntro_Lang" + (i + 1)])
: listAlbums[i].Intro;
listAlbums[i].Status = !String.IsNullOrEmpty(context.Request.Form["cbbStatus"])
? Convert.ToInt32(context.Request.Form["cbbStatus"])
: listAlbums[i].Status;
listAlbums[i].Disable = !String.IsNullOrEmpty(context.Request.Form["cbbDisable"])
? Convert.ToBoolean(context.Request.Form["txt_Disable"])
: listAlbums[i].Disable;
listAlbums[i].CreateDate = !String.IsNullOrEmpty(context.Request.Form["dtpPublishDate"])
? DateTime.ParseExact(context.Request.Form["dtpPublishDate"], "dd/MM/yyyy", _culture)
: listAlbums[i].CreateDate;
listAlbums[i].CreateByIDUser = currentSystemUsers.ID;
listAlbums[i].Image = !String.IsNullOrEmpty(context.Request.Form["txtImage_1"])
? Convert.ToString(context.Request.Form["txtImage_1"])
: listAlbums[i].Image;
listAlbums[i].Image1 = !String.IsNullOrEmpty(context.Request.Form["txtImage_2"])
? Convert.ToString(context.Request.Form["txtImage_2"])
: listAlbums[i].Image1;
listAlbums[i].Image2 = !String.IsNullOrEmpty(context.Request.Form["txtImage_3"])
? Convert.ToString(context.Request.Form["txtImage_3"])
: listAlbums[i].Image2;
listAlbums[i].Image3 = !String.IsNullOrEmpty(context.Request.Form["txtImage_4"])
? Convert.ToString(context.Request.Form["txtImage_4"])
: listAlbums[i].Image3;
listAlbums[i].Type = !String.IsNullOrEmpty(context.Request.Form["cbbType"])
? Convert.ToInt32(context.Request.Form["cbbType"])
: listAlbums[i].Type;
listAlbums[i].IDLang = !String.IsNullOrEmpty(context.Request.Form["IDLang_" + (i + 1)])
? Convert.ToInt32(context.Request.Form["IDLang_" + (i + 1)])
: listAlbums[i].IDLang;
listAlbums[i].ViewCount = !String.IsNullOrEmpty(context.Request.Form["txtViewCount"])
? Convert.ToInt64(context.Request.Form["txtViewCount"])
: listAlbums[i].ViewCount;
listAlbums[i].DownloadCount = !String.IsNullOrEmpty(context.Request.Form["txtDownloadCount"])
? Convert.ToInt64(context.Request.Form["txtDownloadCount"])
: listAlbums[i].DownloadCount;
ret = albumsBO.Upd_Albums(listAlbums[i]);
if (ret == 0) {
jSonString = "{\"status\":\"error|" + ret + "\"}";
break;
}
}
}
if (ret != 0) {
jSonString = "{\"status\": \"success\"}";
}
}
catch (Exception ex) {
jSonString = "{\"status\":\"error\" ,\"message\":\"" + ex.Message + "\"}";
}
finally {
context.Response.Write(jSonString);
}
}
private void Sel_ByID(HttpContext context)
{
String jSonString = "";
AlbumsBO albumsBO = new AlbumsBO();
int id = Convert.ToInt32(context.Request.QueryString["IDAlbums"]);
bool disable = !String.IsNullOrEmpty(context.Request.QueryString["Disable"])
? Convert.ToBoolean(context.Request.QueryString["Disable"])
: false;
Albums albums = String.IsNullOrEmpty(context.Request.QueryString["Disable"])
? albumsBO.Sel_ByID(id)
: albumsBO.Sel_ByID(id, disable);
if (albums != null) {
_converter.DateTimeFormat = "dd/MM/yyyy";
jSonString = JsonConvert.SerializeObject(albums, _converter);
}
jSonString = "{\"data\":" + jSonString + "}";
context.Response.Write(jSonString);
}
private void Sel_ByType_ByCode(HttpContext context)
{
String jSonString = string.Empty;
AlbumsBO albumsBO = new AlbumsBO();
String code = Convert.ToString(context.Request.QueryString["Code"]);
int type = Convert.ToInt32(context.Request.QueryString["Type"]);
bool disable = !String.IsNullOrEmpty(context.Request.QueryString["Disable"])
? Convert.ToBoolean(context.Request.QueryString["Disable"])
: false;
List<Albums> listAlbums =
String.IsNullOrEmpty(Convert.ToString(context.Request.QueryString["Disable"]))
? albumsBO.Sel_ByType_ByCode(type, code)
: albumsBO.Sel_ByType_ByCode(type, code, disable);
if (listAlbums.Any()) {
_converter.DateTimeFormat = "dd/MM/yyyy";
jSonString = JsonConvert.SerializeObject(listAlbums, _converter);
}
jSonString = "{\"data\":" + jSonString + "}";
context.Response.Write(jSonString);
}
private void Sel_ByCode_ByIDLang(HttpContext context)
{
String jSonString = string.Empty;
AlbumsBO albumsBO = new AlbumsBO();
int idLang = string.IsNullOrEmpty(context.Request.QueryString["IDLang"])
? CORE_Language.sys_CUR_LANG
: int.Parse(context.Request.QueryString["IDLang"]);
string code = Convert.ToString(context.Request.QueryString["Code"]);
bool disable = !String.IsNullOrEmpty(context.Request.QueryString["Disable"])
? Convert.ToBoolean(context.Request.QueryString["Disable"])
: false;
Albums albums =
String.IsNullOrEmpty(Convert.ToString(context.Request.QueryString["Disable"]))
? albumsBO.Sel_ByCode_ByIDLang(code, idLang)
: albumsBO.Sel_ByCode_ByIDLang(code, idLang, disable);
if (albums != null) {
_converter.DateTimeFormat = "dd/MM/yyyy";
jSonString = JsonConvert.SerializeObject(albums, _converter);
}
jSonString = "{\"data\":" + jSonString + "}";
context.Response.Write(jSonString);
}
private void Sel(HttpContext context)
{
AlbumsBO albumsBO = new AlbumsBO();
String jSonString = "";
bool disable = !String.IsNullOrEmpty(context.Request.QueryString["Disable"])
? Convert.ToBoolean(context.Request.QueryString["Disable"])
: false;
List<Albums> listAlbums =
String.IsNullOrEmpty(Convert.ToString(context.Request.QueryString["Disable"]))
? albumsBO.Sel()
: albumsBO.Sel(disable);
if (listAlbums.Any()) {
_converter.DateTimeFormat = "dd/MM/yyyy";
jSonString = JsonConvert.SerializeObject(listAlbums, _converter);
}
jSonString = "{\"data\":" + jSonString + "}";
context.Response.Write(jSonString);
}
private void Ins(HttpContext context, int NUM_LANG)
{
int ret = -1;
String jSonString = "";
try {
long a = DateTime.Now.Ticks;
TimeSpan Codespan = new TimeSpan(a);
AlbumsBO albumsBO = new AlbumsBO();
for (int i = 1; i <= NUM_LANG; i++) {
Albums aAlbums = new Albums();
aAlbums.Code = Math.Floor(Codespan.TotalSeconds).ToString();
aAlbums.Status = !String.IsNullOrEmpty(context.Request.Form["cbbStatus"])
? Convert.ToInt32(context.Request.Form["cbbStatus"])
: 1;
aAlbums.Disable = !String.IsNullOrEmpty(context.Request.Form["cbbDisable"])
? Convert.ToBoolean(context.Request.Form["cbbDisable"])
: false;
aAlbums.CreateDate = DateTime.Now;
aAlbums.CreateByIDUser = currentSystemUsers.ID;
aAlbums.Image = !String.IsNullOrEmpty(context.Request.Form["txtImage_1"])
? Convert.ToString(context.Request.Form["txtImage_1"])
: "";
aAlbums.Image1 = !String.IsNullOrEmpty(context.Request.Form["txtImage_2"])
? Convert.ToString(context.Request.Form["txtImage_2"])
: "";
aAlbums.Image2 = !String.IsNullOrEmpty(context.Request.Form["txtImage_3"])
? Convert.ToString(context.Request.Form["txtImage_3"])
: "";
aAlbums.Image3 = !String.IsNullOrEmpty(context.Request.Form["txtImage_4"])
? Convert.ToString(context.Request.Form["txtImage_4"])
: "";
aAlbums.Type = !String.IsNullOrEmpty(context.Request.Form["cbbType"])
? Convert.ToInt32(context.Request.Form["cbbType"])
: 0;
aAlbums.ViewCount = !String.IsNullOrEmpty(context.Request.Form["txtViewCount"])
? Convert.ToInt64(context.Request.Form["txtViewCount"])
: 0;
aAlbums.DownloadCount = !String.IsNullOrEmpty(context.Request.Form["txtViewdowload"])
? Convert.ToInt64(context.Request.Form["txtViewdowload"])
: 0;
aAlbums.IDLang = !String.IsNullOrEmpty(context.Request.Form["IDLang_" + i])
? Convert.ToInt32(context.Request.Form["IDLang_" + i])
: 0;
aAlbums.Title = !String.IsNullOrEmpty(context.Request.Form["txtTitle_Lang" + i])
? Convert.ToString(context.Request.Form["txtTitle_Lang" + i])
: "";
aAlbums.Info = !String.IsNullOrEmpty(context.Request.Form["txtInfo_Lang" + i])
? Convert.ToString(HttpUtility.HtmlDecode(context.Request.Form["txtInfo_Lang" + i]))
: "";
aAlbums.Intro = !String.IsNullOrEmpty(context.Request.Form["txtIntro_Lang" + i])
? Convert.ToString(context.Request.Form["txtIntro_Lang" + i])
: "";
ret = albumsBO.Ins(aAlbums);
if (ret == 0) {
jSonString = "{\"status\":\"error|" + ret + "\"}";
break;
}
}
if (ret != 0) {
jSonString = "{\"status\": \"success\"}";
}
}
catch (Exception ex) {
jSonString = "{\"status\":\"error\" ,\"message\":\"" + ex.Message + "\"}";
}
finally {
context.Response.Write(jSonString);
}
}
private void Del_ByIDLang(HttpContext context)
{
AlbumsBO albumsBO = new AlbumsBO();
String jSonString = "";
int idLang = Convert.ToInt32(context.Request.QueryString["IDLang"]);
int ret = albumsBO.Del_ByIDLang(idLang);
if (ret != 0) jSonString = "{\"status\": \"success\"}";
if (ret == 0) jSonString = "{\"status\":\"error|" + ret + "\"}";
context.Response.Write(jSonString);
}
private void Del_ByCode(HttpContext context)
{
AlbumsBO albumsBO = new AlbumsBO();
String jSonString = "";
string Code = context.Request.QueryString["Code"];
int ret = albumsBO.Del_ByCode(Code);
if (ret != 0) jSonString = "{\"status\": \"success\"}";
if (ret == 0) jSonString = "{\"status\":\"error|" + ret + "\"}";
context.Response.Write(jSonString);
}
