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();
}
}
}
