Ejemplo n.º 1
0
        public void SendAllEmails()
        {
            Log.Info("Running Summary Email Reports ...");

            using (AdoDataConnection connection = new AdoDataConnection("systemSettings"))
            {
                List <SummaryEmail> emails = new TableOperations <SummaryEmail>(connection).QueryRecords().ToList();
                emails.ForEach(item =>
                {
                    try
                    {
                        string xmlData = connection.ExecuteScalar <string>(item.DataSQL).Replace("&amp;", "&").Replace("&gt;", ">");

                        xmlData                = xmlData.Replace("&lt;", "<");
                        string htmlText        = xmlData.ApplyXSLTransform(item.Template);
                        XDocument htmlDocument = XDocument.Parse(htmlText, LoadOptions.PreserveWhitespace);
                        htmlDocument.TransformAll("format", element => element.Format());

                        SendEmail(item.Subject, htmlDocument
                                  .ToString(SaveOptions.DisableFormatting)
                                  .Replace("&amp;", "&")
                                  .Replace("&lt;", "<")
                                  .Replace("&gt;", ">"));

                        Log.Info($"Sent email: {item.Subject}");
                    }
                    catch (Exception ex)
                    {
                        Log.Error(ex.Message, ex);
                    }
                });
            }
        }
        public IHttpActionResult Update(string id)
        {
            int xdaID = int.Parse(id);

            List <T> xdaObj = new List <T>();

            try
            {
                using (AdoDataConnection connection = new AdoDataConnection(Connection))
                {
                    if (xdaID < 0)
                    {
                        xdaObj = (new TableOperations <T>(connection)).QueryRecords().ToList();
                    }
                    else
                    {
                        if ((new TableOperations <T>(connection)).QueryRecordCountWhere("ID = {0}", xdaID) > 0)
                        {
                            xdaObj.Add((new TableOperations <T>(connection)).QueryRecordsWhere("ID = {0}", xdaID).First());
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                return(InternalServerError(ex));
            }

            List <Model.ExternalDBField> result = new List <Model.ExternalDBField>();

            List <Model.AdditionalField>      fields    = new List <Model.AdditionalField>();
            List <Model.ExternalOpenXDAField> xdaFields = new List <Model.ExternalOpenXDAField>();

            TableNameAttribute tableNameAttribute;
            string             tableName;

            if (typeof(T).TryGetAttribute(out tableNameAttribute))
            {
                tableName = tableNameAttribute.TableName;
            }
            else
            {
                tableName = typeof(T).Name;
            }



            try
            {
                using (AdoDataConnection connection = new AdoDataConnection(AdditionalFieldConnection))
                {
                    fields    = new TableOperations <Model.AdditionalField>(connection).QueryRecordsWhere("ParentTable = {0} AND ExternalDB = {1}", tableName, extDBName).ToList();
                    xdaFields = new TableOperations <Model.ExternalOpenXDAField>(connection).QueryRecordsWhere("ParentTable = {0} AND ExternalDB = {1}", tableName, extDBName).ToList();

                    IEnumerable <IGrouping <string, Model.AdditionalField> >      fieldGroups    = fields.GroupBy(item => item.ExternalDBTable);
                    IEnumerable <IGrouping <string, Model.ExternalOpenXDAField> > xdafieldGroups = xdaFields.GroupBy(item => item.ExternalDBTable);

                    foreach (string tbl in fieldGroups.Select(item => item.Key).Union(xdafieldGroups.Select(item => item.Key)))
                    {
                        IGrouping <string, Model.AdditionalField>      fieldgroup = fieldGroups.Where(item => item.Key == tbl).FirstOrDefault();
                        IGrouping <string, Model.ExternalOpenXDAField> xDAgroup   = xdafieldGroups.Where(item => item.Key == tbl).FirstOrDefault();

                        foreach (T asset in xdaObj)
                        {
                            try {
                                result = result.Concat(GetTable(tbl,
                                                                new Tuple <IEnumerable <Model.AdditionalField>, IEnumerable <Model.ExternalOpenXDAField> >(
                                                                    (fieldgroup == null ? new List <Model.AdditionalField>() : fieldgroup.ToList()),
                                                                    (xDAgroup == null ? new List <Model.ExternalOpenXDAField>() : xDAgroup.ToList())),
                                                                asset)).ToList();
                            }
                            catch (Exception ex)
                            {
                                return(InternalServerError(ex));
                            }
                        }
                    }


                    fields.ForEach(item =>
                                   xdaObj.ForEach(asset =>
                                                  connection.ExecuteNonQuery("UPDATE AdditionalFieldValue SET [UpdatedOn] = sysdatetime() WHERE ParentTableID = {0} AND AdditionalFieldID = {1}",
                                                                             asset.GetType().GetProperty("ID").GetValue(asset), item.ID)
                                                  )
                                   );
                }
            }
            catch (Exception ex)
            {
                return(InternalServerError(ex));
            }



            return(Ok(result));
        }