public string SongData(string songkey, string column, DateTime data)
{
MVCSongs target = null;
MVCSongs targetreference = null;
foreach (MVCSongs q in songs)
{
if (q.SongKey == songkey)
{
target = q;
break;
}
}
foreach (MVCSongs q in songsref)
{
if (q.SongKey == songkey)
{
targetreference = q;
break;
}
}
//if (target != null)
//{
// return datestyle(target.EventDate, (targetreference == null) ? DateTime.MinValue : targetreference.EventDate);
//}
//else
return(string.Format("<text>{0}</text>", data));
}
public string Save()
{
string result = "";
int recordschanged = 0;
SingingClubClient client = new SingingClubClient();
client.Open();
if (songs != null && songsref != null)
{
List <MVCSongs> tobeadded = new List <MVCSongs>();
foreach (MVCSongs q in songs)
{
bool found = false;
foreach (MVCSongs qref in songsref)
{
if (q.KeyEquals(qref) == true)
{
found = true;
if (MVCSongs.FieldsEqual(q, qref) == false)
{
result = client.GeneralStore("TSCSongList_Main", "UPDATE", q.GetDataXml());
if (result != null && Utility.IsNumber(result) && int.Parse(result) > 0)
{
recordschanged++;
}
}
}
}
if (found == false)
{
tobeadded.Add(q);
}
}
if (tobeadded.Count > 0)
{
foreach (MVCSongs tba in tobeadded)
{
result = client.GeneralStore("TSCSongList_Main", "INSERT", tba.GetDataXml());
if (result != null && Utility.IsNumber(result) && int.Parse(result) > 0)
{
recordschanged++;
}
}
}
}
client.Close();
return(recordschanged.ToString());
}
public string SongData(string songkey, string column, string data)
{
MVCSongs target = null;
MVCSongs targetreference = null;
foreach (MVCSongs q in songs)
{
if (q.SongKey == songkey)
{
target = q;
break;
}
}
foreach (MVCSongs q in songsref)
{
if (q.SongKey == songkey)
{
targetreference = q;
break;
}
}
if (target != null)
{
switch (column)
{
case "Title":
return(util.textstyle(target.Title, (targetreference == null) ? null : targetreference.Title));
case "Artist":
return(util.textstyle(target.Artist, (targetreference == null) ? null : targetreference.Artist));
case "Disk":
return(util.textstyle(target.Disk, (targetreference == null) ? null : targetreference.Disk));
default:
return(string.Format("<text>{0}</text>", data));
}
}
else
{
return(string.Format("<text>{0}</text>", data));
}
}
