public static void recordTran(string item, int amt)
{
MakerspaceDataDataContext db = new MakerspaceDataDataContext();
Tran trans = new Tran {
UNI = App.UNI, amount = amt, ItemName = item, date = DateTime.Now, Id = System.Guid.NewGuid()
};
db.Trans.InsertOnSubmit(trans);
try { db.SubmitChanges(); }
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
public static void subtractFromInventory(string item, int amtTaken)
{
MakerspaceDataDataContext db = new MakerspaceDataDataContext();
var inv = from e in db.Inventories
where e.ItemID == item
select e;
foreach (var i in inv)
{
i.AmountInStock = i.AmountInStock - amtTaken;
MessageBox.Show(i.AmountInStock.ToString());
//===========================================================================
if (i.AmountInStock < 0)
{
System.Net.Mail.MailMessage mail = new System.Net.Mail.MailMessage();
foreach (string email in adminsEmails)
{
mail.To.Add(email);
}
;
mail.From = new System.Net.Mail.MailAddress("*****@*****.**");
mail.Subject = "We have run out of " + i.ItemID + " -> this note was auto-generated by the Makerspace app as a TEST";
mail.Body = " last transaction info-> UNI:" + App.UNI + "AmountTaken:" + amtTaken + "Time:" + DateTime.Now;
System.Net.Mail.SmtpClient SmtpServer = new System.Net.Mail.SmtpClient();
SmtpServer.Port = 587;
SmtpServer.Credentials = new System.Net.NetworkCredential("jonathanbarrios81", "******");
SmtpServer.EnableSsl = true;
SmtpServer.Host = "smtp.gmail.com";
SmtpServer.Send(mail);
//client.Send(mail);
//================================================================================
}//=============
}
//--------------------------------------------------------------------------------
//========================================================================================*/
try
{
//MessageBox.Show("hi");
db.SubmitChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
public static void subtractFromInventory(string item,int amtTaken )
{
MakerspaceDataDataContext db = new MakerspaceDataDataContext();
var inv = from e in db.Inventories
where e.ItemID == item
select e;
foreach (var i in inv)
{
i.AmountInStock = i.AmountInStock - amtTaken;
MessageBox.Show(i.AmountInStock.ToString());
//===========================================================================
if (i.AmountInStock < 0)
{
System.Net.Mail.MailMessage mail = new System.Net.Mail.MailMessage();
foreach (string email in adminsEmails)
{
mail.To.Add(email);
};
mail.From = new System.Net.Mail.MailAddress("*****@*****.**");
mail.Subject = "We have run out of " + i.ItemID+" -> this note was auto-generated by the Makerspace app as a TEST";
mail.Body = " last transaction info-> UNI:" + App.UNI + "AmountTaken:" + amtTaken + "Time:" + DateTime.Now;
System.Net.Mail.SmtpClient SmtpServer = new System.Net.Mail.SmtpClient();
SmtpServer.Port = 587;
SmtpServer.Credentials = new System.Net.NetworkCredential("jonathanbarrios81", "******");
SmtpServer.EnableSsl = true;
SmtpServer.Host = "smtp.gmail.com";
SmtpServer.Send(mail);
//client.Send(mail);
//================================================================================
}//=============
}
//--------------------------------------------------------------------------------
//========================================================================================*/
try
{
//MessageBox.Show("hi");
db.SubmitChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
public static void recordTran(string item, int amt)
{
MakerspaceDataDataContext db = new MakerspaceDataDataContext();
Tran trans = new Tran { UNI = App.UNI, amount = amt, ItemName = item, date = DateTime.Now, Id = System.Guid.NewGuid() };
db.Trans.InsertOnSubmit(trans);
try { db.SubmitChanges(); }
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}