private void button1_Click(object sender, EventArgs e) { bool conflict = false; for (int i = 0; i < monthCalendar1.BoldedDates.Count(); i++) { if (monthCalendar1.BoldedDates[i] >= monthCalendar1.SelectionStart && monthCalendar1.BoldedDates[i] <= monthCalendar1.SelectionEnd) { conflict = true; break; } } if (conflict) { MessageBox.Show("The tool K" + tools1.SelectedTool.K_number.ToString() + " is not available in this period.", "Error", MessageBoxButtons.OK); this.DialogResult = System.Windows.Forms.DialogResult.None; } else { using (var hobbyklub = new HobbyKlubEntities1()) { hobbyklub.Location.AddObject(new Location() { MemberId = MyMember.MemberId, StartDate = monthCalendar1.SelectionStart, EndDate = monthCalendar1.SelectionEnd, Status = (int)Status.Reserveret, ToolId = tools1.SelectedTool.ToolId }); hobbyklub.SaveChanges(); } } }
private void okButton_Click(object sender, EventArgs e) { using (var db = new HobbyKlubEntities1()) { if (member != null) { db.Member.Attach(member); } else { member = new Member(); db.Member.AddObject(member); } member.Address = address.Text; member.Email1 = mail.Text; member.PhoneMobile = mobile.Text; member.Name = name.Text; db.SaveChanges(); int xxx = 0; } DialogResult = System.Windows.Forms.DialogResult.OK; }
public void LoadData() { if (DesignMode) { return; } using (var hk = new HobbyKlubEntities1()) { members = hk.Member.ToList(); } comboBox1.Items.Clear(); comboBox1.Items.AddRange(members.Select(x => x.Name).ToArray()); }
private void button1_Click(object sender, EventArgs e) { bool conflict = false; for (int i = 0; i < monthCalendar1.BoldedDates.Count(); i++) { if (monthCalendar1.BoldedDates[i] >= monthCalendar1.SelectionStart && monthCalendar1.BoldedDates[i] <= monthCalendar1.SelectionEnd) { conflict = true; break; } } if (conflict) { MessageBox.Show("The tool K" + tools1.SelectedTool.K_number.ToString() + " is not available in this period.", "Error", MessageBoxButtons.OK); this.DialogResult = System.Windows.Forms.DialogResult.None; } else { using (var db = new HobbyKlubEntities1()) { var rv = db.Location.Where(x => x.MemberId == MyMember.MemberId && x.ToolId == MyTool.ToolId && x.Status == (int)Status.Reserveret); if (rv.Count() > 0) { //foreach (var loc in rv) //{ var loc = rv.First(); // convert only first reservation to udlejninger, normally there should only be one db.Location.Attach(loc); loc.Status = (int)Status.Udlejet; loc.StartDate = monthCalendar1.SelectionStart; loc.EndDate = monthCalendar1.SelectionEnd; // break; //} db.SaveChanges(); } else { db.Location.AddObject(new Location() { MemberId = MyMember.MemberId, StartDate = monthCalendar1.SelectionStart, EndDate = monthCalendar1.SelectionEnd, Status = (int)Status.Udlejet, ToolId = tools1.SelectedTool.ToolId }); db.SaveChanges(); } } } }
private void tools1_OnToolSelected(Tool obj) { using (var db = new HobbyKlubEntities1()) { var rv = db.Location.Where(x => x.ToolId == tools1.SelectedTool.ToolId && x.Status > (int)Status.Afleveret && x.EndDate >= DateTime.Now); foreach (var loc in rv) // mark all days where the tool is not available { DateTime start = (DateTime)loc.StartDate; DateTime end = (DateTime)loc.EndDate; for (DateTime l = start; l <= end; l = l.AddDays(1)) { monthCalendar1.AddBoldedDate(l); } } monthCalendar1.UpdateBoldedDates(); locationListOfSelectedTool = rv.ToList(); listBox1.Items.Clear(); listBox1.Items.AddRange(locationListOfSelectedTool.Select(x => x.StartDate.ToShortDateString() + " ... " + x.EndDate.ToString().Substring(0, 8) + "\t" + x.Member.Name + "\t" + ((Status)x.Status).ToString()).ToArray()); } }
private void ShowUdlejninger() { using (var db = new HobbyKlubEntities1()) { if (memberDropDown1.SelectedMember != null) { var rv = db.Location.Where(x => x.MemberId == memberDropDown1.SelectedMember.MemberId && x.Status == (int)Status.Udlejet).OrderBy(x => x.StartDate); //available.TraceQuery(); udlejningsList = rv.ToList(); listBox2.Items.Clear(); listBox2.Items.AddRange(udlejningsList.Select(x => x.StartDate.ToShortDateString() + " ... " + x.EndDate.ToString().Substring(0, 8) + "\t" + x.Tool.Name + " K" + x.Tool.K_number.ToString()).ToArray()); } else { var rv = db.Location.Where(x => x.MemberId > 0 && x.Status == (int)Status.Udlejet).OrderBy(x => x.StartDate); //available.TraceQuery(); udlejningsList = rv.ToList(); listBox2.Items.Clear(); listBox2.Items.AddRange(udlejningsList.Select(x => x.StartDate.ToShortDateString() + " ... " + x.EndDate.ToString().Substring(0, 8) + "\t" + x.Tool.Name + " K" + x.Tool.K_number.ToString() + "\t" + x.Member.Name).ToArray()); } } }
private void button1_Click(object sender, EventArgs e) { using (var db = new HobbyKlubEntities1()) { var rv = db.Location.Where(x => x.MemberId == MyMember.MemberId && x.ToolId == MyTool.ToolId && x.Status == (int)Status.Udlejet); if (rv.Count() > 0) { //foreach (var loc in rv) //{ var loc = rv.First(); // convert only first reservation to udlejninger, normally there should only be one db.Location.Attach(loc); loc.Status = (int)Status.Afleveret; loc.EndDate = dateTimePicker1.Value; // break; //} db.SaveChanges(); } else { MessageBox.Show("Member " + MyMember.Name + " does not have tool " + MyTool.Name + " K" + MyTool.K_number.ToString()); } } }
private void button1_Click(object sender, EventArgs e) { using (var oldHobbyklub = new Hobbyklub2Entities1()) { using (var hobbyKlub = new HobbyKlubEntities1()) { //foreach (var m in hobbyKlub.Member) hobbyKlub.Member.DeleteObject(m); foreach (var t in hobbyKlub.Tool) { hobbyKlub.Tool.DeleteObject(t); } foreach (var p in hobbyKlub.Part) { hobbyKlub.Part.DeleteObject(p); } //foreach (var p in hobbyKlub.Location) hobbyKlub.Location.DeleteObject(p); hobbyKlub.SaveChanges(); //foreach (var m in oldHobbyklub.) MEDLEM existerer ikke i Entity, selvom den existerer i databasen? Desuden ligger der ikke nogen Medlemsdata i denne database, kun tools. //{ // hobbyKlub.Member.AddObject(new Member() { Name = m.NAVN, Address = m.ADRESSE, Zip = m.POSTNUMMER, City = m.BY, LoenNumber = m.LON_NUMMER }); //} int toolid = 1; foreach (var t in oldHobbyklub.VAERKTOJ) { int n; if (t.K_NUMMER[0] != 'K') //throw new Exception("error in K_NUMMER"); { n = int.Parse(t.K_NUMMER); // try without K } else { n = int.Parse(t.K_NUMMER.Substring(1)); } int partno = 1; Action <string> a = s => { if (!string.IsNullOrEmpty(s)) { hobbyKlub.Part.AddObject(new Part() { Description = s, PartNo = partno++, ToolId = toolid }); } }; if (t.DEL1 != null) { if (t.DEL1.Length > 0) { a(t.DEL1); } } if (t.DEL2 != null) { if (t.DEL2.Length > 0) { a(t.DEL2); } } if (t.DEL3 != null) { if (t.DEL3.Length > 0) { a(t.DEL3); } } if (t.DEL4 != null) { if (t.DEL4.Length > 0) { a(t.DEL4); } } if (t.DEL5 != null) { if (t.DEL5.Length > 0) { a(t.DEL5); } } if (t.DEL6 != null) { if (t.DEL6.Length > 0) { a(t.DEL6); } } if (t.DEL7 != null) { if (t.DEL7.Length > 0) { a(t.DEL7); } } string toolName = t.BESKRIV; int pos = t.BESKRIV.IndexOf(' ', 0); if (pos >= 0) { toolName = t.BESKRIV.Substring(0, pos); } hobbyKlub.Tool.AddObject(new Tool() { ToolId = toolid++, Name = toolName, Description = t.BESKRIV, K_number = n }); textBox1.Text = "ToolIDs = " + toolid.ToString(); } hobbyKlub.SaveChanges(); } } }