Example #1
0
        private void btnAdd_Click(object sender, EventArgs e)
        {
            String message = "";

            if (va.doValidation() == false)
            {
                return;
            }
            cons = db.tbl_Consumptions.FirstOrDefault(x => x.id_consumption == int.Parse(tbIdconsumption.Text));
            if (cons != null)
            {
                aksi("update");
                message = "Update";
            }

            else
            {
                aksi("insert");
                message = "Insert";
            }

            MessageBox.Show(message + " data success!", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Information);
            loadGrid();
            va.clear("tbIdconsumption", 0);
        }
Example #2
0
        private void aksi(String aksinya)
        {
            cons = aksinya == "insert" ? new tbl_Consumption() : db.tbl_Consumptions.FirstOrDefault(x => x.id_consumption == int.Parse(tbIdconsumption.Text));
            cons.name_consumption  = tbNameconsumption.Text;
            cons.price_consumption = int.Parse(tbPriceconsumption.Text);
            if (aksinya == "insert")
            {
                cons.id_consumption = int.Parse(tbIdconsumption.Text);
                db.tbl_Consumptions.InsertOnSubmit(cons);
            }

            db.SubmitChanges();
        }
Example #3
0
        private void setTextbox()
        {
            if (!String.IsNullOrEmpty(tbIdconsumption.Text))
            {
                cons = db.tbl_Consumptions.FirstOrDefault(x => x.id_consumption == int.Parse(tbIdconsumption.Text));
                if (cons != null)
                {
                    tbIdconsumption.Text    = cons.id_consumption.ToString();
                    tbNameconsumption.Text  = cons.name_consumption;
                    tbPriceconsumption.Text = cons.price_consumption.ToString();
                    btnAdd.Text             = "UPDATE";
                }

                else
                {
                    va.clear("tbIdconsumption", 0);
                    btnAdd.Text = "ADD";
                }
            }
        }