BeWoPlaner/ReportImp/AlphaEv/ServicesOverviewReport.cs

using System;
using System.Collections;
using System.ComponentModel;
using System.Text;
using System.Text.RegularExpressions;
using BeWo.Report.ReportObjects;
using BeWo.Report;
using System.Collections.Generic;
using System.Drawing;
using System.IO;
using BeWo.Service.ServiceImplementations;
using BS.Shared.Core;
using BS.Shared.DataContracts;
using DevExpress.XtraReports.UI;

namespace AlphaEv
{
    public partial class Stundenzettel : DevExpress.XtraReports.UI.XtraReport, IBeWoReport<ServicesOverviewRO>
    {
        public Stundenzettel()
        {
            InitializeComponent();
        }

        public void SetReportDataSource(ServicesOverviewRO pRO)
        {
			var ba = GetTeam(pRO);
            if (!String.IsNullOrEmpty(ba))
            {
                ba = ba.Replace("Tagesstätte ", "");
                ba = ba.Replace("Tagesstruktur ", "");
                ba = ba.Replace("LT24 ", "");
                lblHeader.Text += " " + ba;
            }

            double minutesEinzel = 0;
            double minutesGruppe = 0;

            bool hatUnterschrift = false;

            if (pRO.Services != null)
			{
				List<ServicesOverviewRO.ServiceDetail> servicesBillable = new List<ServicesOverviewRO.ServiceDetail>();

				foreach (ServicesOverviewRO.ServiceDetail s in pRO.Services)
				{
					if (s.IsBillable || s.ServiceDescription.ToLower().Contains("fehlkontakt") || s.ServiceCategory.ToLower().Contains("fehlkontakt"))
					{
                        minutesEinzel += s.Minutes;
                        s.Notice5 = "E";
                        if (s.IsGroup)
					    {
					        minutesGruppe += s.Minutes;
					        s.Notice = "";
					        s.Notice2 = String.Format("{0:0.##}", s.GroupMinutes);
					        s.Notice3 = String.Format("{0:0.##}", s.Minutes);
					        s.Notice4 = String.Format("{0:0.##}", s.CustomerCount);
                            s.Notice5 = "GR";
                        }
					    else
					    {
                            //minutesEinzel += s.Minutes;
                            s.Notice = String.Format("{0:0.##}", s.Minutes);
                            s.Notice2 = "";
					        s.Notice3 = "";
					        s.Notice4 = "";
                            
                        }

                        if (s.ServiceDescription.ToLower().Contains("fehlkontakt") || s.ServiceCategory.ToLower().Contains("fehlkontakt"))
                        {
                            s.Notice5 = "F";
                        }

                        if (!String.IsNullOrEmpty(s.Signature))
					    {
					        hatUnterschrift = true;
					    }

                        servicesBillable.Add(s);
					}
				}

				pRO.Services = servicesBillable;
			}

            
            bindingSource1.DataSource = pRO;
            cellGesamtEinzel.Text = string.Format("{0:0.##}", minutesEinzel);
            //cellGesamtGruppe.Text = string.Format("{0:0.##}", minutesGruppe);

            lblSummeMinuten.Text = string.Format("{0:0.##}", minutesEinzel);
            lblSummeStunden.Text = string.Format("{0:0.##}", minutesEinzel / 60);

            if (minutesGruppe > 0)
            {
                lblKeineGruppe.Text = "";
            }
            else
            {
                lblKeineGruppe.Text = "X";
            }

            PruefeAbwesenheiten(pRO);

            if (String.IsNullOrWhiteSpace(pRO.AbsenceTimes))
            {
                lblKeineAbwesenheiten.Text = "X";
            }
            else
            {
                lblKeineAbwesenheiten.Text = "";
            }

            //if (!hatUnterschrift)
            //{
            //    //cellUnterschriftHeader.Visible = false;
            //    //cellUnterschrift.Visible = false;

            //    lblUnterschriftKlientDatum.Visible = true;
            //    lblUnterschriftKlient.Visible = true;

            //    lblUnterschriftKlientDatum.Location = lblUnterschriftMitarbeiterDatum.Location;
            //    lblUnterschriftKlient.Location = lblUnterschriftMitarbeiter.Location;

            //    lblUnterschriftMitarbeiterDatum.Top += 80;
            //    lblUnterschriftMitarbeiter.Top += 80;

            //    lblAbsenceTime.Top += 80;
                
            //}
            //else
            //{
                lblUnterschriftKlientDatum.Visible = false;
                lblUnterschriftKlient.Visible = false;
            //}
            //var approved = pRO.ApprovedFLSPerWeek;

            //var stats = GetStatistics(pRO);
            //if (stats != null)
            //{
            //	approved = stats.MinutesApprovedPerWeek / 60;
            //}
            lblSollImMonat.Text = string.Format("{0:0.##}", pRO.ApprovedFLSPerWeek * 4.3m);

		}

        private void PruefeAbwesenheiten(ServicesOverviewRO pRo)
        {
            StringBuilder sb = new StringBuilder();
            var span = new DateTimeSpan();

            span.StartDate = pRo.StartDate;
            span.EndDate = pRo.EndDate;

            if (pRo.Abwesenheiten != null)
            {
                foreach (var at in pRo.Abwesenheiten)
                {
                    if (at.AbsenceSpan != null && at.AbsenceReason != null && !at.AbsenceReason.Description.ToLower().Contains("urlaub"))
                    {
                        bool cont = !(at.Start != null && at.Start > span.EndDateTime);

                        if (cont && at.End != null && at.End < span.StartDateTime)
                        {
                            cont = false;
                        }

                        if (cont)
                        {
                            if (sb.Length > 0)
                            {
                                sb.Append(", ");
                            }

                            if (at.Start.HasValue)
                            {
                                sb.Append(string.Format("{0:00}", at.Start.Value.Day));
                                sb.Append(".");
                                sb.Append(string.Format("{0:00}", at.Start.Value.Month));
                                sb.Append(".");
                                sb.Append(at.Start.Value.Year.ToString().Substring(2));

                                sb.Append(" - ");

                                if (at.End.HasValue)
                                {
                                    sb.Append(string.Format("{0:00}", at.End.Value.Day));
                                    sb.Append(".");
                                    sb.Append(string.Format("{0:00}", at.End.Value.Month));
                                    sb.Append(".");
                                    sb.Append(at.End.Value.Year.ToString().Substring(2));
                                }
                                else
                                {
                                    sb.Append("unbekannt");
                                }
                            }
                        }
                    }
                }
            }

            pRo.AbsenceTimes = sb.ToString();
        }

        public String GetTeam(ServicesOverviewRO pRO)
        {
            if (pRO.CostBearer2SupportConceptList != null && pRO.CostBearer2SupportConceptList.Count > 0)
            {
                var c2s = pRO.CostBearer2SupportConceptList[0];
                var c = c2s.SupportConcept.Customer;
                pRO.Costbearer = c.DebitorNumber;
                foreach (var t2c in c.Team2CustomerList)
                {
                    return t2c.Team.Name;
                }
            }
            return "";
        }


        private SupportConceptPeriodStatisticsDC GetStatistics(ServicesOverviewRO ro)
		{
			if (ro.CostBearer2SupportConceptList != null && ro.CostBearer2SupportConceptList.Count > 0)
			{
				var service = new OperationsServiceImp();

				foreach (var cb2sc in ro.CostBearer2SupportConceptList)
				{
					long cb2scOid = cb2sc.Oid.Value;


					var stats = service.CreateSupportConceptStatistics(cb2scOid, ro.EndDate);

					if (stats.PeriodStatistics != null && stats.PeriodStatistics.Count > 0)
					{
						foreach (var ps in stats.PeriodStatistics)
						{
							if (ps.SupportConceptApprovalPeriod != null && ps.SupportConceptApprovalPeriod.ServiceCategory != null &&
								ps.SupportConceptApprovalPeriod.ServiceCategory.Name.StartsWith("FLS"))
							{
								return ps;
							}
						}
					}
				}

			}
			return null;
		}

        private void xrPictureBox1_BeforePrint(object sender, CancelEventArgs e)
        {
            XRPictureBox xrBox = sender as XRPictureBox;
            //var test = this.GetCurrent
            string base64String = xrBox.Tag as string;
            if (!String.IsNullOrWhiteSpace(base64String))
            {
                var base64Data = Regex.Match(base64String, @"data:image/(?<type>.+?),(?<data>.+)").Groups["data"].Value;
                var binData = Convert.FromBase64String(base64Data);
                Image img = ByteArrayToImage(binData);
                xrBox.Image = Utils.CropImage(img);
            }
            else
            {
                xrBox.Image = null;
            }
        }

        public Image ByteArrayToImage(byte[] byteArrayIn)
        {
            Image returnImage = null;
            MemoryStream ms = new System.IO.MemoryStream(byteArrayIn);
            returnImage = Image.FromStream(ms);
            
            return returnImage;
        }
    }
}