public static void SetNewLaundry(ILaundry aLaundry)
{
newLaundry = aLaundry;
}
public void createLaundryInDB(ILaundry laundry)
{
try
{
DataSet ds = new DataSet();
string sql = "SELECT * From laundry";
SqlDataAdapter da = new SqlDataAdapter(sql, con);
SqlCommandBuilder cb = new SqlCommandBuilder(da); //Generates
da.Fill(ds, "LaundryData");
totalFaults = ds.Tables["LaundryData"].Rows.Count;
DataRow dRow = ds.Tables["LaundryData"].NewRow();
dRow[0] = Convert.ToInt16(laundry.LaundryID);
dRow[1] = Convert.ToDateTime(laundry.SentDate);
dRow[2] = Convert.ToDouble(laundry.Weight);
dRow[3] = Convert.ToDouble(laundry.Price);
dRow[4] = Convert.ToBoolean(laundry.Returned);
dRow[5] = laundry.Category;
ds.Tables["LaundryData"].Rows.Add(dRow);
da.Update(ds, "LaundryData");
}
catch (System.Exception excep)
{
if (con.State.ToString() == "Open")
con.Close();
Application.Exit();
//Environment.Exit(0); //Force the application to close
}
}
