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();
}