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 } }