private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
var dbContext = new OLXDataContext();
comboBox2.Items.Clear();
var judet = comboBox1.Text;
var id_judet = from o in dbContext.DB_RO_COUNTies
where o.NUME_JUDET.ToString() == judet.ToString()
select o.ID;
var result = from o in dbContext.DB_RO_CITies
join j in dbContext.DB_RO_COUNTies
on o.ID_JUDET equals j.ID
where j.NUME_JUDET == judet.ToString()
select o.NUME_ORAS;
foreach (var item in result)
{
comboBox2.Items.AddRange(new object[] { item.ToString() });
}
ComboBox c = (ComboBox)sender;
JUDET = c.Text;
}
private void button1_Click(object sender, EventArgs e)
{
var context = new OLXDataContext();
var result = from u in context.DB_USERs
where u.ID == Program.OLXusername
select u.ID;
List <string> t = new List <string>();
foreach (var item in result)
{
t.Add(item.ToString());
}
if (t.Count != 0)//e in DB_USERS
{
if (USER == Program.OLXusername)
{
ListaConversatii list = new ListaConversatii();
list.Show();
}
else
{
CasutaChat chat = new CasutaChat(Program.OLXusername, USER);
chat.Show();
}
}
else
{
Login log = new Login("CHAT", USER);
log.Show();
}
}
public bool RegisterPageTRANSACTION(string email, string nume, string oras, string telefon, string judet, string parola)
{
///////////////////////////////////////////////////////////////////////////////
using (TransactionScope trans = new TransactionScope())
{
var context = new OLXDataContext();
var res = from u in context.DB_USERs
where u.NUME.ToString() == email
select new { u.ID };
List <string> temp = new List <string>();
foreach (var item in temp)
{
temp.Add(item.ToString());
}
if (temp.Count != 0)
{
return(false);//exista contul
}
context.tranSignIn(email, nume, telefon, judet, oras, parola);
context.SubmitChanges();
this.Close();
Login l = new Login();
l.Show();
trans.Complete();
return(true);
}
//////////////////////////////////////////////////////////////////////////////////////
}
private void buttonSend_Click(object sender, EventArgs e)
{
var context = new OLXDataContext();
context.spSendMesaj(eu, el, richTextBox1.Text.ToString());
dataGridViewMesaje.Refresh();
}
public RegisterPagePage()
{
InitializeComponent();
var context = new OLXDataContext();
var result1 = from j in context.DB_RO_COUNTies
select j.NUME_JUDET;
foreach (var item in result1)
{
if (item.ToString() == "Toata tara")
{
continue;
}
comboBoxJudete.Items.AddRange(new object[] { item.ToString() });
}
var result2 = from o in context.DB_RO_CITies
select o.NUME_ORAS;
foreach (var item in result2)
{
if (item.ToString() == "Toata tara")
{
continue;
}
comboBoxOrase.Items.AddRange(new object[] { item.ToString() });
}
}
static public void load_LogOutButton()
{
var dbContext = new OLXDataContext();
var login = from l in dbContext.DB_LOGINs
where l.ID_USER == Program.OLXusername
select l.ID_USER;
List <string> temp = new List <string>();
foreach (var item in login)
{
temp.Add(item.ToString());
}
if (temp.Count != 0)//buton de log out
{
Label lbnume = new Label();
lbnume.Text = "Bine ai venit, " + Program.OLXusername;
lbnume.Top = 3;
lbnume.Left = 3;
MainPage.panel3.Controls.Add(lbnume);
Button btnLogOut = new Button();
btnLogOut.Left = 3;
btnLogOut.Top = 29;
btnLogOut.Text = "Log Out";
btnLogOut.Width = 114;
btnLogOut.Height = 23;
MainPage.panel3.Controls.Add(btnLogOut); //here
btnLogOut.Click += buttonLogOut_Click;
}
}
static public void buttonLogOut_Click(object sender, EventArgs e)
{
var dbContext = new OLXDataContext();
var result = from u in dbContext.DB_LOGINs
where u.DATA_DELOGAT == null
select new { u.ID_USER };
bool este = false;
foreach (var item in result)
{
if (item.ID_USER.ToString().Equals(Program.OLXusername))
{
este = true;
break;
}
}
if (este == true)
{
dbContext.tranLogOut(Program.OLXusername);
Program.OLXusername = Program.getRandomUserID(16);
MessageBox.Show("V-ati delogat");
OLX.MainPage.hide_LogOutButton();
}
}
public ListaConversatii()
{
InitializeComponent();
label2.Text = Program.OLXusername;
panel1.Visible = true;
int Y = 7, i = 0;
int left = 12, top = 7;
//List<string> conversatii = new List<string>();
//var chats = context.spGetChatsList(Program.OLXusername);
//foreach (var item in chats)
//{
// conversatii.Add(item.ToString());
//}
var context = new OLXDataContext();
var results = from c in context.ACCOUNT_MESSAGEs
where c.ID_USER_CURENT == Program.OLXusername
select new
{
c.ID_USER_CURENT,
c.ID_USER_DESTINATAR,
c.MESAJ
};
//foreach(var persoana in conversatii)
foreach (var index in results)
{
Button button = new Button();
button.Left = left;
button.Top = top;
MaskedTextBox mask = new MaskedTextBox();
mask.Left = left + button.Width + 30;
mask.Top = top;
button.Width = 100;
button.Text = index.ID_USER_CURENT.ToString();
panel1.Controls.Add(button); //here
button.Click += buttonConversatie_Click;
//mask.Text = context.spGetLastMessage(Program.OLXusername, persoana.ToString()).ToString();
mask.Text = index.MESAJ;
mask.Width = 300;
panel1.Controls.Add(mask);
if ((i + 1) % 3 != 0)
{
top += button.Height + 4;
}
else
{
left += button.Width + 4;
top = Y;
}
i++;
}
}
public bool LoginPageTRANSACTION(string email, string hash_parola)
{
///////////////////////////////////////////////////////////////////////////////
using (TransactionScope trans = new TransactionScope())
{
var context = new OLXDataContext();
string parolaBD = "";
var rez = from ps in context.DB_PASSWORDs
select new { ps.PAROLA, ps.ID_USER };
foreach (var item in rez)
{
if (item.ID_USER == email)
{
parolaBD = item.PAROLA.ToString();
}
}
if (parolaBD != hash_parola)
{
MessageBox.Show("Email sau parola gresita", "EROARE", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
var log = from l in context.DB_LOGINs
where l.ID_USER == email
select l.ID_USER;
List <string> temp = new List <string>();
foreach (var item in log)
{
temp.Add(item.ToString());
}
if (temp.Count != 0)
{
var log1 = from l in context.DB_LOGINs
where l.ID_USER == email
select l.DATA_DELOGAT;
List <string> temp1 = new List <string>();
foreach (var item in log1)
{
temp1.Add(item.ToString());
}
if (temp1.Count == 0)
{
MessageBox.Show("Sunteti deja conectat", "ATENTIE", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return(false);
}
}
context.tranLogIn(email, hash_parola);
context.SubmitChanges();
this.Close();
trans.Complete();
return(true);
}
//////////////////////////////////////////////////////////////////////////////////////
}
private void buttonSearch_Click(object sender, EventArgs e)
{
var dbContext = new OLXDataContext();
if (textBox1.Text != "")
{
dbContext.spAddSearchFilterMinPrice(Program.OLXusername, Convert.ToInt32(textBox1.Text));
}
if (textBox2.Text != "")
{
dbContext.spAddSearchFilterMaxPrice(Program.OLXusername, Convert.ToInt32(textBox2.Text));
}
if (JUDET != "" && JUDET != "Toata tara")
{
dbContext.spAddSearchFilterCounty(Program.OLXusername, JUDET);
}
if (ORAS != "" && ORAS != "Toata tara")
{
dbContext.spAddSearchFilterCity(Program.OLXusername, ORAS);
}
if (comboBox3.Text != "" && comboBox3.Text != "Toate")
{
dbContext.spAddSearchFilterMoneda(Program.OLXusername, comboBox3.Text);
}
if (textBox3.Text != "")
{
dbContext.spAddSearchText(Program.OLXusername, textBox3.Text);
}
foreach (int item in getSearchResult(textBox3.Text))
{
int a = Convert.ToInt32(item.ToString());
REZ_CAUTARE.Add(a);
}
foreach (int anunt in REZ_CAUTARE)
{
dbContext.spInsertSearchResult(Program.OLXusername, anunt);
}
var final_result = from r in dbContext.USER_SEARCH_RESULTs
where r.ID_USER == Program.OLXusername
select new
{
r.ID_ANUNT,
r.TITLU,
r.ID_PROPRIETAR,
r.PRET,
r.NEGOCIABIL,
r.JUDET,
r.ORAS,
r.POZA
};
dataGridView1.DataSource = final_result;
dataGridView1.Refresh();
}
public FavoriresPage(string UserCurent)
{
crtUsr = UserCurent;
InitializeComponent();
OLXDataContext dbContext;
dbContext = new OLXDataContext();
dataGridView1.DataSource = dbContext.spGetFavoriteAnounces(UserCurent);
}
private void ButtonCat_Click(object sender, EventArgs e)
{
var dbContext = new OLXDataContext();
Button button = (Button)sender;
mainCategory = button.Text;
dbContext.spAddSearchFilterCategorie(Program.OLXusername, mainCategory);
panel2.Controls.Clear();
panel2.Refresh();
}
public CasutaChat(string user_eu, string user_corespondent)
{
InitializeComponent();
var context = new OLXDataContext();
dataGridViewMesaje.DataSource = context.spGetMessagesBetweenUsers(user_eu, user_corespondent);
eu = user_eu;
el = user_corespondent;
}
static void InsertKeyWords(int id_anunt, string titlu, int pret)
{
var context = new OLXDataContext();
string sep = " ,;:!?";
foreach (string cuvant in titlu.Split(sep.ToCharArray()))
{
context.spInsertAsociatedWord(id_anunt, cuvant);
}
context.spInsertAsociatedWord(id_anunt, pret.ToString());
}
private void buttonDetalii_Click(object sender, EventArgs e)
{
var context = new OLXDataContext();
int topLabel = 300;
int leftLabel = 10;
Label lbtel = new Label();
Label lbemail = new Label();
Label lb1 = new Label();
TextBox tboxloc = new TextBox();
var result = from u in context.DB_USERs
join j in context.DB_RO_COUNTies on u.ID_JUDET equals j.ID
join o in context.DB_RO_CITies on u.ID_ORAS equals o.ID
where u.ID.ToString() == userID
select new
{
u.ID,
u.NUME,
u.TELEFON,
j.NUME_JUDET,
o.NUME_ORAS
};
lbtel.Top = topLabel + 25;
lbtel.Left = leftLabel;
lbtel.Text = "TELEFON: " + result.FirstOrDefault().TELEFON.ToString();
panel2.Controls.Add(lbtel);
lbemail.Top = topLabel + 50;
lbemail.Left = leftLabel;
lbemail.Text = "EMAIL: " + result.FirstOrDefault().ID.ToString();
panel2.Controls.Add(lbemail);
lb1.Top = topLabel + 75;
lb1.Left = leftLabel;
lb1.Text = "Punct de intalnire";
panel2.Controls.Add(lb1);
var meet = from an in context.DB_ANOUNCEs
where an.ID == anuntID
select new
{
an.LOC_INTALNIRE
};
tboxloc.Top = topLabel + 100;
tboxloc.Left = leftLabel;
tboxloc.Text = meet.FirstOrDefault().LOC_INTALNIRE.ToString();
panel2.Controls.Add(tboxloc);
context.spGetUserExtraInfo(anuntID);//NR ACCES TEL++
}
private void star5_Click_1(object sender, EventArgs e)
{
star1.BackgroundImage = Properties.Resources.rsz_star;
star2.BackgroundImage = Properties.Resources.rsz_star;
star3.BackgroundImage = Properties.Resources.rsz_star;
star4.BackgroundImage = Properties.Resources.rsz_star;
star5.BackgroundImage = Properties.Resources.rsz_star;
vot = 5;
OLXDataContext dbContext;
dbContext = new OLXDataContext();
dbContext.tranAddVoteAnounce(userID, anuntID, vot);
}
public AddAnunt()
{
InitializeComponent();
var context = new OLXDataContext();
var result = from c in context.DB_SEARCH_CATEGORies
select c.NUME_CATEGORIE;
foreach (var item in result)
{
comboBoxCategorie.Items.AddRange(new object[] { item.ToString() });
}
}
public static IQueryable printAnounceComments(int id_anunt)
{
var context = new OLXDataContext();
var result = from c in context.ANOUNCES_COMMENTs
where c.ID_ANUNT == id_anunt
orderby c.DATA_ADAUGAT descending
select new
{
c.ID_USER,
c.COMENTARIU
};
return(result);
}
public static IQueryable printPromotedAnounces()
{
var context = new OLXDataContext();
context.spDeletedOldPromotedAnounces();
var result = (from a in context.DB_PROMOTED_ANOUNCEs
join p in context.DB_PROMOTE_PACKAGEs on a.ID_PACHET equals p.ID
orderby p.SUMA, a.DATA_START descending
select a.ID_ANUNT
);
return(result);
}
/// <summary>
/// Clean up any resources being used.
/// </summary>
/// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>
protected override void Dispose(bool disposing)
{
var context = new OLXDataContext();
var result = from u in context.DB_USERs
where u.ID == Program.OLXusername
select new { u.NUME };
label2.Text = result.ToString();
if (disposing && (components != null))
{
components.Dispose();
}
base.Dispose(disposing);
}
private void comboBoxOrase_SelectedIndexChanged(object sender, EventArgs e)
{
ComboBox TEXTO = (ComboBox)sender;
var context = new OLXDataContext();
var resultj = from j in context.DB_RO_COUNTies
join o in context.DB_RO_CITies
on j.ID equals o.ID_JUDET
where o.NUME_ORAS == TEXTO.Text.ToString()
select j.NUME_JUDET;
comboBoxJudete.Items.Clear();
foreach (var item in resultj)
{
comboBoxJudete.Items.AddRange(new object[] { item.ToString() });
}
}
private void comboBoxJudete_SelectedIndexChanged(object sender, EventArgs e)
{
ComboBox TEXTJ = (ComboBox)sender;
var context = new OLXDataContext();
var resulto = from o in context.DB_RO_CITies
join j in context.DB_RO_COUNTies
on o.ID_JUDET equals j.ID
where j.NUME_JUDET == TEXTJ.Text.ToString()
select o.NUME_ORAS;
comboBoxOrase.Items.Clear();
foreach (var item in resulto)
{
comboBoxOrase.Items.AddRange(new object[] { item.ToString() });
}
}
private void buttonFavorite_Click(object sender, EventArgs e)
{
var dbContext = new OLXDataContext();
var login = from l in dbContext.DB_LOGINs
where l.ID_USER == Program.OLXusername
select l.ID_USER;
List <string> temp = new List <string>();
foreach (var item in login)
{
temp.Add(item.ToString());
}
if (temp.Count != 0)//buton de log out
{
FavoriresPage a = new FavoriresPage(Program.OLXusername);
a.Show();
}
}
private void ButtonPromote_Click(object sender, EventArgs e)
{
var context = new OLXDataContext();
context.spAddPromotedAnounce(anuntID, pachetSelectat);
var results = from c in context.DB_PROMOTE_PACKAGEs
where c.NUME_PACHET == pachetSelectat
select new
{
c.NR_ZILE,
c.SUMA
};
string message = "Ati selectat pachetul" + pachetSelectat + "valabil" + results.FirstOrDefault().NR_ZILE + "\n" + "la pretul de numai" + results.FirstOrDefault().SUMA;
MessageBox.Show(message);
this.Hide();
}
public AnouncePage(string idUsr, int idAnun, bool Euamcreat)
{
InitializeComponent();
userID = idUsr;
anuntID = idAnun;
IsTheCreator = Euamcreat;
if (Euamcreat == true)
{
Button btn = new Button();
btn.Left = 24;
btn.Top = 284;
btn.Text = "Promoveaza anunt";
btn.Width = 175;
btn.Height = 24;
panel2.Controls.Add(btn); //here
btn.Click += ButtonPromote_Click;
Label lbpachet = new Label();
lbpachet.Text = "Pachet promovare";
lbpachet.Top = 300;
lbpachet.Left = 24;
panel2.Controls.Add(lbpachet);
ComboBox cboxpachet = new ComboBox();
var con = new OLXDataContext();
cboxpachet.Top = 316;
cboxpachet.Left = 24;
panel2.Controls.Add(cboxpachet);
var rez = from p in con.DB_PROMOTE_PACKAGEs
select p.NUME_PACHET;
foreach (var item1 in rez)
{
cboxpachet.Items.AddRange(new object[] { item1.ToString() });
}
cboxpachet.SelectedIndexChanged += Pachet_SelectedIndexChanged;
}
var context = new OLXDataContext();
context.spAccesAnounce(anuntID);//NR VIZUALIZARI ++
}
public MainPage()
{
var dbContext = new OLXDataContext();
InitializeComponent();
panel3.Top = 4;
panel3.Left = 961;
panel3.Width = 151;
panel3.Height = 52;
panel_up.Controls.Add(panel3);
dbContext.SubmitChanges();
var result1 = from j in dbContext.DB_RO_COUNTies
select j.NUME_JUDET;
foreach (var item in result1)
{
comboBox1.Items.AddRange(new object[] { item.ToString() });
}
var result2 = from o in dbContext.DB_RO_CITies
select o.NUME_ORAS;
foreach (var item in result2)
{
comboBox2.Items.AddRange(new object[] { item.ToString() });
}
comboBox3.Items.AddRange(new object[] { "Toate" });
comboBox3.Items.AddRange(new object[] { "lei" });
comboBox3.Items.AddRange(new object[] { "euro" });
comboBox1.SelectedIndex = 0;
comboBox2.SelectedIndex = 0;
comboBox3.SelectedIndex = 0;
dataGridView1.AutoGenerateColumns = true;
dataGridView1.DataSource = printPromotedAnounces(); //dbContext.spGetFirstDisplay();//
//dataGridView1.Columns["ID"].Visible = false;
dataGridView1.Refresh();
}
public UserPage(string user)
{
InitializeComponent();
USER = user;
var context = new OLXDataContext();
var result = from u in context.DB_USERs
join j in context.DB_RO_COUNTies on u.ID_JUDET equals j.ID
join o in context.DB_RO_CITies on u.ID_ORAS equals o.ID
where u.ID == user
select new
{
u.NUME,
u.TELEFON,
j.NUME_JUDET,
o.NUME_ORAS
};
labelNume.Text = result.FirstOrDefault().NUME.ToString();
labelOras.Text = result.FirstOrDefault().NUME_ORAS.ToString();
labelJudet.Text = result.FirstOrDefault().NUME_JUDET.ToString();
labelTelefon.Text = result.FirstOrDefault().TELEFON.ToString();
labelEmail.Text = user;
var medie = context.spGetMedieUser(user);
List <string> temp = new List <string>();
foreach (var item in temp)
{
temp.Add(item.ToString());
}
if (temp.Count == 0)
{
labelMedie.Text = "0.0";
}
else
{
labelMedie.Text = temp.First();
}
}
private void AddAnunt_Click(object sender, EventArgs e)
{
var dbContext = new OLXDataContext();
var result = from u in dbContext.DB_USERs
where u.ID == Program.OLXusername
select u.ID;
List <string> t = new List <string>();
foreach (var item in result)
{
t.Add(item.ToString());
}
if (t.Count != 0)//e in DB_USERS
{
AddAnunt a = new AddAnunt();
a.Show();
}
else
{
Login l = new Login("ADD");
l.Show();
}
}
private void button4_Click(object sender, EventArgs e)
{
var context = new OLXDataContext();
var result = from u in context.DB_USERs
where u.ID == Program.OLXusername
select u.ID;
List <string> t = new List <string>();
foreach (var item in result)
{
t.Add(item.ToString());
}
if (t.Count != 0)//e in DB_USERS
{
context.spAddComentariu(anuntID, Program.OLXusername, textBox2.Text);
dataGridView1.DataSource = context.spGetAnounceComments(anuntID);
}
else
{
Login log = new Login();
log.Show();
}
}
private void btnLogin_Click(object sender, EventArgs e)
{
var dbContext = new OLXDataContext();
var result = from u in dbContext.DB_USERs
where u.ID == Program.OLXusername
select u.ID;
List <string> t = new List <string>();
foreach (var item in result)
{
t.Add(item.ToString());
}
if (t.Count == 0)//e in DB_USERS
{
Login log = new Login();
log.Show();
}
else
{
UserPage pag = new UserPage(Program.OLXusername);
pag.Show();
}
}
