public bool UpdateLanguageDetails(LanguageDetails details) { List <SqlParameter> sp = new List <SqlParameter>() { new SqlParameter() { ParameterName = "@name", Value = details.Name, SqlDbType = SqlDbType.VarChar }, new SqlParameter() { ParameterName = "@language_id", Value = details.Language_Id, SqlDbType = SqlDbType.BigInt }, new SqlParameter() { ParameterName = "@imagePath", Value = details.ImagePath, SqlDbType = SqlDbType.VarChar }, new SqlParameter() { ParameterName = "@abbrv", Value = details.Abbreviation, SqlDbType = SqlDbType.VarChar }, }; object[] parameters = sp.ToArray(); var users = _languageRepository.ExecuteStoredProcedureList <AuthUser>(PROC_UPDATE_LANGUAGE_DETAILS, parameters); if (users != null) { return(true); } else { return(false); } }
private void SetProjectLanguages(ProjectDetails selectedProject) { // if an project has only one language select that language if (selectedProject?.ProjectLanguages != null && selectedProject.ProjectLanguages.Count.Equals(1)) { var languageName = selectedProject.ProjectLanguages.FirstOrDefault().Key; var languageToBeSelected = _languages.FirstOrDefault(n => n.LanguageName.Equals(languageName)); if (languageToBeSelected != null) { languageToBeSelected.IsChecked = true; } else { var newLanguage = new LanguageDetails { LanguageName = languageName, IsChecked = true }; _languages.Add(newLanguage); } selectedProject.ProjectLanguages[languageName] = true; } var languagesAlreadySelectedForExport = _languages.Where(l => l.IsChecked).ToList(); foreach (var language in languagesAlreadySelectedForExport) { if (selectedProject?.ProjectLanguages != null && selectedProject.ProjectLanguages.ContainsKey(language.LanguageName)) { selectedProject.ProjectLanguages[language.LanguageName] = true; } } AddNewLanguages(selectedProject); }
// Set the languages for the selected project within the languages UI list private void AddNewLanguages(ProjectDetails selectedProject) { try { var selectedProjectToExport = _projectsDataSource?.FirstOrDefault(e => e.ShouldBeExported && e.ProjectName.Equals(selectedProject.ProjectName)); if (selectedProjectToExport?.ProjectLanguages != null) { foreach (var language in selectedProjectToExport.ProjectLanguages.ToList()) { var languageDetails = _languages?.FirstOrDefault(n => n.LanguageName.Equals(language.Key)); if (languageDetails == null) { var newLanguage = new LanguageDetails { LanguageName = language.Key, IsChecked = true }; _languages?.Add(newLanguage); } } } languagesListBox.DataSource = _languages; languagesListBox.DisplayMember = "LanguageName"; languagesListBox.ValueMember = "IsChecked"; } catch (Exception ex) { Log.Logger.Error($"AddNewLanguages method: {ex.Message}\n {ex.StackTrace}"); } }
public LanguageList GetLanguageList() { // = new LanguageDetails(); LanguageList objlst = new LanguageList(); DataSet ds = objServices.GetLanguageList(); if (ds != null && ds.Tables.Count > 0) { int tblIndx = -1; tblIndx++; if (ds.Tables.Count > tblIndx && ds.Tables[tblIndx] != null && ds.Tables[tblIndx].Rows.Count > 0) { List <LanguageDetails> LanguageList = new List <LanguageDetails>(); foreach (DataRow dr in ds.Tables[tblIndx].Rows) { LanguageDetails obj = new LanguageDetails(); obj.LanguageId = Convert.ToInt64(dr["LanguageId"]); obj.Language = Convert.ToString(dr["Language"]); obj.Status = Convert.ToInt16(dr["IsActive"]); LanguageList.Add(obj); } objlst.languagelist = LanguageList; } tblIndx++; if (ds.Tables.Count > tblIndx && ds.Tables[tblIndx] != null && ds.Tables[tblIndx].Rows.Count > 0) { objlst.TotalCount = Convert.ToInt64(ds.Tables[tblIndx].Rows[0]["TotalCount"]); } } return(objlst); }
public IHttpActionResult InsertLanguageDetails(RequestModel model) { ReturnMsg obj = new ReturnMsg(); try { if (string.IsNullOrEmpty(model.Id) || (string.IsNullOrEmpty(model.ScheduleId))) { return(ResponseMessage(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Both Name and Abbreviation are required."))); } LanguageDetails details = new LanguageDetails(); details.Abbreviation = model.ScheduleId; details.Name = model.Id; details.ImagePath = string.Empty; _langService.InsertLanguageDetails(details); obj.IsSuccess = true; obj.Message = "Language inserted successfully."; } catch (Exception e) { return(ResponseMessage(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, e.Message))); } return(Ok(obj)); }
/// <summary> /// Populate the languages. /// </summary> public void ShowLanguages() { int i = 0; while (i < 2) { LanguageModel language = new LanguageModel(); if (i == 0) { language.Id = 1; language.Name = "English"; language.Culture = "en-US"; } else { language.Id = 2; language.Name = "French"; language.Culture = "fr-FR"; } LanguageDetails.Add(language); i++; } Languages = LanguageDetails; }
private void AddLanguageFromDictionary(BindingList <LanguageDetails> languages, Dictionary <string, bool> languagesDictionary) { foreach (var item in languagesDictionary) { var language = new LanguageDetails { LanguageName = item.Key, IsChecked = item.Value }; languages.Add(language); } }
public bool AddLanguage(Int64 Id, LanguageDetails obj) { using (SqlCommand sqlCommand = new SqlCommand()) { sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.CommandText = Procedures.AddLanguage; sqlCommand.Parameters.AddWithValue("@UserId", Id); sqlCommand.Parameters.AddWithValue("@LanguageId", obj.LanguageId); sqlCommand.Parameters.AddWithValue("@Language", obj.Language); sqlCommand.Parameters.AddWithValue("@IsActive", obj.Status); return(Convert.ToBoolean(DAL.ExecuteNonQuery(ConfigurationHelper.connectionString, sqlCommand))); } }
public void Should_have_validation_error_when_url_is_empty() { var command = new LanguageDetails { SiteId = Guid.NewGuid(), Id = Guid.NewGuid(), Name = "Name", CultureName = "aa-bb", Url = string.Empty }; var languageRulesMock = new Mock <ILanguageRules>(); var siteRulesMock = new Mock <ISiteRules>(); var validator = new LanguageDetailsValidator <LanguageDetails>(languageRulesMock.Object, siteRulesMock.Object); validator.ShouldHaveValidationErrorFor(x => x.Url, command); }
public void Should_have_validation_error_when_language_name_is_too_short() { var command = new LanguageDetails { SiteId = Guid.NewGuid(), Id = Guid.NewGuid(), Name = "A", CultureName = "aa-bb", Url = "url" }; var languageRulesMock = new Mock <ILanguageRules>(); var siteRulesMock = new Mock <ISiteRules>(); var validator = new LanguageDetailsValidator <LanguageDetails>(languageRulesMock.Object, siteRulesMock.Object); validator.ShouldHaveValidationErrorFor(x => x.Name, command); }
public LanguageDetails LanguageDetails(Int64 Id) { LanguageDetails obj = new LanguageDetails(); DataSet ds = objServices.GetLanguageDetails(Id); if (ds != null && ds.Tables.Count > 0) { int tblIndx = -1; tblIndx++; if (ds.Tables.Count > tblIndx && ds.Tables[tblIndx] != null && ds.Tables[tblIndx].Rows.Count > 0) { obj.LanguageId = Convert.ToInt64(ds.Tables[tblIndx].Rows[0]["LanguageId"]); obj.Language = Convert.ToString(ds.Tables[tblIndx].Rows[0]["Language"]); obj.Status = Convert.ToInt16(ds.Tables[tblIndx].Rows[0]["IsActive"]); } } return(obj); }
public void Should_have_validation_error_when_url_is_not_unique() { var command = new LanguageDetails { SiteId = Guid.NewGuid(), Id = Guid.NewGuid(), Name = "My Language", CultureName = "aa-bb", Url = "url" }; var languageRulesMock = new Mock <ILanguageRules>(); languageRulesMock.Setup(x => x.IsLanguageUrlUnique(command.SiteId, command.CultureName, Guid.Empty)).Returns(false); var siteRulesMock = new Mock <ISiteRules>(); var validator = new LanguageDetailsValidator <LanguageDetails>(languageRulesMock.Object, siteRulesMock.Object); validator.ShouldHaveValidationErrorFor(x => x.Url, command); }
public void Should_have_validation_error_when_culture_name_is_not_valid() { var command = new LanguageDetails { SiteId = Guid.NewGuid(), Id = Guid.NewGuid(), Name = "My Language", CultureName = "a@b", Url = "url" }; var languageRulesMock = new Mock <ILanguageRules>(); languageRulesMock.Setup(x => x.IsCultureNameValid(command.CultureName)).Returns(false); var siteRulesMock = new Mock <ISiteRules>(); var validator = new LanguageDetailsValidator <LanguageDetails>(languageRulesMock.Object, siteRulesMock.Object); validator.ShouldHaveValidationErrorFor(x => x.CultureName, command); }
public void Should_have_validation_error_when_site_does_not_exist() { var command = new LanguageDetails { SiteId = Guid.NewGuid(), Id = Guid.NewGuid(), Name = "My Language", CultureName = "aa-bb", Url = "url" }; var languageRulesMock = new Mock <ILanguageRules>(); var siteRulesMock = new Mock <ISiteRules>(); siteRulesMock.Setup(x => x.DoesSiteExist(command.SiteId)).Returns(false); var validator = new LanguageDetailsValidator <LanguageDetails>(languageRulesMock.Object, siteRulesMock.Object); validator.ShouldHaveValidationErrorFor(x => x.SiteId, command); }
private void FillLanguagesList() { try { var selectedProjectsToExport = _projectsDataSource.Where(e => e.ShouldBeExported).ToList(); foreach (var selectedProject in selectedProjectsToExport) { foreach (var language in selectedProject.LanguagesForPoject.ToList()) { var languageDetails = _languages.FirstOrDefault(n => n.LanguageName.Equals(language.Key)); if (languageDetails == null) { var newLanguage = new LanguageDetails { LanguageName = language.Key, IsChecked = false }; _languages.Add(newLanguage); } } } if (!_languages.Any(l => l.LanguageName.Equals("All languages"))) { _languages.Insert(0, new LanguageDetails { LanguageName = "All languages", IsChecked = false }); } languagesListBox.DataSource = _languages; languagesListBox.DisplayMember = "LanguageName"; languagesListBox.ValueMember = "IsChecked"; } catch (Exception ex) { Log.Logger.Error($"FillLanguagesList method: {ex.Message}\n {ex.StackTrace}"); } }
private void FillLanguagesList() { var selectedProjectsToExport = _projectsDataSource.Where(e => e.ShouldBeExported).ToList(); foreach (var selectedProject in selectedProjectsToExport) { foreach (var language in selectedProject.LanguagesForPoject.ToList()) { var languageDetails = _languages.FirstOrDefault(n => n.LanguageName.Equals(language.Key)); if (languageDetails == null) { var newLanguage = new LanguageDetails { LanguageName = language.Key, IsChecked = false }; _languages.Add(newLanguage); } } } languagesListBox.DataSource = _languages; languagesListBox.DisplayMember = "LanguageName"; languagesListBox.ValueMember = "IsChecked"; }
public void Should_have_validation_error_when_url_is_too_long() { var url = ""; for (int i = 0; i < 101; i++) { url += i; } var command = new LanguageDetails { SiteId = Guid.NewGuid(), Id = Guid.NewGuid(), Name = "My Language", CultureName = "aa-bb", Url = url }; var languageRulesMock = new Mock <ILanguageRules>(); var siteRulesMock = new Mock <ISiteRules>(); var validator = new LanguageDetailsValidator <LanguageDetails>(languageRulesMock.Object, siteRulesMock.Object); validator.ShouldHaveValidationErrorFor(x => x.Url, command); }
private void PrepareProjectToExport(ProjectDetails selectedProject) { try { if (selectedProject != null) { var doc = new XmlDocument(); var selectedProjectIndex = _projectsDataSource.IndexOf(selectedProject); if (selectedProjectIndex > -1) { //Read sdlproj doc.Load(selectedProject.ProjectPath); Help.LoadReports(doc, selectedProject.ProjectFolderPath, selectedProject); selectedProject.ShouldBeExported = true; //if an project has only one language select that language if (selectedProject.LanguagesForPoject != null) { if (selectedProject.LanguagesForPoject.Count.Equals(1)) { var languageName = selectedProject.LanguagesForPoject.First().Key; var languageToBeSelected = _languages.FirstOrDefault(n => n.LanguageName.Equals(languageName)); if (languageToBeSelected != null) { languageToBeSelected.IsChecked = true; } else { var newLanguage = new LanguageDetails { LanguageName = languageName, IsChecked = true }; _languages.Add(newLanguage); } selectedProject.LanguagesForPoject[languageName] = true; } } var languagesAlreadySelectedForExport = _languages.Where(l => l.IsChecked).ToList(); foreach (var language in languagesAlreadySelectedForExport) { if (selectedProject.LanguagesForPoject != null && selectedProject.LanguagesForPoject.ContainsKey(language.LanguageName)) { selectedProject.LanguagesForPoject[language.LanguageName] = true; } } //show languages in language list box FillLanguagesList(); reportOutputPath.Text = selectedProject.ReportPath ?? Empty; copyBtn.Enabled = projListbox.SelectedItems.Count == 1; if (projListbox.SelectedItems.Count > 0) { csvBtn.Enabled = true; } RefreshLanguageListbox(); } } } catch (Exception ex) { Log.Logger.Error($"PrepareProjectToExport method: {ex.Message}\n {ex.StackTrace}"); } }
private bool HaveUniqueLanguageUrl(LanguageDetails cmd, string url) { return(_languageRules.IsLanguageUrlUnique(cmd.SiteId, url, cmd.Id)); }
private bool HaveUniqueCultureName(LanguageDetails cmd, string cultureName) { return(_languageRules.IsCultureNameUnique(cmd.SiteId, cultureName, cmd.Id)); }
private bool HaveUniqueName(LanguageDetails cmd, string name) { return(_languageRules.IsLanguageNameUnique(cmd.SiteId, name, cmd.Id)); }
public bool AddLanguage(Int64 Id, LanguageDetails obj) { return(objServices.AddLanguage(Id, obj)); }
public IHttpActionResult AddLanguage(Int64 Id, LanguageDetails obj) { LanguageBusinessServices objLBS = new LanguageBusinessServices(); return(Ok(objLBS.AddLanguage(Id, obj))); }