public static int Add(FilesDS.FilesRow dr, string SQLConnectionName)
{
try
{
SqlConnection SQLConn = new SqlConnection(getConnstring(SQLConnectionName));
SqlCommand iSqlCommand = GenerateSqlCommandfromDataRow(dr, SP_Add);
iSqlCommand.Connection = SQLConn;
//Set the ID column as output as the GenerateSQLCommand would not have done this.
iSqlCommand.Parameters["@ID"].Direction = ParameterDirection.InputOutput;
iSqlCommand.UpdatedRowSource = UpdateRowSource.OutputParameters;
SQLConn.Open();
iSqlCommand.ExecuteNonQuery();
int newID = (int)iSqlCommand.Parameters["@ID"].Value;
iSqlCommand.Dispose();
SQLConn.Close();
return newID;
}
catch
{
return -1;
}
}
public static bool DelFile(FilesDS.FilesRow rdr)
{
//To do get id from HojuWebDisk context
//String userid = HttpContext.Current.User.Identity.Name.Split(@"\".ToCharArray(), 2)[1];
return FilesDLC.Del(rdr.ID, DBConnName);
}
private int SaveFile(int PID)
{
byte[] _requestInput = GetRequestInput();
FilesDS.FilesRow _newFile = WebDavHelper.getFile(this._requestPath);
if (_newFile == null)
{
FilesDS fds = new FilesDS();
_newFile = fds.Files.NewFilesRow();
_newFile.FileData = _requestInput;
_newFile.FileDataSize = _requestInput.LongLength;
_newFile.ParentID = PID;
_newFile.FileName = WebDavHelper.getResourceName(this._requestPath);
_newFile.ContentType = GetMIMEType(_newFile.FileName);
_newFile.update_user_stamp = HttpContext.Current.User.Identity.Name;
}
else
{
_newFile.FileData = _requestInput;
_newFile.FileDataSize = _requestInput.LongLength;
}
return WebDavHelper.SaveFile(_newFile);
}
/// <summary>
/// Saves a File
/// </summary>
/// <param name="rdr">The file row to save</param>
/// <returns></returns>
public static int SaveFile(FilesDS.FilesRow rdr)
{
return FileBLC.SaveFile(rdr);
}
public static FilesDS.FilesRow Get(int KeyValue, string SQLConnectionName)
{
FilesDS ds = new FilesDS();
try
{
SqlConnection SQLConn = new SqlConnection(getConnstring(SQLConnectionName));
SqlDataAdapter iDataAdapter = new SqlDataAdapter(SP_Get, SQLConn);
iDataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
iDataAdapter.SelectCommand.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int));
iDataAdapter.SelectCommand.Parameters["@ID"].Value = KeyValue;
SQLConn.Open();
//Fill the DataSet with the rows that are returned.
iDataAdapter.Fill(ds, ds.Files.TableName);
iDataAdapter.Dispose();
SQLConn.Close();
}
catch
{
return null;
}
if (ds.Files.Rows.Count == 1)
{
return (FilesDS.FilesRow)ds.Files.Rows[0];
}
else
{
return null;
}
}
private static SqlCommand GenerateSqlCommandfromDataRow(FilesDS.FilesRow Data, string StoredProcName)
{
SqlCommand retCom = new SqlCommand(StoredProcName);
retCom.CommandType = CommandType.StoredProcedure;
for (int Eni = 0; Eni < Data.ItemArray.Length; Eni++)
{
string stype = Data[Eni].GetType().ToString();
switch (stype)
{
case "System.Int32":
retCom.Parameters.Add("@" + Data.Table.Columns[Eni].ColumnName, SqlDbType.Int);
retCom.Parameters["@" + Data.Table.Columns[Eni].ColumnName].Value = Data[Eni];
break;
case "System.Int64":
retCom.Parameters.Add("@" + Data.Table.Columns[Eni].ColumnName, SqlDbType.BigInt);
retCom.Parameters["@" + Data.Table.Columns[Eni].ColumnName].Value = Data[Eni];
break;
case "System.String":
retCom.Parameters.Add("@" + Data.Table.Columns[Eni].ColumnName, SqlDbType.VarChar);
retCom.Parameters["@" + Data.Table.Columns[Eni].ColumnName].Value = Data[Eni];
break;
case "System.Byte[]":
retCom.Parameters.Add("@" + Data.Table.Columns[Eni].ColumnName, SqlDbType.Image);
retCom.Parameters["@" + Data.Table.Columns[Eni].ColumnName].Value = Data[Eni];
break;
case "System.DateTime":
retCom.Parameters.Add("@" + Data.Table.Columns[Eni].ColumnName, SqlDbType.DateTime);
retCom.Parameters["@" + Data.Table.Columns[Eni].ColumnName].Value = Data[Eni];
break;
}
}
return retCom;
}
public static int Update(FilesDS.FilesRow dr, string SQLConnectionName)
{
try
{
SqlConnection SQLConn = new SqlConnection(getConnstring(SQLConnectionName));
SqlCommand iSqlCommand = GenerateSqlCommandfromDataRow(dr, SP_Update);
iSqlCommand.Connection = SQLConn;
//Set the ID column as output as the GenerateSQLCommand would not have done this.
SQLConn.Open();
iSqlCommand.ExecuteNonQuery();
iSqlCommand.Dispose();
SQLConn.Close();
return 1;
}
catch
{
return -1;
}
}
public static int SaveFile(FilesDS.FilesRow rdr)
{
//To do get id from HojuWebDisk context
//String userid = HttpContext.Current.User.Identity.Name.Split(@"\".ToCharArray(), 2)[1];
if (rdr.ID == 0)
{
//this is a new entry.
return FilesDLC.Add(rdr, DBConnName);
}
else
{
//this is an existing entry
return FilesDLC.Update(rdr, DBConnName);
}
}
private void CopyFile(FilesDS.FilesRow _sourceFile, string destination)
{
FilesDS.FilesRow _destFile;
if (_sourceFile != null)
{
try
{
_destFile = WebDavHelper.getFile(destination);
if (!this._overwriteResource && _destFile != null)
{
this._Errors.Add(new ProcessingError(_sourceFile.FileName, WebDavHelper.getEnumHttpResponse(DavCopyResponseCode.PreconditionFailed)));
}
else
{
FoldersDS.FoldersRow _destdir = WebDavHelper.getParentFolder(destination);
if (_destdir == null)
{
this._Errors.Add(new ProcessingError(_sourceFile.FileName, WebDavHelper.getEnumHttpResponse(DavCopyResponseCode.BadGateway)));
}
else
{
if (_destFile == null)
{
FilesDS fds = new FilesDS();
_destFile = fds.Files.NewFilesRow();
}
_destFile.ContentType = _sourceFile.ContentType;
_destFile.FileData = _sourceFile.FileData;
_destFile.FileDataSize = _sourceFile.FileDataSize;
_destFile.FileName = _sourceFile.FileName;
_destFile.ParentID = _destdir.ID;
_destFile.update_user_stamp = HttpContext.Current.User.Identity.Name;
WebDavHelper.SaveFile(_destFile);
}
}
}
catch (Exception)
{
this._Errors.Add(new ProcessingError(_sourceFile.FileName, WebDavHelper.getEnumHttpResponse(DavCopyResponseCode.Forbidden)));
}
}
}