public FineSettings_Info View_Fine_Settings(int latncy_id)
{
con.Open();
SqlCommand cmd = new SqlCommand("View_Fine_Settings", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter p = new SqlParameter();
p = cmd.Parameters.Add("@latency_id", SqlDbType.Int);
p.Value = latncy_id;
SqlDataReader read = cmd.ExecuteReader();
FineSettings_Info f_info = new FineSettings_Info();
if (read.Read())
{
f_info.Latency_Time = float.Parse(read["latency_time"].ToString());
f_info.Fine = float.Parse(read["fine"].ToString());
}
else
{
f_info.Latency_Time = 1000.1000F;
}
read.Close();
con.Close();
return(f_info);
}
public void Update_Fine_Settings(FineSettings_Info info)
{
con.Open();
SqlCommand cmd = new SqlCommand("Update_Fine_Settings", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter p = new SqlParameter();
p = cmd.Parameters.Add("@latency_id", SqlDbType.Int);
p.Value = info.Latency_Id;
p = cmd.Parameters.Add("@latency_time", SqlDbType.Float);
p.Value = info.Latency_Time;
p = cmd.Parameters.Add("@fine", SqlDbType.Float);
p.Value = info.Fine;
cmd.ExecuteNonQuery();
con.Close();
}
