public static void UpdateSusp(Susp susp)
{
String connectionString = DataManager.OraConnString();
string query = " update pmis_suspension set off_order_no= '" + susp.OffOrderNo + "',suspen_date= convert('" + susp.SuspenDate + "','dd/mm/rrrr'),suspen_clause= '" + susp.SuspenClause + "', " +
" withdraw_order_no= '" + susp.WithdrawOrderNo + "',with_date= convert('" + susp.WithDate + "','dd/mm/rrrr'), punishment= '" + susp.Punishment + "' where emp_no='" + susp.EmpNo + "' and off_order_no='" + susp.OffOrderNo + "'";
DataManager.ExecuteNonQuery(connectionString, query);
}
public static void CreateSusp(Susp susp)
{
String connectionString = DataManager.OraConnString();
string query = " insert into pmis_suspension (emp_no,off_order_no,suspen_date,suspen_clause,withdraw_order_no,with_date,punishment) values (" +
" " + " '" + susp.EmpNo + "'," + " '" + susp.OffOrderNo + "'," + " convert('" + susp.SuspenDate + "','dd/mm/rrrr')," + " '" + susp.SuspenClause + "', " +
" " + " '" + susp.WithdrawOrderNo + "'," + " convert('" + susp.WithDate + "','dd/mm/rrrr'), " + " '" + susp.Punishment + "')";
DataManager.ExecuteNonQuery(connectionString, query);
}
private void WorldMap_FormClosing(object sender, FormClosingEventArgs e)
{
FileStream file = new FileStream(@"DataBases\suspects.ipd", FileMode.Create);
StreamWriter writer = new StreamWriter(file);
foreach (Suspect Susp in suspects)
{
writer.WriteLine(Susp.ToString());
}
writer.Close();
file.Close();
}
