private void button5_Click(object sender, EventArgs e) { var ctx = new SCMContext(); ctx.QINs.RemoveRange(ctx.QINs.ToList()); ctx.SaveChanges(); listBox1.Items.Clear(); }
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); } }
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; }
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(); } }