public IList<GetArtisticworksByID> GetArtisticworksByID(GetArtisticworksByID obj)
{
StringBuilder sql = new StringBuilder();
sql.AppendLine("SELECT ");
sql.AppendLine(" Artisticworks_ID, ");
sql.AppendLine(" Artisticworks_Name, ");
sql.AppendLine(" Artisticworks_Date, ");
sql.AppendLine(" Artisticworks_Picture, ");
sql.AppendLine(" Member_Name ");
sql.AppendLine("FROM Artisticworks ");
sql.AppendLine("LEFT JOIN Member ");
sql.AppendLine(" ON Artisticworks.Member_ID = Member.Member_ID ");
sql.AppendLine("WHERE Artisticworks.Member_ID = @Member_ID");
List<SqlParameter> parameter = new List<SqlParameter>()
{
new SqlParameter() {ParameterName = "@Member_ID",Value = obj.Member_ID}
};
DataTable table = ConnectDBToGetData(sql, parameter);
return DataTableToList<GetArtisticworksByID>(table);
}
public string GetArtisticworksdata(GetArtisticworksByID obj)
{
IList<GetArtisticworksByID> objArtisticworksdata = AWS.GetArtisticworksByID(obj);
return Base.ConvertToJson<GetArtisticworksByID>(objArtisticworksdata);
}