public static void UpdateQtr(Qtr qtr)
{
String connectionString = DataManager.OraConnString();
string query = " update pmis_quarter set allot_ref= '" + qtr.AllotRef + "',ref_date= convert('" + qtr.RefDate + "','dd/mm/rrrr'), " +
" post_date= convert('" + qtr.PostDate + "','dd/mm/rrrr'),locat= '" + qtr.Locat + "', road= '" + qtr.Road + "'," +
" build= '" + qtr.Build + "',flat= '" + qtr.Flat + "',flat_typ= '" + qtr.FlatTyp + "',sizee= '" + qtr.Sizee + "' where emp_no='" + qtr.EmpNo + "' and allot_ref='" + qtr.AllotRef + "'";
DataManager.ExecuteNonQuery(connectionString, query);
}
public static void CreateQtr(Qtr qtr)
{
String connectionString = DataManager.OraConnString();
string query = " insert into pmis_quarter (emp_no,allot_ref,ref_date,post_date,locat,road,build,flat,flat_typ,sizee) values (" +
" " + " '" + qtr.EmpNo + "'," + " '" + qtr.AllotRef + "'," + " convert('" + qtr.RefDate + "','dd/mm/rrrr'), " +
" " + " convert('" + qtr.PostDate + "','dd/mm/rrrr')," + " '" + qtr.Locat + "', " + " '" + qtr.Road + "'," +
" " + " '" + qtr.Build + "'," + " '" + qtr.Flat + "'," + " '" + qtr.FlatTyp + "'," + " '" + qtr.Sizee + "')";
DataManager.ExecuteNonQuery(connectionString, query);
}
