public ActionResult DodajPoklon(PokloniModel model)
{
string connStr = ConfigurationManager.ConnectionStrings["dbPopisPoklona"].ConnectionString;
try
{
using (SqlConnection conn = new SqlConnection(connStr))
{
string cmdText = "";
cmdText += "INSERT INTO tblPopisPoklona ";
cmdText += "(NazivPoklona, CijenaPoklona, KupljenPoklon) ";
cmdText += "VALUES ";
cmdText += "('" + model.NazivPoklona + "', '"
+ model.CijenaPoklona + "', '" + model.KupljenPoklon + "') ";
SqlCommand cmd = new SqlCommand(cmdText, conn);
cmd.Connection.Open();
int brojDodanihPoklona = cmd.ExecuteNonQuery();
ViewBag.Message = "Broj dodanih poklona: " + brojDodanihPoklona;
}
}
catch (Exception ex)
{
ViewBag.Message = "Greška kod dodavanja poklona. Opis: " + ex.Message;
}
return(View(model));
}
public ActionResult Uredi(PokloniModel model)
{
try
{
using (SqlConnection conn = new SqlConnection(connStr))
{
string cmdText = "";
cmdText += "UPDATE tblPopisPoklona ";
cmdText += "SET KupljenPoklon = '" + model.KupljenPoklon;
cmdText += "' WHERE IdPoklon = '" + model.IdPoklon + "'";
SqlCommand cmd = new SqlCommand(cmdText, conn);
cmd.Connection.Open();
int brojDodanihPoklona = cmd.ExecuteNonQuery();
if (brojDodanihPoklona > 0)
{
ViewBag.Message = "Zapis je upisan u bazi";
}
else
{
ViewBag.Message = "Dogodila se greška!";
}
}
}
catch (Exception ex)
{
ViewBag.Message = "Greška kod dodavanja poklona. Opis: " + ex.Message;
}
return(View(model));
}
public ActionResult Uredi(int IdPoklon)
{
SqlConnection conn = new SqlConnection(connStr);
string cmdText = "SELECT * FROM tblPopisPoklona WHERE IdPoklon=@IdPoklon";
SqlCommand cmd = new SqlCommand(cmdText, conn);
SqlParameter param = new SqlParameter();
param.ParameterName = "@IdPoklon";
param.DbType = DbType.Int32;
param.Direction = ParameterDirection.Input;
param.Value = IdPoklon;
cmd.Parameters.Add(param);
SqlDataReader dr = null;
PokloniModel pokloni = new PokloniModel();
try
{
conn.Open();
dr = cmd.ExecuteReader();
if (dr != null)
{
if (dr.HasRows)
{
while (dr.Read())
{
//pokloni.IdPoklon = int.Parse(dr["IdPoklon"].ToString());
//pokloni.NazivPoklona = dr["NazivPoklona"].ToString();
//pokloni.CijenaPoklona = double.Parse(dr["CijenaPoklona"].ToString());
pokloni.KupljenPoklon = bool.Parse(dr["KupljenPoklon"].ToString());
}
}
}
}
catch (Exception ex)
{
ViewBag.Message = "Greška kod dohvaćanja poklona. Opis: " + ex.Message;
}
finally
{
if (dr != null)
{
dr.Close();
}
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
conn.Dispose();
cmd.Dispose();
}
return(View(pokloni));
}
public ActionResult ListaPoklona()
{
SqlConnection conn = new SqlConnection(connStr);
SqlCommand cm = new SqlCommand();
cm.Connection = conn;
cm.CommandText = "SELECT * FROM tblPopisPoklona";
SqlDataReader dr = null;
List <PokloniModel> lstPokloni = new List <PokloniModel>();
try
{
conn.Open();
dr = cm.ExecuteReader();
if (dr != null)
{
if (dr.HasRows)
{
while (dr.Read())
{
PokloniModel pokloni = new PokloniModel();
pokloni.IdPoklon = int.Parse(dr["IdPoklon"].ToString());
pokloni.NazivPoklona = dr["NazivPoklona"].ToString();
pokloni.CijenaPoklona = double.Parse(dr["CijenaPoklona"].ToString());
pokloni.KupljenPoklon = bool.Parse(dr["KupljenPoklon"].ToString());
lstPokloni.Add(pokloni);
}
}
}
}
catch (Exception ex)
{
ViewBag.Message = "Greška kod dohvaćanja liste poklona. Opis: " + ex.Message;
}
finally
{
if (dr != null)
{
dr.Close();
}
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
conn.Dispose();
cm.Dispose();
}
return(View(lstPokloni));
}