public RefrubHistoryObj redisco_data(int asset)
{
var result = new RefrubHistoryObj();
// LabelModel.status = "Connection Successful";
String cmdText = "select * from rediscovery where ictag ='" + asset + "'";
using (MySqlCommand cmd = new MySqlCommand(cmdText, conn))
{
conn.Open();
MySqlDataReader reader = cmd.ExecuteReader(); //execure the reader
while (reader.Read())
{
result = new RefrubHistoryObj()
{
asset_tag = int.Parse(reader["ictag"].ToString()), time = DateTime.Parse(reader["time"].ToString()), refurbisher = (reader["refurbisher"].ToString()), sku = (reader["pallet"].ToString()), hdd = (reader["hdd"].ToString()), ram = (reader["ram"].ToString()), cpu = (reader["cpu"].ToString()), made = (reader["brand"].ToString()), model = (reader["model"].ToString()), serial = (reader["serial"].ToString()), optical_drive = (reader["optical_drive"].ToString()), is_ssd = (reader["has_SSD"].ToString())
};
}
conn.Close();
result.ram = magento_sku.ram_format(result, false);
result.hdd = magento_sku.hdd_format(false, result);
}
return(result);
}
public bool insert(RefrubHistoryObj insert)
{
bool sucess = false;
return(sucess);
}
//read and create label by usng source.label located in Debug folder
//returns the preview image
public ILabel generate_label(RefrubHistoryObj spec)
{
string path = Directory.GetCurrentDirectory();
var label = Label.Open(path + "\\source.label");
label.SetObjectText("cpu", spec.cpu);
label.SetObjectText("asset_tag", spec.asset_tag.ToString());
label.SetObjectText("manu", spec.model);
if (spec.is_ssd == "True")
{
label.SetObjectText("hdd", spec.hdd + "GB SSD");
}
else
{
label.SetObjectText("hdd", spec.hdd + "GB");
}
label.SetObjectText("ram", spec.ram + "GB");
label.SetObjectText("time", DateTime.Now.ToString());
label.SetObjectText("refur", spec.refurbisher);
label.SetObjectText("BARCODE", spec.sku);
label.SetObjectText("channel", spec.channel);
label.SetObjectText("pallet", spec.sku);
label.SetObjectText("serial", spec.serial);
//create preview for the label
return(label);
}
// Mysql_DataProvider mysql_data = new Mysql_DataProvider();
//public Idbprovider sqlite_data = new SQlite_DataProvider();
public MainWindow()
{
Tuple <AppTheme, Accent> appStyle = ThemeManager.DetectAppStyle(Application.Current);
ThemeManager.ChangeAppStyle(Application.Current,
ThemeManager.GetAccent("Teal"),
ThemeManager.GetAppTheme("BaseDark"));
InitializeComponent();
labelViewModel = new LabelViewModel(DialogCoordinator.Instance);
RefrubHistoryObj = new RefrubHistoryObj();
DataContext = labelViewModel;
}
public bool insert(RefrubHistoryObj input)
{
bool sucess = false;
try
{
conn.Open();
String cmdText = "Insert into rediscovery(ictag,time,serial,brand,model,cpu,hdd,ram,optical_drive,location,pallet,pre_coa,refurbisher)VALUES ('" + input.asset_tag + "','" + "" + "','" + input.serial + "','" + input.brand + "','" + input.model + "','" + input.cpu + "','" + input.hdd + "','" + input.ram + "','','" + input.channel + "','" + input.sku + "','" + input.pre_coa + "','" + input.refurbisher + "') on Duplicate KEY update hdd='" + input.hdd + "',ram='" + input.ram + "',location='" + input.channel + "',pallet='" + input.sku + "',pre_coa = '" + input.pre_coa + "',refurbisher = '" + input.refurbisher + "'";
using (MySqlCommand cmd = new MySqlCommand(cmdText, conn))
{
cmd.ExecuteNonQuery();
conn.Close();
}
sucess = true;
}
catch
{
}
return(sucess);
}
public bool discovery_insert(RefrubHistoryObj input)
{
bool sucess = false;
try
{
MySqlCommand command = conn.CreateCommand();
conn.Open();
String cmdText = "Insert into discovery(ictag,time,cpu,serial,brand,model,cpu,hdd,ram)VALUES ('" + input.asset_tag + "','" + "" + "','" + input.cpu + "','" + input.serial + "','" + input.brand + "','" + input.model + "','" + input.cpu + "','" + input.hdd + "','" + input.ram + "') on Duplicate KEY update hdd='" + input.hdd + "',ram='" + input.ram + "'";
using (MySqlCommand cmd = new MySqlCommand(cmdText, conn))
{
cmd.ExecuteNonQuery();
conn.Close();
}
sucess = true;
}
catch
{
}
return(sucess);
}
public RefrubHistoryObj redisco_data(int asset)
{
var result = new RefrubHistoryObj();
return(result);
}
public bool discovery_insert(RefrubHistoryObj obj)
{
var result = false;
return(result);
}
