public MeasurementForm(Treatment treatment, SmileFile file, MainWindow m)
{
InitializeComponent();
app = System.Windows.Application.Current as App;
Mantooth = new List<MeasurementTeeth>();
Autotooth = new List<MeasurementTeeth>();
DB = DentalSmileDBFactory.GetInstance();
this.mw = m;
//TODO: DB.User = app.user.UserId;
measurement = new Measurement();
string treatment_id = treatment.Id;
if (treatment_id == null)
{
treatment_id = treatment.RefId;
}
measurement.Treatment = treatment_id;
measurement.Patient = treatment.Patient.Id;
measurement.Pfile = file.Id;
string measurement_id = checkPreviousData(file.Id) ;
if(measurement_id !=null)
{ LoadMeasurementGrid(measurement_id); }
}
internal bool insertMeasurement(Measurement measurement)
{
if (this.OpenConnection() == true)
{
string tableName = "measurement";
string columns = "(patient, treatment, pfile, type, created, createdBy)";
string values = "";
values = "('" + measurement.Patient + "','" + measurement.Treatment + "','" + measurement.Pfile + "'," + measurement.Type + ",'" + DateTime.Now.ToString(Smile.LONG_DATE_FORMAT) + "','"+User+"')";
string query = "INSERT INTO " + tableName + " " + columns + " values " + values + " ;";
IDbCommand cmd = getSqlCommand(query, connection);
cmd.ExecuteNonQuery();
//measurement.Id = (int) cmd.LastInsertedId;
measurement.Id = getLastInsertId(cmd, query, connection);
this.CloseConnection();
return true;
}
return false;
}
private Measurement toMeasurement(IDataReader dataReader)
{
Measurement p = new Measurement();
p.Id = Convert.ToInt32(GetStringSafe(dataReader, "id"));
p.Patient = GetStringSafe(dataReader, "patient");
p.Pfile = GetStringSafe(dataReader, "pfile");
p.Treatment = GetStringSafe(dataReader, "treatment");
p.Type = GetStringSafe(dataReader, "type");
return p;
}
internal bool insertMeasurementTeeth(Measurement measurement, List<MeasurementTeeth> results)
{
if (this.OpenConnection() == true)
{
string tableName = "measurementteeth";
string columns = "(measurementid, teethId, length, spoint, epoint,type)";
string values = "";
foreach (MeasurementTeeth m in results)
{
values = "(" + measurement.Id + ",'" + m.Identity + "'," + m.Length + ",'" + m.SPoint + "','" + m.EPoint + "','" + m.Type+ "')";
string query = "INSERT INTO " + tableName + " " + columns + " values " + values + " ;";
IDbCommand cmd = getSqlCommand(query, connection);
cmd.ExecuteNonQuery();
m.Id = getLastInsertId(cmd, query, connection);
//m.Id = (int)cmd.LastInsertedId;
}
this.CloseConnection();
return true;
}
return false;
}
