Пример #1
0
        private void button2_Click(object sender, EventArgs e)
        {
            long idd = passedId;

            frmRptAdvanceBookingMEMO rpt = new frmRptAdvanceBookingMEMO(idd);

            rpt.ShowDialog();
        }
Пример #2
0
        private void btnCreate_Click(object sender, EventArgs e)
        {
            try
            {
                if (txtCustName.Text == string.Empty && txtMob.Text == string.Empty && txtChild.Text == string.Empty && txtAdults.Text == string.Empty && txtAdvPayment.Text == string.Empty)
                {
                    errorProvider1.Clear();
                    errorProvider1.SetError(txtCustName, "Enter all details.");
                    txtCustName.Focus();
                    panel3.Visible = true;
                    lblError.Text  = "Enter all details.";
                }
                else if (txtCustName.Text == string.Empty)
                {
                    errorProvider1.Clear();
                    errorProvider1.SetError(txtCustName, "Enter Customer-name");
                    txtCustName.Focus();
                    panel3.Visible = true;
                    lblError.Text  = "Enter Customer-name.";
                }
                else if (txtMob.Text == string.Empty)
                {
                    errorProvider1.Clear();
                    errorProvider1.SetError(txtMob, "Enter Mobile Number.");
                    txtMob.Focus();
                    panel3.Visible = true;
                    lblError.Text  = "Enter Qty.";
                }
                else if (txtAdults.Text == string.Empty)
                {
                    errorProvider1.Clear();
                    errorProvider1.SetError(txtAdults, "Enter Adults.");
                    txtAdults.Focus();
                    panel3.Visible = true;
                    lblError.Text  = "There must be atleast 1 adult.";
                }
                else if (txtAdvPayment.Text == string.Empty)
                {
                    errorProvider1.Clear();
                    errorProvider1.SetError(txtAdvPayment, "Enter Adv. Payment.");
                    txtAdvPayment.Focus();
                    panel3.Visible = true;
                    lblError.Text  = "Adv. Payment.";
                }
                else
                {
                    //DateTime date = DateTime.ParseExact(dateToday.Text, "yyyy-MM-dd", null);
                    if (btnCreate.Text == "Create")
                    {
                        tblAdvBooking data = new tblAdvBooking();

                        data.custName       = txtCustName.Text.Trim().ToString();
                        data.mob            = txtMob.Text.Trim().ToString();
                        data.child          = Convert.ToInt32(txtChild.Text.ToString());
                        data.adults         = Convert.ToInt32(txtAdults.Text);
                        data.eventDate      = dtpBookingDate.Value.Date;
                        data.todayDate      = dateToday.Value.Date;
                        data.advancePayment = Convert.ToDecimal(txtAdvPayment.Text);
                        data.status         = "UNPAID";
                        data.cdate          = DateTime.Now;

                        _entities.tblAdvBookings.Add(data);
                        _entities.SaveChanges();
                        MessageBox.Show("Record Created Successfully");


                        DialogResult myResult;
                        myResult = MessageBox.Show("Are you want to print receipt?", "Print Confirmation", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
                        if (myResult == DialogResult.OK)
                        {
                            _entities = new KBBQEntities();
                            long lastId = _entities.tblAdvBookings.OrderByDescending(x => x.id).FirstOrDefault().id;


                            frmRptAdvanceBookingMEMO rpt = new frmRptAdvanceBookingMEMO(lastId);
                            rpt.ShowDialog();
                        }
                    }
                    else
                    {
                        //Update Code

                        _entities = new KBBQEntities();
                        //var pId = _entities.purchaseProducts.Where(x => x.pName == txtitemName.Text.Trim()).FirstOrDefault().id;


                        var advBookingData = _entities.tblAdvBookings.Where(x => x.id == passedId).FirstOrDefault();

                        advBookingData.custName       = txtCustName.Text.Trim().ToString();
                        advBookingData.mob            = txtMob.Text.Trim().ToString();
                        advBookingData.child          = Convert.ToInt32(txtChild.Text.ToString());
                        advBookingData.adults         = Convert.ToInt32(txtAdults.Text);
                        advBookingData.eventDate      = dtpBookingDate.Value.Date;
                        advBookingData.todayDate      = dateToday.Value.Date;
                        advBookingData.advancePayment = Convert.ToDecimal(txtAdvPayment.Text);

                        _entities.SaveChanges();


                        MessageBox.Show("Record Updated Successfully");

                        DialogResult myResult;
                        myResult = MessageBox.Show("Are you want to print receipt?", "Print Confirmation", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
                        if (myResult == DialogResult.OK)
                        {
                            _entities = new KBBQEntities();


                            frmRptAdvanceBookingMEMO rpt = new frmRptAdvanceBookingMEMO(passedId);
                            rpt.ShowDialog();
                        }
                    }
                    clear();
                    gridViewBind();
                }
            }
            catch (Exception x)
            {
            }
        }