//UPDATES
internal void updateMidnStatusType(MidnStatusType statusType)
{
String sql = "update MIDN_STATUS set status=:x where id=:y";
using (MedMidsContext db = new MedMidsContext())
{
db.Database.ExecuteSqlCommand(sql, new OracleParameter(":x", statusType.Status)
, new OracleParameter(":y", statusType.Id));
}
}
internal int addMidnStatusType(MidnStatusType midnstatus)
{
string sql = "insert into MIDN_STATUS (STATUS) values (:s)";
var data = db.Database.ExecuteSqlCommand(sql,
new OracleParameter(":s", midnstatus.Status)
);
return data;
}