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> /// Upload unfinished of file, getting your informations, and deleting it after the process finish /// </summary> /// <returns></returns> public static List <InformationOS> Load() { List <InformationOS> send = new List <InformationOS>(); if (File.Exists(AppDomain.CurrentDomain.BaseDirectory + @"\datawait")) { Service1.LogWriteLine("Getting storaged informations"); int codOS, codcli, osstate, cod_fun; string nomfun; using (StreamReader getdata = new StreamReader(AppDomain.CurrentDomain.BaseDirectory + @"\datawait")) { string line; while ((line = getdata.ReadLine()) != null) { if (line == "startof") { string[] split = getdata.ReadLine().Split('='); codcli = Convert.ToInt32(split[1]); split = getdata.ReadLine().Split('='); codOS = Convert.ToInt32(split[1]); split = getdata.ReadLine().Split('='); cod_fun = Convert.ToInt32(split[1]); split = getdata.ReadLine().Split('='); nomfun = split[1]; split = getdata.ReadLine().Split('='); osstate = Convert.ToInt32(split[1]); send.Add(new InformationOS(codOS, nomfun, codcli, osstate, cod_fun)); } } getdata.Close(); } try { File.Delete(AppDomain.CurrentDomain.BaseDirectory + @"\datawait"); } catch (Exception e) { Service1.LogWriteLine("FAIL TO DELETE PROVISORY FILE OF O.S STATEMENTS. ERROR:" + e.ToString()); } } return(send); }