public void Upd_ByCode(HttpContext context, int NUM_LANG)
{
int ret = -1;
String jSonString = "";
try
{
if (NUM_LANG < 1)
{
NUM_LANG = 1;
}
List<CategoryLevel1> aListCategoryLevel1 = new List<CategoryLevel1>();
CategoryLevel1BO aCategoryLevel1BO = new CategoryLevel1BO();
String Code = context.Request.Form["txtCode"];
aListCategoryLevel1 = aCategoryLevel1BO.Sel_ByCode(Code);
int LoopUpdate = 0;
if (aListCategoryLevel1.Count <= NUM_LANG)
{
LoopUpdate = aListCategoryLevel1.Count;
for (int i = 0; i < LoopUpdate; i++)
{
aListCategoryLevel1[i].ID = aListCategoryLevel1[i].ID;
aListCategoryLevel1[i].Code = aListCategoryLevel1[i].Code;
aListCategoryLevel1[i].IDLang = aListCategoryLevel1[i].IDLang;
aListCategoryLevel1[i].Type = !String.IsNullOrEmpty(context.Request.Form["cbbType"]) ? Convert.ToInt32(context.Request.Form["cbbType"]) : aListCategoryLevel1[i].Type;
aListCategoryLevel1[i].ViewCount = !String.IsNullOrEmpty(context.Request.Form["txtViewCount"]) ? Convert.ToInt64(context.Request.Form["txtViewCount"]) : 0;
aListCategoryLevel1[i].Status = !String.IsNullOrEmpty(context.Request.Form["cbbStatus"]) ? Convert.ToInt32(context.Request.Form["cbbStatus"]) : aListCategoryLevel1[i].Status;
aListCategoryLevel1[i].Disable = !String.IsNullOrEmpty(context.Request.Form["cbbDisable"]) ? Convert.ToBoolean(context.Request.Form["cbbDisable"]) : aListCategoryLevel1[i].Disable;
aListCategoryLevel1[i].Tag = !String.IsNullOrEmpty(context.Request.Form["txtTag"]) ? Convert.ToString(context.Request.Form["txtTag"]) : aListCategoryLevel1[i].Tag;
aListCategoryLevel1[i].IDAlbum = !String.IsNullOrEmpty(context.Request.Form["cbbIDAlbum"]) ? Convert.ToInt32(context.Request.Form["cbbIDAlbum"]) : aListCategoryLevel1[i].IDAlbum;
aListCategoryLevel1[i].Image = !String.IsNullOrEmpty(context.Request.Form["txtImage_1"]) ? Convert.ToString(context.Request.Form["txtImage_1"]) : "";
aListCategoryLevel1[i].Image1 = !String.IsNullOrEmpty(context.Request.Form["txtImage_2"]) ? Convert.ToString(context.Request.Form["txtImage_2"]) : "";
aListCategoryLevel1[i].Image2 = !String.IsNullOrEmpty(context.Request.Form["txtImage_3"]) ? Convert.ToString(context.Request.Form["txtImage_3"]) : "";
aListCategoryLevel1[i].Image3 = !String.IsNullOrEmpty(context.Request.Form["txtImage_4"]) ? Convert.ToString(context.Request.Form["txtImage_4"]) : "";
aListCategoryLevel1[i].CategoryNameLevel1 = !String.IsNullOrEmpty(context.Request.Form["txtCategoryNameLevel1_Lang" + (i + 1)]) ? Convert.ToString(context.Request.Form["txtCategoryNameLevel1_Lang" + (i + 1)]) : aListCategoryLevel1[i].CategoryNameLevel1;
aListCategoryLevel1[i].Note = !String.IsNullOrEmpty(context.Request.Form["txtNote_Lang" + (i + 1)]) ? Convert.ToString(context.Request.Form["txtNote_Lang" + (i + 1)]) : aListCategoryLevel1[i].Note;
aListCategoryLevel1[i].Intro = !String.IsNullOrEmpty(context.Request.Form["txtIntro_Lang" + (i + 1)]) ? Convert.ToString(context.Request.Form["txtIntro_Lang" + (i + 1)]) : aListCategoryLevel1[i].Intro;
aListCategoryLevel1[i].Info = !String.IsNullOrEmpty(context.Request.Form["txtInfo_Lang" + (i + 1)]) ? Convert.ToString(context.Request.Form["txtInfo_Lang" + (i + 1)]) : aListCategoryLevel1[i].Info;
ret = aCategoryLevel1BO.Upd(aListCategoryLevel1);
if (ret == 0)
{
jSonString = "{\"status\":\"error|" + ret.ToString() + "\"}";
break;
}
}
if (ret != 0)
{ jSonString = "{\"status\": \"success\"}"; }
}
}
catch (Exception ex)
{
jSonString = "{\"status\":\"error\" ,\"message\":\"" + ex.Message.ToString() + "\"}";
}
finally
{
context.Response.Write(jSonString);
}
}
public void Sel_ByCode(HttpContext context)
{
String jSonString = "";
string Code = context.Request.QueryString["Code"];
bool Disable = !String.IsNullOrEmpty(context.Request.QueryString["Disable"])
? Convert.ToBoolean(context.Request.QueryString["Disable"])
: false;
CategoryLevel1BO aCategoryLevel1BO = new CategoryLevel1BO();
List<CategoryLevel1> obj = String.IsNullOrEmpty(context.Request.QueryString["Disable"]) ?
aCategoryLevel1BO.Sel_ByCode(Code) : aCategoryLevel1BO.Sel_ByCode(Code, Disable);
if (obj != null)
{
_converter.DateTimeFormat = "dd/MM/yyyy";
jSonString = JsonConvert.SerializeObject(obj, _converter);
}
jSonString = "{\"data\":" + jSonString + "}";
context.Response.Write(jSonString);
}
public void Ins(HttpContext context, int NUM_LANG)
{
ConfigsBO aConfigsBO = new ConfigsBO();
//CodeCategoryLevel1 = Convert.ToString(context.Request.Form["txtCodeCategoryLevel1"]);
String jSonString = "";
try {
List<Contents> aListContents = new List<Contents>();
ContentsBO aContentsBO = new ContentsBO();
Contents aContents = new Contents();
TimeSpan Codespan = new TimeSpan(DateTime.Now.Ticks);
string Code = Math.Floor(Codespan.TotalSeconds).ToString();
for (int i = 1; i <= NUM_LANG; i++) {
aContents = new Contents();
aContents.Code = Code;
aContents.Data = null;
aContents.Type = !String.IsNullOrEmpty(context.Request.Form["cbbType"]) ? Convert.ToInt32(context.Request.Form["cbbType"]) : 0;
aContents.Status = !String.IsNullOrEmpty(context.Request.Form["cbbStatus"]) ? Convert.ToInt32(context.Request.Form["cbbStatus"]) : 0;
aContents.CreatedBy = aCurrentSystemUsers.Username;
aContents.Disable = !String.IsNullOrEmpty(context.Request.Form["cbbDisable"]) ? Convert.ToBoolean(context.Request.Form["cbbDisable"]) : false;
aContents.Tag = !String.IsNullOrEmpty(context.Request.Form["txtTag"]) ? Convert.ToString(context.Request.Form["txtTag"]) : "";
aContents.DateCreated = !String.IsNullOrEmpty(context.Request.Form["txtDateCreated"]) ? DateTime.ParseExact(context.Request.Form["txtDateCreated"], "dd/MM/yyyy", culture) : DateTime.Now;
aContents.DateEdited = !String.IsNullOrEmpty(context.Request.Form["txtDateEdited"]) ? DateTime.ParseExact(context.Request.Form["txtDateEdited"], "dd/MM/yyyy", culture) : DateTime.Now;
aContents.UpdateBy = !String.IsNullOrEmpty(context.Request.Form["txtUpdateBy"]) ? Convert.ToString(context.Request.Form["txtUpdateBy"]) : "";
aContents.PublishDate = !String.IsNullOrEmpty(context.Request.Form["txtPublishDate"]) ? DateTime.ParseExact(context.Request.Form["txtPublishDate"], "dd/MM/yyyy", culture) : DateTime.Now;
aContents.ExpireDate = !String.IsNullOrEmpty(context.Request.Form["txtExpireDate"]) ? DateTime.ParseExact(context.Request.Form["txtExpireDate"], "dd/MM/yyyy", culture) : DateTime.Now;
aContents.IDAlbum = !String.IsNullOrEmpty(context.Request.Form["txtIDAlbum"]) ? Convert.ToInt32(context.Request.Form["txtIDAlbum"]) : 0;
aContents.ViewCount = !String.IsNullOrEmpty(context.Request.Form["txtViewCount"]) ? Convert.ToInt64(context.Request.Form["txtViewCount"]) : 0;
aContents.Image1 = !String.IsNullOrEmpty(context.Request.Form["txtImage_2"]) ? Convert.ToString(context.Request.Form["txtImage_2"]) : "";
aContents.Image2 = !String.IsNullOrEmpty(context.Request.Form["txtImage_3"]) ? Convert.ToString(context.Request.Form["txtImage_3"]) : "";
aContents.Image3 = !String.IsNullOrEmpty(context.Request.Form["txtImage_4"]) ? Convert.ToString(context.Request.Form["txtImage_4"]) : "";
aContents.Title = !String.IsNullOrEmpty(context.Request.Form["txtTitle_Lang" + i]) ? Convert.ToString(context.Request.Form["txtTitle_Lang" + i]) : "";
aContents.Intro = !String.IsNullOrEmpty(context.Request.Form["txtIntro_Lang" + i]) ? Convert.ToString(HttpUtility.HtmlDecode(context.Request.Form["txtIntro_Lang" + i])) : "";
aContents.Info = !String.IsNullOrEmpty(context.Request.Form["txtInfo_Lang" + i]) ? Convert.ToString(HttpUtility.HtmlDecode(context.Request.Form["txtInfo_Lang" + i])) : "";
aContents.ExtendProperties1 = !String.IsNullOrEmpty(context.Request.Form["txtExtendProperties1_Lang" + i]) ? Convert.ToString(context.Request.Form["txtExtendProperties1_Lang" + i]) : "";
aContents.ExtendProperties2 = !String.IsNullOrEmpty(context.Request.Form["txtExtendProperties2_Lang" + i]) ? Convert.ToString(context.Request.Form["txtExtendProperties2_Lang" + i]) : "";
aContents.ExtendProperties3 = !String.IsNullOrEmpty(context.Request.Form["txtExtendProperties3_Lang" + i]) ? Convert.ToString(context.Request.Form["txtExtendProperties3_Lang" + i]) : "";
aContents.Image = !String.IsNullOrEmpty(context.Request.Form["txtImage_1"]) ? Convert.ToString(context.Request.Form["txtImage_1"]) : "";
aContents.IDLang = !String.IsNullOrEmpty(context.Request.Form["IDLang_" + i]) ? Convert.ToInt32(context.Request.Form["IDLang_" + i]) : 0;
aListContents.Add(aContents);
}
int Ret1 = -1;
Ret1 = aContentsBO.Ins(ref aListContents);
if (Ret1 < aListContents.Count) {
jSonString = "{\"status\":\"error\" ,\"message\":\"" + Ret1.ToString() + "\"}";
aContentsBO.Del(aListContents);
return;
}
else {
string ListTempt = !String.IsNullOrEmpty(context.Request.Form["ckbCodeCategoryLevel1[]"]) ? Convert.ToString(context.Request.Form["ckbCodeCategoryLevel1[]"]) : "";
if (string.IsNullOrEmpty(ListTempt) == true) {
CategoryLevel1BO aCategoryLevel1BO = new CategoryLevel1BO();
List<CategoryLevel1> aListItem = aCategoryLevel1BO.Sel_ByCode("000");
if (aListItem.Count > 0) {
ListTempt = aListItem[0].Code;
}
else {
this.CreateCategoryLevel1Default(context, "[Default]", NUM_LANG);
ListTempt = "000";
}
}
//else if (string.IsNullOrEmpty(ListTempt) == false)
//{
List<string> ListCodeCategoryLevel1 = ListTempt.Split(',').ToList();
List<Contents_CategoryLevel1> aListContents_CategoryLevel1 = new List<Contents_CategoryLevel1>();
Contents_CategoryLevel1 aContents_CategoryLevel1 = new Contents_CategoryLevel1();
for (int ii = 0; ii < aListContents.Count; ii++) {
for (int iii = 0; iii < ListCodeCategoryLevel1.Count; iii++) {
aContents_CategoryLevel1 = new Contents_CategoryLevel1();
aContents_CategoryLevel1.CodeCategoryLevel1 = ListCodeCategoryLevel1[iii].ToString();
aContents_CategoryLevel1.CodeContents = aListContents[ii].Code.ToString();
aContents_CategoryLevel1.Disable = aListContents[ii].Disable;
aContents_CategoryLevel1.IDLang = aListContents[ii].IDLang;
aContents_CategoryLevel1.Status = aListContents[ii].Status;
aContents_CategoryLevel1.Type = aListContents[ii].Type;
aListContents_CategoryLevel1.Add(aContents_CategoryLevel1);
}
}
Contents_CategoryLevel1BO aContents_CategoryLevel1BO = new Contents_CategoryLevel1BO();
int Ret2 = -1;
Ret2 = aContents_CategoryLevel1BO.Ins(ref aListContents_CategoryLevel1);
if (Ret2 < aListContents_CategoryLevel1.Count) {
aContents_CategoryLevel1BO.Del(aListContents_CategoryLevel1);
aContentsBO.Del(aListContents);
jSonString = "{\"status\":\"error\" ,\"message\":\"" + Ret2.ToString() + "\"}";
return;
}
//}
}
jSonString = "{\"status\": \"success\"}";
}
catch (Exception ex) {
jSonString = "{\"status\":\"error\" ,\"message\":\"" + ex.Message.ToString() + "\"}";
}
finally {
context.Response.Write(jSonString);
}
}
