protected void btnSearch_Click(object sender, EventArgs e)
{
String text = txtSearch.Text;
if (text != null)
{
if (!text.Trim().Equals(""))
{
clearGridView();
DataSet ds = new DataSet();
DataTable dt = new DataTable();
dt.Columns.Add("username", typeof(string));
dt.Columns.Add("type", typeof(string));
Database db = new Database();
Korisnik k = db.getUserInfoByUsername(text);
dt.Rows.Add(text, k.Type);
ds.Tables.Add(dt);
GridView1.DataSource = ds;
GridView1.DataBind();
}
else
{
fillGridView();
}
}
else
{
fillGridView();
}
}
protected void LogIn_Click(object sender, EventArgs e)
{
// lblError.Visible = false;
System.Diagnostics.Debug.WriteLine("Yes");
baza = new Database();
bool flag = baza.checkKorisnik(tbUsernamelog.Text, tbPasslog.Text);
if (flag == true)
{
Korisnik ab = baza.getUserInfoByUsername(tbUsernamelog.Text);
if (ab.Type == 0)
{
// ova e adminot redirect na adminPage
Session["UserName"] = tbUsernamelog.Text.ToString();
Session["Admin"] = "Admin";
Response.Redirect("Admin.aspx");
}
else
{
System.Diagnostics.Debug.WriteLine("REDIREKT");
Session["UserName"] = tbUsernamelog.Text.ToString();
Response.Redirect("HomePage.aspx");
/// ako e admin redirect na adminPage ; treba vo baza funkcija za proverka dali e admin
///
}
}
else
{
lblError.Visible = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (Session["UserName"] != null)
{
Database db = new Database();
Korisnik k = db.getUserInfoByUsername(Session["UserName"].ToString());
if (k.Type == 1)
{
Response.Redirect("HomePage.aspx");
}
else
{
GridView1.DataSource = db.getAllUsers();
GridView1.DataBind();
}
}
else
{
Response.Redirect("~/");
}
fillAllUsers();
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
String text = txtSearch.Text;
if (text != null)
{
if (!text.Trim().Equals(""))
{
clearGridView();
DataSet ds = new DataSet();
DataTable dt = new DataTable();
dt.Columns.Add("username", typeof(string));
dt.Columns.Add("type", typeof(string));
Database db = new Database();
Korisnik k = db.getUserInfoByUsername(text);
dt.Rows.Add(text, k.Type);
ds.Tables.Add(dt);
GridView1.DataSource = ds;
GridView1.DataBind();
}
else
{
fillGridView();
}
}
else
{
fillGridView();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (Session["UserName"] != null)
{
string username = Session["UserName"].ToString();
db = new Database();
Korisnik k = db.getUserInfoByUsername(username);
if (k != null)
{
tbName.Text = k.Name;
tbEmail.Text = k.Email;
bDay.Text = k.Birthday.ToShortDateString();
rbFemale.Checked = k.Sex == 0;
rbMale.Checked = k.Sex == 1;
}
if (k.Type == 1)
{
}
}
else
{
Response.Redirect("Default.aspx");
}
}
}
protected void LogIn_Click(object sender, EventArgs e)
{
// lblError.Visible = false;
System.Diagnostics.Debug.WriteLine("Yes");
baza = new Database();
bool flag = baza.checkKorisnik(tbUsernamelog.Text, tbPasslog.Text);
if (flag == true)
{
Korisnik ab = baza.getUserInfoByUsername(tbUsernamelog.Text);
if (ab.Type == 0)
{
// ova e adminot redirect na adminPage
Session["UserName"] = tbUsernamelog.Text.ToString();
Session["Admin"] = "Admin";
Response.Redirect("Admin.aspx");
}
else
{
System.Diagnostics.Debug.WriteLine("REDIREKT");
Session["UserName"] = tbUsernamelog.Text.ToString();
Response.Redirect("HomePage.aspx");
/// ako e admin redirect na adminPage ; treba vo baza funkcija za proverka dali e admin
///
}
}
else
{
lblError.Visible = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (Session["UserName"] != null)
{
string username = Session["UserName"].ToString();
db = new Database();
Korisnik k = db.getUserInfoByUsername(username);
if (k != null)
{
tbName.Text = k.Name;
tbEmail.Text = k.Email;
bDay.Text = k.Birthday.ToShortDateString();
rbFemale.Checked = k.Sex == 0;
rbMale.Checked = k.Sex == 1;
}
if (k.Type == 1)
{
}
}
else
{
Response.Redirect("Default.aspx");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (Session["UserName"] != null)
{
Database db = new Database();
Korisnik k = db.getUserInfoByUsername(Session["UserName"].ToString());
if (k.Type == 1)
{
Response.Redirect("HomePage.aspx");
}
}
else
{
Response.Redirect("~/");
}
if (Request.Cookies.Get("AdminCookie") != null)
{
ViewState["title"] = Request.Cookies["AdminCookie"]["albumName"];
ViewState["year"] = Int32.Parse(Request.Cookies["AdminCookie"]["albumYear"]);
ViewState["album_id"] = Int32.Parse(Request.Cookies["AdminCookie"]["albumID"]);
ViewState["mom_br_sliki"] = Int32.Parse(Request.Cookies["AdminCookie"]["momImageNumber"]);
ViewState["br_sliki"] = Int32.Parse(Request.Cookies["AdminCookie"]["imageNumber"]);
changeForm();
setFormInfo();
}
}
}
protected void fillTransakcii()
{
clearScreen();
Database db = new Database();
List <Transakcija> transakcii;
int tab = -1;
if (ViewState["tab"] != null)
{
Int32.TryParse(ViewState["tab"].ToString(), out tab);
}
if (tab != -1)
{
if (tab == 0)
{
transakcii = db.getAllTransakciiKupuvamForUsername(Session["UserName"].ToString(),
Ponuda.DATE);
}
else if (tab == 1)
{
transakcii = db.getAllTransakciiProdavamForUsername(Session["UserName"].ToString(),
Ponuda.DATE);
}
// TODO: ovde za istorija
else
{
transakcii = db.getAllTransakciiHistoryForUsername(Session["UserName"].ToString(),
Ponuda.DATE);
}
}
else
{
return;
}
if (transakcii == null)
{
return;
}
foreach (Transakcija t in transakcii)
{
if (tab == 1) // Prodavam opcii
{
if (t.AlbumID == -1) //E obicna buy transakcija
{
transakciiElementHalfProdavam tranElem = (transakciiElementHalfProdavam)LoadControl("transakciiElementHalfProdavam.ascx");
Ponuda p = db.getOffer(t.ID);
Korisnik user = db.getUserInfoByUsername(t.Username);
Slika s = db.getPicture(p.AlbumID, p.BrojSlika);
Album a = db.getAlbumByID(p.AlbumID);
tranElem.AlbumYear = a.Year;
tranElem.imgID_1 = s.Broj;
tranElem.Name1 = p.Name;
tranElem.Description1 = p.Desc;
tranElem.Email1 = user.Email;
tranElem.Price1 = p.Price;
tranElem.Offer1ID = p.AlbumID;
tranElem.User1 = t.Username;
tranElem.imgUrl_1 = s.Url;
tranElem.Date = t.Datum;
tranElem.tranID = t.ID;
repeaterTransakcii.Controls.Add(tranElem);
}
else
{
transakciiExchangeElementHalfProdavam tranElem = (transakciiExchangeElementHalfProdavam)LoadControl("transakciiExchangeProdavam.ascx");
Ponuda p = db.getOffer(t.ID);
Korisnik user = db.getUserInfoByUsername(t.Username);
Slika s_moja = db.getPicture(p.AlbumID, p.BrojSlika);
Slika s_zamena = db.getPicture(t.AlbumID, t.PictureID);
Album a = db.getAlbumByID(p.AlbumID);
tranElem.AlbumYear = a.Year;
tranElem.Name1 = p.Name;
tranElem.Description1 = p.Desc;
tranElem.Email1 = user.Email;
tranElem.Price1 = p.Price;
tranElem.Offer1ID = p.AlbumID;
tranElem.User1 = t.Username;
tranElem.Date = t.Datum;
tranElem.imgUrl_1 = s_moja.Url;
tranElem.imgID_1 = s_moja.Broj;
tranElem.tranID = t.ID;
tranElem.imgUrl_2 = s_zamena.Url;
tranElem.imgID_2 = s_zamena.Broj;
repeaterTransakcii.Controls.Add(tranElem);
}
}
else if (tab == 0)
{
if (t.AlbumID == -1)//E obicna buy transakcija
{
transakciiExchangeElementHalf tranElem = (transakciiExchangeElementHalf)LoadControl("transakciiExchange.ascx");
Ponuda p = db.getOffer(t.ID);
Korisnik user = db.getUserInfoByUsername(t.Username);
Slika s = db.getPicture(p.AlbumID, p.BrojSlika);
Album a = db.getAlbumByID(p.AlbumID);
tranElem.AlbumYear = a.Year;
tranElem.imgID_1 = s.Broj;
tranElem.Name1 = p.Name;
tranElem.Description1 = p.Desc;
tranElem.Email1 = user.Email;
tranElem.Price1 = p.Price;
tranElem.Offer1ID = p.AlbumID;
tranElem.User1 = t.Username;
tranElem.imgUrl_1 = s.Url;
tranElem.Date = t.Datum;
tranElem.tranID = t.ID;
tranElem.Status = t.Status;
repeaterTransakcii.Controls.Add(tranElem);
}
else
{
transakciiElement tranElem = (transakciiElement)LoadControl("transakciiElement.ascx");
Ponuda p = db.getOffer(t.ID);
Korisnik user = db.getUserInfoByUsername(t.Username);
Slika s_moja = db.getPicture(p.AlbumID, p.BrojSlika);
Slika s_zamena = db.getPicture(t.AlbumID, t.PictureID);
Album a = db.getAlbumByID(p.AlbumID);
tranElem.AlbumYear = a.Year;
tranElem.Name1 = p.Name;
tranElem.Description1 = p.Desc;
tranElem.Email1 = user.Email;
tranElem.Price1 = p.Price;
tranElem.Offer1ID = p.AlbumID;
tranElem.User1 = t.Username;
tranElem.Date = t.Datum;
tranElem.imgUrl_1 = s_moja.Url;
tranElem.imgID_1 = s_moja.Broj;
tranElem.tranID = t.ID;
tranElem.Status = t.Status;
tranElem.imgUrl_2 = s_zamena.Url;
tranElem.imgID_2 = s_zamena.Broj;
repeaterTransakcii.Controls.Add(tranElem);
}
}
else
{ // history
if (t.AlbumID == -1) //E obicna buy transakcija
{
transakciiExchangeElementHalf tranElem = (transakciiExchangeElementHalf)LoadControl("transakciiExchange.ascx");
Ponuda p = db.getOffer(t.ID);
Korisnik user = db.getUserInfoByUsername(t.Username);
Slika s = db.getPicture(p.AlbumID, p.BrojSlika);
Album a = db.getAlbumByID(p.AlbumID);
tranElem.AlbumYear = a.Year;
tranElem.imgID_1 = s.Broj;
tranElem.Name1 = p.Name;
tranElem.Description1 = p.Desc;
tranElem.Email1 = user.Email;
tranElem.Price1 = p.Price;
tranElem.Offer1ID = p.AlbumID;
tranElem.User1 = t.Username;
tranElem.imgUrl_1 = s.Url;
tranElem.Date = t.Datum;
tranElem.tranID = t.ID;
tranElem.Status = t.Status;
repeaterTransakcii.Controls.Add(tranElem);
}
else
{
transakciiElement tranElem = (transakciiElement)LoadControl("transakciiElement.ascx");
Ponuda p = db.getOffer(t.ID);
Korisnik user = db.getUserInfoByUsername(t.Username);
Slika s_moja = db.getPicture(p.AlbumID, p.BrojSlika);
Slika s_zamena = db.getPicture(t.AlbumID, t.PictureID);
Album a = db.getAlbumByID(p.AlbumID);
tranElem.AlbumYear = a.Year;
tranElem.Name1 = p.Name;
tranElem.Description1 = p.Desc;
tranElem.Email1 = user.Email;
tranElem.Price1 = p.Price;
tranElem.Offer1ID = p.AlbumID;
tranElem.User1 = t.Username;
tranElem.Date = t.Datum;
tranElem.imgUrl_1 = s_moja.Url;
tranElem.imgID_1 = s_moja.Broj;
tranElem.tranID = t.ID;
tranElem.imgUrl_2 = s_zamena.Url;
tranElem.imgID_2 = s_zamena.Broj;
tranElem.Status = t.Status;
repeaterTransakcii.Controls.Add(tranElem);
}
}
//repeaterTransakcii.Controls.Add(tranElem);
}
}
protected void fillTransakcii()
{
clearScreen();
Database db = new Database();
List<Transakcija> transakcii;
int tab = -1;
if (ViewState["tab"] != null)
Int32.TryParse(ViewState["tab"].ToString(), out tab);
if (tab != -1)
{
if (tab == 0)
transakcii = db.getAllTransakciiKupuvamForUsername(Session["UserName"].ToString(),
Ponuda.DATE);
else if (tab == 1)
transakcii = db.getAllTransakciiProdavamForUsername(Session["UserName"].ToString(),
Ponuda.DATE);
// TODO: ovde za istorija
else
{
transakcii = db.getAllTransakciiHistoryForUsername(Session["UserName"].ToString(),
Ponuda.DATE);
}
}
else return;
if (transakcii == null) return;
foreach (Transakcija t in transakcii)
{
if (tab == 1) // Prodavam opcii
{
if (t.AlbumID == -1)//E obicna buy transakcija
{
transakciiElementHalfProdavam tranElem = (transakciiElementHalfProdavam)LoadControl("transakciiElementHalfProdavam.ascx");
Ponuda p = db.getOffer(t.ID);
Korisnik user = db.getUserInfoByUsername(t.Username);
Slika s = db.getPicture(p.AlbumID, p.BrojSlika);
Album a = db.getAlbumByID(p.AlbumID);
tranElem.AlbumYear = a.Year;
tranElem.imgID_1 = s.Broj;
tranElem.Name1 = p.Name;
tranElem.Description1 = p.Desc;
tranElem.Email1 = user.Email;
tranElem.Price1 = p.Price;
tranElem.Offer1ID = p.AlbumID;
tranElem.User1 = t.Username;
tranElem.imgUrl_1 = s.Url;
tranElem.Date = t.Datum;
tranElem.tranID = t.ID;
repeaterTransakcii.Controls.Add(tranElem);
}
else
{
transakciiExchangeElementHalfProdavam tranElem = (transakciiExchangeElementHalfProdavam)LoadControl("transakciiExchangeProdavam.ascx");
Ponuda p = db.getOffer(t.ID);
Korisnik user = db.getUserInfoByUsername(t.Username);
Slika s_moja = db.getPicture(p.AlbumID, p.BrojSlika);
Slika s_zamena = db.getPicture(t.AlbumID, t.PictureID);
Album a = db.getAlbumByID(p.AlbumID);
tranElem.AlbumYear = a.Year;
tranElem.Name1 = p.Name;
tranElem.Description1 = p.Desc;
tranElem.Email1 = user.Email;
tranElem.Price1 = p.Price;
tranElem.Offer1ID = p.AlbumID;
tranElem.User1 = t.Username;
tranElem.Date = t.Datum;
tranElem.imgUrl_1 = s_moja.Url;
tranElem.imgID_1 = s_moja.Broj;
tranElem.tranID = t.ID;
tranElem.imgUrl_2 = s_zamena.Url;
tranElem.imgID_2 = s_zamena.Broj;
repeaterTransakcii.Controls.Add(tranElem);
}
}
else if(tab == 0)
{
if (t.AlbumID == -1)//E obicna buy transakcija
{
transakciiExchangeElementHalf tranElem = (transakciiExchangeElementHalf)LoadControl("transakciiExchange.ascx");
Ponuda p = db.getOffer(t.ID);
Korisnik user = db.getUserInfoByUsername(t.Username);
Slika s = db.getPicture(p.AlbumID, p.BrojSlika);
Album a = db.getAlbumByID(p.AlbumID);
tranElem.AlbumYear = a.Year;
tranElem.imgID_1 = s.Broj;
tranElem.Name1 = p.Name;
tranElem.Description1 = p.Desc;
tranElem.Email1 = user.Email;
tranElem.Price1 = p.Price;
tranElem.Offer1ID = p.AlbumID;
tranElem.User1 = t.Username;
tranElem.imgUrl_1 = s.Url;
tranElem.Date = t.Datum;
tranElem.tranID = t.ID;
tranElem.Status = t.Status;
repeaterTransakcii.Controls.Add(tranElem);
}
else
{
transakciiElement tranElem = (transakciiElement)LoadControl("transakciiElement.ascx");
Ponuda p = db.getOffer(t.ID);
Korisnik user = db.getUserInfoByUsername(t.Username);
Slika s_moja = db.getPicture(p.AlbumID, p.BrojSlika);
Slika s_zamena = db.getPicture(t.AlbumID, t.PictureID);
Album a = db.getAlbumByID(p.AlbumID);
tranElem.AlbumYear = a.Year;
tranElem.Name1 = p.Name;
tranElem.Description1 = p.Desc;
tranElem.Email1 = user.Email;
tranElem.Price1 = p.Price;
tranElem.Offer1ID = p.AlbumID;
tranElem.User1 = t.Username;
tranElem.Date = t.Datum;
tranElem.imgUrl_1 = s_moja.Url;
tranElem.imgID_1 = s_moja.Broj;
tranElem.tranID = t.ID;
tranElem.Status = t.Status;
tranElem.imgUrl_2 = s_zamena.Url;
tranElem.imgID_2 = s_zamena.Broj;
repeaterTransakcii.Controls.Add(tranElem);
}
}
else
{ // history
if (t.AlbumID == -1)//E obicna buy transakcija
{
transakciiExchangeElementHalf tranElem = (transakciiExchangeElementHalf)LoadControl("transakciiExchange.ascx");
Ponuda p = db.getOffer(t.ID);
Korisnik user = db.getUserInfoByUsername(t.Username);
Slika s = db.getPicture(p.AlbumID, p.BrojSlika);
Album a = db.getAlbumByID(p.AlbumID);
tranElem.AlbumYear = a.Year;
tranElem.imgID_1 = s.Broj;
tranElem.Name1 = p.Name;
tranElem.Description1 = p.Desc;
tranElem.Email1 = user.Email;
tranElem.Price1 = p.Price;
tranElem.Offer1ID = p.AlbumID;
tranElem.User1 = t.Username;
tranElem.imgUrl_1 = s.Url;
tranElem.Date = t.Datum;
tranElem.tranID = t.ID;
tranElem.Status = t.Status;
repeaterTransakcii.Controls.Add(tranElem);
}
else
{
transakciiElement tranElem = (transakciiElement)LoadControl("transakciiElement.ascx");
Ponuda p = db.getOffer(t.ID);
Korisnik user = db.getUserInfoByUsername(t.Username);
Slika s_moja = db.getPicture(p.AlbumID, p.BrojSlika);
Slika s_zamena = db.getPicture(t.AlbumID, t.PictureID);
Album a = db.getAlbumByID(p.AlbumID);
tranElem.AlbumYear = a.Year;
tranElem.Name1 = p.Name;
tranElem.Description1 = p.Desc;
tranElem.Email1 = user.Email;
tranElem.Price1 = p.Price;
tranElem.Offer1ID = p.AlbumID;
tranElem.User1 = t.Username;
tranElem.Date = t.Datum;
tranElem.imgUrl_1 = s_moja.Url;
tranElem.imgID_1 = s_moja.Broj;
tranElem.tranID = t.ID;
tranElem.imgUrl_2 = s_zamena.Url;
tranElem.imgID_2 = s_zamena.Broj;
tranElem.Status = t.Status;
repeaterTransakcii.Controls.Add(tranElem);
}
}
//repeaterTransakcii.Controls.Add(tranElem);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (Session["UserName"] != null)
{
Database db = new Database();
Korisnik k = db.getUserInfoByUsername(Session["UserName"].ToString());
if (k.Type == 1)
{
Response.Redirect("HomePage.aspx");
}
else
{
GridView1.DataSource = db.getAllUsers();
GridView1.DataBind();
}
}
else
{
Response.Redirect("~/");
}
fillAllUsers();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (Session["UserName"] != null)
{
Database db = new Database();
Korisnik k = db.getUserInfoByUsername(Session["UserName"].ToString());
if (k.Type == 1)
{
Response.Redirect("HomePage.aspx");
}
}
else
{
Response.Redirect("~/");
}
if (Request.Cookies.Get("AdminCookie") != null)
{
ViewState["title"] = Request.Cookies["AdminCookie"]["albumName"];
ViewState["year"] = Int32.Parse(Request.Cookies["AdminCookie"]["albumYear"]);
ViewState["album_id"] = Int32.Parse(Request.Cookies["AdminCookie"]["albumID"]);
ViewState["mom_br_sliki"] = Int32.Parse(Request.Cookies["AdminCookie"]["momImageNumber"]);
ViewState["br_sliki"] = Int32.Parse(Request.Cookies["AdminCookie"]["imageNumber"]);
changeForm();
setFormInfo();
}
}
}
