/// <summary>
/// Update inventure
/// </summary>
/// <param name="message"></param>
/// <param name="obj"></param>
/// <returns></returns>
public bool Update(StringBuilder message, Inventura obj)
{
bool xyz = false;
SqlCommand sqlUpit = new SqlCommand();
sqlUpit.Connection = client.sqlConnection;
sqlUpit.CommandType = CommandType.Text;
sqlUpit.Parameters.Add(new SqlParameter("@ID", pID));
sqlUpit.Parameters.Add(new SqlParameter("@DatumInventure", Inventura.datumInventure));
sqlUpit.Parameters.Add(new SqlParameter("@IDGodina", obj.idGodina));
sqlUpit.Parameters.Add(new SqlParameter("@IDSKladiste", obj.idSkladiste));
sqlUpit.Parameters.Add(new SqlParameter("@TS", DateTime.Now));
sqlUpit.CommandText = "UPDATE [dbo].[MT_Inventura] SET DatumInventure = @DatumInventure,IDSKladiste = @IDSKladiste,IDGodina = @IDGodina,TS = @TS WHERE ID = @ID";
try
{
sqlUpit.ExecuteNonQuery();
xyz = true;
}
catch (SqlException greska)
{
message.Append(greska.Message);
return(xyz);
}
catch (Exception greska)
{
message.Append(greska.Message);
return(xyz);
}
return(xyz);
}
public bool Insert(StringBuilder message, Inventura obj)
{
bool x = false;
SqlConnection conn = new SqlConnection();
conn = client.sqlConnection;
if (client.sqlConnection.State == ConnectionState.Closed)
{
conn.Open();
}
try
{
//dohvat iz StanjaSkladišta!
SqlCommand com = new SqlCommand("spStanjeSkladista", conn);
com.Parameters.AddWithValue("@idSkladista", obj.idSkladiste);
com.Parameters.AddWithValue("@datum", Inventura.datumInventure);
com.Parameters.AddWithValue("@order", "PROIZVOD.NAZIVPROIZVOD");
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(com);
com.CommandType = CommandType.StoredProcedure;
da.Fill(dt); //ova tablica se puni u MT_InventuraStavke
if (dt.Rows.Count == 0)
{
MessageBox.Show("Odabrana inventura ne sadrži nikakve proizvode.");
return(false);
}
//prvo upis inventure u bazu
SqlCommand comm = new SqlCommand();
comm.Connection = client.sqlConnection;
comm.CommandText = "Insert into MT_Inventura (DatumInventure, IDSKladiste, IDGodina, TS) values (@DatumInventure, @IDSKladiste, @IDGodina, @TS) Select @@Identity";
comm.Parameters.AddWithValue("@DatumInventure", Inventura.datumInventure);
comm.Parameters.AddWithValue("@IDSkladiste", obj.idSkladiste);
comm.Parameters.AddWithValue("@IDGodina", obj.idGodina);
comm.Parameters.AddWithValue("@TS", DateTime.Now);
int idInventura = 0;
try
{
idInventura = Convert.ToInt32(comm.ExecuteScalar());
x = true;
}
catch { }
//onda i upis stavki
for (int i = 0; i < dt.Rows.Count; i++)
{
int idSkladiste = Convert.ToInt32(dt.Rows[i]["ID_Skladiste"]);
int idProizvod = Convert.ToInt32(dt.Rows[i]["IDProizvod"]);
decimal stanje = Convert.ToDecimal(dt.Rows[i]["Stanje"]);
decimal cijena = 0;
if (dt.Rows[i]["CijenaPDV"].ToString().Equals(""))
{
cijena = 0;
}
else
{
cijena = Convert.ToDecimal(dt.Rows[i]["CijenaPDV"]);
cijena = Math.Round(cijena, 2);
}
SqlCommand commm = new SqlCommand();
commm.Connection = client.sqlConnection;
commm.CommandText = ("INSERT INTO MT_InventuraStavka ([ID_Inventura],[ID_Proizvod],[CijenaPDV],[KolicinaZaliha],[StvarnaKolicina]) VALUES (@idInventura, @idProizvod, @Cijena, @stanje, @nula) ");
commm.Parameters.AddWithValue("@idInventura", idInventura);
commm.Parameters.AddWithValue("@idProizvod", idProizvod);
commm.Parameters.AddWithValue("@Cijena", cijena == 0? DBNull.Value:(object)cijena);
commm.Parameters.AddWithValue("@stanje", stanje);
commm.Parameters.AddWithValue("@nula", DBNull.Value);
commm.ExecuteNonQuery();
}
}
catch
{
conn.Close();
}
return(x);
}
