Esempio n. 1
0
 public void createQuote(object sender, EventArgs e)
 {
     QuoteForm newQuote = (QuoteForm)((Button)sender).FindForm();
     //save
     QuoteItems items = new QuoteItems();
     string id = new Quote().set(franchiseeUserId, newQuote.getServiceAddressId(), tax.ToString(), newQuote.getTotal());
     DataGridView dt = newQuote.getQuoteItems();
     for (int i = 0; i < dt.Rows.Count-1; i++)
     {
        items.set(dt.Rows[i].Cells[0].Value.ToString(), dt.Rows[i].Cells[4].Value != null ? dt.Rows[i].Cells[4].Value.ToString() : "NULL",
             dt.Rows[i].Cells[3].Value != null ? dt.Rows[i].Cells[3].Value.ToString() : "NULL",
             dt.Rows[i].Cells[5].Value.ToString(), dt.Rows[i].Cells[1].Value.ToString(), id);
     }
     newQuote.Dispose();
     MessageBox.Show("The Quote ID is " + id + "!");
        // _view.Show();
 }
Esempio n. 2
0
        public void createQuote(object sender, EventArgs e)
        {
            QuoteForm newQuote = (QuoteForm)((Button)sender).FindForm();
            //save
            QuoteItems   items = new QuoteItems();
            string       id    = new Quote().set(franchiseeUserId, newQuote.getServiceAddressId(), tax.ToString(), newQuote.getTotal());
            DataGridView dt    = newQuote.getQuoteItems();

            for (int i = 0; i < dt.Rows.Count - 1; i++)
            {
                items.set(dt.Rows[i].Cells[0].Value.ToString(), dt.Rows[i].Cells[4].Value != null ? dt.Rows[i].Cells[4].Value.ToString() : "NULL",
                          dt.Rows[i].Cells[3].Value != null ? dt.Rows[i].Cells[3].Value.ToString() : "NULL",
                          dt.Rows[i].Cells[5].Value.ToString(), dt.Rows[i].Cells[1].Value.ToString(), id);
            }
            newQuote.Dispose();
            MessageBox.Show("The Quote ID is " + id + "!");
            // _view.Show();
        }
Esempio n. 3
0
        public void saveQuote(object sender, EventArgs e)
        {
            QuoteForm quote = (QuoteForm)((Button)sender).FindForm();
            //save
            QuoteItems items = new QuoteItems();

            new Quote().update(quote.getId(), franchiseeUserId, quote.getServiceAddressId(), tax.ToString(), quote.getTotal());
            for (int i = 0; i < rowsDeletedCounter; i++)
            {
                items.delete(rowsDeleted[i].ToString(), quote.getId());
            }
            DataGridView dt = quote.getQuoteItems();

            for (int i = 0; i < dt.Rows.Count - 1; i++)
            {
                items.setUpdate(dt.Rows[i].Cells[0].Value.ToString(), dt.Rows[i].Cells[4].Value != null && dt.Rows[i].Cells[4].Value.ToString() != "" ? dt.Rows[i].Cells[4].Value.ToString() : "NULL",
                                dt.Rows[i].Cells[3].Value != null && dt.Rows[i].Cells[3].Value.ToString() != "" ? dt.Rows[i].Cells[3].Value.ToString() : "NULL",
                                dt.Rows[i].Cells[5].Value.ToString(), dt.Rows[i].Cells[1].Value.ToString(), quote.getId());
            }
            quote.Dispose();
            // _view.Show();
        }
Esempio n. 4
0
 public void saveQuote(object sender, EventArgs e)
 {
     QuoteForm quote = (QuoteForm)((Button)sender).FindForm();
     //save
     QuoteItems items = new QuoteItems();
     new Quote().update(quote.getId(), franchiseeUserId, quote.getServiceAddressId(), tax.ToString(), quote.getTotal());
     for (int i = 0; i < rowsDeletedCounter; i++)
     {
         items.delete(rowsDeleted[i].ToString(), quote.getId());
     }
     DataGridView dt = quote.getQuoteItems();
     for (int i = 0; i < dt.Rows.Count - 1; i++)
     {
         items.setUpdate(dt.Rows[i].Cells[0].Value.ToString(), dt.Rows[i].Cells[4].Value != null && dt.Rows[i].Cells[4].Value.ToString() != "" ? dt.Rows[i].Cells[4].Value.ToString() : "NULL",
             dt.Rows[i].Cells[3].Value != null && dt.Rows[i].Cells[3].Value.ToString() != "" ? dt.Rows[i].Cells[3].Value.ToString() : "NULL",
             dt.Rows[i].Cells[5].Value.ToString(), dt.Rows[i].Cells[1].Value.ToString(), quote.getId());
     }
     quote.Dispose();
     // _view.Show();
 }