using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.IO;
using System.Linq;
using System.Net;
using custom.BLL.Model;
using custom.DAL.EF;

namespace custom.BLL
{
 public interface IPayrollService
    {
        WeekClass GetTimeSheet(int empNo, string period, string tz);
        Time[] GetEntriesFromCustomDb(int empNo, DateTime fromDate, DateTime toDate);
        bool AddTimeEntries(WeekClass week);
        WeekClass ExecutePayRollRules(int empNo, string period, string tz);
    }
    public class PayrollService : IPayrollService
    {
 	public WeekClass GetTimeSheet(int empNo, string period, string tz)
        {
            if (string.IsNullOrEmpty(period))
                throw new ArgumentNullException("period", "A timesheet period is required.");

            if (!period.Contains("-"))
                throw new ArgumentException("The provided period is invalid. Must be formatted as mm/dd/yyyy-mm/dd/yyyy.", "period");

            string[] p = period.Split('-');
            List<TAT_TIME> timeEntries = GetTimeEntries(empNo, DateTime.Parse(p[0]), DateTime.Parse(p[1]));

            // TODO - pass in these entries to be process by payroll rules
            var mealAndRestTimes = GetEntriesFromCustomDb(empNo, DateTime.Parse(p[0]), DateTime.Parse(p[1]));

            var rules = new PayrollRules();
            return rules.CalculateTimeKeeper(p[0], timeEntries);
        }
        public WeekClass ExecutePayRollRules(int empNo, string period, string tz)
        {
            string[] p = period.Split('-');
            List<TAT_TIME> timeEntries = GetTimeEntries(empNo, DateTime.Parse(p[0]), DateTime.Parse(p[1]));
            var rules = new PayrollRules();
            return rules.CalculateMealRestCreditRule(p[0],timeEntries);

        }
        
        public bool AddTimeEntries(WeekClass week)
        {
            try
            {
                var times = new List<Time>();
                var now = DateTime.UtcNow;
                int ctr = 0;
                using (var dbContext = new TimeSheetNEEntities())
                {
                    foreach (var day in week.DayList)
                    {
                            if ((day.Total_Worked != 0) && (day.TRAN_DATE != null))
                            {
                                var check = dbContext.Times.Where(x => x.EmployeeID == week.Emp_Uno && x.Date == day.TRAN_DATE).FirstOrDefault();
                                if ((check == null) && (day.IsMealBreakWaived))
                                {
                                times.Add(new Time
                                {
                                    Date = day.TRAN_DATE,
                                    DateCreated = now,
                                    EmployeeID = week.Emp_Uno,
                                    RestHours = day.Rest_Credit,
                                    MealHours = day.Meal_Credit,
                                }) ;
                                    dbContext.Times.Add(times[ctr++]);
                                }
                                
                                if ((check != null) && (!day.IsMealBreakWaived))
                                {
                                    dbContext.Times.Attach(check);
                                    dbContext.Entry(check).CurrentValues.SetValues(times);

                                }
                        }
                        dbContext.SaveChanges();
                    }
                    //dbContext.Times.AddRange(times);  //dbContext.SaveChanges();
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
                // TODO log, throw;
            }

            return true;
        }

        public Time[] GetEntriesFromCustomDb(int empNo, DateTime fromDate, DateTime toDate)
        {
            using (var dbContext = new TimeSheetNEEntities())
            {
                var times = dbContext.Times
                    .Where(p => p.EmployeeID == empNo && (p.Date >= fromDate && p.Date <= toDate)) // - fix, need payroll week parameter pending
                    .ToArray();

                return times;
            }
        }


    }
}