public static bool CreateUploadRecord(User user, DateTime reqDate, string reqType, string fileName) { // uniquekey, preqdate, customer, partner, preqtype, preqaction, pfilename, pcustomfile, presultfile, presultdate, processed DBConnect connection = new DBConnect(); bool success = false; try { connection.Connect(ConnectionsMgr.GetOCConnInfo(user, _Database.Home)); var insertVals = new Dictionary <string, string>() { { _Column.UniqueKey, connection.GetNewKey() }, { _Column.PReqDate, reqDate.ToString("yyyy-MM-dd HH:mm:ss") }, { _Column.Customer, user.Customer.SQLEscape() }, { _Column.PReqType, reqType.SQLEscape() }, { _Column.PFileName, fileName.SQLEscape() }, { _Column.PCustomFile, "1" }, { _Column.Partner, user.ActivePartner.SQLEscape() } }; using (var res = connection.Insert(_Table.ProcessQ, insertVals.ToNameValueCollection())) { success = res.AffectedRows != 0; } connection.Close(); return(success); } catch (Exception e) { ProgramLog.LogError(user, "ProcessQueue", "CreateUploadRecord", e.Message); return(false); } }
public static Dictionary <string, string> GetReqTypeDict(User user) { Dictionary <string, string> ret = new Dictionary <string, string>(); DBConnect connection = new DBConnect(); try { connection.Connect(ConnectionsMgr.GetAdminConnInfo()); using (var query = connection.Select(new[] { _Column.TrxType, _Column.TrxDesc }, _Table.TrxInfo)) { while (query.Read()) { ret.Add(query.Field(0), query.Field(1)); } } connection.Close(); ret.Add("832_A", "Item Attributes"); ret.Add("850_X", "PO Store X-Ref"); ret.Add("856_X", "ASN Release X-Ref"); ret.Add("832_P", "Al Tayer Item Attributes"); return(ret); } catch (Exception e) { ProgramLog.LogError(user, "ProcessQueue", "GetReqTypeDict", e.Message); connection.Close(); return(new Dictionary <string, string>()); } }
public static List <ProcessRecord> GetPreviousRecords(User user) { List <ProcessRecord> listRecord = new List <ProcessRecord>(); DBConnect connection = new DBConnect(); try { var filter = string.Format("WHERE {0}='{1}' AND {2}='{3}' AND {4}>'{5}'", _Column.Customer, user.Customer.SQLEscape(), _Column.Partner, user.ActivePartner.SQLEscape(), _Column.PReqDate, DateTime.Now.Subtract(new TimeSpan(30, 0, 0, 0)).ToString("yyyy-MM-dd HH:mm:ss")); connection.Connect(ConnectionsMgr.GetOCConnInfo(user, _Database.Home)); using (var query = connection.Select(new[] { _Column.PReqDate, _Column.PReqType, _Column.Processed }, _Table.ProcessQ, filter)) { while (query.Read()) { ProcessRecord pr = new ProcessRecord(); pr.Date = query.Field(0, ""); pr.Type = query.Field(1, ""); pr.Status = query.Field(2, ""); listRecord.Add(pr); } } connection.Close(); return(listRecord); } catch (Exception e) { ProgramLog.LogError(user, "ProcessQueue", "GetPreviousRecords", e.Message); connection.Close(); return(new List <ProcessRecord>()); } }
public static Dictionary <string, string> GetAllowedApps(User user) { DBConnect connection = new DBConnect(); try { connection.Connect(ConnectionsMgr.GetOCConnInfo(user, _Database.Home)); Dictionary <string, string> ret = new Dictionary <string, string>(); using (var queryUserLevelAP = connection.Select(appFlags, _Table.UserInfo, string.Format("WHERE {0}='{1}' AND {2}='{3}' AND {4}='{5}'", _Column.Customer, user.Customer.SQLEscape(), _Column.Partner, user.ActivePartner.SQLEscape(), _Column.UserName, user.UserName.SQLEscape()))) { while (queryUserLevelAP.Read()) { for (int i = 0; i < appFlags.Length; i++) { string f = queryUserLevelAP.Field(i); if (f == "1") { string name = columnToDetail[appFlags[i]].appName; string url = columnToDetail[appFlags[i]].appURL; if (!ret.ContainsKey(name)) { ret.Add(name, url); } } } } if (ret.Count > 0) { return(ret); } } using (var queryCustPartAP = connection.Select(appFlags, _Table.NetGroup, string.Format("WHERE {0}='{1}' AND {2}='{3}'", _Column.Customer, user.Customer.SQLEscape(), _Column.Partner, user.ActivePartner.SQLEscape()))) { while (queryCustPartAP.Read()) { for (int i = 0; i < appFlags.Length; i++) { string f = queryCustPartAP.Field(i); if (f == "1") { string name = columnToDetail[appFlags[i]].appName; string url = columnToDetail[appFlags[i]].appURL; if (!ret.ContainsKey(name)) { ret.Add(name, url); } } } } return(ret); } } catch (Exception e) { ProgramLog.LogError(user, nameof(AppManagement), nameof(GetAllowedApps), e.Message); return(new Dictionary <string, string>()); } }
private static string _GetElemDesc(User user, string usEleNum, string usCode) { DBConnect connect = new DBConnect(); try { connect.Connect(ConnectionsMgr.GetAdminConnInfo()); var queryCodes = connect.Select(_Column.CodeDesc, _Table.DisaCode, string.Format("WHERE {0}='{1}' AND {2}='{3}'", _Column.EleNum, usEleNum.SQLEscape(), _Column.Code, usCode.SQLEscape())); if (queryCodes.Read()) { return(queryCodes.Field(0)); } else { return(""); } } catch (Exception e) { ProgramLog.LogError(user, "ElementLookup", "_GetElemDesc", e.Message); return(""); } }
public static bool IsAllowed(User user, AppID app) { try { if (user == null || app == AppID.None) { return(false); } var connection = ConnectionsMgr.GetOCConnection(user); using (var queryUserLevelAP = connection.Select(idToColumn[app], _Table.UserInfo, string.Format("WHERE {0}='{1}' AND {2}='{3}' AND {4}='{5}'", _Column.Customer, user.Customer.SQLEscape(), _Column.Partner, user.ActivePartner.SQLEscape(), _Column.UserName, user.UserName.SQLEscape()))) { if (queryUserLevelAP.AffectedRows != 0) { queryUserLevelAP.Read(); return(queryUserLevelAP.Field(0) != "0"); } } using (var queryCustPartAP = connection.Select(idToColumn[app], _Table.NetGroup, string.Format("WHERE {0}='{1}' AND {2}='{3}'", _Column.Customer, user.Customer.SQLEscape(), _Column.Partner, user.ActivePartner.SQLEscape()))) { if (queryCustPartAP.AffectedRows == 0) { ProgramLog.LogError(user, nameof(AppManagement), nameof(IsAllowed), string.Format("Error: No information found for customer {0} and partner {1}.", user.Customer, user.ActivePartner)); return(false); } queryCustPartAP.Read(); return(queryCustPartAP.Field(0) != "0"); } } catch (Exception e) { ProgramLog.LogError(user, nameof(AppManagement), nameof(IsAllowed), e.Message); return(false); } }