public FormularzZobacz(WniosekModel model)
{
{
InitializeComponent();
p = model;
WireUpLists(p);
}
}
public void zmienstatus(WniosekModel model)
{
using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GlobalConfig.CnnString("Projekt_PO")))
{
var p = new DynamicParameters();
p.Add("@Id", model.Id);
p.Add("@Wartosc", model.Stan);
connection.Execute("dbo.spZmianaWartoscForm", p, commandType: CommandType.StoredProcedure);
}
}
private void Wyslij_Click(object sender, EventArgs e)
{
wniosek.zawartosc = richTextBox1.Text;
wniosek = GlobalConfig.Connections.DodajWniosek(wniosek);
GlobalConfig.Connections.PrzypisanieFormularza(p.Id, wniosek.Id);
richTextBox1.Text = null;
MessageBox.Show("Wniosek zostal wyslany");
}
public WniosekModel DodajWniosek(WniosekModel wniosek)
{
using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GlobalConfig.CnnString("Projekt_PO")))
{
var p = new DynamicParameters();
p.Add("@Zawartosc", wniosek.zawartosc);
p.Add("@id", 0, dbType: DbType.Int32, direction: ParameterDirection.Output);
connection.Execute("dbo.spDodajFormularz", p, commandType: CommandType.StoredProcedure);
wniosek.Id = p.Get <int>("@id");
return(wniosek);
}
}
void WireUpLists(WniosekModel p)
{
WniosekTextBox.Text = p.zawartosc;
}
