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)); } }