private bool SendClimbersListForTeam(string email, int?team_id, string subj, string body)
        {
            string fileName;

            if (team_id == null)
            {
                fileName = "LIST";
            }
            else
            {
                fileName = "LIST_" + team_id.Value.ToString();
            }
            fileName += "_" + DateTime.UtcNow.ToString("yyyyMMdd_HHmm", CultureInfo.CurrentCulture) + ".csv";

            MemoryStream mStr = new MemoryStream();

            try
            {
                StreamWriter swr = new StreamWriter(mStr, Encoding.Unicode);
                ONLteam[]    teams;
                if (team_id == null)
                {
                    teams = (from t in dc.ONLTeamsCompLinks
                             where t.comp_id == compID
                             select t.ONLteam).Distinct().ToArray();
                }
                else
                {
                    teams = (from tL in dc.ONLteams
                             where tL.iid == team_id
                             select tL).ToArray();
                }
                //teams = (from t in teams
                //         where t.ONLClimberCompLinks.Count(l => l.comp_id == compID) > 0
                //         select t).ToArray();
                bool lead = comp.Lead(), speed = comp.Speed(), boulder = comp.Boulder();

                try
                {
                    var grpLstT = from g in dc.ONLGroups
                                  where g.ONLGroupsCompLinks.Count(gl => gl.comp_id == compID) > 0
                                  orderby g.oldYear, g.genderFemale
                    select g;
                    List <ONLGroup> grpList = new List <ONLGroup>();
                    foreach (var g in grpLstT)
                    {
                        grpList.Add(g);
                    }
                    foreach (var t in teams)
                    {
                        int teamID = t.iid;
                        swr.AutoFlush = true;
                        swr.WriteLine(t.name);
                        if (t.HasClimbers(compID))
                        {
                            swr.WriteLine("№\tФамилия, Имя\tГ.р.\tРазр." +
                                          (lead ? "\tТр." : String.Empty) +
                                          (speed ? "\tСк." : String.Empty) +
                                          (boulder ? "\tБоулд." : String.Empty)
                                          );
                            foreach (var g in grpList)
                            {
                                var clmLstT = from c in dc.ONLClimberCompLinks
                                              where c.group_id == g.iid &&
                                              c.team_id == teamID &&
                                              c.state == Constants.CLIMBER_CONFIRMED &&
                                              c.comp_id == compID
                                              orderby c.ONLclimber.surname, c.ONLclimber.name
                                select c;
                                int curClm = 0;
                                swr.WriteLine(g.name + ":");
                                if (t.HasClimbers(compID, g.iid))
                                {
                                    foreach (var c in clmLstT.Where(w => w.queue_pos < 1))
                                    {
                                        swr.WriteLine((++curClm).ToString() + ".\t" +
                                                      c.ONLclimber.surname + " " + c.ONLclimber.name + "\t" +
                                                      c.ONLclimber.age.ToString() + "\t" +
                                                      c.qf +
                                                      (lead ? ("\t" + getShortValue(c.lead)) : String.Empty) +
                                                      (speed ? ("\t" + getShortValue(c.speed)) : String.Empty) +
                                                      (boulder ? ("\t" + getShortValue(c.boulder)) : String.Empty));
                                    }

                                    swr.WriteLine();
                                    swr.WriteLine("Очередь:");
                                    foreach (var c in clmLstT.Where(w => w.queue_pos > 0))
                                    {
                                        swr.WriteLine(c.queue_pos.ToString() + ".\t" +
                                                      c.ONLclimber.surname + " " + c.ONLclimber.name + "\t" +
                                                      c.ONLclimber.age.ToString() + "\t" +
                                                      c.qf);
                                    }
                                    swr.WriteLine();
                                    swr.WriteLine("Неподтверждённые:");
                                    curClm = 0;
                                    var clmLstU = from c in dc.ONLClimberCompLinks
                                                  where c.group_id == g.iid &&
                                                  c.team_id == teamID &&
                                                  c.comp_id == compID &&
                                                  c.state != Constants.CLIMBER_CONFIRMED
                                                  orderby c.ONLclimber.surname, c.ONLclimber.name
                                    select c;
                                    foreach (var c in clmLstU)
                                    {
                                        swr.WriteLine((++curClm).ToString() + "\t" +
                                                      c.ONLclimber.surname + " " + c.ONLclimber.name + "\t" +
                                                      c.ONLclimber.age.ToString() + "\t" +
                                                      c.qf + "\t" +
                                                      (c.state == Constants.CLIMBER_PENDING_DELETE ? "Удаление" : (c.ONLClimberCompLink1.Count == 0 ? "Добавление" : "Правка"))
                                                      );
                                    }
                                }
                                else
                                {
                                    swr.WriteLine("Участники в данную группу не заявлены");
                                }
                                swr.WriteLine();
                                swr.WriteLine();
                            }
                        }
                        else
                        {
                            swr.WriteLine("УЧАСТНИКИ НЕ ЗАЯВЛЕНЫ");
                        }
                    }
                    string      sTmp;
                    MailService ms = new MailService(dc, compID);
                    return(ms.SendMail(email, subj, body, MailPriority.Normal, fileName, mStr, out sTmp));
                }
                finally { swr.Close(); }
            }
            finally { mStr.Close(); }
        }
Exemple #2
0
        public MembershipUser CreateUser(string username, string password, string email, int?teamID, string chief, bool isApproved, object providerUserKey, out MembershipCreateStatus status)
        {
            ValidatePasswordEventArgs e = new ValidatePasswordEventArgs(username, password, true);

            OnValidatingPassword(e);
            if (e.Cancel)
            {
                status = MembershipCreateStatus.InvalidPassword;
                return(null);
            }
            if (RequiresUniqueEmail && !String.IsNullOrEmpty(GetUserNameByEmail(email)))
            {
                status = MembershipCreateStatus.DuplicateEmail;
                return(null);
            }

            if (!(providerUserKey is string))
            {
                status = MembershipCreateStatus.InvalidProviderUserKey;
                return(null);
            }
            string newIid = (string)providerUserKey;

            if (newIid.Length > 3)
            {
                newIid = newIid.Substring(0, 3);
            }
            if (GetUser(newIid, false) != null)
            {
                status = MembershipCreateStatus.DuplicateUserName;
                return(null);
            }
            try
            {
                ONLuser u = ONLuser.CreateONLuser(newIid, username, password, String.Empty);
                u.team_id      = teamID;
                u.email        = email;
                u.chief        = chief;
                u.creationDate = DateTime.UtcNow;
                dc.ONLusers.AddObject(u);
                dc.SaveChanges();

                status = MembershipCreateStatus.Success;
                try
                {
                    if (!String.IsNullOrEmpty(email))
                    {
                        string      str;
                        MailService ms = new MailService(dc, -1);
                        ms.SendMail(email, "Учетная запись",
                                    "Создана учётная запись в системе подачи заявок на соревнования по скалолазанию.\r\n" +
                                    "Ваш регион: " + username + "\r\n" +
                                    "Ваш пароль: " + password + "\r\n\r\n" +
                                    "С Уважением, Администратор системы.",
                                    System.Net.Mail.MailPriority.Normal,
                                    out str);
                    }
                }
                catch { }
                return(GetUser(newIid, false));
            }
            catch (Exception)
            {
                status = MembershipCreateStatus.ProviderError;
                return(null);
            }
        }