public static Asset AddCheckinItem(string num, object autocheck = null) { num = ParseBarCode(num); var checkin = HttpContext.Current.Session["CheckIn"] as List <Asset>; var asset = Global.Library.Assets.FindAssetByNumber(num); if (asset.IsOut == false) { return(null); } if (checkin == null) { checkin = new List <Asset>(); } foreach (var a in checkin) { //catch duplicates if (a.AssetNumber == asset.AssetNumber) { return(null); } } checkin.Add(asset); HttpContext.Current.Session["CheckIn"] = checkin; if (autocheck as string == "true") { try { var ud = HttpContext.Current.Session["PersistingUserData"] as Data.UserData; if (ud.IsAutoChecked == false) { ud.IsAutoChecked = true; ud.Log.Add(new Data.LogEntry("AutoCheck Changed:" + autocheck as string)); SettingsDBData db = new SettingsDBData(); db.Appname = ud.Guid; db.XmlData = ud.SerializeToXmlString(ud); Save.Setting(db); } } catch { } } else { try { var ud = HttpContext.Current.Session["PersistingUserData"] as Data.UserData; if (ud.IsAutoChecked == true) { ud.IsAutoChecked = false; ud.Log.Add(new Data.LogEntry("AutoCheck Changed:" + autocheck as string)); SettingsDBData db = new SettingsDBData(); db.Appname = ud.Guid; db.XmlData = ud.SerializeToXmlString(ud); Save.Setting(db); } } catch { } } return(asset); }
public static bool PushSetting(SettingsDBData data) { var connected = Extensions.CheckForInternetConnection(); if (!connected) { return(false); } SQL_Request req = new SQL_Request().OpenConnection(); //barcode was scanned or manually inputted var sql_settings = GetSetting(data.Appname); if (sql_settings == null) { var result = req.SettingsAdd(data.Appname, data.XmlData, data.XmlData2, data.XmlData3, data.XmlData4, data.XmlData5); return(true); } try { var result = req.SettingsUpdate(data.Appname, data.XmlData, data.XmlData2, data.XmlData3, data.XmlData4, data.XmlData5); } catch { return(false); } finally { req.CloseConnection(); } return(true); }
public static bool Setting(SettingsDBData data) { try { return(AssetController.PushSetting(data)); } catch { return(false); } }
public void Save() { SettingsDBData db = new SettingsDBData(); db.Appname = this.Guid; db.XmlData = this.SerializeToXmlString(this); Web_App_Master.Save.Setting(db); }
public static Task <bool> SettingAsync(SettingsDBData data) { return(Task.Run(() => { try { return AssetController.PushSetting(data); } catch { return false; } })); }
public static bool Notification(NotificationSystem.Notice notice) { try { SettingsDBData db = new SettingsDBData(); db.Appname = notice.Guid; db.XmlData = notice.SerializeToXmlString(notice); return(AssetController.PushSetting(db)); } catch { return(false); } }
public static bool NotificationSystem() { try { SettingsDBData db = new SettingsDBData(); db.Appname = Global.NoticeSystem.Guid; db.XmlData = Global.NoticeSystem.SerializeToXmlString(Global.NoticeSystem); return(AssetController.PushSetting(db)); } catch { //Global.NoticeSystem.Notices = new Notification.NotificationSystem.NoticeBindinglist(); return(false); } }
public static Task <bool> NotificationSystemAsync() { return(Task.Run(() => { try { SettingsDBData db = new SettingsDBData(); db.Appname = Global.NoticeSystem.Guid; db.XmlData = Global.NoticeSystem.SerializeToXmlString(Global.NoticeSystem); return AssetController.PushSetting(db); } catch { return false; } })); }
public static bool CustomerData(CustomerData data, string app_name = "AWP_CustomerData_System") { try { SettingsDBData db = new SettingsDBData(); db.Appname = data.Guid; db.XmlData = data.SerializeToXmlString(data); return(AssetController.PushSetting(db)); } catch { //Global.NoticeSystem.Notices = new Notification.NotificationSystem.NoticeBindinglist(); return(false); } }
public static bool Certificates(string app_name = "AWP_Certificate_System") { try { SettingsDBData db = new SettingsDBData(); db.Appname = app_name; db.XmlData = Global.Library.Certificates.SerializeToXmlString(Global.Library.Certificates); return(AssetController.PushSetting(db)); } catch { //Global.NoticeSystem.Notices = new Notification.NotificationSystem.NoticeBindinglist(); return(false); } }
public void SaveToUserPersistantLog() { try { var ud = Session["PersistingUserData"] as Data.UserData; string pdf = Session["CombinedPdf"] as string; Data.Attachment a = new Data.Attachment(); a.Email = ud.Email; a.Name = ud.Name; a.Files.Add(new Data.FileReference(Session["Ordernumber"] as string, pdf)); ud.Attachments.Add(a); ud.Log.Add(new Data.LogEntry("Checked Out Order #" + Session["Ordernumber"] as string, Session["Ordernumber"] as string)); SettingsDBData db = new SettingsDBData(); db.Appname = ud.Guid; db.XmlData = ud.SerializeToXmlString(ud); Save.Setting(db); } catch { } }
public static bool SetAutoCheck(string autocheck) { if (autocheck as string == "true") { try { var ud = HttpContext.Current.Session["PersistingUserData"] as Data.UserData; if (ud.IsAutoChecked == false) { ud.IsAutoChecked = true; ud.Log.Add(new Data.LogEntry("AutoCheck Changed:" + autocheck as string)); SettingsDBData db = new SettingsDBData(); db.Appname = ud.Guid; db.XmlData = ud.SerializeToXmlString(ud); Save.Setting(db); return(true); } } catch { return(false); } } else { try { var ud = HttpContext.Current.Session["PersistingUserData"] as Data.UserData; if (ud.IsAutoChecked == true) { ud.IsAutoChecked = false; ud.Log.Add(new Data.LogEntry("AutoCheck Changed:" + autocheck as string)); SettingsDBData db = new SettingsDBData(); db.Appname = ud.Guid; db.XmlData = ud.SerializeToXmlString(ud); Save.Setting(db); return(true); } } catch { return(false); } } return(false); }
public static SQL_Request SettingsGet(this SQL_Request request, string AppName = "AWP_STARRAG_US", bool close = true) { request.Command = new SqlCommand(); try { if (request.Connection.State == ConnectionState.Closed) { request.Connection.Open(); } // Create a object of SqlCommand class request.Command.Connection = request.Connection; //Pass the connection object to Command request.Command.CommandType = CommandType.StoredProcedure; // We will use stored procedure. request.Command.CommandText = "SettingsGet"; //request.Command.CommandText = "spGetTimeData"; //Stored Procedure Name request.Command.Parameters.Add("@AppName", SqlDbType.NVarChar).Value = AppName; SqlDataAdapter da = new SqlDataAdapter(request.Command); DataSet ds = new DataSet(); da.Fill(ds); //create an asset and tag it onto sql_request request.Message = "success:getdata"; request.Data = ds; request.Success = true; try { List <SettingsDBData> newassets = new List <SettingsDBData>(); foreach (DataRow dr in request.Data.Tables[0].Rows) { SettingsDBData a = new SettingsDBData(); a.Appname = dr?.Field <string>("AppName"); a.XmlData = dr?.Field <string>("XmlData"); a.XmlData2 = dr?.Field <string>("XmlData2"); a.XmlData3 = dr?.Field <string>("XmlData3"); a.XmlData4 = dr?.Field <string>("XmlData4"); a.XmlData5 = dr?.Field <string>("XmlData5"); request.Tag = newassets; newassets.Add(a); } if (newassets.Count == 1) { request.Tag = newassets.FirstOrDefault(); } } catch { } } catch (Exception ex) { request.Error.Ex = ex; request.Success = false; request.Message = "error:getdata"; return(request); } finally { if (close) { request.Connection.Close(); } } return(request); }
public static SQL_Request SettingsGetAll(this SQL_Request request, bool close = true) { request.Command = new SqlCommand(); try { if (request.Connection.State == ConnectionState.Closed) { request.Connection.Open(); } // Create a object of SqlCommand class request.Command.Connection = request.Connection; //Pass the connection object to Command request.Command.CommandType = CommandType.StoredProcedure; // We will use stored procedure. request.Command.CommandText = "SettingsGetAll"; SqlDataAdapter da = new SqlDataAdapter(request.Command); DataSet ds = new DataSet(); da.Fill(ds); request.Message = "success:getalldata"; request.Data = ds; request.Success = true; List <SettingsDBData> settingslist = new List <SettingsDBData>(); try { foreach (DataRow dr in request.Data.Tables[0].Rows) { try { SettingsDBData a = new SettingsDBData(); a.Appname = dr?.Field <string>("AppName"); a.XmlData = dr?.Field <string>("XmlData"); a.XmlData2 = dr?.Field <string>("XmlData2"); a.XmlData3 = dr?.Field <string>("XmlData3"); a.XmlData4 = dr?.Field <string>("XmlData4"); a.XmlData5 = dr?.Field <string>("XmlData5"); settingslist.Add(a); } catch { } } request.Tag = settingslist; } catch { } } catch (Exception ex) { request.Error.Ex = ex; request.Success = false; request.Message = "error:getalldata"; return(request); } finally { if (close) { request.Connection.Close(); } } return(request); }