public bool UpdateMember(member UpdatedMember)
{
var before = dbs.member.FirstOrDefault(m => m.MemberID == UpdatedMember.MemberID);
var rowsAffected = dbs.Database.ExecuteSqlCommand("update [dbo].[member] " +
"set FirstName = '" + UpdatedMember.FirstName +
"', LastName = '" + UpdatedMember.LastName +
"', Phone = '" + UpdatedMember.Phone +
"', email = '" + UpdatedMember.Email +
"', Address = '" + UpdatedMember.Address +
"', City = '" + UpdatedMember.City +
"', State = '" + UpdatedMember.State +
"', Zip = '" + UpdatedMember.Zip +
"' WHERE [MemberID]={0}", UpdatedMember.MemberID);
return(rowsAffected > 0);
}
private void UpdateBtn_Click(object sender, RoutedEventArgs e)
{
var UpdatedMember = new member();
UpdatedMember.MemberID = Convert.ToInt32(IDTextBox.Text);
UpdatedMember.FirstName = FirstNameTextbox.Text;
UpdatedMember.LastName = LastNameTextbox.Text;
UpdatedMember.Phone = PhoneTextBox.Text;
UpdatedMember.Email = EmailTextbox.Text;
UpdatedMember.Address = AddressTextBox.Text;
UpdatedMember.City = CityTextBox.Text;
UpdatedMember.State = StateTextBox.Text;
UpdatedMember.Zip = ZipTextBox.Text;
if (_memberFuncs.UpdateMember(UpdatedMember))
{
MessageBox.Show("Member Updated.");
this.Close();
}
else
{
MessageBox.Show("Error Updating Member.");
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
//Check the fields
if (string.IsNullOrEmpty(FirstNameTextbox.Text))
{
FirstNameTextbox.BorderBrush = System.Windows.Media.Brushes.Red;
return;
}
if (string.IsNullOrEmpty(LastNameTextbox.Text))
{
LastNameTextbox.BorderBrush = System.Windows.Media.Brushes.Red;
return;
}
if (string.IsNullOrEmpty(PhoneTextBox.Text))
{
PhoneTextBox.BorderBrush = System.Windows.Media.Brushes.Red;
return;
}
if (string.IsNullOrEmpty(EmailTextbox.Text))
{
EmailTextbox.BorderBrush = System.Windows.Media.Brushes.Red;
return;
}
if (string.IsNullOrEmpty(AddressTextBox.Text))
{
AddressTextBox.BorderBrush = System.Windows.Media.Brushes.Red;
return;
}
if (string.IsNullOrEmpty(CityTextBox.Text))
{
CityTextBox.BorderBrush = System.Windows.Media.Brushes.Red;
return;
}
if (string.IsNullOrEmpty(StateTextBox.Text))
{
StateTextBox.BorderBrush = System.Windows.Media.Brushes.Red;
return;
}
if (string.IsNullOrEmpty(ZipTextBox.Text))
{
ZipTextBox.BorderBrush = System.Windows.Media.Brushes.Red;
return;
}
//Create member entity
var newMember = new member();
newMember.FirstName = FirstNameTextbox.Text;
newMember.LastName = LastNameTextbox.Text;
newMember.Phone = PhoneTextBox.Text;
newMember.Email = EmailTextbox.Text;
newMember.Address = AddressTextBox.Text;
newMember.City = CityTextBox.Text;
newMember.State = StateTextBox.Text;
newMember.Zip = ZipTextBox.Text;
newMember.Status = "OK";
//Add The member to the database
if (memberFuncs.InsertMember(newMember))
{
MessageBox.Show("Member Created.");
this.Close();
}
else
{
MessageBox.Show("Error Creating Member.");
}
}
public bool DeleteMember(member member)
{
var rowsAffected = dbs.Database.ExecuteSqlCommand("DELETE FROM [dbo].[member] WHERE [MemberID]={0}", member.MemberID);
return(rowsAffected > 0);
}
public bool InsertMember(member newMember)
{
dbs.member.Add(newMember);
return(dbs.SaveChanges() > 0);
}
private List <bill_info> GetAPPeriodBill_infoByMember(member singleMember)
{
return(dbs.bill_info.Where(m => m.ServiceDate <= today && m.ServiceDate >= lastWeek &&
m.MemberID == singleMember.MemberID)
.ToList());
}