/// <summary> /// Verify if O.S informations in List<>WaitList are done already /// </summary> public static void CheckList() { LogWriteLine("-------------------Executing unfinished O.S vector-------------------"); Conection.DeskOpen(); MySqlCommand sqlcommand = new MySqlCommand("", Conection.DeskConection); //This method is basically the same thing than the SatisfactionSenderSeeker(). the only difference is that this method already have the os number. for (int i = 0; i < WaitList.Count; i++) { sqlcommand.CommandText = "SELECT stc_os1 FROM v11_mafra.OpOrdensServicoCabecalhos where cod_os1 = " + WaitList[i].Cod; try { int getstate = Convert.ToInt32(sqlcommand.ExecuteScalar()); if (getstate == 83) { InformationOS aux = WaitList[i]; WaitList.Remove(WaitList[i]); GreenSignal(aux, i); System.Threading.Thread.Sleep(1000); } } catch (Exception e) { LogWriteLine("CODE 168 FAIL TO GET THE STATE OF O.S " + WaitList[i].Cod + " ERROR: " + e.Message); } } sqlcommand.Cancel(); Conection.DeskConection.Close(); }
public override int GetId() { Conection.DeskOpen(); command.CommandText = "SELECT cod_fu1 from cadastrosfuncionarios where nom_fu1 = '" + name + "'"; command.Connection = Conection.DeskConection; id_vip = Convert.ToInt32(command.ExecuteScalar()); Conection.DeskConection.Close(); return(id_vip); }
public override string GetName() { Conection.DeskOpen(); command.CommandText = "SELECT nom_fu1 from cadastrosfuncionarios where cod_fu1 = " + id_vip; command.Connection = Conection.DeskConection; name = command.ExecuteScalar().ToString(); Conection.DeskConection.Close(); return(name); }
public override int GetId() { Conection.DeskOpen(); command.CommandText = "SELECT id__cl1 from cadastrosclientesfornecedoresrepresentadastransportadoras where nom_cl1 = '" + name + "'"; command.Connection = Conection.DeskConection; id_vip = Convert.ToInt32(command.ExecuteScalar()); Conection.DeskConection.Close(); return(id_vip); }
/// <summary> /// Check if employee belong to tecnical group (code 4) /// </summary> /// <returns></returns> private static int GetGroupCode() { Conection.DeskOpen(); MySqlCommand sqlcommand = sqlcommand = new MySqlCommand("", Conection.DeskConection); sqlcommand.CommandText = "select gru_se1 from cadastrossenhasusuariosv11 where cod_se1 like '%" + nomfun + "%'"; int getstate = Convert.ToInt32(sqlcommand.ExecuteScalar()); sqlcommand.Cancel(); Conection.DeskConection.Close(); return(getstate); }
/// <summary> /// Get employee code /// </summary> private static void GetFunCode() { Conection.DeskOpen(); MySqlCommand sqlcommand = new MySqlCommand("", Conection.DeskConection); sqlcommand.CommandText = "select cod_fu1 from cadastrosfuncionarios where nom_fu1 like '%" + nomfun + "%'"; try { cod_fun = Convert.ToInt32(sqlcommand.ExecuteScalar()); lastOS = codOS; } catch (Exception e) { LogWriteLine("CODE 123 EXECUTESCALAR ERROR. MSG->" + e.Message); } }
public override string GetName() { Conection.DeskOpen(); command.CommandText = "SELECT nom_cl1 from cadastrosclientesfornecedoresrepresentadastransportadoras where id__cl1 = " + id_vip; command.Connection = Conection.DeskConection; try { name = command.ExecuteScalar().ToString(); return(name); } catch (Exception e) { Service1.LogWriteLine("ERROR GETNAME() FROM CUSTOMER CLASS AT LINE 78 ERROR->" + e.Message); return(""); } }
/// <summary> /// Check if O.S is already finished. (Code 81 = unfinished; 83 = finished) /// </summary> /// <returns></returns> private static int StateOS() { try { Conection.DeskOpen(); MySqlCommand sqlcommand = new MySqlCommand("", Conection.DeskConection); sqlcommand.CommandText = "SELECT stc_os1 FROM v11_mafra.OpOrdensServicoCabecalhos where cod_os1 = " + codOS; int getstate = Convert.ToInt32(sqlcommand.ExecuteScalar()); sqlcommand.Cancel(); Conection.DeskConection.Close(); return(getstate); } catch (Exception e) { LogWriteLine("CODE 168 FAIL TO GET THE STATE OF O.S " + codOS + " ERROR: " + e.Message); return(0); } }
/// <summary> /// Gets the last O.S and client code. Employee name and O.S state. /// </summary> private static void GetAllInfos() { Conection.DeskOpen(); MySqlCommand sqlcommand = sqlcommand = new MySqlCommand("", Conection.DeskConection); sqlcommand.CommandText = "SELECT cod_os1, usu_os1, cl1_os1, stc_os1 FROM v11_mafra.OpOrdensServicoCabecalhos order by cod_os1 desc limit 1"; using (MySqlDataReader datget = sqlcommand.ExecuteReader()) { datget.Read(); codOS = Convert.ToInt32(datget["cod_os1"]); //O.S code nomfun = datget["usu_os1"].ToString(); // employee name codcli = Convert.ToInt32(datget["cl1_os1"]); // cliente code osstate = Convert.ToInt32(datget["stc_os1"]); // O.S code state datget.Close(); } sqlcommand.Cancel(); Conection.DeskConection.Close(); }
/// <summary> /// Retorna a lista de emails disponíveis de um determinado cliente /// </summary> /// <returns></returns> public List <string> GetEmails() { Conection.DeskOpen(); List <string> listemails = new List <string>(); command = new MySqlCommand("SELECT ema_cl1, www_cl1 from v11_mafra.cadastrosclientesfornecedoresrepresentadastransportadoras WHERE id__cl1 = " + id_vip, Conection.DeskConection); string add1, add2, aux2; string[] aux; using (MySqlDataReader read = command.ExecuteReader()) { while (read.Read()) { if (!String.IsNullOrEmpty(read["ema_cl1"].ToString()) || !String.IsNullOrEmpty(read["www_cl1"].ToString())) { add1 = read["ema_cl1"].ToString(); add2 = read["www_cl1"].ToString(); aux = add1.Split(';'); foreach (string str in aux) { aux2 = str.Replace(" ", string.Empty); listemails.Add(aux2); } aux = add2.Split(';'); foreach (string str in aux) { aux2 = str.Replace(" ", string.Empty); listemails.Add(str); } } else { break; } } } Conection.DeskConection.Close(); return(listemails); }