public static bool NotifInsert(string desc, string from, string[] _to, string link, string toolID) { try { DataTable dt = new DataTable(); dt = ConnectSQL.Execute("SELECT IsNull(MAX(NOTIF_ID),0) FROM NOTIF"); int newID = Convert.ToInt32(ConnectSQL.GetString(dt, 0)); SqlDataAdapter da = ConnectSQL.GatDataAdapter("SELECT TOP 1 * FROM NOTIF"); da.Fill(dt); for (int i = 0; i < _to.Length; i++) { newID++; DataRow dr = dt.NewRow(); dr["NOTIF_ID"] = newID; dr["NOTIF_DESC"] = desc; dr["NOTIF_DATE"] = DateTime.Now; dr["NOTIF_FORM"] = from; dr["NOTIF_TO"] = _to[i]; dr["NOTIF_FLAG"] = "F"; dr["NOTIF_LINK"] = link; dr["TOOL_ID"] = toolID; dt.Rows.Add(dr); } da.Update(dt); return(true); } catch (Exception ex) { return(false); // ex.Message; } }
public static string checkUsersALL() { DataTable dataTable = ConnectSQL.Execute("SELECT AD_USER_ID, EMP_ID, EMP_FNAME, EMP_LNAME FROM PORTAL_PROD.dbo.MV_ALL_USER WHERE AD_USER_ID IS NOT NULL"); //Convert DataTable to Json string jsonMessage = JsonConvert.SerializeObject(dataTable); return(jsonMessage); }
public static List <UserProfileFromSQl> SetProfile(string user) { DataTable dataTable = ConnectSQL.Execute("SELECT distinct ORG_ID,EMP_ID,EMP_FNAME,EMP_LNAME,POS_ID,ROLE_ID,IsNull(E_MAIL,'') AS E_MAIL,IsNull(EMP_NICKNAME,'') AS EMP_NICKNAME FROM PORTAL_PROD.dbo.MV_ALL_USER WHERE AD_USER_ID = '" + user + "'"); return(ConvertDataTable <UserProfileFromSQl> (dataTable)); }