Пример #1
0
        private void button5_Click(object sender, EventArgs e)
        {
            var ctx = new SCMContext();

            ctx.QINs.RemoveRange(ctx.QINs.ToList());
            ctx.SaveChanges();
            listBox1.Items.Clear();
        }
Пример #2
0
 private void button2_Click(object sender, EventArgs e)
 {
     if (listBox1.SelectedItem != null)
     {
         int id    = int.Parse((string)listBox1.SelectedItem);
         var ctx   = new SCMContext();
         var qItem = ctx.QINs.Find(id);
         ctx.q_log_call(DateTime.Now.ToString("MM/dd/yy"), DateTime.Now.ToString("HH:mm tt"), "102", "03", null, qItem.TNo, "0:10':20\"");
         listBox1.Items.Remove(listBox1.SelectedItem);
     }
 }
Пример #3
0
        private void button1_Click(object sender, EventArgs e)
        {
            var ext     = txtExt.Text;
            var user    = txtUserName.Text;
            var theDate = Convert.ToDateTime(date.Text, System.Globalization.CultureInfo.InvariantCulture);
            var dt      = theDate.ToString("MM/dd/yy");
            var tt      = theDate.ToString("HH:mm tt");

            var ctx = new SCMContext();

            ctx.q_log_call(dt, tt, null, null, "Incoming", phone.Text, null);
            qid = ctx.QINs.Max(x => x.Id);
            listBox1.Items.Add(qid.ToString());
            qid = 0;
        }
Пример #4
0
        private void button3_Click(object sender, EventArgs e)
        {
            SCMContext ctx   = new SCMContext();
            var        minId = 1;
            var        maxId = 1;

            if (chkExisting.Checked)
            {
                var list = ctx.ServiceRequests.Where(x => x.StatusId < 90).Select(x => x.CustomerId).ToList();
                if (chkRequests.Checked)
                {
                    int index = r.Next(0, list.Count / 2);
                    minId = list[index];
                    index = r.Next(index + 1, list.Count - 1);
                    maxId = list[index];
                }
                else
                {
                    minId = ctx.Customers.Min(x => x.Id);
                    maxId = ctx.Customers.Max(x => x.Id);
                }
                var id  = r.Next(minId, maxId);
                var cus = ctx.Customers.Find(id);
                customerName.Text = cus.Name;
                if (!string.IsNullOrEmpty(cus.Phone))
                {
                    customerPhone.Text = cus.Phone;
                }
                else
                {
                    customerPhone.Text = cus.Mobile;
                }
                phone.Text = customerPhone.Text;
            }
            else
            {
                int no = r.Next(1111111, 9999999);
                phone.Text = "012" + no.ToString();
            }
        }