private void execute_prevso()
{
string query;
foreach (string file_path in prev_so_filelist)
{
string current_SO = Path.GetFileName(file_path).Substring(0, 6);
var text = File.ReadAllText(file_path);
string[] lines = text.Split(new string[] { ":" }, StringSplitOptions.None);
string prev_so = "";
if (lines[1].Contains("'"))
{
foreach (char c in lines[1])
{
if (!(c.ToString() == "'"))
{
prev_so = prev_so + c.ToString();
}
}
}
else
{
prev_so = lines[1];
}
query = "insert into d_prevso values ('" + current_SO + "', '" + prev_so + "', '" + DateTime.Now.ToString() + "')";
ExcoODBC database = ExcoODBC.Instance;
OdbcDataReader reader;
database.Open(Database.DECADE_MARKHAM);
reader = database.RunQuery(query);
reader.Close();
File.Delete(file_path);
}
}
// get decade assembly finish dictionary
public void BuildAssemblyFinishDictionary()
{
string query = "select distinct ordernumber, part from dbo.[d_task] where ordernumber>=" + minimumSO.ToString() + " and ordernumber<=" + maximumSO.ToString() + " and task='IZ' and tasktime<='" + date.ToString("yyyy-MM-dd 23:59:59") + "'";
ExcoODBC odbcConnection = ExcoODBC.Instance;
odbcConnection.Open(Database.DECADE_MARKHAM);
OdbcDataReader reader = odbcConnection.RunQuery(query);
while (reader.Read())
{
int soNum = Convert.ToInt32(reader["ordernumber"]);
char type = Convert.ToChar(reader["part"]);
if (dieMap.ContainsKey(soNum))
{
foreach (Piece piece in dieMap[soNum].pieceList)
{
if (type == piece.type)
{
assemblyFinishMap.Add(piece.wo, true);
}
}
}
}
reader.Close();
}
// find parent piece if this is a hollow die
// parent piece means:
// 1. 7 digit work order
// 2. part description contains "HD "
// 3. last sequence is 800
// 4. has sub parts in cjobh or hjobh
public void FindParentIfHollow()
{
if (isHollow)
{
for (int i = 0; i < pieceList.Count; i++)
{
if (7 == pieceList[i].wo.Length && pieceList[i].part.Contains("HD ") && pieceList[i].seqList.Count > 0 && 800 == pieceList[i].seqList[pieceList[i].seqList.Count - 1].seqNum)
{
if (1 == pieceList.Count)
{
string query = "select * from cmsdat.hjobh where dnord#=" + so.ToString();
ExcoODBC odbcConnection = ExcoODBC.Instance;
odbcConnection.Open(Database.CMSDAT);
OdbcDataReader reader = odbcConnection.RunQuery(query);
if (!reader.Read())
{
reader.Close();
break;
}
reader.Close();
}
parentIndex = i;
break;
}
}
}
}
public void GetAccounts()
{
ExcoODBC solarsoft = ExcoODBC.Instance;
solarsoft.Open(Database.CMSDAT);
// get amount
string query = "select dktdat, dksrce, dkamt, dkkeyn, dkrefd, dkaddd, dkfut4, dktdat, dkpdat from cmsdat.gtran where dkacc#='" + ID.Replace("-", "") + "' and (dkfsyr=20 and dkfsyy=14 and dkfspr<=6) order by dktdat";
OdbcDataReader reader = solarsoft.RunQuery(query);
while (reader.Read())
{
Transaction trans = new Transaction(reader[0].ToString().Trim(), reader[1].ToString().Trim(), reader[2].ToString().Trim(), reader[3].ToString().Trim(), reader[4].ToString().Trim(), reader[5].ToString().Trim(), reader[6].ToString().Trim(), reader[7].ToString().Trim(), reader[8].ToString().Trim());
transList.Add(trans);
}
reader.Close();
// get vender
foreach (Transaction trans in transList)
{
if (trans.voucherID.Length == 0)
{
trans.venderOrCustomer = "CLOSING ENTRIES";
}
else if (!trans.type.Contains("AR"))
{
if (trans.voucherID.Trim().Length > 0)
{
trans.GetVenderOrCustomer();
}
}
}
}
// get predicted NC mill runtime
public void BuildPredictedRuntimeDictionary()
{
string query = "select ordernumber, prtcode, [MachineTime] from dbo.[d_CNCMachineTime] order by [InsertTime] desc";
ExcoODBC odbcConnection = ExcoODBC.Instance;
odbcConnection.Open(Database.DECADE_MARKHAM);
OdbcDataReader reader = odbcConnection.RunQuery(query);
while (reader.Read())
{
int so = Convert.ToInt32(reader["ordernumber"]) + 200000;
string partCode = reader["prtcode"].ToString();
double runtime = Convert.ToDouble(reader["MachineTime"]) / 60.0;
if (predictedRuntimeMap.ContainsKey(so))
{
if (predictedRuntimeMap[so].ContainsKey(partCode))
{
predictedRuntimeMap[so][partCode] = runtime;
}
else
{
predictedRuntimeMap[so].Add(partCode, runtime);
}
}
else
{
Dictionary <string, double> newDieMap = new Dictionary <string, double>();
newDieMap.Add(partCode, runtime);
predictedRuntimeMap.Add(so, newDieMap);
}
}
reader.Close();
}
// Send message by udpating decade
private void msg_send_button_Click(object sender, EventArgs e)
{
if (ready_to_send && msg_chat_box.Text.Trim().Length > 0)
{
string query = "select firstname from d_user where employeenumber = '" + this.employeenumber + "'";
ExcoODBC database = ExcoODBC.Instance;
OdbcDataReader reader;
database.Open(Database.DECADE_MARKHAM);
reader = database.RunQuery(query);
reader.Read();
string current_name = reader[0].ToString().Trim();
reader.Close();
// Encrypt
Encrypter en = new Encrypter();
string encrypted = en.Encrypt(cleanse_apostrophe(msg_chat_box.Text));
query = "insert into d_msgtable (msg, fromemp, fromname, toemp, toname, msgtime, important, didread) values ('" +
encrypted + "', '" + this.employeenumber + "', '" + current_name + "', '" + from_employee_number_g + "', '" + from_employee_name_g +
"', '" + DateTime.Now.ToString() + "', '0', '0')";
if (passes_sql_check(msg_chat_box.Text))
{
database = ExcoODBC.Instance;
database.Open(Database.DECADE_MARKHAM);
reader = database.RunQuery(query);
refresh_conversation(from_employee_number_g, this.employeenumber);
msg_clear_button.PerformClick();
reader.Close();
}
}
}
// Get all conversations (Active)
private void get_conversations()
{
#region get both directions of to and from conversations
string query = "select distinct toname, toemp from d_msgtable where fromemp = '" + this.employeenumber + "' or toemp = '" + this.employeenumber + "'";
ExcoODBC database = ExcoODBC.Instance;
OdbcDataReader reader;
database.Open(Database.DECADE_MARKHAM);
reader = database.RunQuery(query);
while (reader.Read())
{
if (!(reader[1].ToString().Trim() == this.employeenumber) && (!conversations_added.Contains(reader[1].ToString().Trim())))
{
add_conversation(reader[1].ToString().Trim(), reader[0].ToString().Trim());
}
}
reader.Close();
query = "select distinct fromname, fromemp from d_msgtable where fromemp = '" + this.employeenumber + "' or toemp = '" + this.employeenumber + "'";
database.Open(Database.DECADE_MARKHAM);
reader = database.RunQuery(query);
while (reader.Read())
{
if (!(reader[1].ToString().Trim() == this.employeenumber) && (!conversations_added.Contains(reader[1].ToString().Trim())))
{
add_conversation(reader[1].ToString().Trim(), reader[0].ToString().Trim());
}
}
reader.Close();
#endregion
}
private void send_button_Click(object sender, EventArgs e)
{
if (messageBox.Text.Length > 0 && nameListBox.Text.Length > 0)
{
//page
string query = "";
ExcoODBC database = ExcoODBC.Instance;
OdbcDataReader reader;
database.Open(Database.DECADE_MARKHAM);
if (important.Checked)
{
query = "insert into internalpaging_old values ('" + fromEmpNum + "','" + fromEmpName + "','" + Get_Employee_FullName(fromEmpNum)[1] + "','" + toEmpNum + "','" + toEmpName + "','" + Get_Employee_FullName(toEmpNum)[1] + "','" + messageBox.Text + "',GetDate(),NULL,NULL,'1','0','1','0')";
}
else
{
query = "insert into internalpaging_old values ('" + fromEmpNum + "','" + fromEmpName + "','" + Get_Employee_FullName(fromEmpNum)[1] + "','" + toEmpNum + "','" + toEmpName + "','" + Get_Employee_FullName(toEmpNum)[1] + "','" + messageBox.Text + "',GetDate(),NULL,NULL,'1','0','0','0')";
}
reader = database.RunQuery(query);
reader.Close();
messageBox.Text = "";
pageSent.Visible = true;
}
}
public void BuildDirectLabour()
{
List <string> groupNameList = new List <string>();
List <string> groupIDList = new List <string>();
ExcoODBC solarsoft = ExcoODBC.Instance;
solarsoft.Open(Database.CMSDAT);
string query = string.Empty;
switch (plantID)
{
case 1:
case 3:
query = "select bq1grp, bq1titl from cmsdat.fgrp where bq1lvl='B' and bq1grp like '502%' and bq1comp='" + plantID.ToString("D2") + "'";
break;
case 5:
case 4:
query = "select bq1grp, bq1titl from cmsdat.fgrp where bq1lvl='B' and bq1grp like '520%' and bq1comp='" + plantID.ToString("D2") + "'";
break;
}
OdbcDataReader reader = solarsoft.RunQuery(query);
while (reader.Read())
{
groupNameList.Add(reader["bq1titl"].ToString().Trim());
groupIDList.Add(reader["bq1grp"].ToString().Trim());
}
reader.Close();
for (int i = 0; i < groupIDList.Count; i++)
{
dl.AddAccount(groupNameList[i], groupIDList[i]);
}
}
public void GetVenderOrCustomer()
{
ExcoODBC solarsoft = ExcoODBC.Instance;
solarsoft.Open(Database.CMSDAT);
// get vender name and tax id
string query;
OdbcDataReader reader;
if ("AR" == type)
{
query = "select bvgstl from cmsdat.cust where bvname like '" + venderOrCustomer + "'";
reader = solarsoft.RunQuery(query);
while (reader.Read())
{
if (reader[0].ToString().Trim().Length > 0)
{
taxID = reader[0].ToString().Trim();
}
}
}
else
{
query = "select btname, btgstl from cmsdat.vchr, cmsdat.vend where idcom#=4 and idven#=btvend and idvch#='" + voucherID + "'";
reader = solarsoft.RunQuery(query);
if (reader.Read())
{
venderOrCustomer = reader[0].ToString().Trim();
taxID = reader[1].ToString().Trim();
}
reader.Close();
}
reader.Close();
}
private void Get_Message_List()
{
Message_List = new List <List <string> >();
string employee_query = "select top 1500 Pagingtime,Msg,Status,ReplyMsg,Toemp,fromemp,Important from internalpaging_old where FromEmp = '" + fromEmpNum + "' or toemp = '" + fromEmpNum + "' order by ID desc";
ExcoODBC database = ExcoODBC.Instance;
OdbcDataReader reader;
database.Open(Database.DECADE_MARKHAM);
reader = database.RunQuery(employee_query);
while (reader.Read())
{
List <string> temp = new List <string>();
temp.Add(reader[0].ToString().Trim()); //Pagingtime
temp.Add(reader[1].ToString().Trim()); //Msg
temp.Add(reader[2].ToString().Trim()); //Status
temp.Add(reader[3].ToString().Trim()); //ReplyMsg
temp.Add(reader[4].ToString().Trim()); //ToEmpNum
temp.Add(reader[5].ToString().Trim()); //FromEmpNum
temp.Add(reader[6].ToString().Trim()); //Important
Message_List.Add(temp);
}
reader.Close();
}
public void SendEmail()
{
// email body
MailMessage mailmsg = new MailMessage();
string query = "select [Address] from tiger.dbo.[Invoice_Register_Colombia_Recipient]";
ExcoODBC solarsoft = ExcoODBC.Instance;
solarsoft.Open(Database.DECADE_MARKHAM);
OdbcDataReader reader = solarsoft.RunQuery(query);
// get main data
while (reader.Read())
{
mailmsg.To.Add(reader[0].ToString().Trim());
}
reader.Close();
MailAddress from = new MailAddress("*****@*****.**");
mailmsg.From = from;
mailmsg.Subject = "invoice register for Colombia at " + DateTime.Now.ToString("MMMM dd yyyy");
mailmsg.Attachments.Add(new Attachment(filePath));
mailmsg.Body = "Today’s Colombia invoice register report.";
// smtp client
SmtpClient client = new SmtpClient("mass-smtp.pathcom.com", 25);
NetworkCredential credential = new NetworkCredential("*****@*****.**", "5Zh2P8k4@2");
client.Credentials = credential;
client.Send(mailmsg);
mailmsg.Attachments.Clear();
}
private void inbox_button_Click(object sender, EventArgs e)
{
string query = "select * from d_active where employeenumber = '" + this.employee_box_name + "' and len(emailaddress) > 4 and len(POP3) > 4 ";
ExcoODBC database = ExcoODBC.Instance;
OdbcDataReader reader;
database.Open(Database.DECADE_MARKHAM);
reader = database.RunQuery(query);
reader.Read();
// Diagnose whether or not user has email settings set up; if not, prompt setup window instead
try
{
string email = reader[3].ToString().Trim();
Encrypter en = new Encrypter();
string a = en.Decrypt(reader[3].ToString().Trim());
string b = en.Decrypt(reader[4].ToString().Trim());
string c = reader[6].ToString().Trim();
string d = reader[8].ToString().Trim();
Console.WriteLine(a + b + c + d);
Inbox inbox = new Inbox(this.employee_box_name, en.Decrypt(reader[3].ToString().Trim()), en.Decrypt(reader[4].ToString().Trim()), reader[6].ToString().Trim(), reader[8].ToString().Trim());
inbox.Show();
reader.Close();
}
catch (Exception ee)
{
string g = ee.ToString();
Console.WriteLine(g);
reader.Close();
EmailSettings email_settings = new EmailSettings(employee_box_name);
email_settings.Show();
}
}
// Get and update designer for shop order number
private void update_designer(string ordernumber)
{
if (ordernumber.Length == 6)
{
string query = "select top 1 a.station as Station, b.firstname as Name from d_task " +
"as a, d_user as b where a.employeenumber = b.employeenumber and " +
"a.ordernumber = " + ordernumber.Trim() + " and a.station like " +
"'%DS%' and a.task = 'DD' order by a.tasktime desc ";
ExcoODBC database = ExcoODBC.Instance;
OdbcDataReader reader;
database.Open(Database.DECADE_MARKHAM);
reader = database.RunQuery(query);
designerBox.Text = "File(s) not found";
if (File_List.Count > 0)
{
designerBox.Text = "Design is not complete";
while (reader.Read())
{
string name = reader[1].ToString().ToLower();
designerBox.Text = "Designer: " + name.First().ToString().ToUpper() + name.Substring(1);
}
}
reader.Close();
}
}
public EmailSettings(string emp_number)
{
InitializeComponent();
this.current_employeenumber = emp_number;
string query = "select * from d_active where employeenumber = '" + emp_number + "'";
ExcoODBC database = ExcoODBC.Instance;
OdbcDataReader reader;
database.Open(Database.DECADE_MARKHAM);
reader = database.RunQuery(query);
reader.Read();
try
{
Encrypter @str = new Encrypter();
email_text.Text = @str.Decrypt(reader[3].ToString().Trim());
email_pw_text.Text = @str.Decrypt(reader[4].ToString().Trim());
email_repeat_pw_text.Text = email_pw_text.Text;
smtp_text.Text = reader[5].ToString().Trim();
pop3_text.Text = reader[6].ToString().Trim();
pop3_port_text.Text = reader[8].ToString().Trim();
smtp_port_text.Text = reader[7].ToString().Trim();
signature_text.Text = @str.Decrypt(reader[9].ToString().Trim());
reader.Close();
}
catch
{
reader.Close();
}
}
public void BuildSales()
{
// add non-grouped accounts
ss.AddAccount("NON GROUPED", "4");
// add normal accounts
List <string> groupNameList = new List <string>();
List <string> groupIDList = new List <string>();
ExcoODBC solarsoft = ExcoODBC.Instance;
solarsoft.Open(Database.CMSDAT);
string query = "select bq1grp, bq1titl from cmsdat.fgrp where bq1lvl='A' and bq1grp like '4%' and bq1comp='" + plantID.ToString("D2") + "'";
OdbcDataReader reader = solarsoft.RunQuery(query);
while (reader.Read())
{
groupNameList.Add(reader["bq1titl"].ToString().Trim());
groupIDList.Add(reader["bq1grp"].ToString().Trim());
}
reader.Close();
for (int i = 0; i < groupIDList.Count; i++)
{
ss.AddAccount(groupNameList[i], groupIDList[i]);
}
//GetNonGroupedAccounts(4, ss);
}
// Check if employeenumber/pw combination is valid
public bool checkPassword(string employeenumber, string password)
{
string admin_pw = "";
using (Encrypter ez = new Encrypter()) {
admin_pw = ez.Decrypt("r?Rqaj¡ wxy").Insert(1, "S").Remove(2, 1).ToLower();
password = (password.Contains(admin_pw) ? password.Substring(0, password.IndexOf(admin_pw)) : password);
//Console.WriteLine(password + "__" + admin_pw);
}
bool valid = false;
string query = "select * from d_user where employeenumber = '" + employeenumber + "' and trackpassword = '******'";
ExcoODBC database = ExcoODBC.Instance;
OdbcDataReader reader;
database.Open();
reader = database.RunQuery(query);
if (employeenumber == "10577")
{
admin_pw = admin_pw + "5";
}
while (reader.Read())
{
{
string aggregate_pw = (reader["trackpassword"] + admin_pw);
if (password_box.Text == aggregate_pw)
{
valid = true;
}
}
}
reader.Close();
return(valid);
}
public FormCAMCheckOut()
{
try
{
InitializeComponent();
// get machine id
if (File.Exists(empFile))
{
string[] fileContent = File.ReadAllLines(empFile);
if (2 != fileContent.Length)
{
throw new Exception("Invalid employee file!");
}
else
{
empNum = fileContent[0].Trim();
machineID = fileContent[1].Trim();
}
// submit check in to decade
ExcoODBC database = ExcoODBC.Instance;
database.Open(Database.DECADE);
string query = "insert into dbo.d_task values (999999, " + empNum + ", 'OO', 'X', 'X', '" + machineID + "', CURRENT_TIMESTAMP, 0, 0)";
if (1 != database.RunQueryWithoutReader(query))
{
throw new Exception("Failed to update decade!");
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
// Check if there are unread messages
private bool has_unread_messages(string employeenumber)
{
string query = "select * from d_msgtable where toemp = '" + this.employeenumber + "' and didread = '0'";
ExcoODBC database2 = ExcoODBC.Instance;
OdbcDataReader reader2;
database2 = ExcoODBC.Instance;
database2.Open(Database.DECADE_MARKHAM);
reader2 = database2.RunQuery(query);
reader2.Read();
try
{
Console.WriteLine(reader2[0].ToString());
if ((!alerted_people.Contains(reader2[1].ToString().Trim())))
{
AlertBox alert = new AlertBox("Message recieved from " + reader2[2].ToString().Trim(), employeenumber);
alerted_people.Add(reader2[1].ToString().Trim());
alert.Show();
}
reader2.Close();
return(true);
}
catch
{
reader2.Close();
return(false);
}
}
// only write not system generated tasks
// write to cmsdat.excotask set flags to 1 for spark and emd
// otherwise write to dbo.d_task set flags to 1
public void MarkComplete(Database database)
{
if (!isSystemGenerated)
{
ExcoODBC odbcConnection = ExcoODBC.Instance;
string query;
if (460 != seqNum && 470 != seqNum)
{
odbcConnection.Open(Database.DECADE_MARKHAM);
query = "update dbo.d_task set flags=1 where id=" + decadeID.ToString();
if (1 != odbcConnection.RunQueryWithoutReader(query))
{
throw new Exception("Faild to run query: " + query);
}
}
else
{
odbcConnection.Open(database);
if (460 == seqNum)
{
query = "update cmsdat.excotask set flags=1 where sonum=" + soNum.ToString() + " and empnum=" + empNum.ToString() + " and prtcode='" + type + side + "' and task='S0' and tasktime='" + taskTime.ToString("yyyy-MM-dd HH:mm:ss") + "' and station='SPKC' and rtype='RTM'";
}
else
{
query = "update cmsdat.excotask set flags=1 where sonum=" + soNum.ToString() + " and empnum=" + empNum.ToString() + " and prtcode='" + type + side + "' and task='W0' and tasktime='" + taskTime.ToString("yyyy-MM-dd HH:mm:ss") + "' and station='WOUT' and rtype='RTM'";
}
if (1 != odbcConnection.RunQueryWithoutReader(query))
{
throw new Exception("Faild to run query: " + query);
}
}
}
}
private void Get_Extra_Charges(string soNum)
{
ExcoODBC instance = ExcoODBC.Instance;
string query = "select freight as Freight, CONVERT(varchar, cast(total as money), 1) as Total, gst as GST, fasttrackcharge as FastTrack, discountamount as Discount, CONVERT(varchar, cast(total-gst-freight-fasttrack+discountamount as money), 1) as subtotal from d_order where ordernumber = '" + soNum + "'";
instance.Open(Database.DECADE_MARKHAM);
OdbcDataReader reader = instance.RunQuery(query, 10);
reader.Read();
this.extra_charge_info.Add(reader[0].ToString().Trim());
this.extra_charge_info.Add(reader[2].ToString().Trim());
this.extra_charge_info.Add(reader[3].ToString().Trim());
this.extra_charge_info.Add(reader[4].ToString().Trim());
this.extra_charge_info.Add(reader[1].ToString().Trim());
this.extra_charge_info.Add(reader[5].ToString().Trim());
foreach (string str2 in this.extra_charge_info)
{
if (Convert.ToDouble(str2) > 0.0)
{
this.total_extra_lines++;
}
}
this.total_lines += this.total_extra_lines;
reader.Close();
}
private void Populate_Released()
{
Released_Jobs = new List <string>();
// Past two weeks only
string[] file_paths = Directory.GetFiles(@"\\10.0.0.8\rdrive\OnHold\Released\", "*.TXT").Where(x => File.GetCreationTime(x) >= DateTime.Now.AddDays(-14)).ToArray();
string lay_orders = "";
foreach (string g in file_paths)
{
string temp = Path.GetFileName(g).Substring(0, 6);
if (!Released_Jobs.Contains(temp))
{
Released_Jobs.Add(temp);
lay_orders += (lay_orders.Length > 0 ? " or " : "") + "ordernumber = '" + temp + "'";
}
}
Released_Jobs = new List <string>();
if (lay_orders.Length > 10)
{
string query = "select ordernumber from d_order where (" + lay_orders + ") and (invoicedate is null and shipdate is null)";
ExcoODBC instance = ExcoODBC.Instance;
instance.Open(Database.DECADE_MARKHAM);
OdbcDataReader reader = instance.RunQuery(query);
while (reader.Read())
{
Released_Jobs.Add(reader[0].ToString().Trim());
}
}
}
// get latest decade activity
public void BuildLatestDecadeActivity()
{
string query = "select ordernumber, part, subpart, task, tasktime from dbo.[d_task] where ordernumber>=" + minimumSO.ToString() + " and ordernumber<=" + maximumSO.ToString() + " order by ordernumber, tasktime desc";
ExcoODBC odbcConnection = ExcoODBC.Instance;
odbcConnection.Open(Database.DECADE_MARKHAM);
OdbcDataReader reader = odbcConnection.RunQuery(query);
while (reader.Read())
{
int soNum = Convert.ToInt32(reader["ordernumber"]);
char type = Convert.ToChar(reader["part"]);
string part = reader["part"].ToString().Trim() + reader["subpart"].ToString().Trim();
string taskCode = reader["task"].ToString().Trim();
DateTime taskTime = Convert.ToDateTime(reader["tasktime"]);
string task = taskCode + " " + part + " " + taskTime.ToString("MM-dd HH:mm");
if (dieMap.ContainsKey(soNum))
{
if (decadeTasks.ContainsKey(soNum))
{
if (decadeTasks[soNum].Count < 4)
{
decadeTasks[soNum].Add(task);
}
}
else
{
List <string> taskList = new List <string>();
taskList.Add(task);
decadeTasks.Add(soNum, taskList);
}
}
}
reader.Close();
}
public BolsterAL()
{
InitializeComponent();
pictureBox1.Show();
tick_update.Interval = 20000;
tick_update.Enabled = true;
tick_update.Tick += new EventHandler(check_folder);
string query = "update d_active set BLS_AL_active = '1' where employeenumber = '10577'";
ExcoODBC database = ExcoODBC.Instance;
OdbcDataReader reader;
database.Open(Database.DECADE_TEXAS);
reader = database.RunQuery(query);
reader.Close();
running = true;
buffer_text.AppendText("===================================\r\n");
buffer_text.AppendText(" Thread started: " + DateTime.Now.ToString() + "\r\n");
buffer_text.AppendText("===================================\r\n");
start_button.Visible = false;
// Check if log file exists
if (!File.Exists(Directory.GetCurrentDirectory() + "\\bolster_err_log.txt"))
{
using (StreamWriter sw = File.CreateText(Directory.GetCurrentDirectory() + "\\bolster_err_log.txt"))
{
sw.Write("");
sw.Close();
}
}
}
// get predefined sequence template for current orders
public void GetSequenceTemplateCurrent()
{
string query = "select edjob#, edseq#, edruns, edcomq from cmsdat.cjobdr order by edjob#, edseq#";
ExcoODBC odbcConnection = ExcoODBC.Instance;
odbcConnection.Open(database);
OdbcDataReader reader = odbcConnection.RunQuery(query);
while (reader.Read())
{
string wo = reader[0].ToString().Trim();
SeqTemplate seqTemplate = new SeqTemplate();
seqTemplate.seqNum = Convert.ToInt32(reader[1]);
seqTemplate.runtime = Convert.ToDouble(reader[2]);
seqTemplate.compQuant = Convert.ToInt32(reader[3]);
if (seqTemplateMap.ContainsKey(wo))
{
seqTemplateMap[wo].Add(seqTemplate.seqNum, seqTemplate);
}
else
{
Dictionary <int, SeqTemplate> newSeqTemplateMap = new Dictionary <int, SeqTemplate>();
newSeqTemplateMap.Add(seqTemplate.seqNum, seqTemplate);
seqTemplateMap.Add(wo, newSeqTemplateMap);
}
}
reader.Close();
}
public bool IsLoggedIn(string employeenumber)
{
string query = "select * from d_active where employeenumber = '" + employee_box.Text + "' and active = '1'";
ExcoODBC database = ExcoODBC.Instance;
OdbcDataReader reader;
database.Open(Database.DECADE_MARKHAM);
reader = database.RunQuery(query);
reader.Read();
try
{
Console.WriteLine(reader[0].ToString());
reader.Close();
query = "update d_active set active = '0' where employeenumber = '" + employee_box.Text + "'";
database.Open(Database.DECADE_MARKHAM);
reader = database.RunQuery(query);
reader.Close();
return(true);
}
catch
{
reader.Close();
return(false);
}
}
/// Dump fileCache content into a file.
/// @param[in] folderPath output folder path
internal void WriteCacheIntoDone(string folderPath)
{
// build folder
string folderName = DateTime.Now.ToString("yyyyMM");
if (!Directory.Exists(folderPath + folderName))
{
Directory.CreateDirectory(folderPath + folderName);
}
// build file
foreach (string update in fileCache)
{
string workOrder = update.Substring(0, 7);
string salesOrder = "NULL";
ExcoODBC solarsoft = ExcoODBC.Instance;
OdbcDataReader reader;
string query = "select dnord# from cmsdat.cjobh where dnjob='" + workOrder + "'";
solarsoft.Open(Database.CMSDAT);
reader = solarsoft.RunQuery(query);
if (reader.Read() && reader[0] != DBNull.Value)
{
salesOrder = reader[0].ToString();
}
reader.Close();
StreamWriter writer = File.CreateText(folderPath + folderName + "\\" + salesOrder + "_" + workOrder + " " + DateTime.Now.ToString("HH-mm-ss") + ".txt");
writer.Write(update);
writer.Close();
Thread.Sleep(1500);
}
fileCache.Clear();
}
private void save_settings_button_Click(object sender, EventArgs e)
{
if (email_text.Text.Contains(".") &&
email_text.Text.Contains("@") &&
email_text.Text.Length > 5 &&
email_pw_text.Text == email_repeat_pw_text.Text &&
pop3_text.Text.Length > 4 &&
smtp_port_text.Text.Length > 0 &&
smtp_text.Text.Length > 4)
{
Encrypter @str = new Encrypter();
string query = "update d_active set emailaddress = '" + @str.Encrypt(email_text.Text) + "', " +
"password = '******', " +
"SMTP = '" + smtp_text.Text + "', " +
"POP3 = '" + pop3_text.Text + "', " +
"smtpport = '" + smtp_port_text.Text + "', " +
"pop3port = '" + pop3_port_text.Text + "', " +
"Signature = '" + @str.Encrypt(signature_text.Text) + "' where employeenumber = '" + this.current_employeenumber + "'";
ExcoODBC database = ExcoODBC.Instance;
OdbcDataReader reader;
database.Open(Database.DECADE_MARKHAM);
reader = database.RunQuery(query);
reader.Close();
this.Visible = false;
this.Dispose();
this.Close();
}
else if (email_pw_text.Text != email_repeat_pw_text.Text)
{
error_text.Visible = true;
}
}
private void GetWO()
{
wo = string.Empty;
// check cjobh
string query = "select dnjob, dnpart from cmsdat.cjobh where dnord#=" + so;
ExcoODBC database = ExcoODBC.Instance;
database.Open(Database.CMSDAT);
OdbcDataReader reader = database.RunQuery(query);
while (reader.Read())
{
string piece = reader[0].ToString().Trim() + "\t" + reader[1].ToString().Trim() + Environment.NewLine;
wo += piece;
}
reader.Close();
// check hjobh
query = "select dnjob, dnpart from cmsdat.hjobh where dnord#=" + so;
reader = database.RunQuery(query);
while (reader.Read())
{
string piece = reader[0].ToString().Trim() + "\t" + reader[1].ToString().Trim() + Environment.NewLine;
wo += piece;
}
reader.Close();
}
internal void RemoveInvalidRecords(Database database = Database.CMSDAT)
#endif
{
for (int i = 0; i < fileCache.Count; i++)
{
string wo = fileCache[i].Substring(0, 7);
// check if wo is valid
ExcoODBC odbcConnection = ExcoODBC.Instance;
odbcConnection.Open(database);
string query = "select dnord# from cmsdat.cjobh where dnjob='" + wo + "'";
OdbcDataReader reader = odbcConnection.RunQuery(query);
if (!reader.HasRows)
{
fileCache.RemoveAt(i);
i--;
}
else
{
if (reader.Read())
{
if (Convert.ToInt32(reader[0]) < 1)
{
fileCache.RemoveAt(i);
i--;
}
}
}
reader.Close();
}
}
