public string AddFile(HttpRequest Request, int sealRequestID)
{
if (Request.Files.Count == 0)
{
return("0");
}
else
{
string fileTitle = Request.Form["ctl00$ContentPlaceHolder1$txtFileTitle"];
string fileName = Request.Files[0].FileName;
string tmpFileName = string.Format("{0}{2}{1}", DateTime.Now.ToString("MMddyyHHmmss"), fileName.Substring(fileName.LastIndexOf(".")), 1);
Request.Files[0].SaveAs(Config.SealFilePath + tmpFileName);
SealFileEntity fileEntity = new SealFileEntity();
fileEntity.Title = fileTitle;
fileEntity.Name = fileName;
fileEntity.Path = Config.SealFilePath + tmpFileName;
fileEntity.SealRequestsID = sealRequestID;
fileEntity.UserID = UserID;
fileEntity.Type = 2;
fileEntity.IsDeleted = false;
fileEntity.CreateOn = DateTime.Now;
new App.SealsApplication().SealFilesInsert(fileEntity);
return("1");
}
}
public int Insert(SealFileEntity entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into dbo.SealFiles(");
strSql.Append("Path,Name,Title,SealRequestsID,UserID,IsDeleted,WorkflowHistoryID,CreateOn)");
strSql.Append(" values (");
strSql.Append("@Path,@Name,@Title,@SealRequestsID,@UserID,@IsDeleted,@WorkflowHistoryID,@CreateOn)");
strSql.Append(";select ISNULL( SCOPE_IDENTITY(),0);");
Database db = DatabaseFactory.CreateDatabase();
using (DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()))
{
db.AddInParameter(dbCommand, "Path", DbType.String, entity.Path);
db.AddInParameter(dbCommand, "Title", DbType.String, entity.Title);
db.AddInParameter(dbCommand, "Name", DbType.String, entity.Name);
db.AddInParameter(dbCommand, "SealRequestsID", DbType.Int32, entity.SealRequestsID);
db.AddInParameter(dbCommand, "UserID", DbType.Int32, entity.UserID);
db.AddInParameter(dbCommand, "IsDeleted", DbType.Boolean, entity.IsDeleted);
db.AddInParameter(dbCommand, "WorkflowHistoryID", DbType.Int32, entity.WorkflowHistoryID);
db.AddInParameter(dbCommand, "CreateOn", DbType.DateTime, entity.CreateOn);
int result;
object obj = db.ExecuteScalar(dbCommand);
if (!int.TryParse(obj.ToString(), out result))
{
return(0);
}
return(result);
}
}
protected string ShowDeleteButton(int id)
{
SealFileEntity sealFileEntity = app.GetSealFiles(id);
SealRequestsEntity sealRequestsEntity = app.GetSealRequests(sealFileEntity.SealRequestsID);
if (sealFileEntity.UserID != UserInfo.UserID || sealRequestsEntity.Status >= RequestStatus.Approved)
{
return(" ");
}
else
{
SealsEntity sealsEntity = app.Get(sealFileEntity.SealRequestsID);
return(string.Format("<a href=\"#\" onclick=\"deleteFile('{0}',true)\"><img border=\"0\" title=\"Delete\" src=\"/icons/17.gif\"></a>"
, id));
}
}
private void InsertFile(HttpPostedFile file, int sealRequestId, int type, int index)
{
string fileName = file.FileName;
string tmpFileName = string.Format("{0}{2}{1}", DateTime.Now.ToString("MMddyyHHmmss"), fileName.Substring(fileName.LastIndexOf(".")), index);
file.SaveAs(Config.SealFilePath + tmpFileName);
SealFileEntity fileEntity = new SealFileEntity();
fileEntity.Title = string.Empty;
fileEntity.Name = fileName;
fileEntity.Path = Config.SealFilePath + tmpFileName;
fileEntity.SealRequestsID = sealRequestId;
fileEntity.UserID = UserInfo.UserID;
fileEntity.Type = type;
fileEntity.IsDeleted = false;
fileEntity.CreateOn = DateTime.Now;
app.SealFilesInsert(fileEntity);
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (QS("ID", 0) > 0)
{
if (fileUpload.PostedFile.ContentLength == 0)
{
ShowFailMessageToClient("Please specify a file to upload.");
return;
}
string fileName = fileUpload.PostedFile.FileName;
string tmpFileName = string.Format("{0}{2}{1}",
DateTime.Now.ToString("MMddyyHHmmss"),
fileName.Substring(fileName.LastIndexOf(".")),
1);
fileUpload.PostedFile.SaveAs(Config.SealFilePath + tmpFileName);
SealFileEntity fileEntity = new SealFileEntity();
fileEntity.Title = txtTitle.Text;
fileEntity.Name = fileName;
fileEntity.Path = Config.SealFilePath + tmpFileName;
fileEntity.SealRequestsID = QS("ID", 0);
fileEntity.UserID = UserInfo.UserID;
fileEntity.WorkflowHistoryID = 2;
fileEntity.IsDeleted = false;
fileEntity.CreateOn = DateTime.Now;
if (new App.SealsApplication().SealFilesInsert(fileEntity) > 0)
{
Redirect(EmptyPopPageUrl, false, true);
}
else
{
Redirect("File upload error.", "AddSealFile.aspx?ID" + QS("ID"));
}
}
else
{
ShowFailMessageToClient("unauthorized access.");
}
}
public int SealFilesInsert(SealFileEntity entity)
{
return(mgr.SealFilesInsert(entity));
}
public bool Update(SealFileEntity entity)
{
throw new NotImplementedException();
}
public int SealFilesInsert(SealFileEntity entity)
{
return(fileRepository.Insert(entity));
}
