private Medicine getFullMedData(Medicine med)
{
string query = "SELECT * FROM OldMeds WHERE {0} = '{1}'";
query = string.Format(query, DatabaseVars.PARCODE, med.Parecode);
OldMed oldMedInfo = new OldMed();
OleDbConnection dbConnection = dbManager.openDb();
this.comand.Connection = dbConnection;
comand.CommandText = query;
OleDbDataReader result = comand.ExecuteReader();
if (result.Read())
{
oldMedInfo.Id1 = result.GetInt32(0);
oldMedInfo.PareCode = result.GetString(1);
oldMedInfo.RemainingAmount = result.GetInt32(2);
oldMedInfo.ExpiryDate = result.GetDateTime(3);
med.Oldmed = oldMedInfo;
}
result.Close();
dbManager.closeDb();
return(med);
}
public void deleteOldMed(OldMed om)
{
string query = "DELETE FROM OldMeds WHERE {0} = {1};";
query = string.Format(query,
DatabaseVars.ID, om.Id1);
inserUpdatetObj.inserUpdatetData(query);
}
private void deleteOldMed()
{
int idnex = oldMedsGridView.CurrentCell.RowIndex;
OldMed om = (OldMed)med.OldmedsList[idnex];
medsOper.deleteOldMed(om);
oldMedsTable.Rows.RemoveAt(idnex);
med.OldmedsList.RemoveAt(idnex);
}
private bool deletOldMed(OldMed om)
{
string query = "DELETE FROM OldMeds WHERE {0} ='{1}' AND {2} = {3};";
query = string.Format(query,
DatabaseVars.PARCODE, om.PareCode,
DatabaseVars.ID, om.Id1);
return(inserUpdatetObj.inserUpdatetData(query));
}
