private void Save_ti_Click(object sender, EventArgs e)
{
Taraz taraz = new Taraz()
{
Id = _Id,
AccountName = AccountName_txbox.Text,
GardeshBedehkar = Convert.ToInt32(GardeshBedehkar_txbox.Text),
GardeshBestankar = Convert.ToInt32(GardeshBestankar_txbox.Text),
MandeBedehkar = Convert.ToInt32(MandeBedehkar_txbox.Text),
MandeBestankar = Convert.ToInt32(MandeBestankar_txbox.Text),
TotalGardeshBedehkar = Convert.ToInt32(TotalGardeshBedehkar_txbox.Text),
TotalGardeshBestankar = Convert.ToInt32(TotalGardeshBestankar_txbox.Text),
TotalMandeBedehkar = Convert.ToInt32(TotalMandeBedehkar_txbox.Text),
TotalMandeBestankar = Convert.ToInt32(TotalMandeBestankar_txbox.Text)
};
int result = _repository.Update(taraz);
if (result > 0)
{
this.Close();
}
else
{
MessageBox.Show("خطا");
}
}
public int Update(Taraz taraz)
{
int result = 0;
SqlConnection connection = new SqlConnection(connectionString);
SqlCommand command = new SqlCommand("Usp_Taraz_Update", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@Id", taraz.Id);
command.Parameters.AddWithValue("@AccountName", taraz.AccountName);
command.Parameters.AddWithValue("@GardeshBedehkar", taraz.GardeshBedehkar);
command.Parameters.AddWithValue("@GardeshBestankar", taraz.GardeshBestankar);
command.Parameters.AddWithValue("@MandeBedehkar", taraz.MandeBedehkar);
command.Parameters.AddWithValue("@MandeBestankar", taraz.MandeBestankar);
command.Parameters.AddWithValue("@TotalGardeshBedehkar", taraz.TotalGardeshBedehkar);
command.Parameters.AddWithValue("@TotalGardeshBestankar", taraz.TotalGardeshBestankar);
command.Parameters.AddWithValue("@TotalMandeBedehkar", taraz.TotalMandeBedehkar);
command.Parameters.AddWithValue("@TotalMandeBestankar", taraz.TotalMandeBestankar);
connection.Open();
result = command.ExecuteNonQuery();
connection.Close();
return(result);
}
private void UpdateTaraz_Load(object sender, EventArgs e)
{
Taraz taraz = _repository.GetById(_Id);
AccountName_txbox.Text = taraz.AccountName;
GardeshBedehkar_txbox.Text = taraz.GardeshBedehkar.ToString();
GardeshBestankar_txbox.Text = taraz.GardeshBestankar.ToString();
MandeBedehkar_txbox.Text = taraz.MandeBedehkar.ToString();
MandeBestankar_txbox.Text = taraz.MandeBestankar.ToString();
TotalGardeshBedehkar_txbox.Text = taraz.TotalGardeshBedehkar.ToString();
TotalGardeshBestankar_txbox.Text = taraz.TotalGardeshBestankar.ToString();
TotalMandeBedehkar_txbox.Text = taraz.TotalMandeBedehkar.ToString();
TotalMandeBestankar_txbox.Text = taraz.TotalMandeBestankar.ToString();
}
public Taraz GetById(int id)
{
Taraz taraz = new Taraz();
SqlConnection connection = new SqlConnection(connectionString);
SqlCommand command = new SqlCommand("Usp_Taraz_GetById", connection);
command.Parameters.AddWithValue("@Id", id);
command.CommandType = CommandType.StoredProcedure;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
if (reader.HasRows)
{
//var result = reader.GetValue(1);
taraz.Id = (int)reader["Id"];
taraz.AccountName = reader["AccountName"].ToString();
taraz.GardeshBedehkar = (int)reader["GardeshBedehkar"];
taraz.GardeshBestankar = (int)reader["GardeshBestankar"];
taraz.MandeBedehkar = (int)reader["MandeBedehkar"];
taraz.MandeBestankar = (int)reader["MandeBestankar"];
taraz.TotalGardeshBedehkar = (int)reader["TotalGardeshBedehkar"];
taraz.TotalGardeshBestankar = (int)reader["TotalGardeshBestankar"];
taraz.TotalMandeBedehkar = (int)reader["TotalMandeBedehkar"];
taraz.TotalMandeBestankar = (int)reader["TotalMandeBestankar"];
}
}
connection.Close();
return(taraz);
}
