public void ReadNewNotify()
{
List <string> listIDs = new List <string>();
con.fillList("select ID from Emails where Sent=false", listIDs);
if (listIDs.Count > 0)
{
foreach (string s in listIDs)
{
to = con.getValue(string.Format("select Para from Emails where ID={0}", s));
copy = con.getValue(string.Format("select CC from Emails where ID={0}", s));
from = con.getValue(string.Format("select De from Emails where ID={0}", s));
subject = con.getValue(string.Format("select Subject from Emails where ID={0}", s));
body = con.getValue(string.Format("select BodyFile from Emails where ID={0}", s));
if (body != "")
{
email.writeBodyNotify(body);
email.sendEmail(to, subject, copy, from);
}
con.executeQuery(string.Format("update Emails set Sent=true where ID={0}", s));
try
{
File.Delete(@"\\mxtswtjnts\Groups\GRP Tijuana Departments\Plastics\2015 Plastics DB\CAPA Tool\TempFiles\" + body);
}
catch { }
}
}
}
public void makeEmail()
{
if (areasId.Count > 0)
{
foreach (string s in areasId)
{
int actualArea = 0;
int nextArea = 0;
string to = "";
string batch = "";
actualArea = Convert.ToInt32(mycon.getValue(
string.Format("select a.orden from area_orden as b inner join Areas as a on b.AreaId=a.AreaId where b.Area_OrdenId={0}",
s)));
batch = mycon.getValue(string.Format(
"select w.BatchOrden from workordens as w inner join area_orden as a on w.workordenid=a.workordenid where a.area_ordenid={0}",
s));
if (actualArea != 6)
{
nextArea = actualArea + 1;
int newarea = Convert.ToInt32(mycon.getValue(string.Format("select AreaId from Areas where orden={0}", nextArea)));
emails.Clear();
mycon.fillList(emails, string.Format("select emailuser from users where areaid={0}", newarea));
foreach (string e in emails)
{
email.writeBody(batch);
email.sendEmail(e, string.Format("Notificación de TrackBatch: Nuevo batch por iniciar (No. {0})", batch),
"");
}
}
mycon.executeQuery(string.Format("update Area_orden set notify=false where area_ordenid={0}", s));
}
}
}
