public MainViewModel()
{
CheckRoles();
TitleText = "PDMAS V1.0.0.0, PDEX Delivery Management System - " +
Singleton.User.UserName + " - " +
DateTime.Now.ToString("dd/MM/yyyy") + " - " +
ReportUtility.GetEthCalendarFormated(DateTime.Now, "/");
HeaderText = "Request Managment";
DeliveryViewModel.LoadData = true;
CurrentViewModel = DeliveryViewModel;
DeliveryViewModelViewCommand = new RelayCommand(ExecuteDeliveryViewModelViewCommand);
FollowUpViewModelViewCommand = new RelayCommand(ExecuteFollowUpViewModelViewCommand);
}
public MainViewModel()
{
CheckRoles();
TitleText = "PinnaFit V1.0.0.1, Gym and Fitness Management System - " +
Singleton.User.UserName + " - " +
DateTime.Now.ToString("dd/MM/yyyy") + " - " +
ReportUtility.GetEthCalendarFormated(DateTime.Now, "/");
if (UserRoles.DashboardMgmt == "Visible")
{
HeaderText = "Dashboard";
CurrentViewModel = DashBoardViewModel;
}
else
{
HeaderText = "ስራዎች ማስተዳደሪያ";
CurrentViewModel = AttendanceListViewModel;
}
DeliveryViewModelViewCommand = new RelayCommand(ExecuteDeliveryViewModelViewCommand);
FollowUpViewModelViewCommand = new RelayCommand(ExecuteFollowUpViewModelViewCommand);
}
private void ExecutePrintCommand()
{
var myReport4 = new Reports.Summary.DailyActivity();
var myDataSet = new FitnessDataSet();
var selectedCompany = new CompanyService(true).GetCompany();
var selectedDate = DateTime.Now;
int serNo = 1;
string shift = EnumUtil.GetEnumDesc(ShiftTypes.Morning);
if (selectedDate.Hour > 14)
{
shift = EnumUtil.GetEnumDesc(ShiftTypes.Afternoon);
}
foreach (var itemQuantityDto in ItemsQuantity)
{
myDataSet.DailySummaryReport.Rows.Add(
serNo,
ReportUtility.GetEthCalendarFormated(selectedDate, "-") + "(" +
selectedDate.ToShortDateString() + ") - (" + shift + ")",
itemQuantityDto.Item.DisplayName,
itemQuantityDto.QuantityOnHand,
null,
null,
null,
itemQuantityDto.Item.UnitOfMeasure.DisplayName,
"",
null, null,
selectedCompany.Header,
SelectedWarehouse.DisplayName);
serNo++;
}
myReport4.SetDataSource(myDataSet);
new ReportUtil().DirectPrinter(myReport4);
//var report = new ReportViewerCommon(myReport4);
//report.Show();
}
public TransactionDataSet GetListDataSet2()
{
var myDataSet = new TransactionDataSet();
var selectedCompany = new CompanyService(true).GetCompany();
var SelectedTransaction = SelectedMember.LastSubscription;
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);
}
public FitnessDataSet GetAttendanceListDataSet(List <MemberAttendanceDTO> attendances, List <PervisitSubscriptionDTO> pervisitAttendances)
{
var myDataSet = new FitnessDataSet();
var serNo = 1;
var selectedCompany = new CompanyService(true).GetCompany();
var totalNumberOfRows = attendances.Count();
attendances = attendances.OrderBy(a => a.MemberSubscription.FacilitySubscription.PackageName).ToList();
var shift = ShiftTypes.All;
if (_shiftType != null)
{
shift = (ShiftTypes)_shiftType;
}
if (_beginDate == null || _endDate == null)
{
return(null);
}
foreach (var member in attendances)
{
myDataSet.MembersList.Rows.Add(
serNo,
member.MemberSubscription.Member.DisplayName,
member.MemberSubscription.Member.Number,
member.MemberSubscription.Member.Sex,
"አጠቃላይ: " + totalNumberOfRows,
member.MemberSubscription.Member.Address.AddressDetail,
member.MemberSubscription.Member.Address.Mobile,
member.MemberSubscription.FacilitySubscription.PackageName,
member.MemberSubscription.FacilitySubscription.Facility.DisplayName,
member.MemberSubscription.AmountPaid,
member.MemberSubscription.StartDateString,
member.MemberSubscription.EndDateString,
member.MemberSubscription.CurrentStatus,
ReportUtility.GetEthCalendarFormated(_beginDate.Value, "-") + "(" +
_beginDate.Value.ToShortDateString() + ")",
EnumUtil.GetEnumDesc(shift),
0, 0, selectedCompany.Header, "");
serNo++;
}
pervisitAttendances =
pervisitAttendances.OrderBy(a => a.DisplayName).ToList();
foreach (var member in pervisitAttendances)
{
myDataSet.MembersList.Rows.Add(
serNo,
member.DisplayName,
member.VisitNumber,
member.Sex,
"አጠቃላይ: " + totalNumberOfRows,
"",
"",
member.FacilitySubscription.PackageName,
"Per Visit",
member.AmountPaid,
member.CheckedInTime,
member.CheckedInTime,
"የዕለት",
ReportUtility.GetEthCalendarFormated(_beginDate.Value, "-") + "(" +
_beginDate.Value.ToShortDateString() + ")",
EnumUtil.GetEnumDesc(shift),
0, 0, selectedCompany.Header, "");
serNo++;
}
return(myDataSet);
}
public FitnessDataSet GetAttendanceListSummarizedDataSet(List <MemberAttendanceDTO> attendances, List <PervisitSubscriptionDTO> pervisitAttendances)
{
var myDataSet = new FitnessDataSet();
var serNo = 1;
var selectedCompany = new CompanyService(true).GetCompany();
//var totalNumberOfRows = attendances.Count();
attendances = attendances.OrderBy(a => a.MemberSubscription.FacilitySubscription.PackageName).ToList();
var memberSubscriptionListDaysLeft = attendances.Select(member => new SubscriptionModel
{
FacilityName = member.MemberSubscription.FacilitySubscription.PackageName,
DaysLeft = member.MemberSubscription.DaysLeft
}).ToList();
var memberSubscriptionList = attendances.Select(member => new SubscriptionModel
{
FacilityName = member.MemberSubscription.FacilitySubscription.PackageName,
Sex = member.MemberSubscription.Member.Sex
}).ToList();
pervisitAttendances = pervisitAttendances.OrderBy(a => a.DisplayName).ToList();
var pervists = pervisitAttendances.Select(member => new SubscriptionModel
{
FacilityName = member.FacilitySubscription.PackageName,
Sex = member.Sex
}).ToList();
memberSubscriptionList = memberSubscriptionList.Union(pervists.ToList()).ToList();
#region Calculate Sex
var maleSex = memberSubscriptionList.Count(s => s.Sex == Sex.Male);
var feMaleSex = memberSubscriptionList.Count(s => s.Sex == Sex.Female);
#endregion
#region Calculate DaysLeft
var withDays = memberSubscriptionListDaysLeft.Count(s => s.DaysLeft >= 0);
var withNoDays = memberSubscriptionListDaysLeft.Count(s => s.DaysLeft < 0);
#endregion
var querFacility = from memberSubscriptionList2 in memberSubscriptionList
group memberSubscriptionList2 by memberSubscriptionList2.FacilityName
into newGroup
orderby newGroup.Key
select newGroup;
var memberCategorySubList = querFacility.Select(nameGroup => new SubscriptionSumModel
{
Category = nameGroup.Key,
SubscriptionModels = nameGroup
}).ToList();
var shift = ShiftTypes.All;
if (_shiftType != null)
{
shift = (ShiftTypes)_shiftType;
}
if (_beginDate == null || _endDate == null)
{
return(null);
}
string datecaption = ReportUtility.GetEthCalendarFormated(_beginDate.Value, "-") + "(" +
_beginDate.Value.ToShortDateString() + ")";
if (_beginDate.Value.Day != _endDate.Value.Day || _beginDate.Value.Month != _endDate.Value.Month ||
_beginDate.Value.Year != _endDate.Value.Year)
{
datecaption = "ከ " + datecaption + " እስከ " + ReportUtility.GetEthCalendarFormated(_endDate.Value, "-") +
"(" + _endDate.Value.ToShortDateString() + ")";
}
foreach (var member in memberCategorySubList)
{
myDataSet.MembersList.Rows.Add(
serNo,
member.Category,
maleSex,
feMaleSex,
withDays,
withNoDays,
"",
"",
"",
0,
"",
"",
"",
datecaption,
EnumUtil.GetEnumDesc(shift),
member.TotalNumber, 0, selectedCompany.Header, "");
serNo++;
}
return(myDataSet);
}
public FitnessDataSet GetNumberListDataSet(List <SubscriptionModel> list, MemberStatusTypes status)
{
var myDataSet = new FitnessDataSet();
var serNo = 1;
var selectedCompany = new CompanyService(true).GetCompany();
var memberSubscriptionListForNumberSummary = list.ToList();
switch (status)
{
case MemberStatusTypes.Active:
memberSubscriptionListForNumberSummary = list.ToList().Where(m => !m.IsExpired).ToList();
break;
case MemberStatusTypes.Expired:
memberSubscriptionListForNumberSummary = list.ToList().Where(m => m.IsExpired).ToList();
break;
}
#region Group By Facility
var querFacility = from memberSubscriptionList in memberSubscriptionListForNumberSummary
group memberSubscriptionList by memberSubscriptionList.FacilityName
into newGroup
orderby newGroup.Key
select newGroup;
var memberCategorySubList = querFacility.Select(nameGroup => new SubscriptionSumModel
{
Category = nameGroup.Key,
SubscriptionModels = nameGroup
}).ToList();
foreach (var subscriptionSumModel in memberCategorySubList)
{
string cat = subscriptionSumModel.Category;
var subModels = subscriptionSumModel.SubscriptionModels;
var querSubscription = from memberSubscriptionList in subModels
group memberSubscriptionList by memberSubscriptionList.SubscriptionName
into newGroup
orderby newGroup.Key
select newGroup;
var memberCategorySubList2 = querSubscription.Select(nameGroup => new SubscriptionSumModel
{
Category = nameGroup.Key,
SubscriptionModels = nameGroup
}).ToList();
int permonth = 0, threemonth = 0, sixmonth = 0, oneyear = 0;
var firstOrDefault = memberCategorySubList2.FirstOrDefault(a => a.Category == "Per Month");
if (firstOrDefault != null)
{
permonth = firstOrDefault.TotalNumber;
}
firstOrDefault = memberCategorySubList2.FirstOrDefault(a => a.Category == "3 Months");
if (firstOrDefault != null)
{
threemonth = firstOrDefault.TotalNumber;
}
firstOrDefault = memberCategorySubList2.FirstOrDefault(a => a.Category == "6 Months");
if (firstOrDefault != null)
{
sixmonth = firstOrDefault.TotalNumber;
}
firstOrDefault = memberCategorySubList2.FirstOrDefault(a => a.Category == "1 Year");
if (firstOrDefault != null)
{
oneyear = firstOrDefault.TotalNumber;
}
var tot = oneyear + permonth + threemonth + sixmonth;
myDataSet.SummaryReport.Rows.Add(
serNo,
ReportUtility.GetEthCalendarFormated(DateTime.Now, "-") + "(" +
DateTime.Now.ToShortDateString() + ")",
cat,
0,
permonth,
threemonth,
sixmonth,
oneyear,
tot,
"",
"",
0, 0, selectedCompany.Header, "");
serNo++;
}
#endregion
return(myDataSet);
}
public FitnessDataSet GetSummaryDataSet2(IEnumerable <SubscriptionModel> list)
{
try
{
var myDataSet = new FitnessDataSet();
var serNo = 1;
var selectedCompany = new CompanyService(true).GetCompany();
var memberSubsList = list.OrderBy(g => g.FacilityName).ThenBy(g => g.SubscriptionName).ToList();
if (memberSubsList.Count == 0)
{
MessageBox.Show("No Data found on: ");
return(null);
}
#region Group By Facility
var shift = ShiftTypes.All;
if (_shiftType != null)
{
shift = (ShiftTypes)_shiftType;
}
if (_beginDate == null || _endDate == null)
{
return(null);
}
if (_beginDate.Value.Year < 2000)
{
_beginDate = DateTime.Now;
_endDate = DateTime.Now;
}
string datecaption = ReportUtility.GetEthCalendarFormated(_beginDate.Value, "-") + "(" +
_beginDate.Value.ToShortDateString() + ")";
if (_beginDate.Value.Day != _endDate.Value.Day || _beginDate.Value.Month != _endDate.Value.Month || _beginDate.Value.Year != _endDate.Value.Year)
{
datecaption = "ከ " + datecaption + " እስከ " + ReportUtility.GetEthCalendarFormated(_endDate.Value, "-") + "(" +
_endDate.Value.ToShortDateString() + ")";
}
foreach (var member in memberSubsList)
{
var durAmharic = "1 ወር";
if (member.SubscriptionName == "3 Months")
{
durAmharic = "3 ወር";
}
if (member.SubscriptionName == "6 Months")
{
durAmharic = "6 ወር";
}
if (member.SubscriptionName == "1 Year")
{
durAmharic = "1 አመት";
}
myDataSet.MembersList.Rows.Add(
serNo,
member.MemberName,
"አዲስ የተመዘገቡና ያደሱ",
EnumUtil.GetEnumDesc(member.Sex),
member.Age,
member.MobileNumber,
"",
member.FacilityName,
durAmharic,
member.Amount,
ReportUtility.GetEthCalendarFormated(member.StartDate, "-"),
ReportUtility.GetEthCalendarFormated(member.EndDate, "-"),
"",
datecaption,
EnumUtil.GetEnumDesc(shift),
0, 0, selectedCompany.Header, "");
serNo++;
}
#endregion
return(myDataSet);
}
catch
{
return(null);
}
}
public FitnessDataSet GetSummaryDataSet(IEnumerable <SubscriptionModel> list)
{
try
{
var myDataSet = new FitnessDataSet();
var serNo = 1;
var selectedCompany = new CompanyService(true).GetCompany();
var memberSubsList = list.ToList();
if (memberSubsList.Count == 0)
{
MessageBox.Show("No Data found on: ");
return(null);
}
#region Group By Facility
var querFacility = from memberSubscriptionList in memberSubsList
group memberSubscriptionList by memberSubscriptionList.PackageName
into newGroup
orderby newGroup.Key
select newGroup;
var memberCategorySubList = querFacility.Select(nameGroup => new SubscriptionSumModel
{
Category = nameGroup.Key,
SubscriptionModels = nameGroup
}).ToList();
var shift = ShiftTypes.All;
if (_shiftType != null)
{
shift = (ShiftTypes)_shiftType;
}
if (_beginDate == null || _endDate == null)
{
return(null);
}
string datecaption = ReportUtility.GetEthCalendarFormated(_beginDate.Value, "-") + "(" +
_beginDate.Value.ToShortDateString() + ")";
if (_beginDate.Value.Day != _endDate.Value.Day || _beginDate.Value.Month != _endDate.Value.Month || _beginDate.Value.Year != _endDate.Value.Year)
{
datecaption = "ከ " + datecaption + " እስከ " + ReportUtility.GetEthCalendarFormated(_endDate.Value, "-") + "(" +
_endDate.Value.ToShortDateString() + ")";
}
foreach (var subscriptionSumModel in memberCategorySubList)
{
var subtototal = subscriptionSumModel.TotalAmount / (decimal)1.15;
var tax = subtototal * (decimal)0.15;
myDataSet.DailySummaryReport.Rows.Add(
serNo, datecaption +
" - (" + EnumUtil.GetEnumDesc(shift) + ")",
subscriptionSumModel.Category,
subscriptionSumModel.TotalUnit,
subtototal,
tax,
subscriptionSumModel.TotalAmount,
"",
"",
0, 0, selectedCompany.Header, "");
serNo++;
}
#endregion
return(myDataSet);
}
catch
{
return(null);
}
}