Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- @using MySql.Data.MySqlClient
- @using System.Configuration
- @{
- Layout = "~/Layout/_Layout.cshtml";
- Page.Title = "Angebote";
- string benutzer = Session["user"].ToString();
- string constring = "server = localhost;user = root;database = ucpm; port = 3306;password = PX397;SsLMode = none";
- bool sort_votes = true;
- String sortieren = Request.QueryString["ansicht"];
- List<string> uP = new List<string>() { };
- string url = HttpContext.Current.Request.Url.PathAndQuery;
- string upvote_ = Request.QueryString["Upvote"];
- }
- <form action="~/Detail.cshtml" id="detail"></form>
- <div class="row" style="background-color:#5cb85c;">
- <div class="col-md-2 col-sm-6 col-xs-6">
- <div class="sidebar-nav">
- <div class="navbar">
- </div>
- </div>
- <header></header>
- </div>
- <div class="col-md-10 col-sm-6 col-xs-6" style="border-bottom:1px solid #5cb85c; border-left:1px solid #5cb85c;background-color:white">
- <h1 class="text-left text-success"><b>Zukünftige Angebote</b></h1>
- </div>
- @if ((string)Session["user"] == "ExterneFirma")
- {
- <div class="col-md-2 col-sm-6 col-xs-6" style="background-color:#5cb85c;">
- <div class="sidebar-nav">
- <div class="navbar navbar-default" role="navigation">
- <div class="navbar-collapse collapse sidebar-navbar-collapse">
- <ul class="nav" id="side_nav">
- <li class="nav_item" style="background-color:#5cb85c;"><a href="~/Home.cshtml"><b>Meine Übersicht</b></a></li>
- <li class="nav_item" style="background-color:#5cb85c;"><a href="~/Angeboterstellen.cshtml"><b>Angebot erstellen</b></a></li>
- <li class="nav_item" style="background-color:#5cb85c;"><a href="~/Angebote.cshtml"><b>Angebote</b></a></li>
- <li class="nav_item" style="background-color:#5cb85c;"><a href="~/Login.cshtml"><b>Logout</b></a></li>
- "@Session["user"].ToString()" Sie sind als @Session["role"].ToString() angemeldet!!
- </ul>
- </div>
- </div>
- </div>
- </div>
- }
- else if (string.IsNullOrEmpty(Session["role"] as string))
- {
- <meta http-equiv="refresh" content="0; URL=Login.cshtml/">
- }
- else
- {
- <div class="col-md-2 col-sm-6 col-xs-6">
- <div class="sidebar-nav">
- <div class="navbar navbar-default" role="navigation">
- <div class="navbar-collapse collapse sidebar-navbar-collapse">
- <ul class="nav" id="side_nav">
- <li class="nav_item" style="background-color:#5cb85c;"><a href="~/Home.cshtml"><b>Meine Übersicht</b></a></li>
- <li class="nav_item" style="background-color:#5cb85c;"><a href="~/unbestätigte_Angebote.cshtml"><b>Angebote voten</b></a></li>
- <li class="nav_item" style="background-color:#5cb85c;"><a href="~/Angebote.cshtml"><b>Angebote</b></a></li>
- <li class="nav_item" style="background-color:#5cb85c;"><a href="~/Login.cshtml"><b>Logout</b></a></li>
- "@Session["user"].ToString()" Sie sind als @Session["role"].ToString() angemeldet!!
- </ul>
- </div>
- </div>
- </div>
- </div>
- }
- <div class="col-md-10 col-sm-6 col-xs-6">
- <main>
- <div class="row">
- <div class="col-md-12 col-sm-8 col-xs-8" style="padding-top:2.5%; padding-bottom:2.5%; padding-right:2.5%; background-color:white">
- <div class="col-md-8 col-sm-6 col-xs-6" style="padding-top:2.5%; padding-bottom:2.5%; padding-right:2.5%; background-color:white">
- <form>
- <table class="blueTable">
- <thead>
- <tr>
- <th><button type="submit" class="btn btn-success" id="angebot_btn" name="ansicht" value="Nr">Nr.</button></th>
- <th><button type="submit" class="btn btn-success" id="angebot_btn" name="ansicht" value="Name">Name</button> </th>
- <th><button type="submit" class="btn btn-success" id="angebot_btn" name="ansicht" value="Wochentag">Wochentag</button> </th>
- <th><button type="submit" class="btn btn-success" id="angebot_btn" name="ansicht" value="Uhrzeit">Uhrzeit</button> </th>
- <th><button type="submit" class="btn btn-success" id="angebot_btn" name="ansicht" value="Preis">Preis</button> </th>
- <th><button type="submit" class="btn btn-success" id="angebot_btn" name="ansicht" value="Votes">Votes</button> </th>
- <th><button type="submit" class="btn btn-success" id="angebot_btn" name="ansicht" value="Upvote">UpVote</button> </th>
- @{
- MySqlConnection con10 = new MySqlConnection(constring);
- try
- {
- con10.Open();
- MySqlCommand cmd = con10.CreateCommand();
- cmd.CommandText = "select nr from benutzer where loginname = '" + Session["user"].ToString() + "'";
- MySqlDataReader r = cmd.ExecuteReader();
- if (r.Read())
- {
- cmd.CommandText = "select geschaeftfuehrer from mitarbeiter where benutzernr = " + r[0].ToString();
- r.Close();
- r = cmd.ExecuteReader();
- if (r.Read())
- {
- string test = r[0].ToString();
- if (test == "True")
- {
- <th><button type="submit" class="btn btn-success" id="angebot_btn" name="ansicht" value="öffentlich">Öffentlich</button> </th>
- }
- }
- r.Close();
- con10.Close();
- }
- }
- catch(Exception e)
- {
- }
- }
- </tr>
- </thead>
- @{
- MySqlConnection con = new MySqlConnection(constring);
- try
- {
- con.Open();
- MySqlCommand cmd = con.CreateCommand();
- if (sortieren.IsEmpty() || sortieren == "Nr")
- {
- cmd.CommandText = "SELECT angebot.*, bild.Binaerdaten ,angebotzeit.* from angebot LEFT JOIN bild ON angebot.BildID = bild.ID JOIN angebotzeit on angebot.zeitID = angebotzeit.ID WHERE angebot.Angenommen ='0' ORDER BY AngebotID;";
- }
- else if (sortieren == "Name")
- {
- cmd.CommandText = "SELECT angebot.*, bild.Binaerdaten ,angebotzeit.* from angebot LEFT JOIN bild ON angebot.BildID = bild.ID JOIN angebotzeit on angebot.zeitID = angebotzeit.ID WHERE angebot.Angenommen ='0' ORDER BY Titel";
- }
- else if (sortieren == "Wochentag")
- {
- cmd.CommandText = "SELECT angebot.*, bild.Binaerdaten ,angebotzeit.* from angebot LEFT JOIN bild ON angebot.BildID = bild.ID JOIN angebotzeit on angebot.zeitID = angebotzeit.ID WHERE angebot.Angenommen ='0' ORDER BY Montag AND Dienstag AND Mittwoch AND Donnerstag AND Freitag DESC";
- }
- else if (sortieren == "Uhrzeit")
- {
- cmd.CommandText = " SELECT angebot.*, bild.Binaerdaten ,angebotzeit.* from angebot LEFT JOIN bild ON angebot.BildID = bild.ID JOIN angebotzeit on angebot.zeitID = angebotzeit.ID WHERE angebot.Angenommen ='0' ORDER BY Start";
- }
- else if (sortieren == "Preis")
- {
- cmd.CommandText = " SELECT angebot.*, bild.Binaerdaten ,angebotzeit.* from angebot LEFT JOIN bild ON angebot.BildID = bild.ID JOIN angebotzeit on angebot.zeitID = angebotzeit.ID WHERE angebot.Angenommen ='0' ORDER BY Preis";
- }
- else if (sortieren == "Votes")
- {
- cmd.CommandText = " SELECT angebot.*, bild.Binaerdaten ,angebotzeit.* from angebot LEFT JOIN bild ON angebot.BildID = bild.ID JOIN angebotzeit on angebot.zeitID = angebotzeit.ID WHERE angebot.Angenommen ='0' ORDER BY Votes DESC";
- }
- else
- {
- cmd.CommandText = "SELECT angebot.*, bild.Binaerdaten ,angebotzeit.* from angebot LEFT JOIN bild ON angebot.BildID = bild.ID JOIN angebotzeit on angebot.zeitID = angebotzeit.ID WHERE angebot.Angenommen ='0' ORDER BY AngebotID;";
- }
- MySqlDataReader r = cmd.ExecuteReader();
- while (r.Read())
- {
- string img_url = r["Binaerdaten"].ToString();
- if (!img_url.IsEmpty())
- {
- byte[] myFile = (Byte[])r["Binaerdaten"];
- string img = Convert.ToBase64String(myFile);
- img_url = string.Format("data:image/png;base64,{0}", img);
- }
- double prei1 = (double)r["Preis"];
- //bool teilnahme_ = (bool)r[""];
- <tbody>
- <tr>
- <td>@r["AngebotID"].ToString()</td>
- <td>
- @if (!img_url.IsEmpty())
- {
- <img src="@img_url" width="35" height="35" alt=@r["Titel"].ToString()>
- }
- <button type="submit" form="detail" value=@r["Titel"].ToString() name="detail" style=" background: none !important; color: inherit; border: none; padding: 0 !important; font: inherit; border-bottom: 1px solid #444; cursor: pointer;">@r["Titel"].ToString()</button>
- </td>
- <td>
- @{
- if (!r["Montag"].Equals(false))
- {
- <p>Montag<br /></p>
- }
- if (!r["Dienstag"].Equals(false))
- {
- <p>Dienstag<br /></p>
- }
- if (!r["Mittwoch"].Equals(false))
- {
- <p>Mittwoch<br /></p>
- }
- if (!r["Donnerstag"].Equals(false))
- {
- <p>Donnerstag<br /></p>
- }
- if (!r["Freitag"].Equals(false))
- {
- <p>Freitag<br /></p>
- }
- }
- </td>
- <td>@r["Start"].ToString() : @r["Ende"].ToString() Uhr</td>
- <td>@r["preis"].ToString() €</td>
- <th>@r["votes"].ToString() </th>
- @{
- string angebot = r["Titel"].ToString();
- int j = 0;
- // welceh url haben wir
- for (int i = 0; i < url.Length; i++)
- {
- if(url[i].Equals(angebot[j]) && i+1 < url.Length && i != 0)
- {
- j += 1;
- }
- }
- if (angebot.Length - 1 == j)
- {
- con = new MySqlConnection(constring);
- try
- {
- con.Open();
- MySqlCommand cmd3 = con.CreateCommand();
- cmd3.CommandText = "select angebot.angebotid, nr from angebot, benutzer WHERE angebot.Titel = '" + r["Titel"].ToString() + "' and loginname = '" + Session["user"].ToString() + "'";
- MySqlDataReader r3 = cmd3.ExecuteReader();
- if (r3.Read())
- {
- cmd3.CommandText = "insert into hatgevoted values ('" + r3[0].ToString() + "','" + r3[1].ToString() + "')";
- r3.Close();
- r3 = cmd3.ExecuteReader();
- }
- r3.Close();
- }
- catch (Exception e)
- {
- }
- }
- MySqlConnection con1 = new MySqlConnection(constring);
- con1.Open();
- MySqlCommand cmd1 = con1.CreateCommand();
- cmd1.CommandText = "select angebot.angebotid, nr from angebot, benutzer WHERE angebot.Titel = '" + r["Titel"].ToString() + "' and benutzer.loginname = '" + Session["user"].ToString() + "'";
- MySqlDataReader r2 = cmd1.ExecuteReader();
- string test1 = "";
- string test2 = "";
- if (r2.Read())
- {
- test1 = r2[0].ToString();
- test2 = r2[1].ToString();
- }
- r2.Close();
- cmd1.CommandText = "select angebot, benutzer from hatgevoted where angebot = " + test1 + " and benutzer = " + test2;
- r2 = cmd1.ExecuteReader();
- if (!r2.Read())
- {
- <td> <button value=@r["Titel"].ToString() type="submit" name="Upvote">Upvote</button></td>
- }
- else
- {
- <td> <button value=@r["Titel"].ToString() hidden="true" type="submit" name="Upvote"> Upvote </button></td>
- }
- r2.Close();
- // URL testen und wenn anischt= öffentlich, dann change value
- j = 0;
- int k = 0;
- string öffen = "Offentlich+" + r["AngebotID"].ToString();
- string ausstehend = "Ausstehend+" + r["AngebotID"].ToString();
- for (int i = 0; i < url.Length; i++)
- {
- if(i != 0 && url[i] == öffen[j])
- {
- j += 1;
- }
- else if (i != 0 && url[i] == ausstehend[k])
- {
- k += 1;
- }
- }
- if(j == öffen.Length)
- {
- // Url steht öffentlich
- cmd1.CommandText = "UPDATE angebot SET Angenommen= '0' where titel = '" + r["Titel"].ToString() + "'";
- r2 = cmd1.ExecuteReader();
- }
- else if(k == ausstehend.Length)
- {
- // Url steht ausstehend
- cmd1.CommandText = "UPDATE angebot SET Angenommen= '1' where titel = '" + r["Titel"].ToString() + "'";
- r2 = cmd1.ExecuteReader();
- }
- r2.Close();
- cmd1.CommandText = "select nr from benutzer where loginname = '" + Session["user"].ToString() + "'";
- r2 = cmd1.ExecuteReader();
- if (r2.Read())
- {
- cmd1.CommandText = "select geschaeftfuehrer from mitarbeiter where benutzernr = " + r2[0].ToString();
- r2.Close();
- r2 = cmd1.ExecuteReader();
- if (r2.Read())
- {
- string test = r2[0].ToString();
- if (test == "True")
- {
- cmd1.CommandText = "select angenommen from angebot where titel = '" + r["Titel"].ToString() + "'";
- r2.Close();
- r2 = cmd1.ExecuteReader();
- if (r2.Read())
- {
- if (r2[0].ToString() == "True")
- {
- <td> <button value="Offentlich @r["AngebotID"].ToString()" type="submit" name="Sicht">Öffentlich</button></td>
- }
- else
- {
- <td> <button value="Ausstehend @r["AngebotID"].ToString()" type="submit" name="Sicht">ausstehend</button></td>
- }
- }
- }
- }
- r2.Close();
- con1.Close();
- }
- }
- </tr>
- </tbody>
- }
- r.Close();
- con.Close();
- }
- catch (Exception e)
- {
- }
- con = new MySqlConnection(constring);
- try
- {
- con.Open();
- MySqlCommand cmd = con.CreateCommand();
- cmd.CommandText = "select angebot.angebotid, benutzer.nr from angebot, benutzer WHERE angebot.Titel = '" + upvote_ + "' and benutzer.nr = '" + Session["user"].ToString() + "'";
- MySqlDataReader r = cmd.ExecuteReader();
- if (!r.Read())
- {
- if (!upvote_.IsEmpty())
- {
- r.Close();
- cmd.CommandText = "UPDATE angebot SET Votes = Votes + 1 WHERE angebot.Titel = '" + upvote_ + "'";
- r = cmd.ExecuteReader();
- con.Close();
- }
- }
- }
- catch (Exception e)
- {
- }
- }
- </table>
- </form>
- </div>
- </div>
- </div>
- </main>
- </div>
- </div>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement