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());
}
