using framework_business;
using framework_library;
using System;
using System.Configuration;
using System.Data;
using System.IO;
using System.Reflection;
using System.Web;

/// <summary>
/// Summary description for Loyalty
/// </summary>
public class Loyalty
{
    public Loyalty()
    {

    }

    /// <summary>
    /// Send today's loyalty members
    /// </summary>
    public void SendLoyaltyMembers()
    {
        try
        {
            if (ConfigurationManager.AppSettings["loyaltyEmailAddy"] != null && utils.validateEmail(ConfigurationManager.AppSettings["loyaltyEmailAddy"]))
            {
                DataTable dtLoyaltyDetail = new DataTable();

                DateTime today = DateTime.Now.Date;
                dtLoyaltyDetail = xData.GetTypedByCriteriaSpecificTable("recId", typeof(ovLoyaltyDetail), "~DATEONLYdateCreated", today.ToShortDateString(), "", "pal_");

                if (dtLoyaltyDetail.Rows.Count > 0)
                {
                    dtLoyaltyDetail.Columns.Remove("recId");
                    utils.SetDataTableColumnOrder(ref dtLoyaltyDetail, new string[] { "storeCode","storeName","groupCode","groupName",
                    "name","surname","idNumber","mobileNo","email","loyaltyNumber","optIn","isActive","dateCreated","dateUpdated"});

                    var path = HttpContext.Current.Server.MapPath("~/upload/temp/loyalty.xlsx");
                    if (File.Exists(path))
                        File.Delete(path);
                    utils.ExportDataTabletoExcel(dtLoyaltyDetail, path);

                    oEmail mail = new oEmail();
                    mail.Attachments.Add(path);
                    mail.toAddress = ConfigurationManager.AppSettings["loyaltyEmailAddy"];
                    mail.Subject = "Today's New Loyalty Members";

                    communication.SendAnEmail(mail);
                }
            }
        }
        catch (Exception ex)
        {
            exception.HandleException("loyalty class:", MethodBase.GetCurrentMethod().Name, ex, 0, false);
        }

    }
}