private void ArtistSelected(int id)
{
// Get the employee entity with the selected ID.
var albums = this.dataService.GetAlbums().Where(x => x.Artist.ArtistId == id).ToList();
var artistSummaryModel = new ArtistSummaryModel
{
AlbumCount = albums.Count,
SongsCount = albums.Sum(o => o.SongsCount)
};
if (albums.FirstOrDefault() != null)
{
var firstOrDefault = albums.FirstOrDefault();
artistSummaryModel.ArtistName = firstOrDefault.Artist.Name;
}
Albumses = new Model.Albums();
foreach (var alb in albums)
{
Albumses.Add(alb);
}
ArtistSummaryModel = artistSummaryModel;
}
private async void BtnSave_Click(object sender, EventArgs e)
{
if (!ValidateChildren())
{
return;
}
request.Name = txtName.Text;
request.Year = int.Parse(txtYear.Text);
request.ArtistId = (cmbArtist.SelectedItem as Model.Artists).Id;
request.Status = Model.ReviewStatus.Approved;
if (_id == 0)
{
entity = await _serviceAlbums.Insert <Model.Albums>(request);
if (entity != null)
{
MessageBox.Show("Album added");
DialogResult = DialogResult.OK;
}
}
else
{
entity = await _serviceAlbums.Update <Model.Albums>(_id, request);
if (entity != null)
{
MessageBox.Show("Album updated");
DialogResult = DialogResult.OK;
}
}
}
private async void frmAlbumDetails_Load(object sender, EventArgs e)
{
if (_id != 0)
{
entity = await _serviceAlbums.GetById <Model.Albums>(_id);
if (entity != null)
{
if (entity.Status == Model.ReviewStatus.Pending)
{
btnSave.Text = "Approve";
btnReject.Visible = true;
}
txtName.Text = entity.Name;
txtYear.Text = entity.Year.ToString();
foreach (var item in cmbArtist.Items)
{
if ((item as Model.Artists).Id == entity.ArtistId)
{
cmbArtist.SelectedItem = item;
break;
}
}
LoadPicture();
}
}
await LoadCmbArtists();
}
private async void AlbumComboBox_SelectionChanged(object sender, Syncfusion.XForms.ComboBox.SelectionChangedEventArgs e)
{
SfComboBox cmb = sender as SfComboBox;
Model.Albums album = cmb.SelectedValue as Model.Albums;
VM.AlbumId = album.Id;
await VM.LoadSongs();
SongComboBox.SelectedItem = null;
SongComboBox.Text = "";
}
/// <summary>
/// 修改相册信息
/// </summary>
public int ModifyAlbum(Model.Albums model)
{
SqlParameter[] parameters =
{
new SqlParameter("@AlbumName", SqlDbType.NVarChar, 50),
new SqlParameter("@AlbumTypeId", SqlDbType.Int, 4),
new SqlParameter("@AlbumDesc", SqlDbType.NVarChar, 200),
new SqlParameter("@AlbumId", SqlDbType.Int, 4)
};
parameters[0].Value = model.AlbumName;
parameters[1].Value = model.AlbumTypeId;
parameters[2].Value = model.AlbumDesc;
parameters[3].Value = model.AlbumId;
int result = 0;
return(DbHelperSQL.RunProcedure("ModifyAlbum", parameters, out result));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.Albums model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Albums set ");
strSql.Append("AlbumName=@AlbumName,");
strSql.Append("AddUser=@AddUser,");
strSql.Append("AddTime=@AddTime,");
strSql.Append("AlbumTypeId=@AlbumTypeId,");
strSql.Append("CoverPhotoPath=@CoverPhotoPath,");
strSql.Append("AlbumDesc=@AlbumDesc,");
strSql.Append("AlbumPath=@AlbumPath");
strSql.Append(" where AlbumId=@AlbumId");
SqlParameter[] parameters =
{
new SqlParameter("@AlbumName", SqlDbType.NVarChar, 50),
new SqlParameter("@AddUser", SqlDbType.NVarChar, 50),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@AlbumTypeId", SqlDbType.Int, 4),
new SqlParameter("@CoverPhotoPath", SqlDbType.NVarChar, 100),
new SqlParameter("@AlbumDesc", SqlDbType.NVarChar, 200),
new SqlParameter("@AlbumPath", SqlDbType.NVarChar, 50),
new SqlParameter("@AlbumId", SqlDbType.Int, 4)
};
parameters[0].Value = model.AlbumName;
parameters[1].Value = model.AddUser;
parameters[2].Value = model.AddTime;
parameters[3].Value = model.AlbumTypeId;
parameters[4].Value = model.CoverPhotoPath;
parameters[5].Value = model.AlbumDesc;
parameters[6].Value = model.AlbumPath;
parameters[7].Value = model.AlbumId;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.Albums DataRowToModel(DataRow row)
{
Model.Albums model = new Model.Albums();
if (row != null)
{
if (row["AlbumId"] != null && row["AlbumId"].ToString() != "")
{
model.AlbumId = int.Parse(row["AlbumId"].ToString());
}
if (row["AlbumName"] != null)
{
model.AlbumName = row["AlbumName"].ToString();
}
if (row["AddUser"] != null)
{
model.AddUser = row["AddUser"].ToString();
}
if (row["AddTime"] != null && row["AddTime"].ToString() != "")
{
model.AddTime = DateTime.Parse(row["AddTime"].ToString());
}
if (row["AlbumTypeId"] != null && row["AlbumTypeId"].ToString() != "")
{
model.AlbumTypeId = int.Parse(row["AlbumTypeId"].ToString());
}
if (row["CoverPhotoPath"] != null)
{
model.CoverPhotoPath = row["CoverPhotoPath"].ToString();
}
if (row["AlbumDesc"] != null)
{
model.AlbumDesc = row["AlbumDesc"].ToString();
}
if (row["AlbumPath"] != null)
{
model.AlbumPath = row["AlbumPath"].ToString();
}
}
return(model);
}
/// <summary>
/// 新增相册
/// </summary>
public int AddAlbum(Model.Albums model)
{
SqlParameter[] parameters =
{
new SqlParameter("@AlbumName", SqlDbType.NVarChar, 50),
new SqlParameter("@AddUser", SqlDbType.NVarChar, 50),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@AlbumTypeId", SqlDbType.Int, 4),
new SqlParameter("@CoverPhotoPath", SqlDbType.NVarChar, 100),
new SqlParameter("@AlbumDesc", SqlDbType.NVarChar, 200),
new SqlParameter("@AlbumPath", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.AlbumName;
parameters[1].Value = model.AddUser;
parameters[2].Value = model.AddTime;
parameters[3].Value = model.AlbumTypeId;
parameters[4].Value = model.CoverPhotoPath;
parameters[5].Value = model.AlbumDesc;
parameters[6].Value = model.AlbumPath;
int result = 0;
return(DbHelperSQL.RunProcedure("AddAlbum", parameters, out result));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.Albums model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Albums(");
strSql.Append("AlbumName,AddUser,AddTime,AlbumTypeId,CoverPhotoPath,AlbumDesc,AlbumPath)");
strSql.Append(" values (");
strSql.Append("@AlbumName,@AddUser,@AddTime,@AlbumTypeId,@CoverPhotoPath,@AlbumDesc,@AlbumPath)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@AlbumName", SqlDbType.NVarChar, 50),
new SqlParameter("@AddUser", SqlDbType.NVarChar, 50),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@AlbumTypeId", SqlDbType.Int, 4),
new SqlParameter("@CoverPhotoPath", SqlDbType.NVarChar, 100),
new SqlParameter("@AlbumDesc", SqlDbType.NVarChar, 200),
new SqlParameter("@AlbumPath", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.AlbumName;
parameters[1].Value = model.AddUser;
parameters[2].Value = model.AddTime;
parameters[3].Value = model.AlbumTypeId;
parameters[4].Value = model.CoverPhotoPath;
parameters[5].Value = model.AlbumDesc;
parameters[6].Value = model.AlbumPath;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.Albums GetModel(int AlbumId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 AlbumId,AlbumName,AddUser,AddTime,AlbumTypeId,CoverPhotoPath,AlbumDesc,AlbumPath from Albums ");
strSql.Append(" where AlbumId=@AlbumId");
SqlParameter[] parameters =
{
new SqlParameter("@AlbumId", SqlDbType.Int, 4)
};
parameters[0].Value = AlbumId;
Model.Albums model = new Model.Albums();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 修改相册信息
/// </summary>
public int ModifyAlbum(Model.Albums model)
{
return(dal.ModifyAlbum(model));
}
/// <summary>
/// 新增相册
/// </summary>
public int AddAlbum(Model.Albums model)
{
return(dal.AddAlbum(model));
}
