Пример #1
0
 private void metroButton1_Click(object sender, EventArgs e)
 {
     typeOne.Checked   = false;
     typeTwo.Checked   = false;
     typeThree.Checked = true;
     try
     {
         DataClasses1DataContext db = new DataClasses1DataContext();
         int            id          = int.Parse(metroTextBox1.Text);
         Multiple_order ee          = db.Multiple_orders.SingleOrDefault(x => x.Id == id);
         if (ee != null)
         {
             orderNoBox.Text      = ee.Order_no;
             descriptionBox.Text  = ee.Description;
             totalBox.Text        = Convert.ToString(ee.Ammount);
             advanceBox.Text      = Convert.ToString(ee.Advanced);
             contactBox.Text      = ee.Mobile;
             dueBox.Text          = Convert.ToString(ee.Due);
             dateTimePicker1.Text = ee.Date.ToString();
         }
         else
         {
             MessageBox.Show("data not found");
         }
     }
     catch (Exception ex)
     {
         MessageBox.Show("Please Select the id then Edit In the textbox Thank You");
     }
 }
Пример #2
0
 private void metroButton3_Click(object sender, EventArgs e)
 {
     try
     {
         int            id = int.Parse(metroTextBox1.Text);
         Multiple_order ee = db.Multiple_orders.SingleOrDefault(x => x.Id == id);
         db.Multiple_orders.DeleteOnSubmit(ee);
         db.SubmitChanges();
         MessageBox.Show("data deleted");
     }
     catch (Exception ex)
     {
         MessageBox.Show("Please Select the id then Edit In the textbox Thank You");
     }
 }
Пример #3
0
        private void loginButton_Click(object sender, EventArgs e)
        {
            Multiple_order table = new Multiple_order();

            if (orderToggle.Checked == true)
            {
                try {
                    int    amount;
                    int    ad, due;
                    string ordrNo;
                    string des = "";
                    string mobile;
                    ordrNo = (orderNoBox.Text);
                    if (typeOne.Checked == false && typeThree.Checked == false && typeTwo.Checked == false)
                    {
                        MessageBox.Show("Select your type");
                        goto last;
                    }
                    if (typeOne.Checked == true)
                    {
                        des += "typeOne ";
                    }
                    if (typeTwo.Checked == true)
                    {
                        des += "typeTwo ";
                    }
                    if (typeThree.Checked == true)
                    {
                        des = "";
                        des = descriptionBox.Text;
                    }
                    amount = int.Parse(totalBox.Text);
                    ad     = int.Parse(advanceBox.Text);
                    due    = int.Parse(dueBox.Text);
                    mobile = contactBox.Text;
                    if (mobile.Length == 11)
                    {
                        if (mobile[0] != '0' || mobile[1] != '1')
                        {
                            MessageBox.Show("valid contact please");
                            goto last;
                        }
                    }
                    else
                    {
                        MessageBox.Show("valid contact please");
                        goto last;
                    }
                    if (mobile.Equals("") || ordrNo.Equals("") || amount <= 0)
                    {
                        MessageBox.Show("Fill all field correctly");
                        goto last;
                    }
                    table.Ammount     = amount;
                    table.Advanced    = ad;
                    table.Due         = due;
                    table.Description = des;
                    table.Mobile      = mobile;
                    table.Order_no    = ordrNo;
                    table.Date        = dateTimePicker1.Value;
                    db.Multiple_orders.InsertOnSubmit(table);
                    db.SubmitChanges();
                    MessageBox.Show("Order create successfully");
                }catch (Exception ex) {
                    MessageBox.Show("Fill all field correctly");
                }
            }
            else
            {
                try {
                    int    amount;
                    int    ad, due;
                    string ordrNo;
                    string mobile;
                    ordrNo = (orderNoBox.Text);
                    amount = int.Parse(totalBox.Text);
                    ad     = int.Parse(advanceBox.Text);
                    due    = int.Parse(dueBox.Text);
                    mobile = contactBox.Text;
                    if (mobile.Length == 11)
                    {
                        if (mobile[0] != '0' || mobile[1] != '1')
                        {
                            MessageBox.Show("valid contact please");
                            goto last;
                        }
                    }
                    else
                    {
                        MessageBox.Show("valid contact please");
                        goto last;
                    }
                    if (mobile.Equals("") || ordrNo.Equals("") || amount <= 0)
                    {
                        MessageBox.Show("Fill all field correctly");
                        goto last;
                    }
                    table.Ammount  = amount;
                    table.Advanced = ad;
                    table.Due      = due;
                    table.Mobile   = mobile;
                    table.Order_no = ordrNo;
                    table.Date     = dateTimePicker1.Value;
                    db.Multiple_orders.InsertOnSubmit(table);
                    db.SubmitChanges();
                    MessageBox.Show("Order create successfully");
                } catch (Exception ex) {
                    MessageBox.Show("Fill all field correctly");
                }
            }
last:
            {
            }
        }
Пример #4
0
        private void metroButton2_Click(object sender, EventArgs e)
        {
            int    amount;
            int    ad, due;
            string ordrNo;
            string des = "";
            string mobile;

            ordrNo = (orderNoBox.Text);
            try
            {
                int            id = int.Parse(metroTextBox1.Text);
                Multiple_order ee = db.Multiple_orders.SingleOrDefault(x => x.Id == id);
                ordrNo = orderNoBox.Text;
                amount = Convert.ToInt32(totalBox.Text);
                ad     = Convert.ToInt32(advanceBox.Text);
                due    = Convert.ToInt32(dueBox.Text);
                mobile = contactBox.Text;
                if (typeOne.Checked == false && typeThree.Checked == false && typeTwo.Checked == false)
                {
                    MessageBox.Show("Select your type");
                    goto last;
                }
                if (typeOne.Checked == true)
                {
                    des += "typeOne ";
                }
                if (typeTwo.Checked == true)
                {
                    des += "typeTwo ";
                }
                if (typeThree.Checked == true)
                {
                    des = "";
                    des = descriptionBox.Text;
                }
                if (mobile.Length == 11)
                {
                    if (mobile[0] != '0' || mobile[1] != '1')
                    {
                        MessageBox.Show("valid contact please");
                        goto last;
                    }
                }
                else
                {
                    MessageBox.Show("valid contact please");
                    goto last;
                }

                ee.Advanced    = ad;
                ee.Due         = due;
                ee.Description = des;
                ee.Mobile      = mobile;
                ee.Ammount     = amount;
                db.SubmitChanges();
                MessageBox.Show("Data update successfully");
            }
            catch (Exception ex)
            {
                MessageBox.Show("Please Select the id then Edit In the textbox Thank You");
            }
last:
            {
            }
        }
 partial void DeleteMultiple_order(Multiple_order instance);
 partial void UpdateMultiple_order(Multiple_order instance);
 partial void InsertMultiple_order(Multiple_order instance);