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