Ejemplo n.º 1
0
        public void Execute(IJobExecutionContext context)
        {
            try
                {
                    Console.WriteLine("RemoveMoneyJob is starting....." + DateTime.Now.ToString());

                    Log.Info("RemoveMoneyJob запущен!");

                        List<GetBillsecForClientInfo> BillsecForClientInfoList_Curent = new List<GetBillsecForClientInfo>();
                        List<GetPhonesCountForClientInfo> PhonesCountForClientInfoList_Curent = new List<GetPhonesCountForClientInfo>();

                        ////выбираем дату последнего успешного запуска Job-а ( Начало )
                        DateTime lastactiondate = new DateTime();
                        JobsInfo JobsInfoQuery = _jobsinfoRep.GetLastActionDateForJob(Constants.RemoveMoneyJob);
                        if (JobsInfoQuery != null)
                            lastactiondate = JobsInfoQuery.lastactiondate;
                        // выбираем дату последнего успешного запуска Job-а ( Конец )
                        else
                            lastactiondate = DateTime.Parse("2013-03-15");

                        double numbercostforday = 0;

                        DateTime FinishDate = /*GetDateFromFile()[1];*/DateTime.Now.AddHours(-1).ToUniversalTime();
                        DateTime StartDate = /*GetDateFromFile()[0];*/ lastactiondate;
                        DateTime CurentDate = StartDate;

                        MinutesCost lastminutecostdate = null;
                        NumberCost lastnumbercostdate = null;

                        //StartDate = DateTime.Parse("29.04.2013 23:00:00");
                        //CurentDate = StartDate;
                        //FinishDate = DateTime.Parse("30.04.2013 00:00:00").AddHours(-1);

                        while (CurentDate <= FinishDate)//условие <= приводит к двойному выполнению Job-а для одного и того же клиента в сутки
                        {
                            string clients = GetClientsForRemoveMoney_(CurentDate/*DateTime.Parse("30.04.2013 0:00:00")*/);//получаем всех клиентов, для которых нужно списать деньги

                            if (!String.IsNullOrEmpty(clients))
                            {
                                        Console.WriteLine("Диапазон между startdate и finishdate: " + StartDate.ToString() + " - " + FinishDate.ToString());
                                        Console.WriteLine("Грабеж!!!!!!!!! Время грабежа: " + CurentDate.ToString() + " Клиенты: " + clients);
                                        List<BillSecForClientsInfo> billsecforclientsinfo = Call_GetBillSecForClients(CurentDate, clients);
                                        List<ActivedClientsNumbersCountInfo> activedclientsnumberscountinfo = Call_GetActivedClientsNumbers(CurentDate, clients);

                                        lastminutecostdate = _minutescostRep.GetAll().Where(t => t.lastupdate <= CurentDate).OrderByDescending(t => t.lastupdate).FirstOrDefault();
                                        lastnumbercostdate = _numbercostRep.GetAll().Where(t => t.lastupdate <= CurentDate).OrderByDescending(t => t.lastupdate).FirstOrDefault();

                                        List<InfoForPaymants> infoforpaymants = new List<InfoForPaymants>();

                                        var commondata = from b in billsecforclientsinfo
                                                         from a in activedclientsnumberscountinfo
                                                         where b.date == a.date && b.ClientId == a.ClientId
                                                         select new
                                                         {
                                                             ClientId = b.ClientId,
                                                             date = b.date,
                                                             count = a.count,
                                                             codes_billsec = b.codes_billsec
                                                         };

                                        var differentdata = from a in activedclientsnumberscountinfo
                                                            where !billsecforclientsinfo.Any(t => t.ClientId == a.ClientId && t.date == a.date)
                                                            select a;

                                        if (commondata.Count() > 0)
                                            foreach (var item in commondata)
                                                infoforpaymants.Add(new InfoForPaymants() { codes_billsec = item.codes_billsec, ClientId = item.ClientId, count = item.count, date = item.date });

                                        if (differentdata.Count() > 0)
                                            foreach (var item in differentdata)
                                                infoforpaymants.Add(new InfoForPaymants() { codes_billsec = null, count = item.count, date = item.date, ClientId = item.ClientId });

                                        int allbillsec = 0;//общее колическво секунд разговоров для клиента для всех кодов

                                        if (infoforpaymants.Count() > 0)
                                        {
                                            foreach (InfoForPaymants item in infoforpaymants)
                                            {
                                                numbercostforday = _numbercostRep.GetLastNumberCostToThisDate(item.date);//последняя стоимость номера за день
                                                if (item.codes_billsec != null)
                                                    item.sum = Math.Round(GetCommonBillsecCostForAllCodes(item.codes_billsec) + item.count * numbercostforday, 2);
                                                else
                                                    item.sum = Math.Round(item.count * numbercostforday, 2);

                                                if (item.codes_billsec != null)
                                                    allbillsec = item.codes_billsec.Sum(t => t.billsec);

                                                Paymant new_paymant = new Paymant() { ClientId = item.ClientId, date = item.date, Type = false, sum = -1 * item.sum, coment = "Снятие денег со счета. Время разговоров: " + allbillsec + " сек; Количество арендуемых номеров: " + item.count + " Время: " + DateTime.Now.ToString() };
                                                _paymantsRep.Add(new_paymant);
                                                _paymantsRep.Save();

                                                Client curent_client = _clientRep.Find(item.ClientId);
                                                if (curent_client != null)
                                                {
                                                    string message_ = "Уважаемый " + curent_client.Name + ", " + item.date.ToShortDateString() + " с вашего счета было снято " + item.sum + " грн за " + allbillsec + " секунд разговоров и за аренду телефонов в количестве " + item.count + ".";
                                                    _sendemailjobinfoRep.Add(new SendEmailJobInfo() { attemptcount = 0, date = DateTime.Now.ToUniversalTime(), message = message_, status = false, subject = "CallTracking Info", To = curent_client.Email });
                                                    _sendemailjobinfoRep.Save();
                                                }
                                                allbillsec = 0;
                                            }
                                }
                            }
                            CurentDate = CurentDate.AddHours(1);
                        }

                       // AddOneHourToDatesFromFile();

                        JobsInfo new_jobs_info = new JobsInfo() { status = true, lastactiondate = DateTime.Now.ToUniversalTime(), jobId = Constants.RemoveMoneyJob };//поставить еще jobId! ( также в классе JobsInfo )
                        _jobsinfoRep.Add(new_jobs_info);
                        _jobsinfoRep.Save();

                        Log.Info("RemoveMoneyJob успешно выполнен!");
                        Console.WriteLine("RemoveMoneyJob is finished....." + DateTime.Now.ToString());
                    }
                catch (Exception ex)
                {

                    while (ex.InnerException != null)
                        ex = ex.InnerException;
                   /* JobsInfo new_jobs_info = new JobsInfo() { status = false, lastactiondate = DateTime.Now.ToUniversalTime(), jobId = Constants.RemoveMoneyJob, ExceptionText = String.Format(@"Message: {0}, Source: {1}, TargetSite: {2}, Trace: {3} ", ex.Message, ex.Source, ex.TargetSite, ex.StackTrace) };//поставить еще jobId! ( также в классе JobsInfo )
                    _jobsinfoRep.Add(new_jobs_info);
                    _jobsinfoRep.Save();

                    Log.Error(String.Format(@"Message: {0}, Source: {1}, TargetSite: {2}, Trace: {3} ", ex.Message, ex.Source, ex.TargetSite, ex.StackTrace));
                    Console.WriteLine("RemoveMoneyJob is running with error....." + DateTime.Now.ToString());
                    Console.WriteLine(String.Format(@"Message: {0}, Source: {1}, TargetSite: {2}, Trace: {3} ", ex.Message, ex.Source, ex.TargetSite, ex.StackTrace));*/
                    throw ex;
                }
        }
Ejemplo n.º 2
0
        public void Execute(IJobExecutionContext context)
        {
            try
            {
                Console.WriteLine("RemoveMoneyJob is starting....." + DateTime.Now.ToString());

                Log.Info("RemoveMoneyJob запущен!");

                List <GetBillsecForClientInfo>     BillsecForClientInfoList_Curent     = new List <GetBillsecForClientInfo>();
                List <GetPhonesCountForClientInfo> PhonesCountForClientInfoList_Curent = new List <GetPhonesCountForClientInfo>();

                ////выбираем дату последнего успешного запуска Job-а ( Начало )
                DateTime lastactiondate = new DateTime();
                JobsInfo JobsInfoQuery  = _jobsinfoRep.GetLastActionDateForJob(Constants.RemoveMoneyJob);
                if (JobsInfoQuery != null)
                {
                    lastactiondate = JobsInfoQuery.lastactiondate;
                }
                // выбираем дату последнего успешного запуска Job-а ( Конец )
                else
                {
                    lastactiondate = DateTime.Parse("2013-03-15");
                }

                double numbercostforday = 0;

                DateTime FinishDate = /*GetDateFromFile()[1];*/ DateTime.Now.AddHours(-1).ToUniversalTime();
                DateTime StartDate  = /*GetDateFromFile()[0];*/ lastactiondate;
                DateTime CurentDate = StartDate;

                MinutesCost lastminutecostdate = null;
                NumberCost  lastnumbercostdate = null;

                //StartDate = DateTime.Parse("29.04.2013 23:00:00");
                //CurentDate = StartDate;
                //FinishDate = DateTime.Parse("30.04.2013 00:00:00").AddHours(-1);

                while (CurentDate <= FinishDate)                                                                     //условие <= приводит к двойному выполнению Job-а для одного и того же клиента в сутки
                {
                    string clients = GetClientsForRemoveMoney_(CurentDate /*DateTime.Parse("30.04.2013 0:00:00")*/); //получаем всех клиентов, для которых нужно списать деньги

                    if (!String.IsNullOrEmpty(clients))
                    {
                        Console.WriteLine("Диапазон между startdate и finishdate: " + StartDate.ToString() + " - " + FinishDate.ToString());
                        Console.WriteLine("Грабеж!!!!!!!!! Время грабежа: " + CurentDate.ToString() + " Клиенты: " + clients);
                        List <BillSecForClientsInfo>          billsecforclientsinfo          = Call_GetBillSecForClients(CurentDate, clients);
                        List <ActivedClientsNumbersCountInfo> activedclientsnumberscountinfo = Call_GetActivedClientsNumbers(CurentDate, clients);

                        lastminutecostdate = _minutescostRep.GetAll().Where(t => t.lastupdate <= CurentDate).OrderByDescending(t => t.lastupdate).FirstOrDefault();
                        lastnumbercostdate = _numbercostRep.GetAll().Where(t => t.lastupdate <= CurentDate).OrderByDescending(t => t.lastupdate).FirstOrDefault();

                        List <InfoForPaymants> infoforpaymants = new List <InfoForPaymants>();

                        var commondata = from b in billsecforclientsinfo
                                         from a in activedclientsnumberscountinfo
                                         where b.date == a.date && b.ClientId == a.ClientId
                                         select new
                        {
                            ClientId      = b.ClientId,
                            date          = b.date,
                            count         = a.count,
                            codes_billsec = b.codes_billsec
                        };

                        var differentdata = from a in activedclientsnumberscountinfo
                                            where !billsecforclientsinfo.Any(t => t.ClientId == a.ClientId && t.date == a.date)
                                            select a;

                        if (commondata.Count() > 0)
                        {
                            foreach (var item in commondata)
                            {
                                infoforpaymants.Add(new InfoForPaymants()
                                {
                                    codes_billsec = item.codes_billsec, ClientId = item.ClientId, count = item.count, date = item.date
                                });
                            }
                        }

                        if (differentdata.Count() > 0)
                        {
                            foreach (var item in differentdata)
                            {
                                infoforpaymants.Add(new InfoForPaymants()
                                {
                                    codes_billsec = null, count = item.count, date = item.date, ClientId = item.ClientId
                                });
                            }
                        }

                        int allbillsec = 0;                //общее колическво секунд разговоров для клиента для всех кодов

                        if (infoforpaymants.Count() > 0)
                        {
                            foreach (InfoForPaymants item in infoforpaymants)
                            {
                                numbercostforday = _numbercostRep.GetLastNumberCostToThisDate(item.date);                //последняя стоимость номера за день
                                if (item.codes_billsec != null)
                                {
                                    item.sum = Math.Round(GetCommonBillsecCostForAllCodes(item.codes_billsec) + item.count * numbercostforday, 2);
                                }
                                else
                                {
                                    item.sum = Math.Round(item.count * numbercostforday, 2);
                                }

                                if (item.codes_billsec != null)
                                {
                                    allbillsec = item.codes_billsec.Sum(t => t.billsec);
                                }

                                Paymant new_paymant = new Paymant()
                                {
                                    ClientId = item.ClientId, date = item.date, Type = false, sum = -1 * item.sum, coment = "Снятие денег со счета. Время разговоров: " + allbillsec + " сек; Количество арендуемых номеров: " + item.count + " Время: " + DateTime.Now.ToString()
                                };
                                _paymantsRep.Add(new_paymant);
                                _paymantsRep.Save();

                                Client curent_client = _clientRep.Find(item.ClientId);
                                if (curent_client != null)
                                {
                                    string message_ = "Уважаемый " + curent_client.Name + ", " + item.date.ToShortDateString() + " с вашего счета было снято " + item.sum + " грн за " + allbillsec + " секунд разговоров и за аренду телефонов в количестве " + item.count + ".";
                                    _sendemailjobinfoRep.Add(new SendEmailJobInfo()
                                    {
                                        attemptcount = 0, date = DateTime.Now.ToUniversalTime(), message = message_, status = false, subject = "CallTracking Info", To = curent_client.Email
                                    });
                                    _sendemailjobinfoRep.Save();
                                }
                                allbillsec = 0;
                            }
                        }
                    }
                    CurentDate = CurentDate.AddHours(1);
                }

                // AddOneHourToDatesFromFile();

                JobsInfo new_jobs_info = new JobsInfo()
                {
                    status = true, lastactiondate = DateTime.Now.ToUniversalTime(), jobId = Constants.RemoveMoneyJob
                };                                                                                                                                                   //поставить еще jobId! ( также в классе JobsInfo )
                _jobsinfoRep.Add(new_jobs_info);
                _jobsinfoRep.Save();

                Log.Info("RemoveMoneyJob успешно выполнен!");
                Console.WriteLine("RemoveMoneyJob is finished....." + DateTime.Now.ToString());
            }
            catch (Exception ex)
            {
                while (ex.InnerException != null)
                {
                    ex = ex.InnerException;
                }

                /* JobsInfo new_jobs_info = new JobsInfo() { status = false, lastactiondate = DateTime.Now.ToUniversalTime(), jobId = Constants.RemoveMoneyJob, ExceptionText = String.Format(@"Message: {0}, Source: {1}, TargetSite: {2}, Trace: {3} ", ex.Message, ex.Source, ex.TargetSite, ex.StackTrace) };//поставить еще jobId! ( также в классе JobsInfo )
                 * _jobsinfoRep.Add(new_jobs_info);
                 * _jobsinfoRep.Save();
                 *
                 * Log.Error(String.Format(@"Message: {0}, Source: {1}, TargetSite: {2}, Trace: {3} ", ex.Message, ex.Source, ex.TargetSite, ex.StackTrace));
                 * Console.WriteLine("RemoveMoneyJob is running with error....." + DateTime.Now.ToString());
                 * Console.WriteLine(String.Format(@"Message: {0}, Source: {1}, TargetSite: {2}, Trace: {3} ", ex.Message, ex.Source, ex.TargetSite, ex.StackTrace));*/
                throw ex;
            }
        }