public bool LogImport(long idUser, string text = "")
{
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
DataTable dt = cnn.CreateDataTable("select * from Tbl_Log_Loai where IdRow=" + Loai);
if (dt == null || dt.Rows.Count == 0)
{
Error = "Loại đối tượng không đúng";
return(false);
}
string ip = _accessor.HttpContext.Connection.RemoteIpAddress.ToString();
Hashtable val = new Hashtable();
val.Add("IdLoaiLog", Loai);
val.Add("IdHanhDong", 7);
val.Add("IP", ip);
val.Add("NoiDung", "Import danh sách " + dt.Rows[0]["LoaiLog"].ToString().ToLower() + " " + text);
val.Add("CreatedBy", idUser);
val.Add("CreatedDate", DateTime.Now);
int kq = cnn.Insert(val, "Tbl_Log");
cnn.Disconnect();
if (kq == 1)
{
return(true);
}
else
{
return(false);
}
}
}
/// <summary>
///
/// </summary>
/// <param name="type">1: Update, 2: Check, 3: Get</param>
/// <param name="request">reqtest json khi bắn API</param>
/// <param name="response">response json khi API trả về</param>
/// <param name="ErrorCode">ErrorCode</param>
/// <param name="ErrorMessage">ErrorMessage</param>
/// <returns></returns>
public bool LogJeedocs(int type, string request, string response, string ProcessCode, string ProcessMessage, int idUser, bool Success)
{
try
{
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
Hashtable val = new Hashtable();
//val.Add("type", Loai);
val.Add("ProcessCode", ProcessCode);
val.Add("ProcessMessage", ProcessMessage);
val.Add("ResponseJson", response);
val.Add("Request", request);
val.Add("Type", type);
val.Add("Success", Success);
val.Add("CreatedBy", idUser);
val.Add("CreatedDate", DateTime.Now);
int kq = cnn.Insert(val, "Tbl_JeeDocs_Log");
cnn.Disconnect();
if (kq == 1)
{
return(true);
}
else
{
return(false);
}
}
}
catch (Exception ex)
{ return(false); }
}
/// <summary>
/// Lưu lịch sử Tbl_LichSu
/// </summary>
/// <param name="Loai">1: văn bản đến, 2: văn bản đi, 3: hồ sơ, 4: công việc</param>
/// <param name="hanhDong"></param>
/// <param name="idUser"></param>
/// <param name="noidung"></param>
/// <param name="idDoituong"></param>
/// <param name="cnn"></param>
/// <param name="IdProcess"></param>
/// <param name="LSDetails">IdRow của bảng bị tác động</param>
/// <returns></returns>
public static long LuuLichSu(int Loai, string hanhDong, long idUser, string noidung, bool email, bool sms, long idDoituong, DpsConnection cnn, long IdProcess = 0, bool traLoi = false)
{
Hashtable val = new Hashtable();
val.Add("Loai", Loai);
val.Add("HanhDong", hanhDong);
val.Add("NoiDung", string.IsNullOrEmpty(noidung) ? "" : noidung);
val.Add("Email", email);
val.Add("SMS", sms);
val.Add("YeuCauTraLoi", traLoi);
val.Add("Id", idDoituong);
val.Add("CreatedBy", idUser);
val.Add("CreatedDate", DateTime.Now);
if (IdProcess > 0)
{
val.Add("IdProcess", IdProcess);
}
int kq = cnn.Insert(val, "Tbl_LichSu");
if (kq == 1)
{
var id = cnn.ExecuteScalar("select IDENT_CURRENT ('Tbl_LichSu')");
return(long.Parse(id.ToString()));
}
else
{
return(0);
}
}
public object Create_TrangCanNhan()
{
{
SqlConditions Conds = new SqlConditions();
DataTable dt = new DataTable();
DataRow[] dr;
DataTable dt_tb = new DataTable();
Hashtable val = new Hashtable();
DataTable dt_token = new DataTable();
string tam = "";
int id_user = 0;
try
{
//Conds.Add("email", Email);
//Conds.Add("password", Pass);
//val.Add("ID_COMMENT", data.id_cmt);
// val.Add("ID_BAIDANG", data.ID_BaiDang);
//Conds.Add("ID_USER", data.ID_User);
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
dt_tb = cnn.CreateDataTable(@"SELECT Max(ID_USER) as asLastID FROM TBL_Account");
dr = dt_tb.Select();
tam = dt_tb.Rows[0]["asLastID"].ToString();
id_user = Int32.Parse(tam);
Thread.Sleep(500);
val.Add("ID_USER", id_user);
if (cnn.Insert(val, "TBL_TRANGCANHAN") < 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 addTBLGhim(int id_user, int id_thongdiep)
{
{
int status = 0;
SqlConditions Conds = new SqlConditions();
DataTable dt = new DataTable();
DataRow[] dr;
Hashtable val = new Hashtable();
Hashtable val2 = new Hashtable();
DataTable dt_token = new DataTable();
try
{
//Conds.Add("email", Email);
//Conds.Add("password", Pass);
//val.Add("ID_COMMENT", data.id_cmt);
//val.Add("ID_BAIDANG", data.ID_BaiDang);
val.Add("ID_THONGDIEP", id_thongdiep);
val.Add("ID_USER", id_user);
//Conds.Add("ID_USER", id_user);
Conds.Add("ID_THONGDIEP", id_thongdiep);
//Conds.Add("ID_USER", data.ID_User);
using (DpsConnection cnn = new DpsConnection("ConnectSQLMXH", true))
{
// dt = cnn.CreateDataTable(@"SELECT COL_DISABLE FROM TBL_THONGDIEPCEO as g where g.ID_THONGDIEP="+id_thongdiep, Conds);
// dr = dt.Select();
// var total = dt.Rows.Count;
if (cnn.Insert(val, "TBL_GHIM") < 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 UpdateQuyenLoaiBaiDang(int loai)
{
{
string Token = lc.GetHeader(Request);
LoginData loginData = lc._GetInfoUser(Token);
if (loginData == null)
{
return(JsonResultCommon.DangNhap());
}
int status = 0;
string Id = "";
SqlConditions Conds = new SqlConditions();
DataTable dt = new DataTable();
DataRow[] dr;
bool Visible = true;
Hashtable val = new Hashtable();
List <object> rs = new List <object>();
string title = "", link = "";
DataTable dt_token = new DataTable();
try
{
//Conds.Add("password", Pass);
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
val.Add("ID_LOAIBAIDANG", loai);
val.Add("ID_USER", loginData.Id);
if (cnn.Insert(val, "TBL_NHOM_QUYEN_LOAIBAIDANG") < 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 Task OnConnectedTokenAsync(string infoToken)
{
try
{
var id = Context.ConnectionId;
TokenRequesModel infoDataCon = JsonConvert.DeserializeObject <TokenRequesModel>(infoToken);
string Token = infoDataCon.Token;
string idUser = infoDataCon.UserID.ToString();
string clientId = Context.ConnectionId;
if (!ConnectedClients.Keys.Contains(Token))
{
ConnectedClients.Add(Token, clientId);
}
else
{
ConnectedClients[Token] = clientId;
}
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
Hashtable has = new Hashtable();
has.Add("Token", Token);
has.Add("TimeConnect", DateTime.Now);
has.Add("TimeTokenConnect", DateTime.Now);
has.Add("ConnectionId", clientId);
string sql_ = @" IF EXISTS (SELECT * FROM SignalR_Connect c WHERE c.Token=@Token)
BEGIN
DELETE SignalR_Connect WHERE Token =@Token
END " ;
cnn.ExecuteNonQuery(sql_, new SqlConditions {
{ "Token", Token }
});
if (cnn.Insert(has, "SignalR_Connect") == 1)
{
}
}
}catch (Exception ex)
{
return(base.OnDisconnectedAsync(ex));
}
return(base.OnConnectedAsync());
}
public object addFlow(int id_canhan)
{
string Token = lc.GetHeader(Request);
LoginData loginData = lc._GetInfoUser(Token);
if (loginData == null)
{
return(JsonResultCommon.DangNhap());
}
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();
DataTable dt_token = new DataTable();
try
{
val.Add("ID_CANHAN", id_canhan);
val.Add("USER_Flow", loginData.Id);
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
if (cnn.Insert(val, "TBL_Flow") < 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 addUserGroup(int id_group, int id_user, Models.Group.User_Group data)
{
string sqlq = "";
SqlConditions Conds = new SqlConditions();
sqlq = "select * from TBL_GROUPMEMBER where ID_USER="******" and ID_GROUP=" + id_group;
bool value = true;
DataRow[] dr;
int re = 0;
int id_gr = 0;
Hashtable val_member = new Hashtable();
string Id = "";
DataTable lastid = new DataTable();
Hashtable val = new Hashtable();
try
{
//string Token = Request.Headers.GetValues("Token").FirstOrDefault();
//LoginData loginData = API_KD.Assets.Common.GetUserByToken(Token);
//if (loginData == null)
// return JsonResultCommon.DangNhap();
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
Thread.Sleep(500);
DataTable dt = cnn.CreateDataTable(sqlq);
if (cnn.LastError != null || dt == null)
{
return(JsonResultCommon.Exception(cnn.LastError));
}
if (dt.Rows.Count == 0 && id_group != 0)
{
val.Add("ID_GROUP", data.Id_Group);
val.Add("CREATE_DATE", DateTime.Now.ToString("MM/dd/yyyy HH:mm"));
val.Add("ID_USER", id_user);
val.Add("QUYEN_ADMIN", data.quyen_group);
re = cnn.Insert(val, "TBL_GROUPMEMBER");
}
else if (data.Id_Group == 0 || id_group == 0)
{
lastid = cnn.CreateDataTable(@"
SELECT TOP 1 ID_GROUP asLastID FROM TBL_GROUP ORDER BY ID_GROUP DESC");
dr = lastid.Select();
foreach (DataRow r in dr[0].Table.Rows)
{
Id = r["asLastID"].ToString();
}
id_gr = Int32.Parse(Id);
val_member.Add("ID_GROUP", id_gr);
val_member.Add("CREATE_DATE", DateTime.Now.ToString("MM/dd/yyyy HH:mm"));
val_member.Add("ID_USER", id_user);
val_member.Add("QUYEN_ADMIN", 1);
if (cnn.Insert(val_member, "TBL_GROUPMEMBER") < 0)
{
return(JsonResultCommon.ThatBai("Cập nhật thất bại", cnn.LastError));
}
}
else
{
return(JsonResultCommon.ThatBai("Thành viên đã tồn tại !", cnn.LastError));
}
return(JsonResultCommon.ThanhCong());
}
}
catch (Exception ex)
{
return(JsonResultCommon.Exception(ex));
}
}
public object UpdateQuyenLoaiBaiDang_Default()
{
{
int status = 0;
string Id = "";
string Token = "";
SqlConditions Conds = new SqlConditions();
DataTable dt = new DataTable();
DataRow[] dr;
int id_user;
DataTable lastid = new DataTable();
bool Visible = true;
Hashtable val = new Hashtable();
Hashtable val2 = new Hashtable();
List <object> rs = new List <object>();
string title = "", link = "";
DataTable dt_token = new DataTable();
try
{
//Conds.Add("password", Pass);
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
Thread.Sleep(500);
lastid = cnn.CreateDataTable(@"
SELECT Max(ID_USER) as asLastID FROM TBL_USER");
dr = lastid.Select();
Id = lastid.Rows[0]["asLastID"].ToString();
id_user = Int32.Parse(Id);
val.Add("ID_LOAIBAIDANG", 6);
//val.Add("ID_LOAIBAIDANG", 1);
val.Add("ID_USER", id_user);
if (cnn.Insert(val, "TBL_NHOM_QUYEN_LOAIBAIDANG") < 0)
{
return(JsonResultCommon.ThatBai("Cập nhật thất bại", cnn.LastError));
}
val2.Add("ID_LOAIBAIDANG", 1);
//val.Add("ID_LOAIBAIDANG", 1);
val2.Add("ID_USER", id_user);
if (cnn.Insert(val2, "TBL_NHOM_QUYEN_LOAIBAIDANG") < 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 addGroup(Models.Group.Group data)
{
string Token = lc.GetHeader(Request);
LoginData loginData = lc._GetInfoUser(Token);
if (loginData == null)
{
return(JsonResultCommon.DangNhap());
}
int status = 0;
string Id = "";
int id_group = 0;
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
{
val.Add("TEN_GROUP", data.ten_group);
val.Add("CREATE_DATE", DateTime.Now.ToString("MM/dd/yyyy HH:mm"));
val.Add("CREATE_BY", loginData.Id);
val.Add("UPDATE_DATE", DateTime.Now.ToString("MM/dd/yyyy HH:mm"));
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
sqlq = "select TEN_GROUP from TBL_GROUP where TEN_GROUP='" + data.ten_group + "'";
dt = cnn.CreateDataTable(sqlq);
if (dt.Rows.Count == 0)
{
if (cnn.Insert(val, "TBL_GROUP") < 0)
{
return(JsonResultCommon.ThatBai("Cập nhật thất bại", cnn.LastError));
}
}
else
{
return(JsonResultCommon.ThatBai("Tên Nhóm Đã Tồn Tại", cnn.LastError));
}
lastid = cnn.CreateDataTable(@"
SELECT TOP 1 ID_GROUP asLastID FROM TBL_GROUP ORDER BY ID_GROUP DESC");
dr = lastid.Select();
foreach (DataRow r in dr[0].Table.Rows)
{
Id = r["asLastID"].ToString();
}
id_group = Int32.Parse(Id);
val_member.Add("ID_GROUP", id_group);
val_member.Add("CREATE_DATE", DateTime.Now.ToString("MM/dd/yyyy HH:mm"));
val_member.Add("ID_USER", loginData.Id);
val_member.Add("QUYEN_ADMIN", 1);
if (cnn.Insert(val_member, "TBL_GROUPMEMBER") < 0)
{
return(JsonResultCommon.ThatBai("Cập nhật thất bại", cnn.LastError));
}
}
return(JsonResultCommon.ThanhCong(id_group));
}
catch (Exception ex)
{
return(JsonResultCommon.Exception(ex));
}
}
/// <summary>
/// Tạo tiến trình và xác định checkers đầu tiên<para/>
/// </summary>
/// <returns></returns>
public bool Begin()
{
string check = "select * from DP_Process where IdDoiTuong=19 and Id=" + Id;
DataTable dtCheck = cnn.CreateDataTable(check);
if (dtCheck.Rows.Count > 0)
{
Error = "Quy trình cho phản ánh đã được thiết lập";
return(false);
}
string sql = "select * from DP_Action where Disabled=0";
DataTable dt = cnn.CreateDataTable(sql);
if (dt == null || dt.Rows.Count == 0)
{
Error = "Không tìm thấy quy trình";
return(false);
}
Hashtable val;
foreach (DataRow dr in dt.Rows)
{
val = new Hashtable();
val["Id"] = Id;
val["IdStep"] = dr["IdStep"];
val["Next"] = dr["Next"];
val["ButtonText"] = dr["ButtonText"];
val["IsComeBackPro"] = dr["IsComeBack"];
val["IdDoiTuong"] = 19;
cnn.Insert(val, "DP_Process");
}
string lstUser = "";
string str1 = @"SELECT distinct pro.IdRow, pro.IdStep, pro.Next, pro.IsComeBackPro from DP_Process pro
join DP_Step step on pro.IdStep = step.IdRow and step.disabled=0 where step.Loai=0 and Id=" + Id;
DataTable dtProcess = cnn.CreateDataTable(str1);
foreach (DataRow dr in dtProcess.Rows)
{
//Tim Checkers dau tien
List <string> lst = GetCheckers(dr["IdStep"].ToString(), dr["Next"].ToString(), Convert.ToBoolean(dr["IsComeBackPro"]));
if (!string.IsNullOrEmpty(Error))
{
return(false);
}
lstUser = string.Join(",", lst);
foreach (string id in lst)
{
Hashtable val1 = new Hashtable();
val1["IdProcess"] = dr["IdRow"];
val1["Checker"] = id;
cnn.Insert(val1, "DP_Process_Detail");
}
}
if (string.IsNullOrEmpty(lstUser))
{
string str1084 = @" select distinct UserID from Dps_User_GroupUser gu inner join Dps_UserGroupRoles gr on gu.IdGroupUser=gr.IdGroupUser
inner join Dps_Roles on IdRole = gr.IDGroupRole
inner join DPS_User u on u.UserID = gu.IdUser
where IdRole = 1084 and Deleted = 0";
DataTable dtUser1084 = cnn.CreateDataTable(str1084);
var temp = dtUser1084.AsEnumerable().Select(x => x["UserID"].ToString()).ToList();
lstUser = string.Join(",", temp);
}
string msg = "Bạn có một phản ánh góp ý mới cần xử lý.";
return(notify(lstUser, msg));
}
/// <summary>
/// Tiến hành gửi mail
/// </summary>
/// <param name="mailTo"></param>
/// <param name="title"></param>
/// <param name="cc"></param>
/// <param name="contents"></param>
/// <param name="AttacheFiles"></param>
/// <param name="SaveCannotSend"></param>
/// <param name="ErrorMessage"></param>
/// <param name="MInfo"></param>
/// <returns></returns>
public static bool Send(MailAddressCollection mailTo, string title, MailAddressCollection cc, MailAddressCollection bcc, string contents, string[] AttacheFiles, bool SaveCannotSend, out string ErrorMessage, MailInfo MInfo)
{
bool success = true;
ErrorMessage = "";
//Lưu lại email đã gửi
Hashtable val = new Hashtable();
if (MInfo == null || MInfo.Email == "")
{
ErrorMessage = "Không tìm thấy cấu hình mail";
return(false);
}
if (mailTo.Count == 0 && cc.Count == 0 && bcc.Count == 0)
{
ErrorMessage = "Không có người nhận mail";
return(false);
}
val.Add("Loai", MInfo.Loai);
val.Add("Id", MInfo.Id);
val.Add("Title", title);
val.Add("Contents", contents);
val.Add("SendDate", DateTime.Now);
val.Add("SendFrom", MInfo.Email);
MailMessage m = new MailMessage();
string guiden = "", strcc = "", strbcc = "";
for (int i = 0; i < mailTo.Count; i++)
{
m.To.Add(mailTo[i]);
guiden += "," + mailTo[i];
}
m.From = new MailAddress(MInfo.Email);
if (AttacheFiles != null)
{
foreach (var AttacheFile in AttacheFiles)
{
if ((!"".Equals(AttacheFile)) && (File.Exists(AttacheFile)))
{
Attachment att = new Attachment(AttacheFile);
m.Attachments.Add(att);
}
}
}
if (cc != null)
{
for (int i = 0; i < cc.Count; i++)
{
m.CC.Add((MailAddress)cc[i]);
strcc += "," + cc[i];
}
}
if (bcc != null)
{
for (int i = 0; i < bcc.Count; i++)
{
m.Bcc.Add((MailAddress)bcc[i]);
strbcc += "," + bcc[i];
}
}
m.IsBodyHtml = true;
m.Subject = title;
m.Body = contents;
if (!"".Equals(guiden))
{
guiden = guiden.Substring(1);
}
val.Add("MailTo", guiden);
if (!"".Equals(strcc))
{
strcc = strcc.Substring(1);
}
val.Add("CC", strcc);
if (!"".Equals(strbcc))
{
strbcc = strbcc.Substring(1);
}
val.Add("BCC", strbcc);
if ("".Equals(MInfo.Email))
{
ErrorMessage = "Không tìm thấy cấu hình mailserver";
success = false;
}
if (!success)
{
val.Add("Success", success);
val.Add("ErrorMsg", ErrorMessage);
DpsConnection cnn1 = new DpsConnection(MInfo._config.ConnectionString);
cnn1.Insert(val, "Sys_SendMail");
return(false);
}
string str = "";
Task.Factory.StartNew((Action)(() =>
{
SmtpClient s = new SmtpClient(MInfo.SmptClient, MInfo.Port);
s.UseDefaultCredentials = false;
s.EnableSsl = MInfo.EnableSSL;
s.Credentials = new NetworkCredential(MInfo.UserName, MInfo.Password);
s.DeliveryMethod = SmtpDeliveryMethod.Network;
try
{
s.Send(m);
}
catch (Exception ex)
{
str = ex.Message;
success = false;
}
val.Add("Success", success);
val.Add("ErrorMsg", str);
DpsConnection cnn1 = new DpsConnection(MInfo._config.ConnectionString);
cnn1.Insert(val, "Sys_SendMail");
}));
ErrorMessage = str;
return(success);
}
public BaseModel <object> GetCreateUser(Models.User.Account data)
{
{
int status = 0;
string Id = "";
string Token = "";
SqlConditions Conds = new SqlConditions();
DataTable dt = new DataTable();
DataTable dt_user = new DataTable();
DataRow[] dr;
Hashtable val_user = new Hashtable();
Hashtable val = new Hashtable();
bool Visible = true;
List <object> rs = new List <object>();
string title = "", link = "";
string name;
bool check;
DataTable dt_token = new DataTable();
try
{
//Conds.Add("email", Email);
//Conds.Add("password", Pass);
using (DpsConnection cnn = new DpsConnection(_config.ConnectionString))
{
dt_user = cnn.CreateDataTable(@"
select Email from TBL_Account
", Conds);
dr = dt_user.Select();
if (dpsUserMr.ktma(data.email.ToString()) == false)
{
val.Add("IDNV", data.IDNV);
val.Add("Email", data.email);
val.Add("UserName", data.username);
val.Add("Pass", data.pass);
val.Add("TINHTRANG", data.TinhTrang);
}
else
{
val.Add("IDNV", data.IDNV);
val.Add("Email", data.email + "hufi");
val.Add("UserName", data.username);
val.Add("Pass", data.pass);
val.Add("TINHTRANG", data.TinhTrang);
return(JsonResultCommon.Trung("Tài khoản" + data.email));
//val.Add("IDNV", data.IDNV);
//val.Add("Email", data.email);
//val.Add("UserName", data.username);
//val.Add("Pass", data.pass);
//val.Add("TINHTRANG", data.TinhTrang);
}
if (cnn.Insert(val, "TBL_Account") < 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));
}
}
