public Response <Customer> FindAll(Guid queryID, int index, int count, IEnumerable <Sort> sorts) { Model.Customers.Query cQuery = _queryRepository.FindBy(queryID); // Sorting string orderByClause = string.Empty; if (sorts != null) { orderByClause = " Order By "; bool firstFlag = true; foreach (var sort in sorts) { orderByClause += String.Format("{0} {1} {2} ", firstFlag ? "" : ",", sort.SortColumn, sort.Asc ? "" : "Desc"); firstFlag = false; } } cQuery.QueryText = cQuery.QueryText.Replace("OrderByClause", orderByClause); cQuery.QueryText = cQuery.QueryText.Replace("WhereClause", string.Empty); IQuery query = SessionFactory.GetCurrentSession().CreateQuery(cQuery.QueryText); if (cQuery.PrmDefinition != null && cQuery.PrmValues != null) { string[] PrmDefinition = cQuery.PrmDefinition.Split(new char[] { ';' }); string[] PrmValues = cQuery.PrmValues.Split(new char[] { ';' }); int i = 0; foreach (string prmDef in PrmDefinition) { query.SetParameter(prmDef, PrmValues[i]); i++; } } ICriteria criteriaQuery = SessionFactory.GetCurrentSession().CreateCriteria(typeof(Customer)); //criteriaQuery.SetFetchMode("Center", FetchMode.Lazy). // SetFetchMode("Agency", FetchMode.Lazy). // SetFetchMode("Network", FetchMode.Lazy). // SetFetchMode("SuctionMode", FetchMode.Lazy). // SetFetchMode("SuctionModeDetail", FetchMode.Lazy). // SetFetchMode("DocumentStatus", FetchMode.Lazy). // SetFetchMode("Employee", FetchMode.Lazy). // SetFetchMode("BuyPossibility", FetchMode.Lazy). // SetFetchMode("FollowStatus", FetchMode.Lazy); //int resultCount = criteriaQuery.SetProjection(Projections.Count("ID")).UniqueResult<int>(); var count1 = SessionFactory.GetCurrentSession().QueryOver <Customer>().RowCount(); //IList<Customer> list=new List<Customer>(); //list = query.List<Customer>(); //int total = list.Count(); //IEnumerable<Customer> customerList = list.Skip(index).Take(count); IList <Customer> customerList = query.SetFirstResult(index).SetMaxResults(count).List <Customer>(); //int resultCount = customerList.Count(); int finalCount = 0; if (cQuery.Counting) { finalCount = cQuery.CustomerCount; } if (!cQuery.Counting && cQuery.AllCustomer) { finalCount = SessionFactory.GetCurrentSession().QueryOver <Customer>().RowCount(); } if (!cQuery.Counting && !cQuery.AllCustomer) { finalCount = query.List <Customer>().Count(); } return(new Response <Customer>(customerList, finalCount)); }
public GeneralResponse PrepareToAddCustomerLevel(AddCustomerLevelRequest request) { GeneralResponse response = new GeneralResponse(); try { CustomerLevel customerLevel = new CustomerLevel(); customerLevel.ID = Guid.NewGuid(); customerLevel.CreateDate = PersianDateTime.Now; customerLevel.CreateEmployee = _employeeRepository.FindBy(request.CreateEmployeeID); customerLevel.Customer = this._customerRepository.FindBy(request.CustomerID); customerLevel.Level = this._levelRepository.FindBy(request.NewLevelID); customerLevel.Note = request.Note; customerLevel.RowVersion = 1; #region Validation if (customerLevel.GetBrokenRules().Count() > 0) { foreach (BusinessRule businessRule in customerLevel.GetBrokenRules()) { response.ErrorMessages.Add(businessRule.Rule); } return(response); } #endregion #region Check Conditions if (customerLevel.Customer.Center == null) { response.ErrorMessages.Add("هیچ گونه مرکز مخابراتی برای مشتری مورد نظر تعریف نشده است. لطفاً با مراجعه به تنظیمات، مرکز مخابراتی مربوط به پیش شماره مشتری را تعریف کنید."); return(response); } CheckConditionResponse cres = CheckLevelCondition(customerLevel.Level, customerLevel.Customer); if (!cres.CanEnter) { foreach (string error in cres.ErrorMessages) { response.ErrorMessages.Add(error); } return(response); } #endregion #region Change Customer Query Count #endregion #region CreateSupport if (customerLevel.Level.CreateSupportOnEnter) { Support support = new Support(); support.ID = Guid.NewGuid(); support.CreateDate = PersianDateTime.Now; support.CreateEmployee = customerLevel.CreateEmployee; support.SupportTitle = "پشتیبانی "; support.SupportComment = "پشتیبانی ایجاد شده خودکار توسط سیستم"; support.Customer = customerLevel.Customer; support.CreateBy = Support.Creator.BySystem; support.SupportStatus = _supportStatusRepository.FindAll().Where(x => x.Key == "NoStatus").FirstOrDefault(); _supportRepository.Add(support); } #endregion _customerLevelRepository.Add(customerLevel); #region Query Customer Count //اگر مشتری جدید بود فقط به مرحله جدید یک واحد اضافه کن if (request.NewCustomer == true) { Infrastructure.Querying.Query newQuery = new Infrastructure.Querying.Query(); Criterion crt1 = new Criterion("Level.ID", request.NewLevelID, CriteriaOperator.Equal); newQuery.Add(crt1); Model.Customers.Query OldQuery = _queryRepository.FindBy(newQuery).FirstOrDefault(); if (OldQuery != null) { OldQuery.CustomerCount += 1; _queryRepository.Save(OldQuery); } } // اگر مشتری قبلی بود از مرحله قبل یکی کم و به مرحله جدید یکی اضافه کنذ else { Infrastructure.Querying.Query oldQuery = new Infrastructure.Querying.Query(); Criterion crt1 = new Criterion("Level.ID", customerLevel.Customer.Level.ID, CriteriaOperator.Equal); oldQuery.Add(crt1); Model.Customers.Query OldQuery = _queryRepository.FindBy(oldQuery).FirstOrDefault(); OldQuery.CustomerCount -= 1; _queryRepository.Save(OldQuery); Infrastructure.Querying.Query newQuery = new Infrastructure.Querying.Query(); Criterion crt2 = new Criterion("Level.ID", request.NewLevelID, CriteriaOperator.Equal); newQuery.Add(crt2); Model.Customers.Query NewQuery = _queryRepository.FindBy(newQuery).FirstOrDefault(); NewQuery.CustomerCount += 1; _queryRepository.Save(NewQuery); } #endregion #region Change Customer Level In Customer Table Customer customer = _customerRepository.FindBy(request.CustomerID); customer.Level = _levelRepository.FindBy(request.NewLevelID); customer.LevelEntryDate = PersianDateTime.Now; _customerRepository.Save(customer); #endregion _uow.Commit(); #region Sending Email string displayName = "ماهان نت"; string subject; //List<string> recipients = new List<string>(); GeneralResponse sendResponse = new GeneralResponse(); // if OnEnterSendEmail is true if (customerLevel.Level.OnEnterSendEmail) { email.ID = Guid.NewGuid(); email.CreateDate = PersianDateTime.Now; email.CreateEmployee = customerLevel.CreateEmployee; email.Customer = customerLevel.Customer; subject = customer.Name; email.Subject = subject; email.RowVersion = 1; #region Validation if (email.GetBrokenRules().Count() > 0) { foreach (BusinessRule businessRule in email.GetBrokenRules()) { response.ErrorMessages.Add(businessRule.Rule); } return(response); } #endregion #region Send Email // Replacing: string emailBody = ReplaceTemplate(customerLevel.Level.EmailText, customerLevel.Customer.ConvertToCustomerView()); email.Body = emailBody; string recipient = email.Customer.Email; if (recipient == null || recipient == string.Empty) { response.ErrorMessages.Add("برای مشتری مورد نظر هیچ ایمیلی در سیستم تعریف نشده است."); return(response); } //=============== Threading: EmailData emailData = new EmailData() { displayName = displayName, body = emailBody, subject = subject, recipient = recipient }; Thread oThread = new Thread(SendEmailVoid); oThread.Start(emailData); #endregion _emailRepository.Add(email); } #endregion #region Sending Sms if (customerLevel.Level.OnEnterSendSMS) { Sms sms = new Sms(); sms.ID = Guid.NewGuid(); sms.CreateDate = PersianDateTime.Now; sms.CreateEmployee = customerLevel.CreateEmployee; //sms.Body = customerLevel.Level.SMSText; sms.Customer = customerLevel.Customer; sms.RowVersion = 1; #region Validation if (sms.GetBrokenRules().Count() > 0) { foreach (BusinessRule businessRule in sms.GetBrokenRules()) { response.ErrorMessages.Add(businessRule.Rule); } return(response); } #endregion string smsBody = ReplaceTemplate(customerLevel.Level.SMSText, customerLevel.Customer.ConvertToCustomerView()); // Threading SmsData smsData = new SmsData() { body = smsBody, phoneNumber = customerLevel.Customer.Mobile1 }; Thread oThread = new Thread(SendSmsVoid); oThread.Start(smsData); _smsRepository.Add(sms); } #endregion } catch (Exception ex) { response.ErrorMessages.Add(ex.Message); } return(response); }