/// <summary>
/// Prepare a command.
/// </summary>
private static void PrepareCommand(SqlCommand command, Platba platba)
{
command.Parameters.AddWithValue("@id_platba", platba.id_platba);
command.Parameters.AddWithValue("@faktura", platba.cislo_f);
command.Parameters.AddWithValue("@typ_platby", platba.typ_pl);
command.Parameters.AddWithValue("@castka", platba.castka);
}
protected void rezervaceZak_SelectedIndexChanged(object sender, EventArgs e)
{
cisloR = Int32.Parse(rezervaceZak.SelectedRow.Cells[1].Text);
faktura = mapper.FindFak(cisloR);
platba = mapper.FindPlat(cisloR);
auta = mapper.FindAutaOnRez(cisloR);
DateTime nope = new DateTime(0001, 01, 01, 0, 0, 0);
string f = "Číslo faktury " + faktura.cisloFaktury + " Vytvořeno " + faktura.vytvorena + " Potvrzeno " + faktura.potvrzena + " Zaplaceno ";
if (faktura.zaplacena == nope)
{
f += "ne";
}
else
{
f += faktura.zaplacena;
}
string p = "Rezervace nebyla zaplacena";
if (platba != null)
{
p = "Číslo platby " + platba.id_platby + " Typ platby " + platba.typ_platby + " Částka " + platba.castka;
}
fak.Text = f;
plat.Text = p;
autaRez.DataSource = auta;
autaRez.DataBind();
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
string typ = vypsatDetail.Text;
BindingSource binding = new BindingSource();
switch (typ)
{
case ("Auta"):
List <Auto> auta = new List <Auto>();
auta = mapper.FindAutaOnRez(cisloR);
binding.DataSource = auta;
dataNaRez.DataSource = binding;
break;
case ("Faktura"):
Faktura faktura = mapper.FindFak(cisloR);
binding.DataSource = faktura;
dataNaRez.DataSource = binding;
break;
case ("Platba"):
Platba platba = mapper.FindPlat(cisloR);
binding.DataSource = platba;
dataNaRez.DataSource = binding;
break;
}
}
public int SavePlat(Platba platba)
{
SqlConnectionStringBuilder builder = DBConnector.GetBuilder();
using (SqlConnection connection = new SqlConnection(builder.ConnectionString))
{
connection.Open();
StringBuilder sb = new StringBuilder();
sb.Clear();
sb.Append("INSERT INTO vis.platba (id_platba,cislo_faktury,typ_platby,castka)");
sb.Append("VALUES (@id, @cisloF, @typ_platby, @castka);");
//sb.Append("SELECT CAST(scope_identity() AS int)");
string sql = sb.ToString();
using (SqlCommand command = new SqlCommand(sql, connection))
{
command.Parameters.AddWithValue("@id", platba.id_platby);
command.Parameters.AddWithValue("@cisloF", platba.cisloFaktury);
command.Parameters.AddWithValue("@typ_platby", platba.typ_platby);
command.Parameters.AddWithValue("@castka", platba.castka);
}
}
return(0);
}
/*
* /// <summary>
* /// Select records.
* /// </summary>
* public Collection<Platba> select()
* {
* Database db;
* if (pDb == null)
* {
* db = new Database();
* db.Connect();
* }
* else
* {
* db = (Database)pDb;
* }
*
* SqlCommand command = db.CreateCommand(SQL_SELECT);
* SqlDataReader reader = db.Select(command);
*
* Collection<Platba> Platbas = Read(reader, true);
* reader.Close();
* if (pDb == null)
* {
* db.Close();
* }
* return Platbas;
* }
*/
/// <summary>
/// Select records for platba.
/// </summary>
public Platba select(int id_platba, Database pDb = null)
{
Database db;
if (pDb == null)
{
db = new Database();
db.Connect();
}
else
{
db = (Database)pDb;
}
SqlCommand command = db.CreateCommand(SQL_SELECT_ID);
command.Parameters.AddWithValue("@id_platba", id_platba);
SqlDataReader reader = db.Select(command);
Collection <Platba> platbas = Read(reader);
Platba platba = null;
if (platbas.Count == 1)
{
platba = platbas[0];
}
reader.Close();
if (pDb == null)
{
db.Close();
}
return(platba);
}
private static Platba MapPlaToObj(SqlDataReader reader)
{
Platba platba = new Platba();
platba.id_platby = reader.GetInt32(0);
platba.cisloFaktury = reader.GetInt32(1);
platba.typ_platby = reader.GetString(2);
platba.castka = reader.GetInt32(3);
return(platba);
}
protected void Page_Load(object sender, EventArgs e)
{
rezervace = new List <Rezervace>();
zakaznici = new List <Zakaznik>();
zakaznik = new Zakaznik();
faktura = new Faktura();
platba = new Platba();
auta = new List <Auto>();
zakaznici = mapper.FindZak();
vsichniZak.DataSource = zakaznici;
vsichniZak.DataBind();
}
public int DeletePlat(Platba platba)
{
SqlConnectionStringBuilder builder = DBConnector.GetBuilder();
using (SqlConnection connection = new SqlConnection(builder.ConnectionString))
{
connection.Open();
StringBuilder sb = new StringBuilder();
sb.Clear();
sb.Append("DELETE FROM vis.platba where id_platba = @id");
string sql = sb.ToString();
using (SqlCommand command = new SqlCommand(sql, connection))
{
command.Parameters.AddWithValue("@id", platba.id_platby);
}
}
return(0);
}
private static Collection <Platba> Read(SqlDataReader reader, bool withItemsCount = false)
{
Collection <Platba> platbas = new Collection <Platba>();
while (reader.Read())
{
Platba platba = new Platba();
int i = -1;
platba.id_platba = reader.GetInt32(++i);
platba.cislo_f = reader.GetInt32(++i);
platba.faktura = new Faktura();
platba.faktura.cislo_faktury = platba.cislo_f;
platba.typ_pl = reader.GetInt32(++i);
platba.typ_platby = new Typ_platby();
platba.typ_platby.id_typ_platby = platba.typ_pl;
platba.castka = reader.GetInt32(++i);
platbas.Add(platba);
}
return(platbas);
}
public Platba FindPlat(int cisloR)
{
string sql = ("Select id_platba, p.cislo_faktury,typ_platby, castka from vis.Platba p JOIN vis.faktura f on f.cislo_faktury = p.cislo_faktury where f.cislo_rezervace = @cisloR");
Platba platba = null;
using (SqlConnection connection = new SqlConnection(DBConnector.GetBuilder().ConnectionString))
{
connection.Open();
using (SqlCommand cmd = new SqlCommand(sql, connection))
{
cmd.Parameters.AddWithValue("@cisloR", cisloR);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
platba = MapPlaToObj(reader);
}
}
}
}
return(platba);
}
/// <summary>
/// Update the record.
/// </summary>
/// <param nazev="platba"></param>
/// <returns></returns>
public static int update(Platba platba, Database pDb = null)
{
Database db;
if (pDb == null)
{
db = new Database();
db.Connect();
}
else
{
db = (Database)pDb;
}
SqlCommand command = db.CreateCommand(SQL_UPDATE);
PrepareCommand(command, platba);
int ret = db.ExecuteNonQuery(command);
if (pDb == null)
{
db.Close();
}
return(ret);
}
