public object UpdateThongDiep(Models.ThongDiepCEO data)
{
int status = 0;
string Id = "";
int id_group = 0;
string Token = "";
SqlConditions Conds = new SqlConditions();
DataTable dt = new DataTable();
DataRow[] dr;
bool Visible = true;
List <object> rs = new List <object>();
string title = "", link = "";
Hashtable val = new Hashtable();
Hashtable val_member = new Hashtable();
DataTable dt_token = new DataTable();
DataTable lastid = new DataTable();
string sqlq = "";
try
{
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
val.Add("TIEUDE", data.title);
val.Add("NOIDUNG", data.noidung);
Conds.Add("ID_THONGDIEP", data.id_thongdiep);
if (cnn.Update(val, Conds, "TBL_THONGDIEPCEO") < 0)
{
return(JsonResultCommon.ThatBai("Cập nhật thất bại", cnn.LastError));
}
}
return(JsonResultCommon.ThanhCong());
}
catch (Exception ex)
{
return(JsonResultCommon.Exception(ex));
}
}
public object addThongDiep(Models.ThongDiepCEO data)
{
int status = 0;
string Id = "";
int id_group = 0;
string Token = "";
SqlConditions Conds = new SqlConditions();
DataTable dt = new DataTable();
DataRow[] dr;
string Idtb = "";
int id_thongd;
DataRow[] dr_tb;
DataTable lastidTD = new DataTable();
bool Visible = true;
List <object> rs = new List <object>();
string title = "", link = "";
Hashtable val = new Hashtable();
Hashtable val_member = new Hashtable();
DataTable dt_token = new DataTable();
DataTable lastid = new DataTable();
string sqlq = "";
try
{
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
val.Add("TIEUDE", data.title);
val.Add("COL_DISABLE", false);
val.Add("NOIDUNG", data.noidung);
val.Add("CreatedBy", data.create_by);
val.Add("CreatedDate", DateTime.Now.ToString("MM/dd/yyyy HH:mm"));
if (cnn.Insert(val, "TBL_THONGDIEPCEO") < 0)
{
return(JsonResultCommon.ThatBai("Cập nhật thất bại", cnn.LastError));
}
dt = cnn.CreateDataTable(@"select * from TBL_THONGDIEPCEO as td ,TBL_USER as u where u.ID_USER=td.CreatedBy", Conds);
lastidTD = cnn.CreateDataTable(@"SELECT Max(ID_THONGDIEP) as asLastTB FROM TBL_THONGDIEPCEO");
dr_tb = lastidTD.Select();
Idtb = lastidTD.Rows[0]["asLastTB"].ToString();
id_thongd = Int32.Parse(Idtb);
Thread.Sleep(500);
dr = dt.Select();
var dl = from g in dt.AsEnumerable()
where g["ID_THONGDIEP"].Equals(id_thongd)
select new
{
id_thongdiep = g["ID_THONGDIEP"],
title = g["TIEUDE"],
noidung = g["NOIDUNG"],
media = g["TYPEPOST"],
imgmedia = $"{link}/UploadedFiles/{g["TYPEPOST"]}",
//id_user = r["ID_USER"],
ghim = g["COL_DISABLE"],
//user_name = r["UserName"],
create_by = g["CreatedBy"],
createdate = g["CreatedDate"],
hinhanh = g["AVATAR"],
AlowEdit = g["CreatedBy"],
Avatar = $"{link}/Avatar/{ g["AVATAR"]}",
};
return(JsonResultCommon.ThanhCong(dl));
// mangxahoi.PushTChangelThongDiep(dl, null);
}
return(JsonResultCommon.ThanhCong());
}
catch (Exception ex)
{
return(JsonResultCommon.Exception(ex));
}
}
