// 1
public int Ins(ExtendProperties aExtendProperties)
{
try
{
aDatabaseDA.ExtendProperties.AddOrUpdate(aExtendProperties);
return(aDatabaseDA.SaveChanges());
}
catch (Exception ex)
{
throw new Exception(String.Format("ExtendPropertiesBO.Ins: {0}", ex.Message));
}
}
public ExtendProperties Sel_ByID(Int32 ID)
{
try
{
ExtendProperties aExtendProperties = aDatabaseDA.ExtendProperties.Where(b => b.ID == ID).ToList()[0];
return(aExtendProperties);
}
catch (Exception ex)
{
throw new Exception(String.Format("ExtendPropertiesBO.Sel: {0}", ex.Message));
}
}
public void SetValue(ExtendProperties aExtendProperties)
{
this.ID = aExtendProperties.ID;
this.Name = aExtendProperties.Name;
this.Value = aExtendProperties.Value;
this.ValueType = aExtendProperties.ValueType;
this.Image = aExtendProperties.Image;
this.Code = aExtendProperties.Code;
this.IDObject = aExtendProperties.IDObject;
this.ObjectType = aExtendProperties.ObjectType;
this.IDLang = aExtendProperties.IDLang;
this.Type = aExtendProperties.Type;
this.Group = aExtendProperties.Group;
this.Status = aExtendProperties.Status;
this.CodeObject = aExtendProperties.CodeObject;
this.Disable = aExtendProperties.Disable;
}
private bool CheckReferenceData(long tableId, string tableName, string schema, List <Column> columns)
{
// If table is deference data
// For check reference data
bool existAddOrUpdate = false;
if (ExtendProperties.Any(x =>
x.major_id == tableId && x.name.Equals("ReferenceData", StringComparison.OrdinalIgnoreCase) &&
x.value.Equals("Enum", StringComparison.OrdinalIgnoreCase)))
{
var data = SqlService.LoadData(CurrentSqlConnection, tableName, $"SELECT * FROM [{schema}].[{tableName}]");
if (data.Rows.Count > 0)
{
var tableElement = new XElement("Table");
var dataElement = new XElement("Data");
tableElement.SetAttributeValue("Name", tableName);
if (schema.ToLower() != "dbo")
{
tableElement.SetAttributeValue("Schema", schema);
}
foreach (var rowData in data.Rows.Cast <DataRow>())
{
var rowElement = new XElement("Row");
foreach (var column in data.Columns.Cast <DataColumn>().OrderBy(x => x.ColumnName))
{
if (column.ColumnName.Equals("ID", StringComparison.OrdinalIgnoreCase) ||
rowData[column.ColumnName] == System.DBNull.Value)
{
continue;
}
existAddOrUpdate = true;
rowElement.SetAttributeValue(XmlConvert.EncodeName(column.ColumnName) ?? column.ColumnName, rowData[column.ColumnName].ToString());
}
existAddOrUpdate = true;
dataElement.Add(rowElement);
}
var columnType = GetColumnTypes(columns);
dataElement.AddFirst(columnType);
tableElement.Add(dataElement);
RootDatabase.Add(tableElement);
}
}
return(existAddOrUpdate);
}
public void Sel_ByID(HttpContext context)
{
String jSonString = "";
int IDExtendProperties = int.Parse(context.Request.QueryString["IDExtendProperties"]);
ExtendPropertiesBO aExtendPropertiesBO = new ExtendPropertiesBO();
ExtendProperties obj = aExtendPropertiesBO.Sel_ByID(IDExtendProperties);
//obj.Info = HttpUtility.HtmlDecode(obj.Info);
//obj.Intro = HttpUtility.HtmlDecode(obj.Intro);
if (obj != null)
{
_converter.DateTimeFormat = "dd/MM/yyyy";
jSonString = JsonConvert.SerializeObject(obj, _converter);
}
jSonString = "{\"data\":" + jSonString + "}";
context.Response.Write(jSonString);
}
public ExtendProperties ConvertToExtendProperties()
{
ExtendProperties aExtendProperties = new ExtendProperties();
aExtendProperties.ID = this.ID;
aExtendProperties.Name = this.Name;
aExtendProperties.Value = this.Value;;
aExtendProperties.ValueType = this.ValueType;
aExtendProperties.Image = this.Image;
aExtendProperties.Code = this.Code;
aExtendProperties.IDObject = this.IDObject;
aExtendProperties.ObjectType = this.ObjectType;
aExtendProperties.IDLang = this.IDLang;
aExtendProperties.Type = this.Type;
aExtendProperties.Group = this.Group;
aExtendProperties.Status = this.Status;
aExtendProperties.CodeObject = this.CodeObject;
aExtendProperties.Disable = this.Disable;
return(aExtendProperties);
}
public void Ins(HttpContext context, int NUM_LANG)
{
ConfigsBO aConfigsBO = new ConfigsBO();
//CodeCategoryLevel1 = Convert.ToString(context.Request.Form["txtCodeCategoryLevel1"]);
String jSonString = "";
try
{
List <ExtendProperties> aListExtendProperties = new List <ExtendProperties>();
ExtendPropertiesBO aExtendPropertiesBO = new ExtendPropertiesBO();
ExtendProperties aExtendProperties = new ExtendProperties();
TimeSpan Codespan = new TimeSpan(DateTime.Now.Ticks);
string Code = Math.Floor(Codespan.TotalSeconds).ToString();
for (int i = 1; i <= NUM_LANG; i++)
{
aExtendProperties = new ExtendProperties();
aExtendProperties.Code = Code;
//aContents.Data = null;
aExtendProperties.Name = !String.IsNullOrEmpty(context.Request.Form["txtName"]) ? Convert.ToString(context.Request.Form["txtName"]) : "";
aExtendProperties.Value = !String.IsNullOrEmpty(context.Request.Form["txtValue"]) ? Convert.ToString(context.Request.Form["txtValue"]) : "";
aExtendProperties.ValueType = !String.IsNullOrEmpty(context.Request.Form["cbbValueType"]) ? Convert.ToInt32(context.Request.Form["cbbValueType"]) : 0;
aExtendProperties.Image = !String.IsNullOrEmpty(context.Request.Form["txtImage"]) ? Convert.ToString(context.Request.Form["txtImage"]) : "";
aExtendProperties.Code = Code;
aExtendProperties.IDObject = !String.IsNullOrEmpty(context.Request.Form["cbbIDObject"]) ? Convert.ToInt32(context.Request.Form["cbbIDObject"]) : 0;
aExtendProperties.ObjectType = !String.IsNullOrEmpty(context.Request.Form["cbbObjectType"]) ? Convert.ToInt32(context.Request.Form["cbbObjectType"]) : 0;
aExtendProperties.IDLang = !String.IsNullOrEmpty(context.Request.Form["IDLang_" + i]) ? Convert.ToInt32(context.Request.Form["IDLang_" + i]) : 0;
aExtendProperties.Type = !String.IsNullOrEmpty(context.Request.Form["cbbType"]) ? Convert.ToInt32(context.Request.Form["cbbType"]) : 0;
aExtendProperties.Group = !String.IsNullOrEmpty(context.Request.Form["cbbGroup"]) ? Convert.ToInt32(context.Request.Form["cbbGroup"]) : 0;
aExtendProperties.Status = !String.IsNullOrEmpty(context.Request.Form["cbbStatus"]) ? Convert.ToInt32(context.Request.Form["cbbStatus"]) : 0;
aExtendProperties.CodeObject = !String.IsNullOrEmpty(context.Request.Form["cbbCodeObject"]) ? Convert.ToInt32(context.Request.Form["cbbCodeObject"]) : 0;
//aContents.CreatedBy = aCurrentSystemUsers.Username;
aExtendProperties.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.FormCodeObjecttxtDateCreated"]) ? 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;
aExtendProperties.Image = !String.IsNullOrEmpty(context.Request.Form["txtImage"]) ? Convert.ToString(context.Request.Form["txtImage"]) : "";
//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"]) : "";
aListExtendProperties.Add(aExtendProperties);
}
int Ret1 = -1;
Ret1 = aExtendPropertiesBO.Ins(ref aListExtendProperties);
//if (Ret1 < aListExtendProperties.Count)
//{
// jSonString = "{\"status\":\"error\" ,\"message\":\"" + Ret1.ToString() + "\"}";
// aExtendPropertiesBO.Del(aListExtendProperties);
// 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);
}
}
