public void Insert(string p_id, ExaminationType e) { IDatabase db = new MSSqlDatabase(); db.Connect(); DbCommand command = db.CreateCommand(sqlINSERT); PrepareCommand(db, command, e); e.Id = db.ExecuteScalar(command); db.Close(); }
public void InsertRequest(string p_id, Request r) { SampleRequest er = (SampleRequest)r; IDatabase db = new MSSqlDatabase(); db.Connect(); DbCommand command = db.CreateCommand(sqlINSERT); PrepareCommand(db, command, er); er.Id = db.ExecuteScalar(command); db.Close(); }
public void InsertRequest(string p_id, Request r) { Prescription er = (Prescription)r; if (er.Medicines.Count == 0) { throw new ApplicationException(ErrorMessages.Messages["REQ_P_medicines"]); } IDatabase db = new MSSqlDatabase(); db.Connect(); db.BeginTransaction(); DbCommand command = db.CreateCommand(sqlINSERT); PrepareCommand(db, command, er, p_id); er.Id = db.ExecuteScalar(command); int added = this.InsertMedicines(er, db); db.EndTransaction(); if (added != er.Medicines.Count) { db.Rollback(); } db.Close(); }