public List <MyPhotos.File> GetFilesByProperty(string key, string value)
{
List <MyPhotos.File> files = new List <MyPhotos.File>();
using (SqlCommand sqlCommand = SqlServerDbConnection.Connection.CreateCommand())
{
sqlCommand.CommandText = @"Select f.* From Properties p join Files f On p.FileId=f.Id Where p.[Key] =@Key AND p.[Value] =@Value";
sqlCommand.Parameters.Add("@Key", System.Data.SqlDbType.NVarChar).Value = key;
sqlCommand.Parameters.Add("@Value", System.Data.SqlDbType.NVarChar).Value = value;
using (SqlDataReader reader = sqlCommand.ExecuteReader())
{
while (reader.Read())
{
MyPhotos.File file = new MyPhotos.File();
file.Id = reader.GetGuid(reader.GetOrdinal("Id"));
file.Name = reader["Name"].ToString();
file.Path = reader["Path"].ToString();
files.Add(file);
}
}
}
return(files);
}
public void Update(MyPhotos.File file)
{
using (SqlCommand sqlCommand = SqlServerDbConnection.Connection.CreateCommand())
{
sqlCommand.CommandText = "UPDATE Files SET Name = @Name, Path = @Path WHERE Id = @Id";
sqlCommand.Parameters.Add("@Id", System.Data.SqlDbType.UniqueIdentifier).Value = file.Id;
sqlCommand.Parameters.Add("@Name", System.Data.SqlDbType.NVarChar).Value = file.Name;
sqlCommand.Parameters.Add("@Path", System.Data.SqlDbType.NVarChar).Value = file.Path;
sqlCommand.ExecuteNonQuery();
}
}
public void Add(MyPhotos.File file)
{
using (SqlCommand sqlCommand = SqlServerDbConnection.Connection.CreateCommand())
{
sqlCommand.CommandText = "INSERT INTO Files(Id,Name,Path) VALUES(@param1,@param2,@param3)";
sqlCommand.Parameters.Add("@param1", System.Data.SqlDbType.UniqueIdentifier).Value = Guid.NewGuid();
sqlCommand.Parameters.Add("@param2", System.Data.SqlDbType.NVarChar).Value = file.Name;
sqlCommand.Parameters.Add("@param3", System.Data.SqlDbType.NVarChar).Value = file.Path;
sqlCommand.ExecuteNonQuery();
}
}
private void btnAddFile_Click(object sender, EventArgs e)
{
if (pictureBox.Image != null)
{
MyPhotos.File file = new MyPhotos.File();
file.Name = txtName.Text;
file.Path = path;
if (setId != Guid.Empty)
{
file.Id = setId;
filePropertyClient.UpdateFile(file);
}
else
{
filePropertyClient.AddFile(file);
}
Close();
}
}
public List <MyPhotos.File> GetAllFiles()
{
List <MyPhotos.File> files = new List <MyPhotos.File>();
using (SqlCommand sqlCommand = SqlServerDbConnection.Connection.CreateCommand())
{
sqlCommand.CommandText = _sqlGetAllFiles;
using (SqlDataReader reader = sqlCommand.ExecuteReader())
{
while (reader.Read())
{
MyPhotos.File file = new MyPhotos.File();
file.Id = reader.GetGuid(reader.GetOrdinal("Id"));
file.Name = reader["Name"].ToString();
file.Path = reader["Path"].ToString();
files.Add(file);
}
}
}
return(files);
}
public System.Threading.Tasks.Task <MyPhotos.FileData> CreateFileDataAsync(MyPhotos.File file, MyPhotos.Data data, string value)
{
return(base.Channel.CreateFileDataAsync(file, data, value));
}
public MyPhotos.FileData CreateFileData(MyPhotos.File file, MyPhotos.Data data, string value)
{
return(base.Channel.CreateFileData(file, data, value));
}
public System.Threading.Tasks.Task UpdateFileAsync(MyPhotos.File file)
{
return(base.Channel.UpdateFileAsync(file));
}
public void UpdateFile(MyPhotos.File file)
{
base.Channel.UpdateFile(file);
}
public void AddFile(MyPhotos.File file)
{
base.Channel.AddFile(file);
}
