public void MemberSubscription(bool isRenewal)
{
bool showDialogue = true;
var memberSub = new Window();// MemberSubscriptions(SelectedMember);/
try
{
if (!isRenewal)
{
if (!SaveMember(null))
{
showDialogue = false;
}
else
{
memberSub = new MemberSubscriptions(SelectedMember);
}
}
else
{
memberSub = new MemberSubscriptions(SelectedMember, true);
}
if (showDialogue)
{
_selectedMemberId = SelectedMember.Id;
memberSub.ShowDialog();
if (memberSub.DialogResult != null && (bool)memberSub.DialogResult)
{
if (Members != null)
{
SelectedMember = Members.FirstOrDefault(m => m.Id == _selectedMemberId);
}
var criteria = new SearchCriteria <MemberSubscriptionDTO>();
criteria.FiList.Add(m => m.MemberId == SelectedMember.Id);
var memSub = new MemberSubscriptionService(true)
.GetAll(criteria)
.OrderByDescending(m => m.Id)
.FirstOrDefault();
if (memSub != null && SelectedMember != null)
{
SelectedMember.LastSubscriptionId = memSub.Id; //Convert.ToInt32(memberSub.TxtId);
}
}
}
}
catch
{
MessageBox.Show("got problem while processing member package, try again");
}
}
public IEnumerable <SubscriptionModel> GetSubscriptions()
{
var criteria = new SearchCriteria <MemberSubscriptionDTO>();
criteria.FiList.Add(f => f.Member.Enabled);
if (_beginDate != null && _endDate != null && _beginDate.Value.Year > 2000 && _endDate.Value.Year > 2000)
{
criteria.BeginingDate = _beginDate;
criteria.EndingDate = _endDate;
if (_shiftType != null)
{
criteria.Shift = (ShiftTypes)_shiftType;
}
}
if (_facility != null && _facility != -1)
{
criteria.FiList.Add(f => f.FacilitySubscription.FacilityId == _facility);
}
if (_subscription != null && _subscription != -1)
{
criteria.FiList.Add(f => f.FacilitySubscription.SubscriptionId == _subscription);
}
var memberList = new MemberSubscriptionService(true).GetAll(criteria).ToList();
var memberSubscriptionList = memberList.Select(member => new SubscriptionModel
{
Id = member.Id,
MemberName = member.Member.DisplayName,
Sex = member.Member.Sex,
Age = member.Member.Age ?? 0,
MobileNumber = member.Member.Address.Mobile,
Amount = member.AmountPaid,
TransactionDate = member.SubscribedDate,
StartDate =
new DateTime(member.SubscribedDate.Year,
member.SubscribedDate.Month, member.SubscribedDate.Day, 0, 0,
0),
EndDate =
new DateTime(member.EndDate.Value.Year, member.EndDate.Value.Month,
member.EndDate.Value.Day, 23, 59, 59),
PackageName = member.FacilitySubscription.PackageName,
FacilityName = member.FacilitySubscription.Facility.DisplayName,
SubscriptionName = member.FacilitySubscription.Subscription.DisplayName,
NoOfAttendances = 1, //Convert.ToInt32(member.NoOfAttendances)
DaysLeft = Convert.ToInt32(member.DaysLeft),
IsExpired = member.SubscriptionExpired
}).ToList();
return(memberSubscriptionList);
}
public void LoadSubscriptions()
{
MemberSubscriptionDetail = new ObservableCollection <MemberSubscriptionDTO>();
var member = new MemberService(true).Find(SelectedMember.Id.ToString());
var lastSubId = member != null ? member.LastSubscriptionId : 0;
var criteria = new SearchCriteria <MemberSubscriptionDTO>();
criteria.FiList.Add(m => m.Id == lastSubId); //SelectedMember.LastSubscriptionId
var lastSub = new MemberSubscriptionService(true).GetAll(criteria).FirstOrDefault();
PackageCommandVisibility = "Collapsed";
PackageRenewCommandVisibility = "Collapsed";
if (lastSub == null)
{
MemberText = "ፓኬጅ አስገባ";
if (UserRoles.PackageAdd == "Visible")
{
PackageCommandVisibility = "Visible";
}
}
else
{
TotalNumberOfMembers = lastSub.DaysLeft + " " + lastSub.CurrentStatus;
MemberText = "ፓኬጅ አስተካክል";
if (UserRoles.PackageEdit == "Visible")
{
PackageCommandVisibility = "Visible";
}
if (lastSub.EndDate != null)
{
var daysleft = lastSub.EndDate.Value.Subtract(DateTime.Now).Days;
if (daysleft < 7) //lastSub.SubscriptionExpired
{
if (UserRoles.PackageRenewal == "Visible")
{
PackageRenewCommandVisibility = "Visible";
}
}
}
MemberSubscriptionDetail.Add(lastSub);
}
}
private void ExecuteDeleteCommand()
{
if (SelectedMemberSubscription == null)
{
return;
}
if (System.Windows.MessageBox.Show("Are you Sure You want to Delete this Record?",
"Pinna Fitness",
MessageBoxButton.YesNo, MessageBoxImage.Warning) != MessageBoxResult.Yes)
{
return;
}
var stat = new MemberSubscriptionService(true).Delete(SelectedMemberSubscription.Id.ToString());
if (stat == -1)
{
MessageBox.Show("Can't Delete Subscription");
}
else
{
MemberSubscriptions.Remove(SelectedMemberSubscription);
}
}
public TransactionDataSet GetAttachmentDataSet()
{
var myDataSet = new TransactionDataSet();
var selectedCompany = new CompanyService(true).GetCompany();
var cri = new SearchCriteria <MemberSubscriptionDTO>();
cri.FiList.Add(s => s.Id == SelectedMember.LastSubscriptionId);
var selectedTransaction = new MemberSubscriptionService(true).GetAll(cri).FirstOrDefault();
if (selectedTransaction == null)
{
return(null);
}
try
{
#region Fields
var brCode = new BarcodeProcess();
var tranNumberbarcode =
ImageToByteArray(brCode.GetBarcode(selectedTransaction.SubscriptionNumber, 320, 40, true),
ImageFormat.Bmp);
var subTotal = selectedTransaction.AmountPaid / (decimal)1.15;
var tax = Convert.ToDecimal((subTotal * ((decimal)0.15)).ToString("N2"));
string reciptNo = selectedTransaction.ReceiptNumber, prefix = "";
int recLen = 10 - reciptNo.Length;
while (recLen != 0)
{
prefix = prefix + "0";
recLen--;
}
reciptNo = prefix + reciptNo;
#endregion
#region Header
myDataSet.TransactionHeader.Rows.Add(
reciptNo,
tranNumberbarcode,
SelectedMember.TinNumber,
SelectedMember.DisplayName,
SelectedMember.Number,
SelectedMember.SexAmharic,
selectedTransaction.SubscribedDateString + "(" +
ReportUtility.GetEthCalendarFormated(selectedTransaction.SubscribedDate, "/") + ")",
"",
subTotal,
"VAT (" + 15 + "%)",
tax,
subTotal + tax,
"linknumber1"
);
#endregion
#region Client Address
myDataSet.ClientDetail.Rows.Add(
selectedCompany.Header,
selectedCompany.Footer,
selectedCompany.Address.AddressDetail,
selectedCompany.Address.SubCity,
selectedCompany.Address.Kebele,
selectedCompany.Address.HouseNumber,
selectedCompany.Address.Mobile,
selectedCompany.Address.AlternateMobile,
selectedCompany.Address.Fax,
selectedCompany.Address.PrimaryEmail,
selectedCompany.Address.AlternateEmail,
selectedCompany.TinNumber,
selectedCompany.VatNumber,
"CASH", "CASH", Singleton.User.FullName.ToUpper(), "linknumber1");
#endregion
#region BPAddress
myDataSet.BPAddress.Rows.Add(
SelectedMember.Address.AddressDetail,
SelectedMember.Address.SubCity,
SelectedMember.Address.Kebele,
SelectedMember.Address.HouseNumber,
SelectedMember.Address.Mobile,
SelectedMember.Address.AlternateMobile,
SelectedMember.Address.Fax,
SelectedMember.Address.PrimaryEmail,
SelectedMember.Address.AlternateEmail,
"linknumber1");
#endregion
#region Lines
myDataSet.TransactionLine.Rows.Add(
"1",
"00" + selectedTransaction.FacilitySubscription.Facility.Id.ToString(),
selectedTransaction.FacilitySubscription.PackageName,
"",
"Gym",
"Pcs",
subTotal,
1,
subTotal,
0,
"linknumber1");
#endregion
}
catch (Exception exception)
{
MessageBox.Show("Can't get data for the report"
+ Environment.NewLine + exception.Message, "Can't get data", MessageBoxButton.OK,
MessageBoxImage.Error);
}
return(myDataSet);
}
