private bool LoadData()
{
bool res;
try
{
AccountForm.CheckPointsTable(cn, null);
AccountForm.OrderPoints(cn, null);
// TODO: This line of code loads data into the 'dsClimbing.Points' table. You can move, or remove it, as needed.
this.pointsTableAdapter.Fill(this.dsClimbing.Points);
SqlCommand cmd = new SqlCommand("SELECT pts FROM Points WHERE pos = 0", cn);
object oTmp = cmd.ExecuteScalar();
if (oTmp == null || oTmp == DBNull.Value)
{
tbLastPoints.Text = "0";
}
else
{
tbLastPoints.Text = Convert.ToDouble(oTmp).ToString();
}
res = true;
}
catch (Exception ex)
{
MessageBox.Show("Ошибка загрузки данных:\r\n" + ex.Message);
res = false;
}
return(res);
}
private void btnOK_Click(object sender, EventArgs e)
{
try
{
this.pointsBindingSource.EndEdit();
SqlTransaction tranOld = this.pointsTableAdapter.Transaction;
this.pointsTableAdapter.Transaction = cn.BeginTransaction();
bool transactionSuccess = false;
try
{
this.pointsTableAdapter.Update(dsClimbing);
AccountForm.OrderPoints(cn, this.pointsTableAdapter.Transaction);
double lastPts;
if (tbLastPoints.Text.Length < 1)
{
lastPts = -1.0;
}
else if (!getDoubleFromString(tbLastPoints.Text, out lastPts))
{
MessageBox.Show(this, "Очки последним участникам введены неверно");
return;
}
SqlCommand cmd = new SqlCommand();
cmd.Connection = cn;
cmd.Transaction = this.pointsTableAdapter.Transaction;
cmd.CommandText = "DELETE FROM Points WHERE pos = 0";
cmd.ExecuteNonQuery();
if (lastPts > 0.0)
{
cmd.CommandText = "INSERT INTO Points(pos,pts) VALUES (0,@pts)";
cmd.Parameters.Add("@pts", SqlDbType.Float);
cmd.Parameters[0].Value = lastPts;
cmd.ExecuteNonQuery();
}
transactionSuccess = true;
}
finally
{
if (transactionSuccess)
{
this.pointsTableAdapter.Transaction.Commit();
this.Close();
}
else
{
try { this.pointsTableAdapter.Transaction.Rollback(); }
catch { }
}
this.pointsTableAdapter.Transaction = tranOld;
}
}
catch (Exception ex) { MessageBox.Show("Ошибка сохранения данных:\r\n" + ex.Message); }
}