private void lbOptics_SelectedIndexChanged(object sender, EventArgs e)
{
UpdateEditingMode(EditingModes.Edit, ref emOptics, ref lblOptics, "Optics");
currentOptic = listOptics[lbOptics.SelectedIndex];
LoadOpticData(currentOptic);
}
public static int AddOptics(Optic optic)
{
SqlConnection con = DbManager.GetConnection();
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "INSERT INTO [tblOptics] ([Type],[Value]) " +
"OUTPUT INSERTED.Id " +
"VALUES (@Type,@Value)";
cmd.Parameters.AddWithValue("@Type", (int)optic.OpticType);
cmd.Parameters.AddWithValue("@Value", optic.Value);
int res = int.Parse(cmd.ExecuteScalar().ToString());
con.Close();
return(res);
}
public static void EditOptics(int Id, Optic optic)
{
SqlConnection con = DbManager.GetConnection();
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "UPDATE [tblOptics] SET " +
"[Type] = @Type, " +
"[Value] = @Value " +
"WHERE [Id] = @Id";
cmd.Parameters.AddWithValue("@Type", (int)optic.OpticType);
cmd.Parameters.AddWithValue("@Value", optic.Value);
cmd.Parameters.AddWithValue("@Id", Id);
cmd.ExecuteNonQuery();
con.Close();
}
private void LoadOpticData(Optic Optic)
{
tbOpticId.Text = Optic.Id.ToString();
cbOpticType.SelectedIndex = (int)Optic.OpticType;
tbOpticValue.Text = Optic.Value.ToString();
}
// Optics
private void btnOpticsSave_Click(object sender, EventArgs e)
{
// Valiations:
if (cbOpticType.SelectedIndex == -1)
{
errorProvider.SetError(cbOpticType, "Must provide a value.");
}
else
{
errorProvider.SetError(cbOpticType, "");
}
if (tbOpticValue.Text.Length == -1)
{
errorProvider.SetError(tbOpticValue, "Must provide a value.");
return;
}
else
{
errorProvider.SetError(tbOpticValue, "");
}
if (!float.TryParse(tbOpticValue.Text, out _))
{
errorProvider.SetError(tbOpticValue, "Invalid format.");
return;
}
else
{
errorProvider.SetError(tbOpticValue, "");
}
// Save new/changes:
int id = 0;
Optic.OpticTypes type = (Optic.OpticTypes)cbOpticType.SelectedIndex;
double value = double.Parse(tbOpticValue.Text);
if (emOptics == EditingModes.Add)
{
id = 0;
}
else
{
id = currentOptic.Id;
}
Optic candidate = new Optic(id, type, value);
if (emOptics == EditingModes.Add)
{
id = OpticsController.AddOptics(candidate);
}
else
{
OpticsController.EditOptics(id, candidate);
}
// Reload data:
lblStatus.Text = "Issuing optics saving command... ";
currentOptic = OpticsController.GetOptics(new List <int>()
{
id
})[0];
LoadOpticData(currentOptic);
PrepareDataLists();
lblStatus.Text += "Complete.";
}
