public FitnessDataSet GetListDataSet() { var myDataSet = new FitnessDataSet(); var serNo = 1; var selectedCompany = new CompanyService(true).GetCompany(); foreach (var member in Members) { myDataSet.MembersList.Rows.Add( serNo, member.DisplayName, member.Number, member.SexAmharic, member.Age, member.Address.AddressDetail, member.Address.Mobile, member.LastSubscription.FacilitySubscription.PackageName, member.LastSubscription.FacilitySubscription.Subscription.DisplayName, member.LastSubscription.AmountPaid, member.LastSubscription.SubscribedDateStringAmharicFormatted, member.LastSubscription.EndDateStringAmharicFormatted, member.LastSubscription.CurrentStatus, "", "", 0, 0, selectedCompany.Header, ""); serNo++; } return(myDataSet); }
public FitnessDataSet GetListDataSet() { var myDataSet = new FitnessDataSet(); //var brCode = new BarcodeProcess(); //var businessPartnerNumberbarcode = ImageToByteArray(brCode.GetBarcode(SelectedBusinessPartner.Id.ToString() + "_ABC850", 620, 50, false), ImageFormat.Bmp); //var businessPartnerSub = BusinessPartnerSubscriptionDetail.FirstOrDefault(); ////if (SelectedBusinessPartner.LastSubscription != null) //myDataSet.BusinessPartnerDetail.Rows.Add( // SelectedBusinessPartner.DisplayName, // SelectedBusinessPartner.ShortPhoto, // SelectedBusinessPartner.Number, // businessPartnerNumberbarcode, // SelectedBusinessPartner.Sex, // SelectedBusinessPartner.Address.AddressDetail, // "", "", "", "", // SelectedBusinessPartner.Address.Mobile, // "", "", "", "", // businessPartnerSub != null ? businessPartnerSub.SubscribedDateStringAndAmharic : null, // businessPartnerSub != null ? businessPartnerSub.EndDateString : null, // businessPartnerSub != null ? businessPartnerSub.FacilitySubscription.PackageName : null, // ""); ////SelectedBusinessPartner.LastSubscription.SubscribedDateStringAndAmharic, //// SelectedBusinessPartner.LastSubscription.EndDateString, //// SelectedBusinessPartner.LastSubscription.FacilitySubscription.PackageName, return(myDataSet); }
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 FitnessDataSet GetListDataSet() { var myDataSet = new FitnessDataSet(); var brCode = new BarcodeProcess(); var memberNumberbarcode = ImageToByteArray(brCode.GetBarcode(SelectedMember.Number.ToString(), 1200, 40, false), ImageFormat.Bmp); //ImageToByteArray(brCode.GetBarcode(SelectedMember.Id.ToString() + "11850908", 1200, 40, false), // ImageFormat.Bmp); var memberPhoto = new AttachmentService(true).Find(SelectedMember.PhotoId.ToString()) ?? new AttachmentDTO(); var memberSub = MemberSubscriptionDetail.FirstOrDefault(); //if (SelectedMember.LastSubscription != null) myDataSet.MemberDetail.Rows.Add( SelectedMember.DisplayName, memberPhoto.AttachedFile, SelectedMember.Number, memberNumberbarcode, SelectedMember.SexAmharic, SelectedMember.Address.AddressDetail, "", "", "", "", SelectedMember.Address.Mobile, "", "", "", "", memberSub != null ? memberSub.StartDateStringAndAmharic : null, memberSub != null ? memberSub.EndDateStringAndAmharic : null, memberSub != null ? memberSub.FacilitySubscription.PackageName : null, ""); //SelectedMember.LastSubscription.SubscribedDateStringAndAmharic, // SelectedMember.LastSubscription.EndDateString, // SelectedMember.LastSubscription.FacilitySubscription.PackageName, 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); } }