internal void updateNewToken(LoginModel login) { try { mysql.Open(); MySqlCommand cmd = new MySqlCommand(); cmd.Connection = mysql.mysqlConnection; string qry = ""; qry += "update myApi.Users "; qry += " set token=@TOKEN "; qry += ", exipre_timestamp=@EXPIRETIME "; qry += "where Username=@USERNAME and "; qry += " Password=@PASSWORD; "; cmd.CommandText = qry; cmd.Prepare(); cmd.Parameters.AddWithValue("@TOKEN", login.Token); cmd.Parameters.AddWithValue("@EXPIRETIME", DateTime.Now.AddDays(1)); cmd.Parameters.AddWithValue("@USERNAME", login.Username); cmd.Parameters.AddWithValue("@PASSWORD", login.Password); mysql.GoSql(cmd); } catch (Exception ex) { throw new Exception(ex.Message); } finally { mysql.Close(); } }
public static void Insert(ModelFullApplicant data) //javított { MySqlDB mySql = new MySqlDB(); string command = "INSERT INTO jeloltek (`id`, `nev`, `email`, `telefon`, `lakhely`, `ertesult`, `szuldatum`, neme, `tapasztalat_ev`, `munkakor`, `munkakor2`, `munkakor3`, `vegz_terulet`, `nyelvtudas`,`nyelvtudas2`, `reg_date`) " + "VALUES(NULL, '" + data.nev + "', '" + data.email + "', '" + data.telefon + "', '" + data.lakhely + "', " + data.ertesult + ", " + data.szuldatum + ", " + data.neme + "," + data.tapasztalat_ev + "," + data.munkakor + "," + data.munkakor2 + "," + data.munkakor3 + "," + data.vegz_terulet + "," + data.nyelvtudas + "," + data.nyelvtudas2 + ",'" + data.reg_date + "');"; mySql.Execute(command); command = "SELECT jeloltek.id FROM jeloltek WHERE jeloltek.email = '" + data.email + "' AND jeloltek.nev = '" + data.nev + "'"; mySql.Close(); Session.ApplicantID = Convert.ToInt16(mySql.UniqueList(command, "jeloltek", 1)[0]); mySql.Close(); }
public void AddRecruitedToProject(int projekt_index) { MySqlDB mySql = new MySqlDB(); string command = "SELECT * FROM projekt_jelolt_kapcs WHERE jelolt_id = " + data.id + " AND projekt_id = " + projekt_index + ""; if (!mySql.IsExists(command)) { mySql.Close(); command = "INSERT INTO projekt_jelolt_kapcs_kulsos (id, projekt_id, jelolt_id, datum) VALUES (NULL, " + projekt_index + ", " + data.id + ", '" + DateTime.Now.ToString("yyyy.MM.dd") + "' );"; mySql.Execute(command); } mySql.Close(); }
public static List <ModelFreelancerApplicant> GetModelFreelancerApplicantList(string command) { List <ModelFreelancerApplicant> list = new List <ModelFreelancerApplicant>(); MySqlDB mySql = new MySqlDB(); if (mySql.Open() == true) { mySql.cmd = new MySqlCommand(command, mySql.conn); mySql.sdr = mySql.cmd.ExecuteReader(); while (mySql.sdr.Read()) { list.Add(new ModelFreelancerApplicant { id = Convert.ToInt32(mySql.sdr["id"]), nev = mySql.sdr["nev"].ToString(), email = mySql.sdr["email"].ToString(), freelancername = mySql.sdr["freelancername"].ToString(), lakhely = mySql.sdr["lakhely"].ToString(), szuldatum = Convert.ToInt32(mySql.sdr["szuldatum"]), project_db = Convert.ToInt32(mySql.sdr["project_db"]), kategoria = Convert.ToInt32(mySql.sdr["kategoria"]), bekuldo = Convert.ToInt32(mySql.sdr["bekuldo"]), reg_datum = mySql.sdr["reg_date"].ToString() }); } mySql.sdr.Close(); } mySql.Close(); return(list); }
public List <ModelErrorLog> Get(string command) { MySqlDB mySql = new MySqlDB(); List <ModelErrorLog> list = new List <ModelErrorLog>(); if (mySql.Open() == true) { mySql.cmd = new MySqlCommand(command, mySql.conn); mySql.sdr = mySql.cmd.ExecuteReader(); int j = 0; while (mySql.sdr.Read()) { list.Add(new ModelErrorLog { id = (Convert.ToInt32(mySql.sdr["id"])), placeofbug = mySql.sdr["placeofbug"].ToString(), description = mySql.sdr["description"].ToString(), solution = mySql.sdr["solution"].ToString(), date = mySql.sdr["date"].ToString(), result = mySql.sdr["result"].ToString(), resultdate = mySql.sdr["resultdate"].ToString() }); j++; } mySql.sdr.Close(); } mySql.Close(); return(list); }
public static List <ModelSmallProject> GetModelSmallProject(string command) { List <ModelSmallProject> list = new List <ModelSmallProject>(); MySqlDB mySql = new MySqlDB(); if (mySql.Open() == true) { mySql.cmd = new MySqlCommand(command, mySql.conn); mySql.sdr = mySql.cmd.ExecuteReader(); int j = 0; while (mySql.sdr.Read()) { list.Add(new ModelSmallProject { id = Convert.ToInt32(mySql.sdr["id"]), megnevezes_projekt = mySql.sdr["megnevezes_projekt"].ToString(), jeloltek_db = 0 }); j++; } mySql.sdr.Close(); } mySql.Close(); return(list); }
public static List <ModelTamogatas> GetModelTamogatas(string command) { MySqlDB mySql = new MySqlDB(); List <ModelTamogatas> list = new List <ModelTamogatas>(); if (mySql.Open() == true) { try { mySql.cmd = new MySqlCommand(command, mySql.conn); mySql.sdr = mySql.cmd.ExecuteReader(); while (mySql.sdr.Read()) { list.Add(new ModelTamogatas { tamogatom = Convert.ToInt32(mySql.sdr["tamogatom"]), }); } } catch (Exception) { } mySql.sdr.Close(); } mySql.Close(); return(list); }
public static void Update(ModelFullApplicant data) //javított { MySqlDB mySql = new MySqlDB(); string query = "UPDATE jeloltek SET " + " `nev` = '" + data.nev + "'" + ", `email` = '" + data.email + "'" + ", `telefon` = '" + data.telefon + "'" + ", `lakhely` = '" + data.lakhely + "'" + ", `ertesult` = " + data.ertesult + "" + ", `szuldatum` = '" + data.szuldatum + "'" + ", `neme` = " + data.neme + "" + ", `tapasztalat_ev` = " + data.tapasztalat_ev + "" + ", `munkakor` = " + data.munkakor + "" + ", `munkakor2` = " + data.munkakor2 + "" + ", `munkakor3` = " + data.munkakor3 + "" + ", `vegz_terulet` = " + data.vegz_terulet + "" + ", `nyelvtudas` = " + data.nyelvtudas + "" + ",`nyelvtudas2` = " + data.nyelvtudas2 + "" + ", `reg_date` = '" + data.reg_date + "'" + "WHERE jeloltek.id = " + Session.ApplicantID + ""; mySql.Execute(query); int appID = Convert.ToInt16(mySql.UniqueList("SELECT jeloltek.id FROM jeloltek WHERE jeloltek.email = '" + data.email + "' AND jeloltek.nev = '" + data.nev + "' AND jeloltek.lakhely = '" + data.lakhely + "'", "jeloltek", 1)[0]); Session.ApplicantID = appID; mySql.Close(); }
public static void DeleteApplicant(int id, bool recruited = false) //javított használja: applicantlist { MySqlDB mySql = new MySqlDB(); string command = "DELETE FROM jeloltek WHERE jeloltek.id = " + id + ";"; mySql.Execute(command); command = "DELETE FROM kepessegek WHERE kepessegek.jelolt_id = " + id + ";"; mySql.Execute(command); if (recruited) { command = "DELETE FROM projekt_jelolt_kapcs_kulsos WHERE projekt_jelolt_kapcs_kulsos.jelolt_id = " + id + ";"; mySql.Execute(command); } else { command = "DELETE FROM projekt_jelolt_kapcs WHERE projekt_jelolt_kapcs.jelolt_id = " + id + ";"; mySql.Execute(command); } command = "DELETE FROM megjegyzesek WHERE megjegyzesek.jelolt_id = " + id + ";"; mySql.Execute(command); mySql.Close(); try{ Files.DeleteFolder(id); } catch { } }
public List <ModelSzakmaiInterviewIgeny> Get(string command) { List <ModelSzakmaiInterviewIgeny> list = new List <ModelSzakmaiInterviewIgeny>(); MySqlDB mySql = new MySqlDB(); if (mySql.Open() == true) { mySql.cmd = new MySqlCommand(command, mySql.conn); mySql.sdr = mySql.cmd.ExecuteReader(); while (mySql.sdr.Read()) { list.Add(new ModelSzakmaiInterviewIgeny { id = (Convert.ToInt32(mySql.sdr["id"])), jelolt_id = (Convert.ToInt32(mySql.sdr["jelolt_id"])), user_id = (Convert.ToInt32(mySql.sdr["user_id"])), projekt_id = (Convert.ToInt32(mySql.sdr["projekt_id"])), state = (Convert.ToInt32(mySql.sdr["state"])) }); } mySql.sdr.Close(); } mySql.Close(); return(list); }
public static List <ModelComment> GetModelComment(string command) { MySqlDB mySql = new MySqlDB(); List <ModelComment> list = new List <ModelComment>(); if (mySql.Open() == true) { mySql.cmd = new MySqlCommand(command, mySql.conn); mySql.sdr = mySql.cmd.ExecuteReader(); while (mySql.sdr.Read()) { list.Add(new ModelComment { id = Convert.ToInt32(mySql.sdr["id"]), jelolt_id = Convert.ToInt32(mySql.sdr["jelolt_id"]), projekt_id = Convert.ToInt32(mySql.sdr["projekt_id"]), hr_id = Convert.ToInt32(mySql.sdr["hr_id"]), hr_nev = mySql.sdr["hr_nev"].ToString(), megjegyzes = mySql.sdr["megjegyzes"].ToString(), datum = mySql.sdr["datum"].ToString(), }); } mySql.sdr.Close(); } mySql.Close(); return(list); }
public static List <ModelErtesitendok> GetModelErtesitendok(string command) { MySqlDB mySql = new MySqlDB(); List <ModelErtesitendok> list = new List <ModelErtesitendok>(); if (mySql.Open() == true) { mySql.cmd = new MySqlCommand(command, mySql.conn); mySql.sdr = mySql.cmd.ExecuteReader(); while (mySql.sdr.Read()) { list.Add(new ModelErtesitendok { id = Convert.ToInt32(mySql.sdr["id"]), name = mySql.sdr["name"].ToString(), email = mySql.sdr["email"].ToString(), kategoria = Convert.ToInt32(mySql.sdr["kategoria"]), jogosultsag = Convert.ToInt32(mySql.sdr["jogosultsag"]), validitas = Convert.ToInt32(mySql.sdr["validitas"]), }); } mySql.sdr.Close(); } mySql.Close(); return(list); }
public void insertWeb(MySqlDB mySql) { string command = "INSERT INTO `freelancer_list`(`id`, `name`, `email`) VALUES (" + id + ",'" + name + "','" + email + "')"; mySql.Execute(command); mySql.Close(); }
void Start() { try { MySqlDB mysql = new MySqlDB(); //mysql.CreateTableAutoID("momo",new string[]{"id","name","qq","email","blog"}, new string[]{"int","text","text","text","text"}); //mysql.InsertInto("momo",new string[]{"name","qq","email","blog"},new string[]{"xuanyusong","289187120","*****@*****.**","xuanyusong.com"}); //mysql.InsertInto("momo",new string[]{"name","qq","email","blog"},new string[]{"ruoruo","34546546","*****@*****.**","xuanyusong.com"}); //DataSet ds = mysql.SelectWhere("momo",new string[]{"name","qq"},new string []{"id"},new string []{"="},new string []{"1"}); DataTable dt = mysql.SelectLimitLines("momo",0,100); if(dt != null) { foreach (DataRow row in dt.Rows) { foreach (DataColumn column in dt.Columns) { Debug.Log(row[column]); } } } //mysql.UpdateInto("momo",new string[]{"name","qq"},new string[]{"'ruoruo'","'11111111'"}, "email", "'*****@*****.**'" ); //mysql.Delete("momo",new string[]{"id","email"}, new string[]{"1","'*****@*****.**'"} ); mysql.Close(); }catch(Exception e) { Error = e.Message; } }
public List <ModelUserData> Data_UserSession(string username) //javítva használja: login { MySqlDB mySql = new MySqlDB(); MySqlDataReader sdr; List <ModelUserData> list = new List <ModelUserData>(); if (mySql.Open() == true) { mySql.cmd = new MySqlCommand("SELECT * FROM users WHERE username='******'", mySql.conn); sdr = mySql.cmd.ExecuteReader(); while (sdr.Read()) { list.Add(new ModelUserData { id = Convert.ToInt32(sdr["id"]), username = sdr["username"].ToString(), name = sdr["name"].ToString(), email = sdr["email"].ToString(), kategoria = Convert.ToInt32(sdr["kategoria"]), jogosultsag = Convert.ToInt32(sdr["jogosultsag"]), validitas = Convert.ToInt32(sdr["validitas"]), belepve = sdr["belepve"].ToString(), reg_datum = sdr["reg_datum"].ToString(), }); } sdr.Close(); } mySql.Close(); return(list); }
public List <ModelProfession> Get(string command) { MySqlDB mySql = new MySqlDB(); List <ModelProfession> list = new List <ModelProfession>(); if (mySql.Open() == true) { mySql.cmd = new MySqlCommand(command, mySql.conn); mySql.sdr = mySql.cmd.ExecuteReader(); while (mySql.sdr.Read()) { list.Add(new ModelProfession { id = Convert.ToInt32(mySql.sdr["id"]), name = mySql.sdr["nev"].ToString(), email = mySql.sdr["email"].ToString(), telephone = mySql.sdr["telefon"].ToString(), reg_date = mySql.sdr["reg_date"].ToString(), projekt = mySql.sdr["projekt"].ToString(), }); } mySql.sdr.Close(); } mySql.Close(); return(list); }
public static List <ModelKompetenciaSummary> GetModelKompetenciaSummary(string command) { MySqlDB mySql = new MySqlDB(); List <ModelKompetenciaSummary> list = new List <ModelKompetenciaSummary>(); if (mySql.Open() == true) { try { mySql.cmd = new MySqlCommand(command, mySql.conn); mySql.sdr = mySql.cmd.ExecuteReader(); while (mySql.sdr.Read()) { list.Add(new ModelKompetenciaSummary { k1_val = Convert.ToInt32(mySql.sdr["k1_val"]), k2_val = Convert.ToInt32(mySql.sdr["k2_val"]), k3_val = Convert.ToInt32(mySql.sdr["k3_val"]), k4_val = Convert.ToInt32(mySql.sdr["k4_val"]), k5_val = Convert.ToInt32(mySql.sdr["k5_val"]), tamogatom = Convert.ToInt32(mySql.sdr["tamogatom"]), }); } } catch (Exception) { } mySql.sdr.Close(); } mySql.Close(); return(list); }
public static ModelStat GetModelStat1(string from, string to) { //web db-ből string command = @"SELECT projektek.megnevezes_projekt, count(regisztraltak.email) FROM regisztraltak LEFT JOIN projektek on projektek.id = regisztraltak.projekt_id WHERE regisztraltak.reg_date > '2019.03.10' AND regisztraltak.reg_date < '2019.03.18' GROUP BY projektek.megnevezes_projekt"; MySqlDB mySql = new MySqlDB(); ModelStat data = new ModelStat(); if (mySql.Open() == true) { mySql.cmd = new MySqlCommand(command, mySql.conn); mySql.sdr = mySql.cmd.ExecuteReader(); while (mySql.sdr.Read()) { data = (new ModelStat { szerelo = Convert.ToInt32(mySql.sdr["szerelo"]), raktar = Convert.ToInt32(mySql.sdr["raktar"]), qs = Convert.ToInt32(mySql.sdr["qs"]), szellemi = Convert.ToInt32(mySql.sdr["szellemi"]), date = from + " - " + to }); } mySql.sdr.Close(); } mySql.Close(); return(data); }
public static void Update(ModelInsertProject data) // javított newprojectpanel { MySqlDB mySql = new MySqlDB(); string command = "UPDATE projektek SET " + " `hr_id` = " + data.hr_id + ", " + "`megnevezes_projekt` = '" + data.megnevezes_projekt + "', " + " `pc` = " + data.pc + ", " + "`vegzettseg` = " + data.vegzettseg + ", " + "`tapasztalat_ev` = " + data.tapasztalat_ev + ", " + "`statusz` = " + data.statusz + ", " + "`nyelvtudas` = " + data.nyelvtudas + ", " + "`munkakor` = " + data.munkakor + ", " + "`szuldatum` = " + data.szuldatum + ", " + "`ber` = " + data.ber + ", " + "`kepesseg1` = " + data.kepesseg1 + ", " + "`kepesseg2` = " + data.kepesseg2 + ", " + "`kepesseg3` = " + data.kepesseg3 + ", " + "`kepesseg4` = " + data.kepesseg4 + ", " + "`kepesseg5` = " + data.kepesseg5 + " WHERE id = " + Session.ProjektID + ""; mySql.Execute(command); int proID = Convert.ToInt16(mySql.UniqueList("SELECT projektek.id FROM projektek WHERE projektek.megnevezes_projekt = '" + data.megnevezes_projekt + "' AND projektek.pc = " + data.pc + " AND projektek.munkakor = '" + data.munkakor + "'", "projektek", 1)[0]); Session.ProjektID = proID; mySql.Close(); }
public List <ModelApplicantSzakmaiList> Get(string command) { List <ModelApplicantSzakmaiList> list = new List <ModelApplicantSzakmaiList>(); MySqlDB mySql = new MySqlDB(); if (mySql.Open() == true) { mySql.cmd = new MySqlCommand(command, mySql.conn); mySql.sdr = mySql.cmd.ExecuteReader(); while (mySql.sdr.Read()) { string color = "White"; string label = "-"; if (Convert.ToInt32(mySql.sdr["state"]) == 1) { label = "Behívott"; color = "#e6ffe6"; } list.Add(new ModelApplicantSzakmaiList { id = (Convert.ToInt32(mySql.sdr["id"])), nev = mySql.sdr["nev"].ToString(), state = (Convert.ToInt32(mySql.sdr["state"])), color = color, label = label }); } mySql.sdr.Close(); } mySql.Close(); return(list); }
public void projectDescriptionUpdate(string type, string content) // javított { MySqlDB mySql = new MySqlDB(); string command = ""; switch (type) { case "feladatok": command = "UPDATE projektek SET feladatok='" + content + "' WHERE projektek.id = " + Session.ProjektID + ""; break; case "elvarasok": command = "UPDATE projektek SET elvarasok='" + content + "' WHERE projektek.id = " + Session.ProjektID + ""; break; case "kinalunk": command = "UPDATE projektek SET kinalunk='" + content + "' WHERE projektek.id = " + Session.ProjektID + ""; break; case "elonyok": command = "UPDATE projektek SET elonyok='" + content + "' WHERE projektek.id = " + Session.ProjektID + ""; break; default: break; } mySql.Execute(command); mySql.Close(); }
public static List <MailData> GetMails() { List <MailData> list = new List <MailData>(); MySqlDB mySql = new MySqlDB(); if (mySql.Open() == true) { string command = "SELECT * FROM email_storage WHERE state=0"; mySql.cmd = new MySqlCommand(command, mySql.conn); mySql.sdr = mySql.cmd.ExecuteReader(); while (mySql.sdr.Read()) { list.Add(new MailData { id = Convert.ToInt32(mySql.sdr["id"]), to = mySql.sdr["to"].ToString(), subject = mySql.sdr["subject"].ToString(), content = mySql.sdr["content"].ToString(), hr_id = Convert.ToInt32(mySql.sdr["hr_id"]), state = Convert.ToInt32(mySql.sdr["state"]), date = mySql.sdr["date"].ToString() }); } mySql.sdr.Close(); mySql.Close(); } return(list); }
public int Fullify(ModelProfession prof) { MySqlDB mySql = new MySqlDB(); string command = "INSERT INTO jeloltek (nev,email,telefon,reg_date" + (!prof.szuldatum.Equals("") ? ",szuldatum" : "") + (!prof.lakhely.Equals("") ? ",lakhely" : "") + (!prof.neme.Equals(9999) ? ",neme": "") + (!prof.vegzettseg.Equals(9999) ? ",vegz_terulet" : "") + (!prof.nyelvtudas.Equals(9999) ? ",nyelvtudas" : "") + (!prof.ertesult.Equals(9999) ? ",ertesult" : "") + ") VALUES ('" + prof.name + "','" + prof.email + "','" + prof.telephone + "','" + prof.reg_date + "'" + (!prof.szuldatum.Equals("") ? ",'" + prof.szuldatum.ToString() + "'" : "") + (!prof.lakhely.Equals("") ? ",'" + prof.lakhely.ToString() + "'" : "") + (!prof.neme.Equals(9999) ? "," + prof.neme.ToString() : "") + (!prof.vegzettseg.Equals(9999) ? "," + prof.vegzettseg.ToString() : "") + (!prof.nyelvtudas.Equals(9999) ? "," + prof.nyelvtudas.ToString() : "") + (!prof.ertesult.Equals(9999) ? "," + prof.ertesult.ToString() : "") + ")"; mySql.Execute(command); mySql.Close(); ModelFullApplicant udata = Applicant.GetFullApplicantByEmail(prof.email); DirectoryInfo profession = new DirectoryInfo(Files.GetStatisticsUrl() + prof.id); DirectoryInfo newID = new DirectoryInfo(Files.GetApplicantUrl() + udata.id); Files.CopyAll(profession, newID); Delete(prof.id); return(udata != null ? udata.id : 0); }
public static List <ModelInterview> GetSzakmaiInterview(string command) { MySqlDB mySql = new MySqlDB(); List <ModelInterview> list = new List <ModelInterview>(); if (mySql.Open() == true) { mySql.cmd = new MySqlCommand(command, mySql.conn); mySql.sdr = mySql.cmd.ExecuteReader(); while (mySql.sdr.Read()) { list.Add(new ModelInterview { id = Convert.ToInt32(mySql.sdr["id"]), projekt_megnevezes = mySql.sdr["megnevezes_projekt"].ToString(), projekt_id = Convert.ToInt32(mySql.sdr["projekt_id"]), jelolt_id = Convert.ToInt32(mySql.sdr["jelolt_id"]), jelolt_megnevezes = mySql.sdr["nev"].ToString(), date_start = mySql.sdr["date_start"].ToString(), time_start = mySql.sdr["time_start"].ToString(), time_end = mySql.sdr["time_end"].ToString(), interju_cim = mySql.sdr["interju_cim"].ToString(), helyszin = mySql.sdr["helyszin"].ToString(), }); } mySql.sdr.Close(); } mySql.Close(); return(list); }
public void publishProject(int stat) { MySqlDB mySql = new MySqlDB(); string command = "UPDATE projektek SET publikalt= " + stat + " WHERE projektek.id = " + Session.ProjektID + ";"; mySql.Execute(command); mySql.Close(); }
public void ertesitendokKapcsDelete(int id) { MySqlDB mySql = new MySqlDB(); string command = "DELETE FROM projekt_ertesitendok_kapcs WHERE ertesitendok_id = " + id + " AND projekt_id = " + Session.ProjektID + ";"; mySql.Execute(command); mySql.Close(); }
public void jeloltKapcsUpdate(int id, int allapota) { MySqlDB mySql = new MySqlDB(); string command = "UPDATE projekt_jelolt_kapcs SET allapota = " + allapota + " WHERE jelolt_id = " + id + " AND projekt_id = " + Session.ProjektID + ";"; mySql.Execute(command); mySql.Close(); }
public void projectCostDelete(int id) // javított { MySqlDB mySql = new MySqlDB(); string command = "DELETE FROM projekt_koltsegek WHERE projekt_koltsegek.id = " + id + ""; mySql.Execute(command); mySql.Close(); }
public void projectCostInsert(string megnevezes, string osszeg) // javított { MySqlDB mySql = new MySqlDB(); string command = "INSERT INTO `projekt_koltsegek` (id, projekt_id, koltseg_megnevezes, osszeg) VALUES (null, " + Session.ProjektID + ", '" + megnevezes + "', " + osszeg + ");"; mySql.Execute(command); mySql.Close(); }
public void Delete(int id) { MySqlDB mySql = new MySqlDB(); string command = "DELETE FROM pmkcvtest.errorlog WHERE id =" + id; mySql.Execute(command); mySql.Close(); }
public void Update(ModelErrorLog data) { MySqlDB mySql = new MySqlDB(); string command = "UPDATE pmkcvtest.errorlog SET placeofbug='" + data.placeofbug + "', description='" + data.description + "', solution='" + data.solution + "', date='" + data.date + "', result='" + data.result + "', resultdate='" + data.resultdate + "'"; mySql.Execute(command); mySql.Close(); }