protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string id = Request.QueryString["id"];
if (!string.IsNullOrEmpty(id))
{
indexManager index = new indexManager();
this.data = index.getproduct(id);
connectionManager baseurl = new connectionManager();
url = baseurl.getbasurl("image/product/");
while (data.Read())
{
deleteproduct.Value = id;
/*
* txtname.Text = data[data.GetOrdinal("title")].ToString();
* desc.Text = data[data.GetOrdinal("description")].ToString();
* img.ImageUrl = url + data[data.GetOrdinal("img")].ToString();
*
* price.Text = data[data.GetOrdinal("price")].ToString();
* stock.Text = data[data.GetOrdinal("stock")].ToString();
*/
}
}
}
}
public Rakt(string uname)
{
connectionManager cnt = new connectionManager();
user = new us();
InitializeComponent();
dataGridView1.ReadOnly = true;
dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
this.uname = uname;
dataGridView1.MultiSelect = false;
placeHolderTextBox1.setPlaceHolder("keresés név alapján");
string REGISTRY_KEY = @"HKEY_CURRENT_USER\GastroKer";
string REGISTRY_VALUE = cnt.keyValue;
if (Convert.ToInt32(Microsoft.Win32.Registry.GetValue(REGISTRY_KEY, REGISTRY_VALUE, 0)) == 0)
{
aru = new addRktUser(true);
cst = new connectionSetter();
cst.ShowDialog();
if (cst.DialogResult == DialogResult.OK)
{
if (cst.setCons() == 1)
{
Microsoft.Win32.Registry.SetValue(REGISTRY_KEY, REGISTRY_VALUE,
1, Microsoft.Win32.RegistryValueKind.DWord);
}
}
}
if (Convert.ToInt32(Microsoft.Win32.Registry.GetValue(REGISTRY_KEY, REGISTRY_VALUE, 0)) == 0)
{
this.Close();
}
}
public DBOperation()
{
cm = new connectionManager();
if (cm.readG() == null)
{
conG = "SERVER =\"localhost\";"
+ "DATABASE=\"gastro\";"
+ "UID=\"root\";"
+ "PASSWORD=\"\";"
+ "PORT=\"3306\";";
}
else
{
conG = cm.readG();
}
if (cm.readF() == null)
{
conF = "SERVER =\"localhost\";"
+ "DATABASE=\"felh\";"
+ "UID=\"root\";"
+ "PASSWORD=\"\";"
+ "PORT=\"3306\";";
}
else
{
conF = cm.readF();
}
}
public connectionSetter()
{
InitializeComponent();
cm = new connectionManager();
button1.DialogResult = DialogResult.OK;
placeHolderTextBox1.PlaceHolderText = "felhasználók adatbázis IP címe";
placeHolderTextBox2.PlaceHolderText = "Raktár adatbázis IP címe";
placeHolderTextBox3.PlaceHolderText = "adatbázis név Felhasználók számára";
placeHolderTextBox4.PlaceHolderText = "adatbázis név Raktár számára";
placeHolderTextBox5.PlaceHolderText = "adatbázis felhasználónév felhasználók számára";
placeHolderTextBox6.PlaceHolderText = "adatbázis felhasználónév Raktár számára";
placeHolderTextBox7.PlaceHolderText = "adatbázis jelszó felhasználók számára";
placeHolderTextBox8.PlaceHolderText = "adatbázis jelszó Raktár számára";
}
public string emailOfUser(string username)
{
string name = username;
string mail = "";
string con = "SERVER=\"localhost\";"
+ "DATABASE=\"felh\";"
+ "UID=\"root\";"
+ "PASSWORD=\"\";"
+ "PORT=\"3306\";";
connectionManager cm = new connectionManager();
con = cm.readF();
MySqlConnection connect = new MySqlConnection(con);
try
{
connect.Open();
}
catch (Exception e)
{
Debug.WriteLine(e.Message);
throw new Exception("Sikertelen adatbázismegnyitás.");
}
string query = "SELECT email from deskusers where username like '" + name + "'";
try
{
MySqlCommand cmd = new MySqlCommand(query, connect);
MySqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
mail = dr["email"].ToString();
}
}
catch (Exception e)
{
Debug.WriteLine(e.Message);
}
return(mail);
}
private void fillCustomersListFromDatabase()
{
connectionManager cm = new connectionManager();
/*d = new DBOperation();
* Adatbazis a = new Adatbazis();
* MySQLDatabaseInterface mdi = a.kapcsolodas();
* mdi.open();
* string query = "SELECT * FROM vevok ";
* = mdi.getToDataTable(query);
* mdi.close();*/
string query = "select * from vevok";
MySqlConnection con = new MySqlConnection(cm.readG());
con.Open();
MySqlCommand cmd = new MySqlCommand(query, con);
MySqlDataAdapter dp = new MySqlDataAdapter(cmd);
DataTable dtCustomer = new DataTable();
dp.Fill(dtCustomer);
foreach (DataRow row in dtCustomer.Rows)
{
int azon = Convert.ToInt32(row["azon"].ToString());
string nev = row["nev"].ToString();
int adoazon = Convert.ToInt32(row["adoazon"].ToString());
long banksz = Convert.ToInt64(row["banksz"].ToString());
long tel = Convert.ToInt64(row["tel"].ToString());
bool dolg = Convert.ToBoolean(row["dolg"].ToString());
bool torzs = Convert.ToBoolean(row["torzs"].ToString());
int vasmenny = Convert.ToInt32(row["vasmenny"].ToString());
string felh = row["felh"].ToString();
string jelsz = row["jelsz"].ToString();
string email = row["email"].ToString();
MDVevok v = new MDVevok(azon, nev, adoazon, banksz, tel, dolg, torzs, vasmenny, felh, jelsz, email);
customers.Add(v);
}
}
public string getRights(string uname)
{
string con = "SERVER=\"localhost\";"
+ "DATABASE=\"felh\";"
+ "UID=\"root\";"
+ "PASSWORD=\"\";"
+ "PORT=\"3306\";";
connectionManager cm = new connectionManager();
con = cm.readF();
MySqlConnection connect = new MySqlConnection(con);
try
{
connect.Open();
}
catch (Exception e)
{
Debug.WriteLine(e.Message);
throw new Exception("Sikertelen adatbázismegnyitás.");
}
string priv = "";
string query = "SELECT jog from deskusers where username='******'";
MySqlCommand cmd = new MySqlCommand(query, connect);
MySqlDataReader dr = cmd.ExecuteReader();
string remelemnemures = string.Empty;
try
{
while (dr.Read())
{
priv = dr["jog"].ToString();
}
}
catch (Exception e)
{
Debug.WriteLine(e.Message);
}
return(priv);
}
public void reduceTermekek(string vevoNev)
{
/*try
* {*/
MySqlConnection connect = new MySqlConnection(conG);
connect.Open();
string query = "";
MySqlCommand cm = new MySqlCommand(query, connect);
cm = new MySqlCommand(query, connect);
vevoNev = '"' + vevoNev + '"';
increaseVasMenny(vevoNev);
query = "call szamla(" + vevoNev + ");";
cm = new MySqlCommand(query, connect);
cm.ExecuteNonQuery();
query = "call mozgatas(" + vevoNev + ");";
cm = new MySqlCommand(query, connect);
cm.ExecuteNonQuery();
query = "UPDATE `szamlatetel` SET nyomtatvae=1 WHERE szamlatetel.vevo=" + vevoNev + "";
cm = new MySqlCommand(query, connect);
cm.ExecuteNonQuery();
if (has550BoughtItems(vevoNev))
{
query = "UPDATE `vevok` SET `torzs`=true WHERE felh=" + vevoNev + "";
}
/*}
* catch(Exception e) { MessageBox.Show("hiba történt az adatok mozgatása közben: "+e.Message+""); return; }*/
}
public int belep(string username, string password)
{
string uname = username;
string pw = password;
string RealPW = null;
string con = "SERVER=\"localhost\";"
+ "DATABASE=\"felh\";"
+ "UID=\"root\";"
+ "PASSWORD=\"\";"
+ "PORT=\"3306\";";
connectionManager cm = new connectionManager();
con = cm.readF();
MySqlConnection connect = new MySqlConnection(con);
try
{
connect.Open();
}
catch (Exception e)
{
Debug.WriteLine(e.Message);
throw new Exception("Sikertelen adatbázismegnyitás.");
}
string query = "SELECT password from deskusers where username='******'";
MySqlCommand cmd = new MySqlCommand(query, connect);
MySqlDataReader dr = cmd.ExecuteReader();
string remelemnemures = string.Empty;
try
{
while (dr.Read())
{
RealPW = dr["password"].ToString();
remelemnemures = RealPW;
}
}
catch (Exception e)
{
Debug.WriteLine(e.Message);
}
/*
* hibakódok:
* 0: minden jó
* 1: nem jó jelszó
* 2: nincs ilyen felhasználónév
* 3: üres jelszó mező
* 4: üres felhasználónév
*/
if (uname == null)
{
return(4);
}
if (RealPW != null)
{
if (RealPW == pw)
{
return(0);
}
}
if (string.IsNullOrEmpty(password))
{
return(3);
}
if (string.IsNullOrEmpty(remelemnemures))
{
return(2);
}
if (RealPW != pw)
{
return(1);
}
return(0);
}
public ClienteService(string Connectionstrings)
{
_conexion = new connectionManager(Connectionstrings);
_repositorio = new PacienteRepository(_conexion);
}
private void button1_Click(object sender, EventArgs e)
{
u = new us();;
connectionManager cnt = new connectionManager();
string REGISTRY_KEY = @"HKEY_CURRENT_USER\GastroKer";
string REGISTRY_VALUE = cnt.keyValue;
if (Convert.ToInt32(Microsoft.Win32.Registry.GetValue(REGISTRY_KEY, REGISTRY_VALUE, 0)) == 0)
{
if (textBox1.Text == "admin" && textBox2.Text == "admin")
{
Rakt rkt = new Rakt("admin");
return;
}
}
if (textBox1.Text == "" || textBox1.Text == null)
{
uname.SetError(textBox1, "üres felhasználónév mező");
}
else
{
if (u.belep(textBox1.Text, textBox2.Text) == 0)
{
rakt = new Rakt(textBox1.Text);
try
{
rakt.Show();
}
catch { return; }
}
if (u.belep(textBox1.Text, textBox2.Text) == 1)
{
pw.SetError(textBox2, "helytelen jelszó");
}
else
{
pw.Clear();
pw.SetError(textBox2, "");
}
if (u.belep(textBox1.Text, textBox2.Text) == 2)
{
uname.SetError(textBox1, "nincs ilyen felhasználónév");
}
else
{
uname.Clear();
uname.SetError(textBox1, "");
}
if (u.belep(textBox1.Text, textBox2.Text) == 3)
{
pw.SetError(textBox2, "üres jeszó mező");
}
else
{
pw.Clear();
pw.SetError(textBox2, "");
}
}
}
