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; }