protected void Update_to_DB_Click(object sender, EventArgs e)
{
var db = new AccessDB();
db.QueryType = CommandType.StoredProcedure;
db.QueryString = "UpdateDataToAllTable";
var intern = new InternData();
intern.FirstName = first_name.Text;
intern.LastName = last_name.Text;
intern.FullName = first_name.Text + " " + last_name.Text;
intern.ContactNumber = contact_number.Text;
intern.Email = email_address.Text;
intern.Role = Int32.Parse(Role.SelectedValue.ToString());
intern.IsPrimary = PrimaryCheckBox.Checked;
intern.IsBusiness = IsBusinesCheckBox.Checked;
intern.DateOfBirth = DOB.SelectedDate.ToShortDateString();
intern.personID = interID;
db.Update(intern);
string message = intern.FullName + " You have Sucessfully Updated Your Details";
HttpContext.Current.Response.Redirect("SuccessfulPage.aspx?" + message);
}
protected void sand_to_DB_Click(object sender, EventArgs e)
{
var intern = new InternData();
var db = new AccessDB();
intern.FirstName = first_name.Text;
intern.LastName = last_name.Text;
intern.FullName = first_name.Text + " " + last_name.Text;
intern.ContactNumber = contact_number.Text;
intern.Email = email_address.Text;
intern.Role = Int32.Parse(Role.SelectedValue.ToString());
intern.IsPrimary = PrimaryCheckBox.Checked;
intern.IsBusiness = IsBusinesCheckBox.Checked;
intern.DateOfBirth = DOB.SelectedDate.ToShortDateString();
db.QueryType = CommandType.StoredProcedure;
db.QueryString = "InsertDataToAllTables";
var get = db.InsertIntoDB(intern);
var dob = DOB.SelectedDate.ToShortDateString();
System.Diagnostics.Debug.WriteLine(intern.FirstName);
System.Diagnostics.Debug.WriteLine(intern.LastName);
System.Diagnostics.Debug.WriteLine(intern.ContactNumber);
System.Diagnostics.Debug.WriteLine(intern.Email);
System.Diagnostics.Debug.WriteLine(intern.DateOfBirth);
System.Diagnostics.Debug.WriteLine(intern.Role);
System.Diagnostics.Debug.WriteLine(intern.IsPrimary);
System.Diagnostics.Debug.WriteLine(intern.IsBusiness);
if (get > 0)
{
System.Diagnostics.Debug.WriteLine("Data Stored");
var message = intern.FullName + " You have Sucessfully Registered Your Details";
HttpContext.Current.Response.Redirect("SuccessfulPage.aspx?" + message);
}
}
private void AddRemoveBtn_Click(object sender, RoutedEventArgs e)
{
DependencyObject tvi = null;
var button = sender as Button;
//walk up the tree to find the ListboxItem
var mic = sender as MetersInvoerControl;
if (button != null)
{
tvi = findParentTreeItem(button, typeof(ListBoxItem));
}
else
{
tvi = findParentTreeItem(mic, typeof(ListBoxItem));
}
//if not null cast the Dependancy object to type of Listbox item.
if (tvi != null)
{
ListBoxItem lbi = tvi as ListBoxItem;
//select it.
lbi.IsSelected = true;
}
var regel = AccentenListBox.SelectedItem as AdvancedVervangRegel;
if (regel != null && regel.Status == StatusType.Leeg)
{
regel.Status = StatusType.Toevoeging;
var nwRegel = AdvancedVervangRegel.GetNewTegelRegel(AdvancedTegelSubCatInfo.GetTegelColl(InternData.TegelInput, InternData.BasisTegel.InwisselPrijs, InternData.BasisTegel.ProdSoort), InternData.GetFirstFreeIndex(), InternData.Regels.FirstOrDefault().Eenheid);
InternData.Regels.Add(nwRegel);
regel.VervangInfo.Wijzigstand = true;
}
else if (regel != null && regel.Status == StatusType.Toevoeging)
{
InternData.Regels.Remove(regel);
if (InternData.Regels.Count == 1)
{
InternData.Regels.Add(AdvancedVervangRegel.GetNewTegelRegel(AdvancedTegelSubCatInfo.GetTegelColl(InternData.TegelInput, InternData.BasisTegel.InwisselPrijs, InternData.BasisTegel.ProdSoort), InternData.GetFirstFreeIndex(), InternData.Regels.FirstOrDefault().Eenheid));
}
RecalcBasisMeters();
}
OnPropertyChanged("CanAddDelete");
}
