protected void btnUpdatePart_Click(object sender, EventArgs e)
{
if (txtPart.Text != "")
{
try
{
SqlConnection sqlconn = new SqlConnection(conn_str);
//test macak345sasdasdcv
SqlCommand sqlcomm = new SqlCommand("Parts_Save", sqlconn);
sqlcomm.CommandType = CommandType.StoredProcedure;
sqlcomm.Parameters.Add("@id", SqlDbType.Int);
sqlcomm.Parameters[0].Value = hfSelectedIndex.Value;
sqlcomm.Parameters.Add("@parts", SqlDbType.Text);
sqlcomm.Parameters[1].Value = txtPart.Text;
string id;
sqlconn.Open();
id = sqlcomm.ExecuteScalar().ToString();
if (id != "0")
{
Poruka.PorukaRedirekcija(this, "Item updated successfully.", ResolveUrl("Parts.aspx?id=" + hfSelectedIndex.Value));
}
else
{
Poruka.PorukaRedirekcija(this, "Item already exists.", ResolveUrl("Parts.aspx"));
}
sqlconn.Close();
}
catch (Exception ex)
{
ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + ex.Message.ToString() + "');", true);
}
}
else
{
Poruka.PorukaRedirekcija(this, "Enter value.", ResolveUrl("Parts.aspx"));
}
}
protected void btnNewYear_Click(object sender, EventArgs e)
{
if (txtYear.Text != "")
{
try
{
SqlConnection sqlconn = new SqlConnection(conn_str);
SqlCommand sqlcomm = new SqlCommand("Years_New", sqlconn);
sqlcomm.CommandType = CommandType.StoredProcedure;
sqlcomm.Parameters.Add("@years", SqlDbType.Int);
sqlcomm.Parameters[0].Value = txtYear.Text;
string id;
sqlconn.Open();
id = sqlcomm.ExecuteScalar().ToString();
if (id != "0")
{
Poruka.PorukaRedirekcija(this, "Item added successfully.", ResolveUrl("Years.aspx?id=" + id));
}
else
{
Poruka.PorukaRedirekcija(this, "Item already exists.", ResolveUrl("Years.aspx"));
}
sqlconn.Close();
}
catch (Exception ex)
{
ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + ex.Message.ToString() + "');", true);
}
}
else
{
Poruka.PorukaRedirekcija(this, "Enter value.", ResolveUrl("Years.aspx"));
}
}
