public DirectoryObjectsEntity Get(int entityId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from DirectoryObjects ");
strSql.Append(" where ID=@ID ");
Database db = DatabaseFactory.CreateDatabase();
using (DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()))
{
try
{
db.AddInParameter(dbCommand, "ID", DbType.Int32, entityId);
DirectoryObjectsEntity model = null;
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
model = DirectoryObjectsEntity.ReaderBind(dataReader);
}
}
return(model);
}
catch (Exception ex)
{
WebLogAgent.Write(string.Format("[SQLText:{0},{1}Messages:\r\n{2}]",
strSql.ToString(), base.FormatParameters(dbCommand.Parameters), ex.Message));
return(null);
}
}
}
public DirectoryObjectsEntity Get(int entityId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from DirectoryObjects ");
strSql.Append(" where ID=@ID ");
Database db = DatabaseFactory.CreateDatabase();
using (DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()))
{
try
{
db.AddInParameter(dbCommand, "ID", DbType.Int32, entityId);
DirectoryObjectsEntity model = null;
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
model = DirectoryObjectsEntity.ReaderBind(dataReader);
}
}
return(model);
}
catch (Exception ex)
{
return(null);
}
}
}
public int Insert(DirectoryObjectsEntity model)
{
StringBuilder strSql = new StringBuilder();
// first
strSql.Append(@"if exists (select 1 from [DirectoryObjects] where DirectoryID=@DirectoryID and ObjectID=@ObjectID and [Type]=@Type)
begin
select 0
end
else
begin ");
strSql.Append(@"if not exists (select 1 from Directories where ID=@DirectoryID)
begin
select -1
end
else
begin ");
strSql.Append(" insert into DirectoryObjects(");
strSql.Append("DirectoryID,Type,Logo,ObjectID,CreatedOn,CreatedBy,ModifiedOn,ModifiedBy)");
strSql.Append(" values (");
strSql.Append("@DirectoryID,@Type,@Logo,@ObjectID,@CreatedOn,@CreatedBy,@ModifiedOn,@ModifiedBy)");
strSql.Append(";select ISNULL( SCOPE_IDENTITY(),0); ");
strSql.Append(" end ");
//first end
strSql.Append(" end");
Database db = DatabaseFactory.CreateDatabase();
using (DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()))
{
try
{
db.AddInParameter(dbCommand, "DirectoryID", DbType.Int32, model.DirectoryID);
db.AddInParameter(dbCommand, "Type", DbType.String, model.ObjectType.ToString());
db.AddInParameter(dbCommand, "Logo", DbType.AnsiString, model.Logo);
db.AddInParameter(dbCommand, "ObjectID", DbType.Int32, model.ObjectID);
db.AddInParameter(dbCommand, "CreatedOn", DbType.DateTime, model.CreatedOn);
db.AddInParameter(dbCommand, "CreatedBy", DbType.Int32, model.CreatedBy);
db.AddInParameter(dbCommand, "ModifiedOn", DbType.DateTime, model.ModifiedOn);
db.AddInParameter(dbCommand, "ModifiedBy", DbType.Int32, model.ModifiedBy);
int result;
object obj = db.ExecuteScalar(dbCommand);
if (!int.TryParse(obj.ToString(), out result))
{
return(0);
}
return(result);
}
catch (Exception ex)
{
WebLogAgent.Write(string.Format("[SQLText:{0},{1}Messages:\r\n{2}]",
strSql.ToString(), base.FormatParameters(dbCommand.Parameters), ex.Message));
return(-2);
}
}
}
private DirectoryObjectsEntity GetObject(int fileID)
{
DirectoryObjectsEntity model = FileFactory.CreateDirectoryObject(UserInfo.ID, ObjectFactory.GetInstance <ISystemDateTime>());
model.DirectoryID = int.Parse(ddlCurrent.SelectedValue);
model.Logo = "File.png";
model.ObjectID = fileID;
model.Type = DirectoryObjectType.File.ToString();
return(model);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (string.IsNullOrEmpty(Request.QueryString["id"]) ||
string.IsNullOrEmpty(Request.QueryString["type"]) ||
(QS("id", 0) == 0))
{
ShowArgumentErrorMessageToClient();
return;
}
int id = int.Parse(Request.QueryString["id"]);
string type = Request.QueryString["type"];
if (type == DirectoryObjectType.Directory.ToString())
{
rbtnNewDirectory.Checked = true;
rbtnNewFile.Checked = false;
DirectoryEntity model = fileApp.GetDirectory(int.Parse(Request.Params["id"]));
DirectoryEntity parent = fileApp.GetDirectory(model.ParentID);
List <DirectoryEntity> list = fileApp.GetDirectories(parent.ParentID);
list.BindDropdown <DirectoryEntity>(ddlCurrent, "Title", "ID", "Please Select", "0");
ddlCurrent.SelectedValue = model.ParentID.ToString();
txtTitle.Text = model.Title;
txtDesc.Text = model.Description;
}
else if (type == DirectoryObjectType.File.ToString())
{
int direid = 0;
if (!string.IsNullOrEmpty(Request.Params["direid"]) &&
int.TryParse(Request.Params["direid"], out direid))
{
DirectoryObjectsEntity objects = fileApp.GetObjects(direid);
if (!ISReadOnlyRole || UserInfo.ID == objects.CreatedBy)
{
DirectoryEntity parent = fileApp.GetDirectory(objects.DirectoryID);
ddlCurrent.Items.Add(new ListItem(parent.Title, parent.ID.ToString(), true));
FilesEntity file = fileApp.Get(objects.ObjectID);
txtDesc.Text = file.ThumbPath;
}
else
{
ShowArgumentErrorMessageToClient();
return;
}
}
rbtnNewDirectory.Checked = false;
rbtnNewFile.Checked = true;
}
}
}
private bool InsertObjects(HttpContext context, out string msg, out int id)
{
DirectoryObjectsEntity model = GetObjectFromRequest(context);
FileApplication fileApp = new FileApplication();
msg = string.Empty;
id = fileApp.PushObjectToDirectory(model);
if (fileApp.BrokenRuleMessages.Count > 0)
{
msg = string.Format("{0},{1}", fileApp.BrokenRuleMessages[0].Key, fileApp.BrokenRuleMessages[0].Message);
return(false);
}
return(true);
}
protected void btnSave_Click(object sender, EventArgs e)
{
string msg = string.Empty;
if (!CheckInput(out msg))
{
ShowMessageToClient(msg, 2, false, false);
return;
}
if (rbtnNewDirectory.Checked)
{
DirectoryEntity model = GetDirectory();
int id = fileApp.UpdateDirectory(model);
if (id > 0)
{
Session["CreatedDirectory"] = string.Format("{0}-{1}", ddlCurrent.SelectedValue, id.ToString());
this.ShowSuccessMessageToClient();
}
else
{
this.ShowFailMessageToClient(fileApp.BrokenRuleMessages, false);
}
}
else if (rbtnNewFile.Checked)
{
FilesEntity model = GetFile();
FileApplication fileApp = new FileApplication();
int result = fileApp.AddFile(model);
if (result <= 0)
{
ShowFailMessageToClient(fileApp.BrokenRuleMessages, false);
return;
}
else
{
DirectoryObjectsEntity objecttoadd = GetObject(result);
int id = fileApp.PushObjectToDirectory(objecttoadd);
if (id > 0)
{
ShowSuccessMessageToClient(true, true);
}
else
{
ShowFailMessageToClient(fileApp.BrokenRuleMessages, false);
return;
}
}
}
}
private DirectoryObjectsEntity GetObjectFromRequest(HttpContext context)
{
try
{
DirectoryObjectsEntity model = FileFactory.CreateDirectoryObject(IdentityContext.UserID, ObjectFactory.GetInstance <ISystemDateTime>());
model.DirectoryID = int.Parse(context.Request["directoryid"]);
model.ObjectID = int.Parse(context.Request["objectid"]);
model.Type = context.Request.Params["objecttype"];
model.Logo = model.Type + ".png";
return(model);
}
catch (Exception ex)
{
WebLogAgent.Write(ex);
return(null);
}
}
public bool Update(DirectoryObjectsEntity entity)
{
throw new NotImplementedException();
}
