public List<string> ValidateEntity(CallContext outputContext) { outputContext.ResultCode = ETEMEnums.ResultEnum.Success; ETEMDataModelEntities dbContext = new ETEMDataModelEntities(); ValidationErrorsAsString = string.Empty; List<string> result = new List<string>(); if (string.IsNullOrEmpty(this.IP)) { result.Add(string.Format(BaseHelper.GetCaptionString("Entity_Common_Field_Mandatory"), BaseHelper.GetCaptionString("Entity_AllowIP_IP"))); } var existIP = dbContext.AllowIPs.Where(u => u.IP == this.IP && u.idAllowIP != this.idAllowIP).FirstOrDefault(); if (existIP != null) { result.Add(BaseHelper.GetCaptionString("Entity_AllowIP_IP_Exist")); } ValidationErrorsAsString = string.Join(",", result.ToArray()); if (!string.IsNullOrEmpty(ValidationErrorsAsString)) { outputContext.ResultCode = ETEMEnums.ResultEnum.Error; } outputContext.Message = this.ValidationErrorsAsString; outputContext.EntityID = this.EntityID.ToString(); return result; }
public List<string> ValidateEntity(CallContext outputContext) { outputContext.ResultCode = ETEMEnums.ResultEnum.Success; ETEMDataModelEntities dbContext = new ETEMDataModelEntities(); ValidationErrorsAsString = string.Empty; List<string> result = new List<string>(); if (this.idRole == 0) { Role role = dbContext.Roles.FirstOrDefault(s => s.Name == this.Name); if (role != null) { result.Add("Вече съществува роля с това име"); } } ValidationErrorsAsString = string.Join(",", result.ToArray()); if (!string.IsNullOrEmpty(ValidationErrorsAsString)) { outputContext.ResultCode = ETEMEnums.ResultEnum.Error; } outputContext.Message = this.ValidationErrorsAsString; outputContext.EntityID = this.EntityID.ToString(); return result; }
public List<string> ValidateEntity(CallContext outputContext) { outputContext.ResultCode = ETEMEnums.ResultEnum.Success; ETEMDataModelEntities dbContext = new ETEMDataModelEntities(); this.ValidationErrorsAsString = string.Empty; List<string> result = new List<string>(); var existEntity = dbContext.Locations.Where( e => e.Name == this.Name && e.idVillageType == this.idVillageType && e.idMunicipality == this.idMunicipality && e.idLocation != this.idLocation ).FirstOrDefault(); if (existEntity != null) { result.Add(BaseHelper.GetCaptionString("Entity_Location_VillageType_Municipality_Exist")); } this.ValidationErrorsAsString = string.Join(",", result.ToArray()); if (!string.IsNullOrEmpty(ValidationErrorsAsString)) { outputContext.ResultCode = ETEMEnums.ResultEnum.Error; } outputContext.Message = this.ValidationErrorsAsString; outputContext.EntityID = this.EntityID.ToString(); return result; }
public List<string> ValidateEntity(CallContext outputContext) { List<string> result = new List<string>(); ValidationErrorsAsString = string.Empty; outputContext.ResultCode = ETEMEnums.ResultEnum.Success; if (this.idVendor == Constants.INVALID_ID || this.idVendor == Constants.INVALID_ID_ZERO) { result.Add("The field `Vendor` is required!"); } if (this.DateFrom == DateTime.MinValue) { result.Add("The field `Valid from` is required!"); } if (this.DateTo.HasValue && this.DateTo.Value < this.DateFrom) { result.Add("The field `Valid to` must be grater than or equal the field `Date from`!"); } ETEMDataModelEntities dbContext = new ETEMDataModelEntities(); var checkDiePriceList = dbContext.DiePriceLists.Where(w => w.idDiePriceList != this.idDiePriceList && w.idVendor == this.idVendor && ((this.DateTo.HasValue && w.DateTo.HasValue && (this.DateTo.Value >= w.DateFrom && this.DateTo.Value <= w.DateTo.Value || this.DateFrom >= w.DateFrom && this.DateFrom <= w.DateTo.Value)) || (!this.DateTo.HasValue && w.DateTo.HasValue && (this.DateFrom <= w.DateTo.Value && this.DateFrom >= w.DateFrom || this.DateFrom <= w.DateFrom)) || (this.DateTo.HasValue && !w.DateTo.HasValue && this.DateTo.Value >= w.DateFrom && this.DateFrom <= w.DateFrom) || (!this.DateTo.HasValue && !w.DateTo.HasValue && this.DateFrom == w.DateFrom)) ).ToList(); if (checkDiePriceList.Count > 0) { result.Add("Die price list with the same vendor and period already exists in the database!"); } this.ValidationErrorsAsString = string.Join(Constants.ERROR_MESSAGES_SEPARATOR, result.ToArray()); if (!string.IsNullOrEmpty(this.ValidationErrorsAsString)) { outputContext.ResultCode = ETEMEnums.ResultEnum.Error; } outputContext.Message = this.ValidationErrorsAsString; if (result.Count > 0) { outputContext.EntityID = ""; } else { outputContext.EntityID = this.EntityID.ToString(); } return result; }
public List<string> ValidateEntity(CallContext outputContext) { outputContext.ResultCode = ETEMEnums.ResultEnum.Success; ETEMDataModelEntities dbContext = new ETEMDataModelEntities(); ValidationErrorsAsString = string.Empty; List<string> result = new List<string>(); var existEntity = dbContext.KeyValues.Where( e => e.KeyValueIntCode == this.KeyValueIntCode && e.idKeyType == this.idKeyType && e.idKeyValue != this.idKeyValue ).FirstOrDefault(); if (existEntity != null) { result.Add(BaseHelper.GetCaptionString("Entity_KeyValue_KeyValueIntCode_Exist")); } ValidationErrorsAsString = string.Join(",", result.ToArray()); if (!string.IsNullOrEmpty(ValidationErrorsAsString)) { outputContext.ResultCode = ETEMEnums.ResultEnum.Error; } outputContext.Message = this.ValidationErrorsAsString; outputContext.EntityID = this.EntityID.ToString(); return result; }
public List<string> ValidateEntity(CallContext outputContext) { outputContext.ResultCode = ETEMEnums.ResultEnum.Success; ETEMDataModelEntities dbContext = new ETEMDataModelEntities(); ValidationErrorsAsString = string.Empty; List<string> result = new List<string>(); if (string.IsNullOrEmpty(this.URL)) { result.Add(String.Format(BaseHelper.GetCaptionString("Entity_Common_Field_Mandatory"), BaseHelper.GetCaptionString("Entity_NAV_URL"))); } ValidationErrorsAsString = string.Join(",", result.ToArray()); if (!string.IsNullOrEmpty(ValidationErrorsAsString)) { outputContext.ResultCode = ETEMEnums.ResultEnum.Error; } outputContext.Message = this.ValidationErrorsAsString; outputContext.EntityID = this.EntityID.ToString(); return result; }
public List<string> ValidateEntity(CallContext outputContext) { List<string> result = new List<string>(); ValidationErrorsAsString = string.Empty; outputContext.ResultCode = ETEMEnums.ResultEnum.Success; if (this.DateFrom == DateTime.MinValue) { result.Add("The field `Valid from` is required!"); } if (this.DateTo.HasValue && this.DateTo.Value < this.DateFrom) { result.Add("The field `Valid to` must be grater than or equal the field `Date from`!"); } ETEMDataModelEntities dbContext = new ETEMDataModelEntities(); var checkProductivityAndScrapList = dbContext.ProductivityAndScraps.Where(w => w.idProductivityAndScrap != this.idProductivityAndScrap && ((this.DateTo.HasValue && w.DateTo.HasValue && (this.DateTo.Value >= w.DateFrom && this.DateTo.Value <= w.DateTo.Value || this.DateFrom >= w.DateFrom && this.DateFrom <= w.DateTo.Value)) || (!this.DateTo.HasValue && w.DateTo.HasValue && (this.DateFrom <= w.DateTo.Value && this.DateFrom >= w.DateFrom || this.DateFrom <= w.DateFrom)) || (this.DateTo.HasValue && !w.DateTo.HasValue && this.DateTo.Value >= w.DateFrom && this.DateFrom <= w.DateFrom) || (!this.DateTo.HasValue && !w.DateTo.HasValue && this.DateFrom == w.DateFrom)) ).ToList(); if (checkProductivityAndScrapList.Count > 0) { result.Add("Productivity & Scrap list with overlapping date from/to interval persist in the data base!"); } this.ValidationErrorsAsString = string.Join(Constants.ERROR_MESSAGES_SEPARATOR, result.ToArray()); if (!string.IsNullOrEmpty(this.ValidationErrorsAsString)) { outputContext.ResultCode = ETEMEnums.ResultEnum.Error; } outputContext.Message = this.ValidationErrorsAsString; if (result.Count > 0) { outputContext.EntityID = ""; } else { outputContext.EntityID = this.EntityID.ToString(); } return result; }
public List<string> ValidateEntity(CallContext outputContext) { outputContext.ResultCode = ETEMEnums.ResultEnum.Success; ETEMDataModelEntities dbContext = new ETEMDataModelEntities(); ValidationErrorsAsString = string.Empty; List<string> result = new List<string>(); ValidationErrorsAsString = string.Join(",", result.ToArray()); outputContext.Message = this.ValidationErrorsAsString; outputContext.EntityID = this.EntityID.ToString(); return result; }
protected void Page_Load(object sender, EventArgs e) { System.Collections.IList visibleTables = Global.DefaultModel.VisibleTables; if (visibleTables.Count == 0) { throw new InvalidOperationException("There are no accessible tables. Make sure that at least one data model is registered in Global.asax and scaffolding is enabled or implement custom pages."); } Menu1.DataSource = visibleTables; Menu1.DataBind(); ETEMDataModelEntities model = new ETEMDataModelEntities(); }
public void StartCheck() { if (Thread.CurrentThread.Name == "ThreadCheckForWrongEmails") { int waitTimeInMinutes = 2; if (resultContext.ListKvParams.Where(w => w.Key == "WaitCheckMailDeliveryInMinutes").Count() == 1) { waitTimeInMinutes = Int32.Parse(resultContext.ListKvParams.Where(w => w.Key == "WaitCheckMailDeliveryInMinutes").First().Value.ToString()); } Thread.Sleep((waitTimeInMinutes * 60 * 1000)); } Pop3Client pop3Client = null; try { pop3Client = new Pop3Client(); string mailServerPop3 = string.Empty; int mailServerPop3Port = 0; string mailFromPassword = string.Empty; string mailDeliverySubsystemEmail = string.Empty; string mailFrom = string.Empty; string mailTo = string.Empty; if (resultContext.ListKvParams.Where(w => w.Key == "DefaultEmail").Count() == 1) { mailFrom = resultContext.ListKvParams.Where(w => w.Key == "DefaultEmail").First().Value.ToString(); mailTo = resultContext.ListKvParams.Where(w => w.Key == "DefaultEmail").First().Value.ToString(); } if (resultContext.ListKvParams.Where(w => w.Key == "MailServerPop3").Count() == 1) { mailServerPop3 = resultContext.ListKvParams.Where(w => w.Key == "MailServerPop3").First().Value.ToString(); } if (resultContext.ListKvParams.Where(w => w.Key == "MailServerPop3Port").Count() == 1) { mailServerPop3Port = Int32.Parse(resultContext.ListKvParams.Where(w => w.Key == "MailServerPop3Port").First().Value.ToString()); } if (resultContext.ListKvParams.Where(w => w.Key == "MailFromPassword").Count() == 1) { mailFromPassword = resultContext.ListKvParams.Where(w => w.Key == "MailFromPassword").First().Value.ToString(); } if (resultContext.ListKvParams.Where(w => w.Key == "MailDeliverySubsystemEmail").Count() == 1) { mailDeliverySubsystemEmail = resultContext.ListKvParams.Where(w => w.Key == "MailDeliverySubsystemEmail").First().Value.ToString(); } List<string> listWrongEmails = new List<string>(); DateTime dtCurrDateSent = DateTime.Now; pop3Client.Connect(mailServerPop3, mailServerPop3Port, true); pop3Client.Authenticate(mailFrom, mailFromPassword); Message message = null; int countMessages = pop3Client.GetMessageCount(); for (int i = 1; i <= countMessages; i++) { message = pop3Client.GetMessage(i); if (message != null && message.Headers != null && message.Headers.DateSent != null && message.Headers.From.Address == mailDeliverySubsystemEmail) { dtCurrDateSent = message.Headers.DateSent; if (message.Headers.DateSent.Kind == DateTimeKind.Utc) { dtCurrDateSent = message.Headers.DateSent.ToLocalTime(); } if (this.dtStartDateSend <= dtCurrDateSent && dtCurrDateSent <= DateTime.Now) { if (message.MessagePart != null && message.MessagePart.GetBodyAsText().Split('\r', '\n').Where(w => w.Contains("@")).Count() > 0) { string wrongEmail = message.MessagePart.GetBodyAsText().Split('\r', '\n').Where(w => w.Contains("@")).First().Trim(); listWrongEmails.Add(wrongEmail); } } } } List<Person> listPersonsWithWrongEmails = new List<Person>(); ETEMDataModelEntities dbContext = new ETEMDataModelEntities(); listPersonsWithWrongEmails = (from p in dbContext.Persons where listWrongEmails.Contains(p.EMail) orderby p.FirstName ascending, p.SecondName ascending, p.LastName ascending select p).ToList<Person>(); if (listPersonsWithWrongEmails.Count > 0) { string subject = (from kv in dbContext.KeyValues join kt in dbContext.KeyTypes on kv.idKeyValue equals kt.idKeyType where kt.KeyTypeIntCode == ETEMEnums.KeyTypeEnum.EmailSubject.ToString() && kv.KeyValueIntCode == ETEMEnums.EmailSubjectEnum.WrongSentEmails.ToString() select kv.Description).FirstOrDefault(); string body = (from kv in dbContext.KeyValues join kt in dbContext.KeyTypes on kv.idKeyValue equals kt.idKeyType where kt.KeyTypeIntCode == ETEMEnums.KeyTypeEnum.EmailSubject.ToString() && kv.KeyValueIntCode == ETEMEnums.EmailBodyEnum.WrongSentEmails.ToString() select kv.Description).FirstOrDefault(); if (!string.IsNullOrEmpty(subject) && !string.IsNullOrEmpty(body)) { string bodyInnerText = string.Empty; foreach (Models.Person person in listPersonsWithWrongEmails) { if (string.IsNullOrEmpty(bodyInnerText)) { bodyInnerText += BaseHelper.GetCaptionString("Email_WrongSentEmail_Email") + " " + person.EMail + "\n"; bodyInnerText += BaseHelper.GetCaptionString("Email_WrongSentEmail_PersonName") + " " + person.FullName; } else { bodyInnerText += "\n" + BaseHelper.GetNumberOfCharAsString('-', 100) + "\n"; bodyInnerText += BaseHelper.GetCaptionString("Email_WrongSentEmail_Email") + " " + person.EMail + "\n"; bodyInnerText += BaseHelper.GetCaptionString("Email_WrongSentEmail_PersonName") + " " + person.FullName; } } body = string.Format(body, bodyInnerText); SendMailAction(mailFrom, mailTo, subject, body); } } } catch (Exception ex) { BaseHelper.Log("Грешка при проверка за неуспешно изпратени имейли - (ThreadCheckForWrongEmails.StartCheck)!"); BaseHelper.Log(ex.Message); BaseHelper.Log(ex.StackTrace); } finally { if (pop3Client != null) { if (pop3Client.Connected) { pop3Client.Disconnect(); } pop3Client.Dispose(); } } }
public List<string> ValidateEntity(CallContext outputContext) { outputContext.ResultCode = ETEMEnums.ResultEnum.Success; ETEMDataModelEntities dbContext = new ETEMDataModelEntities(); ValidationErrorsAsString = string.Empty; List<string> result = new List<string>(); var existEntity = dbContext.Settings.Where(e => e.SettingIntCode == this.SettingIntCode && e.idSetting != this.idSetting).FirstOrDefault(); if (existEntity != null) { result.Add(BaseHelper.GetCaptionString("Entity_Setting_SettingIntCode_Exist")); outputContext.ResultCode = ETEMEnums.ResultEnum.Error; } if (this.SettingClass == ETEMEnums.AppSettingsClass.Date.ToString()) { DateTime tmp; if (!DateTime.TryParse(this.SettingValue, out tmp)) { result.Add(BaseHelper.GetCaptionString("Entity_Setting_SettingValue_Date")); outputContext.ResultCode = ETEMEnums.ResultEnum.Error; } } else if (this.SettingClass == ETEMEnums.AppSettingsClass.Double.ToString()) { Double tmp; if (!Double.TryParse(this.SettingValue, out tmp)) { result.Add(BaseHelper.GetCaptionString("Entity_Setting_SettingValue_Double")); outputContext.ResultCode = ETEMEnums.ResultEnum.Error; } } else if (this.SettingClass == ETEMEnums.AppSettingsClass.EMail.ToString()) { //TODO:Да се прави проверка за e-mail } else if (this.SettingClass == ETEMEnums.AppSettingsClass.Integer.ToString()) { Int32 tmp; if (!Int32.TryParse(this.SettingValue, out tmp)) { result.Add(BaseHelper.GetCaptionString("Entity_Setting_SettingValue_Int32")); outputContext.ResultCode = ETEMEnums.ResultEnum.Error; } } else if (this.SettingClass == ETEMEnums.AppSettingsClass.List.ToString()) { //TODO:Да се прави проверка за list } else if (this.SettingClass == ETEMEnums.AppSettingsClass.String.ToString()) { //TODO:Да се прави проверка за стринг } ValidationErrorsAsString = string.Join(",", result.ToArray()); outputContext.Message = this.ValidationErrorsAsString; outputContext.EntityID = this.EntityID.ToString(); return result; }
public List<string> ValidateEntity(CallContext outputContext) { List<string> result = new List<string>(); ValidationErrorsAsString = string.Empty; outputContext.ResultCode = ETEMEnums.ResultEnum.Success; if (this.idDiePriceList == Constants.INVALID_ID || this.idDiePriceList == Constants.INVALID_ID_ZERO) { result.Add("The field `Vendor die price list` is required!"); } if (this.idNumberOfCavities == Constants.INVALID_ID || this.idNumberOfCavities == Constants.INVALID_ID_ZERO) { result.Add("The field `Number of cavities` is required!"); } if (this.idNumberOfCavities == Constants.INVALID_ID || this.idNumberOfCavities == Constants.INVALID_ID_ZERO) { result.Add("The field `Profile category` is required!"); } if (this.idNumberOfCavities == Constants.INVALID_ID || this.idNumberOfCavities == Constants.INVALID_ID_ZERO) { result.Add("The field `Profile complexity` is required!"); } if (this.DimensionA == int.MinValue) { result.Add("The field `Dimension A (mm)` is required!"); } if (this.DimensionB == int.MinValue) { result.Add("The field `Dimension B (mm)` is required!"); } if (this.Price == decimal.MinValue) { result.Add("The field `Die price (EUR)` is required!"); } if (this.Lifespan == decimal.MinValue) { result.Add("The field `Lifespan (ton)` is required!"); } ETEMDataModelEntities dbContext = new ETEMDataModelEntities(); var checkDiePriceListDetail = dbContext.DiePriceListDetails.Where(w => w.idDiePriceListDetail != this.idDiePriceListDetail && w.idDiePriceList == this.idDiePriceList && w.idNumberOfCavities == this.idNumberOfCavities && w.idProfileComplexity == this.idProfileComplexity && w.idProfileCategory == this.idProfileCategory && w.Price == this.Price && w.DimensionA == this.DimensionA && w.DimensionB == this.DimensionB).ToList(); if (checkDiePriceListDetail.Count > 0) { result.Add("Die price for the same vendor and dimensions already exists in the database!"); } this.ValidationErrorsAsString = string.Join(Constants.ERROR_MESSAGES_SEPARATOR, result.ToArray()); if (!string.IsNullOrEmpty(this.ValidationErrorsAsString)) { outputContext.ResultCode = ETEMEnums.ResultEnum.Error; } outputContext.Message = this.ValidationErrorsAsString; if (result.Count > 0) { outputContext.EntityID = ""; } else { outputContext.EntityID = this.EntityID.ToString(); } return result; }
public ExpenseCalculationBL() { dbContext = new ETEMDataModelEntities(); }
public ProductCostBL() { dbContext = new ETEMDataModelEntities(); }
public OfferOverviewBL() { dbContext = new ETEMDataModelEntities(); }
public List<string> GetCompletionList(string prefixText, int count, string contextKey) { List<string> selectionList = new List<string>(); string customCase = string.Empty; string tableForSelection = string.Empty; string columnIdForSelection = string.Empty; string columnNameForSelection = string.Empty; string columnNameForOrderBy = string.Empty; string additionalWhereParam = string.Empty; string[] arrContextParams = contextKey.Split(new char[1] { '|' }, StringSplitOptions.RemoveEmptyEntries); if (contextKey.Contains("case")) { customCase = arrContextParams[0].Replace("case=", ""); arrContextParams = contextKey.Split(new char[1] { '|' }, StringSplitOptions.RemoveEmptyEntries).Skip(1).ToArray(); if (arrContextParams.Where(w => w.Contains("=")).Count() == 1) { additionalWhereParam = arrContextParams.Where(w => w.Contains("=")).First(); } } if (arrContextParams.Length == 2) { tableForSelection = arrContextParams[0]; columnNameForSelection = arrContextParams[1]; } else if (arrContextParams.Length == 3) { tableForSelection = arrContextParams[0]; columnNameForSelection = arrContextParams[1]; if (arrContextParams[2].Split('=', '!', '<', '>').Length > 1) { additionalWhereParam = arrContextParams[2]; } else { columnIdForSelection = arrContextParams[2]; } } else if (arrContextParams.Length == 4) { tableForSelection = arrContextParams[0]; columnNameForSelection = arrContextParams[1]; columnIdForSelection = arrContextParams[2]; if (arrContextParams[3].Split('=', '!', '<', '>').Length > 1) { additionalWhereParam = arrContextParams[3]; } else { columnNameForOrderBy = arrContextParams[3]; } } else if (arrContextParams.Length == 5) { tableForSelection = arrContextParams[0]; columnNameForSelection = arrContextParams[1]; columnIdForSelection = arrContextParams[2]; columnNameForOrderBy = arrContextParams[3]; additionalWhereParam = arrContextParams[4]; } if (!contextKey.Contains("case") && arrContextParams.Length == 0) { return selectionList; } if (string.IsNullOrEmpty(columnNameForOrderBy)) { columnNameForOrderBy = columnNameForSelection; } using (this.dbContext = new ETEMDataModelEntities()) { switch (customCase) { case "PersonALLByName": { List<PersonDataView> list = (from p in this.dbContext.Persons select new PersonDataView { idPerson = p.idPerson, FirstName = p.FirstName, SecondName = p.SecondName, LastName = p.LastName }).Distinct().ToList<PersonDataView>(); list = list.GroupBy(g => new { g.FirstNameTrimed, g.SecondNameTrimed, g.LastNameTrimed }). Select(s => new PersonDataView { idPerson = s.First().idPerson, FirstName = s.Key.FirstNameTrimed, SecondName = s.Key.SecondNameTrimed, LastName = s.Key.LastNameTrimed }).ToList(); string[] arrSearchTerms = prefixText.Split(Constants.CHAR_SEPARATORS, StringSplitOptions.RemoveEmptyEntries); string searchItem = string.Join(" ", arrSearchTerms).Trim().ToLower(); //HashSet<PersonDataView> listPersons = new HashSet<PersonDataView>(); //for (int i = 0; i < arrSearchTerms.Length; i++) //{ // var term = arrSearchTerms[i].Trim().ToLower(); // var listItems = (from p in list // where (p.FirstName != null && p.FirstName.Trim().ToLower().Contains(term)) || // (p.SecondName != null && p.SecondName.Trim().ToLower().Contains(term)) || // (p.LastName != null && p.LastName.Trim().ToLower().Contains(term)) || // (p.FullNameTwo != null && p.FullNameTwo.Trim().ToLower().Contains(term)) || // (p.FullNameLastTwo != null && p.FullNameLastTwo.Trim().ToLower().Contains(term)) || // (p.FullName != null && p.FullName.Trim().ToLower().Contains(term)) // select p).ToList(); // listPersons.UnionWith(listItems); //} var listSearchedData = (from p in list where (p.FirstName != null && p.FirstName.Trim().ToLower().Contains(searchItem)) || (p.SecondName != null && p.SecondName.Trim().ToLower().Contains(searchItem)) || (p.LastName != null && p.LastName.Trim().ToLower().Contains(searchItem)) || (p.FullNameTwo != null && p.FullNameTwo.Trim().ToLower().Contains(searchItem)) || (p.FullNameLastTwo != null && p.FullNameLastTwo.Trim().ToLower().Contains(searchItem)) || (p.FullName != null && p.FullName.Trim().ToLower().Contains(searchItem)) select new { idPerson = p.idPerson, FullText = p.FullName }).OrderBy(o => o.FullText); foreach (var completionResult in listSearchedData) { selectionList.Add(AutoCompleteExtender.CreateAutoCompleteItem(completionResult.FullText, completionResult.idPerson.ToString())); } } break; case "PersonALLByEGN": { var list = (from p in this.dbContext.Persons select new PersonDataView { idPerson = p.idPerson, FirstName = p.FirstName, SecondName = p.SecondName, LastName = p.LastName, EGN = p.EGN, IdentityNumber = p.IdentityNumber }).Distinct().ToList<PersonDataView>(); var listSearchedData = (from p in list where (p.EGN != null && p.EGN.Contains(prefixText)) || (p.IdentityNumber != null && p.IdentityNumber.Contains(prefixText)) select new { idPerson = p.idPerson, FullText = p.FullName }).OrderBy(o => o.FullText); foreach (var completionResult in listSearchedData) { selectionList.Add(AutoCompleteExtender.CreateAutoCompleteItem(completionResult.FullText, completionResult.idPerson.ToString())); } } break; case "NSICode": { List<KeyValue> allNSICode = dbContext.KeyValues.Where(k => k.KeyType.KeyTypeIntCode == "NSICode").ToList(); var listSearchedData = (from k in allNSICode where k.Name.ToLower().Contains(prefixText.ToLower()) || k.KeyValueIntCode.ToLower().Contains(prefixText.ToLower()) select new { idKeyValue = k.idKeyValue, FullText = k.KeyValueIntCode.Trim() + " | " + k.Name.Trim() }).OrderBy(o => o.FullText); foreach (var completionResult in listSearchedData) { selectionList.Add(AutoCompleteExtender.CreateAutoCompleteItem(completionResult.FullText, completionResult.idKeyValue.ToString())); } } break; case "EmployeePerson": { List<PersonDataView> personList = new List<PersonDataView>(); personList = (from p in this.dbContext.Persons join u in this.dbContext.Users on p.idPerson equals u.idPerson select new PersonDataView { idPerson = p.idPerson, FirstName = p.FirstName, SecondName = p.SecondName, LastName = p.LastName, Title = p.Title } ).Distinct().ToList(); string[] arrSearchTerms = prefixText.Split(Constants.CHAR_SEPARATORS, StringSplitOptions.RemoveEmptyEntries); string searchItem = string.Join(" ", arrSearchTerms).Trim().ToLower(); //HashSet<ArtModelDataView> listArtModels = new HashSet<ArtModelDataView>(); //for (int i = 0; i < arrSearchTerms.Length; i++) //{ // var term = arrSearchTerms[i].Trim().ToLower(); // var listItems = (from p in allArtModel // where (p.FirstName != null && p.FirstName.Trim().ToLower().Contains(term)) || // (p.SecondName != null && p.SecondName.Trim().ToLower().Contains(term)) || // (p.LastName != null && p.LastName.Trim().ToLower().Contains(term)) || // (p.FullName != null && p.FullName.Trim().ToLower().Contains(term)) // select p).ToList(); // listArtModels.UnionWith(listItems); //} var listSearchedData = (from p in personList where (p.FirstName != null && p.FirstName.Trim().ToLower().Contains(searchItem)) || (p.SecondName != null && p.SecondName.Trim().ToLower().Contains(searchItem)) || (p.LastName != null && p.LastName.Trim().ToLower().Contains(searchItem)) || (p.FullNameTwo != null && p.FullNameTwo.Trim().ToLower().Contains(searchItem)) || (p.FullNameLastTwo != null && p.FullNameLastTwo.Trim().ToLower().Contains(searchItem)) || (p.FullName != null && p.FullName.Trim().ToLower().Contains(searchItem)) select p).OrderBy(o => o.FullName).ToList(); foreach (var completionResult in listSearchedData) { selectionList.Add(AutoCompleteExtender.CreateAutoCompleteItem(completionResult.TitlePlusFullName, completionResult.idPerson.ToString())); } } break; case "PersonEmployee": { List<PersonDataView> personList = new List<PersonDataView>(); personList = (from p in this.dbContext.Persons join e in this.dbContext.Employees on p.idPerson equals e.idPerson select new PersonDataView { idPerson = p.idPerson, FirstName = p.FirstName, SecondName = p.SecondName, LastName = p.LastName, Title = p.Title } ).Distinct().ToList(); string[] arrSearchTerms = prefixText.Split(Constants.CHAR_SEPARATORS, StringSplitOptions.RemoveEmptyEntries); string searchItem = string.Join(" ", arrSearchTerms).Trim().ToLower(); //HashSet<ArtModelDataView> listArtModels = new HashSet<ArtModelDataView>(); //for (int i = 0; i < arrSearchTerms.Length; i++) //{ // var term = arrSearchTerms[i].Trim().ToLower(); // var listItems = (from p in allArtModel // where (p.FirstName != null && p.FirstName.Trim().ToLower().Contains(term)) || // (p.SecondName != null && p.SecondName.Trim().ToLower().Contains(term)) || // (p.LastName != null && p.LastName.Trim().ToLower().Contains(term)) || // (p.FullName != null && p.FullName.Trim().ToLower().Contains(term)) // select p).ToList(); // listArtModels.UnionWith(listItems); //} var listSearchedData = (from p in personList where (p.FirstName != null && p.FirstName.Trim().ToLower().Contains(searchItem)) || (p.SecondName != null && p.SecondName.Trim().ToLower().Contains(searchItem)) || (p.LastName != null && p.LastName.Trim().ToLower().Contains(searchItem)) || (p.FullNameTwo != null && p.FullNameTwo.Trim().ToLower().Contains(searchItem)) || (p.FullNameLastTwo != null && p.FullNameLastTwo.Trim().ToLower().Contains(searchItem)) || (p.FullName != null && p.FullName.Trim().ToLower().Contains(searchItem)) select p).OrderBy(o => o.FullName).ToList(); foreach (var completionResult in listSearchedData) { selectionList.Add(AutoCompleteExtender.CreateAutoCompleteItem(completionResult.TitlePlusFullName, completionResult.idPerson.ToString())); } } break; default: { string selectStmt = string.Empty; selectStmt = "SELECT TOP " + count + (string.IsNullOrEmpty(columnIdForSelection) ? " [" : " [" + columnIdForSelection + "] AS Id, [") + columnNameForSelection + "] AS Name " + "FROM [" + tableForSelection + "] " + "WHERE LOWER([" + columnNameForOrderBy + "]) LIKE '" + BaseHelper.MySqlEscapeString(prefixText.ToLower().Trim()) + "%' " + (string.IsNullOrEmpty(additionalWhereParam) ? "" : "AND " + additionalWhereParam + " ") + "ORDER BY [" + columnNameForOrderBy + "] ASC"; if (string.IsNullOrEmpty(columnIdForSelection)) { var result = this.dbContext.ExecuteStoreQuery<string>(selectStmt); selectionList.AddRange(result.ToList()); } else { var result = this.dbContext.ExecuteStoreQuery<CompletionResult>(selectStmt); foreach (CompletionResult completionResult in result) { selectionList.Add(AutoCompleteExtender.CreateAutoCompleteItem(completionResult.Name, completionResult.Id.ToString())); } } } break; } } return selectionList; }
public CommonBL() { dbContext = new ETEMDataModelEntities(); }
public List<string> ValidateEntity(CallContext outputContext) { outputContext.ResultCode = ETEMEnums.ResultEnum.Success; ETEMDataModelEntities dbContext = new ETEMDataModelEntities(); ValidationErrorsAsString = string.Empty; List<string> result = new List<string>(); if (string.IsNullOrEmpty(this.FirstName)) { result.Add(String.Format(BaseHelper.GetCaptionString("Entity_Common_Field_Mandatory"), BaseHelper.GetCaptionString("Entity_Person_FirstName"))); } if (string.IsNullOrEmpty(this.LastName)) { result.Add(String.Format(BaseHelper.GetCaptionString("Entity_Common_Field_Mandatory"), BaseHelper.GetCaptionString("Entity_Person_LastName"))); } //if (this.idCitizenship==Constants.INVALID_ID) //{ // result.Add(String.Format(BaseHelper.GetCaptionString("Entity_Common_Field_Mandatory"), BaseHelper.GetCaptionString("Entity_Person_Citizenship"))); //} /* if (this.BirthDate == null) { result.Add(String.Format(BaseHelper.GetCaptionString("Entity_Common_Field_Mandatory"), BaseHelper.GetCaptionString("Entity_BirthYear"))); } if (!this.idSex.HasValue || this.idSex.Value == Constants.INVALID_ID || this.idSex.Value == Constants.INVALID_ID_ZERO) { result.Add(String.Format(BaseHelper.GetCaptionString("Entity_Common_Field_Mandatory"), BaseHelper.GetCaptionString("Entity_Person_Sex"))); } if (string.IsNullOrEmpty(this.EGN) && string.IsNullOrEmpty(this.IdentityNumber) && string.IsNullOrEmpty(this.IDN)) { result.Add(BaseHelper.GetCaptionString("Entity_Person_Identifiers")); } */ if (!string.IsNullOrEmpty(this.EGN)) { var existUser = dbContext.Persons.Where(u => u.EGN == this.EGN && u.FirstName != this.FirstName && u.LastName != this.LastName && u.idPerson != this.idPerson).FirstOrDefault(); if (existUser != null) { result.Add(BaseHelper.GetCaptionString("Entity_Person_IdentityNumber_Exist")); } } else if (!string.IsNullOrEmpty(this.IdentityNumber)) { var existUser = dbContext.Persons.Where(u => u.IdentityNumber == this.IdentityNumber && u.FirstName != this.FirstName && u.LastName != this.LastName && u.idPerson != this.idPerson).FirstOrDefault(); if (existUser != null) { result.Add(BaseHelper.GetCaptionString("Entity_Person_IdentityNumber_Exist")); } } ValidationErrorsAsString = string.Join(",", result.ToArray()); if (!string.IsNullOrEmpty(ValidationErrorsAsString)) { outputContext.ResultCode = ETEMEnums.ResultEnum.Error; } outputContext.Message = this.ValidationErrorsAsString; outputContext.EntityID = this.EntityID.ToString(); return result; }
public BaseSettingHelper() { dbContext = new ETEMDataModelEntities(); }