private void SaveMp3IdInfo() { ID3Info id3 = new ID3Info(ddtbMp3File.ItemText, true); try { id3.ID3v1Info.TrackNumber = BCHUtilities.IsNumeric(tbTrack3v1.Text) ? byte.Parse(tbTrack3v1.Text) : byte.Parse("1"); id3.ID3v1Info.Title = tbTitle3v1.Text; id3.ID3v1Info.Artist = tbArtist3v1.Text; id3.ID3v1Info.Album = tbAlbum3v1.Text; id3.ID3v1Info.Year = tbYear3v1.Text; id3.ID3v1Info.Comment = tbComment3v1.Text; id3.ID3v1Info.Genre = Convert.ToByte(cbGenre3v1.GenreIndex); id3.ID3v2Info.SetTextFrame("TRCK", tbTrack3v2.Text); id3.ID3v2Info.SetTextFrame("TIT2", tbTitle3v2.Text); id3.ID3v2Info.SetTextFrame("TPE1", tbArtist3v2.Text); id3.ID3v2Info.SetTextFrame("TALB", tbAlbum3v2.Text); id3.ID3v2Info.SetTextFrame("TYER", tbYear3v2.Text); id3.ID3v2Info.SetTextFrame("WCOM", tbComment3v2.Text); id3.ID3v2Info.SetTextFrame("TCON", cbGenre3v2.Genre); id3.ID3v2Info.HaveTag = true; id3.ID3v1Info.HaveTag = true; id3.Save(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private string ValidateAndInsertParamList(string sql, ref Dictionary <string, SqlScriptParameter> paramList, ref Dictionary <string, string> sqlPrmNameValueList, ref OperationResult op) { StringBuilder sb = new StringBuilder(); sb.Append(sql); if (paramList.Count != sqlPrmNameValueList.Count) { op.AddError("Number of given parameters do not match what is needed!"); return(string.Empty); } foreach (KeyValuePair <string, SqlScriptParameter> item in paramList) { if (!sqlPrmNameValueList.ContainsKey(item.Key)) { op.AddError("One or more parameters are missing"); return(string.Empty); } string val = sqlPrmNameValueList[item.Key]; if ((item.Value.Type == SqlScriptParameterTypeEnum.Decimal && !BCHUtilities.IsNumeric(val)) || (item.Value.Type == SqlScriptParameterTypeEnum.Integer && !BCHUtilities.IsInteger(val))) { op.AddError("One or more parameters are not the correct type"); return(string.Empty); } sb.Replace(item.Value.Marker, val); } return(sb.ToString()); }