public RepositoryVo GetRepositoryItem(int intRepositoryId)
{
RepositoryDao repoDao = new RepositoryDao();
RepositoryVo repoVo = new RepositoryVo();
try
{
repoVo = repoDao.GetRepositoryItem(intRepositoryId);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "RepositoryBo.cs:GetRepositoryItem(int intRepositoryId)");
object[] objects = new object[2];
objects[0] = intRepositoryId;
objects[1] = repoDao;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(repoVo);
}
public bool UpdateRepositoryItem(RepositoryVo repoVo)
{
RepositoryDao repoDao = new RepositoryDao();
bool blResult = false;
try
{
blResult = repoDao.UpdateRepositoryItem(repoVo);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "RepositoryBo.cs:UpdateRepositoryItem(RepositoryVo repoVo)");
object[] objects = new object[1];
objects[0] = repoVo;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(blResult);
}
public bool AddOrderDocument(RepositoryVo repoVo, int orderid)
{
Database db;
DbCommand cmdAddRepository;
bool blResult = false;
try
{
db = DatabaseFactory.CreateDatabase("wealtherp");
cmdAddRepository = db.GetStoredProcCommand("Sp_CreateCustomerOrderDocument");
db.AddInParameter(cmdAddRepository, "@orderid", DbType.Int32, orderid);
db.AddInParameter(cmdAddRepository, "@ProofTypeCode", DbType.Int32, repoVo.CategoryCode);
db.AddInParameter(cmdAddRepository, "@ProofCode", DbType.String, repoVo.HeadingText);
db.AddInParameter(cmdAddRepository, "@image", DbType.String, repoVo.Description);
db.ExecuteNonQuery(cmdAddRepository);
blResult = true;
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
return(blResult);
}
private void UpdateClick()
{
repoVo = new RepositoryVo();
bool blResult = false;
bool blZeroBalance = false;
bool blFileSizeExceeded = false;
repoVo = (RepositoryVo)Session[SessionContents.RepositoryVo];
if (ddlUploadDataType.SelectedValue.Equals(Constants.F.ToString()))
{
if (radUploadRepoItem.UploadedFiles.Count == 0)
{
blResult = UpdateFile(out blZeroBalance, out blFileSizeExceeded);
}
else
{
if (fStorageBalance > 0)
{
blResult = UpdateFile(out blZeroBalance, out blFileSizeExceeded);
}
else
{
blZeroBalance = true;
}
}
}
else if (ddlUploadDataType.SelectedValue.Equals(Constants.L.ToString()))
{
blResult = UpdateLink();
}
if (blResult)
{
Session[SessionContents.RepositoryVo] = null;
ResetControls();
// Change the tab
ChangeTelerikRadTab(1);
ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "ManageRepository", "alert('Repository Item updated successfully!');", true);
}
else
{
if (blZeroBalance)
{
ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "ManageRepository", "alert('You do not have enough space. You have only " + fStorageBalance + " MB left in your account!');", true);
}
else if (blFileSizeExceeded)
{
ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "pageloadscript", "alert('Sorry your repository file size exceeds the allowable 2 MB limit!');", true);
}
else
{
// Display error message
ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "ManageRepository", "alert('Error updating repository item!');", true);
}
}
}
public RepositoryVo toMoreVo(RepositoryEntity entity)
{
RepositoryVo vo = toVo(entity);
List <TheMetaRepositoryTypeEntity> theMetaRepositoryTypeEntityList = theMetaRepositoryTypeMeta.GetEntityList();
vo.RepositoryTypeId = theMetaRepositoryTypeConvertor.getMoreVoList(theMetaRepositoryTypeEntityList, entity.RepositoryTypeId);
return(vo);
}
public RepositoryVo toEmptyVo()
{
RepositoryVo vo = new RepositoryVo();
List <TheMetaRepositoryTypeEntity> theMetaRepositoryTypeEntityList = theMetaRepositoryTypeMeta.GetEntityList();
vo.RepositoryTypeId = theMetaRepositoryTypeConvertor.getVoList(theMetaRepositoryTypeEntityList);
return(vo);
}
/// <summary>
/// 将entity转换为vo。不包括来自元数据的属性
/// </summary>
private RepositoryVo toVo(RepositoryEntity entity)
{
RepositoryVo vo = new RepositoryVo();
vo.Id = entity.Id;
vo.RepositoryName = entity.RepositoryName;
vo.GitlabProjectFullname = entity.GitlabProjectFullname;
vo.DataStatus = entity.DataStatus;
vo.Description = entity.Description;
return(vo);
}
public RepositoryVo GetRepositoryItem(int intRepositoryId)
{
Database db;
DbCommand cmdGetRepositoryItem;
DataSet ds = null;
RepositoryVo repoVo = new RepositoryVo();
try
{
db = DatabaseFactory.CreateDatabase("wealtherp");
cmdGetRepositoryItem = db.GetStoredProcCommand("sproc_Repository_GetRepositoryItem");
db.AddInParameter(cmdGetRepositoryItem, "@repositoryId", DbType.Int32, intRepositoryId);
ds = db.ExecuteDataSet(cmdGetRepositoryItem);
if (ds.Tables[0].Rows.Count > 0)
{
repoVo.RepositoryId = intRepositoryId;
repoVo.AdviserId = Int32.Parse(ds.Tables[0].Rows[0]["A_AdviserId"].ToString());
repoVo.CategoryCode = ds.Tables[0].Rows[0]["ARC_RepositoryCategoryCode"].ToString();
repoVo.Description = ds.Tables[0].Rows[0]["AR_Description"].ToString();
repoVo.HeadingText = ds.Tables[0].Rows[0]["AR_HeadingText"].ToString();
repoVo.IsFile = Boolean.Parse(ds.Tables[0].Rows[0]["AR_IsFile"].ToString());
if (repoVo.IsFile)
{
repoVo.Link = ds.Tables[0].Rows[0]["AR_Filename"].ToString();
}
else
{
repoVo.Link = ds.Tables[0].Rows[0]["AR_Link"].ToString();
}
}
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "RepositoryDao.cs:GetRepositoryItem(int intRepositoryId)");
object[] objects = new object[2];
objects[0] = intRepositoryId;
objects[1] = repoVo;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(repoVo);
}
public bool AddOrderDocument(RepositoryVo repoVo, int issueId)
{
RepositoryDao repoDao = new RepositoryDao();
bool blResult = false;
try
{
blResult = repoDao.AddOrderDocument(repoVo, issueId);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
return(blResult);
}
private bool AddLink()
{
bool blResult = false;
// If the upload type is link
repoVo = new RepositoryVo();
repoVo.AdviserId = advisorVo.advisorId;
repoVo.CategoryCode = ddlRCategory.SelectedValue;
repoVo.Description = txtDescription.Text.Trim();
repoVo.HeadingText = txtHeadingText.Text.Trim();
repoVo.IsFile = false;
repoVo.Link = txtOutsideLink.Text.Trim();
blResult = AddUpdateRepositoryLink(blResult, Constants.Add.ToString(), repoVo);
return(blResult);
}
protected void lnkBtnFileNameClientListGrid_Click(object sender, EventArgs e)
{
LinkButton lnkBtn = (sender as LinkButton);
GridDataItem dataItem = lnkBtn.NamingContainer as GridDataItem;
int intKey = Int32.Parse(dataItem.GetDataKeyValue("AR_RepositoryId").ToString());
// Get RepositoryVo
RepositoryVo repoVo = new RepositoryVo();
RepositoryBo repoBo = new RepositoryBo();
repoVo = repoBo.GetRepositoryItem(intKey);
Session[SessionContents.RepositoryVo] = repoVo;
// Change the tab
ChangeTelerikRadTab(0);
BindEditFields();
}
private bool AddUpdateRepositoryLink(bool blResult, string strAction, RepositoryVo repoVo)
{
repoBo = new RepositoryBo();
try
{
blResult = (strAction.Equals(Constants.Add.ToString())) ? repoBo.AddRepositoryItem(repoVo, issueId) : repoBo.UpdateRepositoryItem(repoVo);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
object[] objects = new object[1];
objects[0] = repoVo;
PageException(objects, Ex, "ManageRepository.ascx:AddClick()");
}
return(blResult);
}
public bool AddRepositoryItem(RepositoryVo repoVo, int issueId)
{
Database db;
DbCommand cmdAddRepository;
bool blResult = false;
try
{
db = DatabaseFactory.CreateDatabase("wealtherp");
cmdAddRepository = db.GetStoredProcCommand("sproc_Repository_AddRepositoryItem");
db.AddInParameter(cmdAddRepository, "@adviserId", DbType.Int32, repoVo.AdviserId);
db.AddInParameter(cmdAddRepository, "@repoCatCode", DbType.String, repoVo.CategoryCode);
db.AddInParameter(cmdAddRepository, "@repoHeadingText", DbType.String, repoVo.HeadingText);
db.AddInParameter(cmdAddRepository, "@repoDescription", DbType.String, repoVo.Description);
db.AddInParameter(cmdAddRepository, "@repoIsFile", DbType.Boolean, repoVo.IsFile);
db.AddInParameter(cmdAddRepository, "@repoLink", DbType.String, repoVo.Link);
if (issueId > 0)
{
db.AddInParameter(cmdAddRepository, "@issueId", DbType.Int32, issueId);
}
db.ExecuteNonQuery(cmdAddRepository);
blResult = true;
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "RepositoryDao.cs:AddRepositoryItem(RepositoryVo repoVo)");
object[] objects = new object[1];
objects[0] = repoVo;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(blResult);
}
private void BindEditFields()
{
repoVo = new RepositoryVo();
repoVo = (RepositoryVo)Session[SessionContents.RepositoryVo];
ddlRCategory.SelectedValue = repoVo.CategoryCode;
ddlRCategory.Enabled = ddlUploadDataType.Enabled = false;
txtHeadingText.Text = repoVo.HeadingText;
txtDescription.Text = repoVo.Description;
if (repoVo.IsFile)
{
ddlUploadDataType.SelectedValue = Constants.F.ToString();
FileUploadVisibility(false, true);
trUploadedFileName.Visible = true;
string[] strUplFile;
strUplFile = repoVo.Link.Split('_');
StringBuilder sb = new StringBuilder();
for (int i = 2; i < strUplFile.Length; i++)
{
sb.Append(strUplFile[i]);
sb.Append('_');
}
sb.Remove(sb.Length - 1, 1);
// The 3rd item in the array is the actual file name
lblUploadedFile.Text = sb.ToString();
}
else
{
ddlUploadDataType.SelectedValue = Constants.L.ToString();
FileUploadVisibility(true, false);
trUploadedFileName.Visible = false;
txtOutsideLink.Text = repoVo.Link;
}
btnAdd.Text = Constants.Update.ToString();
}
private bool AddFile(out bool blZeroBalance, out bool blFileSizeExceeded)
{
// If the upload type is file
// We need to see if the adviser has a folder in Repository folder
// Case 1: If not, then encode the adviser id and create a folder with the encoded id
// then create a folder for the repository category within the encoded folder
// then store the encoded adviserID + GUID + file name
// Case 2: If folder exists, check if the category folder exists.
// If not then, create a folder with the category code and store the file as done above.
// If yes, then just store the file as done above.
// Once this is done, store the info in the DB with the file path.
strRepositoryPath = Server.MapPath(strRepositoryPath) + "\\advisor_" + advisorVo.advisorId;
AdvisorBo advBo = new AdvisorBo();
repoBo = new RepositoryBo();
bool blResult = false;
blZeroBalance = false;
blFileSizeExceeded = false;
try
{
// Reading File Upload Control
if (radUploadRepoItem.UploadedFiles.Count != 0)
{
// Put this part under a transaction scope
using (TransactionScope scope1 = new TransactionScope())
{
UploadedFile file = radUploadRepoItem.UploadedFiles[0];
float fileSize = float.Parse(file.ContentLength.ToString()) / 1048576; // Converting bytes to MB
// If space is there to upload file
if (fStorageBalance >= fileSize)
{
if (fileSize <= 20) // If upload file size is less than 10 MB then upload
{
// Check if directory for advisor exists, and if not then create a new directoty
if (!Directory.Exists(strRepositoryPath))
{
Directory.CreateDirectory(strRepositoryPath);
}
strGuid = Guid.NewGuid().ToString();
string newFileName = SaveFileIntoServer(file, strGuid, strRepositoryPath);
repoVo = new RepositoryVo();
repoVo.AdviserId = advisorVo.advisorId;
repoVo.CategoryCode = ddlRCategory.SelectedValue;
repoVo.Description = txtDescription.Text.Trim();
repoVo.HeadingText = txtHeadingText.Text.Trim();
repoVo.IsFile = true;
repoVo.Link = newFileName;
if (Request.QueryString["NCDProspect"] != null)
{
issueId = Convert.ToInt32(Request.QueryString["issueId"].ToString());
}
blResult = repoBo.AddRepositoryItem(repoVo, issueId);
if (blResult)
{
// Once the adding of repository is a success, then update the balance storage in advisor subscription table
fStorageBalance = UpdateAdvisorStorageBalance(fileSize, 0, fStorageBalance);
}
}
else
{
blFileSizeExceeded = true;
}
}
else
{
blZeroBalance = true;
}
scope1.Complete(); // Commit the transaction scope if no errors
}
}
else
{
ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "pageloadscript", "alert('Please select a file to upload!');", true);
}
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
object[] objects = new object[2];
objects[0] = repoVo;
objects[1] = repoBo;
PageException(objects, Ex, "ManageRepository.ascx:AddClick()");
}
return(blResult);
}
public bool UpdateRepositoryItem(RepositoryVo repoVo)
{
Database db;
DbCommand cmdUpdateRepositoryItem;
bool blResult = false;
try
{
db = DatabaseFactory.CreateDatabase("wealtherp");
cmdUpdateRepositoryItem = db.GetStoredProcCommand("sproc_Repository_UpdateRepositoryItem");
db.AddInParameter(cmdUpdateRepositoryItem, "@repoId", DbType.Int32, repoVo.RepositoryId);
db.AddInParameter(cmdUpdateRepositoryItem, "@repoHeadingText", DbType.String, repoVo.HeadingText);
db.AddInParameter(cmdUpdateRepositoryItem, "@repoDescription", DbType.String, repoVo.Description);
if (repoVo.IsFile)
{
// File Update
if (repoVo.Link != String.Empty)
{
db.AddInParameter(cmdUpdateRepositoryItem, "@repoFile", DbType.String, repoVo.Link);
}
else
{
db.AddInParameter(cmdUpdateRepositoryItem, "@repoFile", DbType.String, DBNull.Value);
}
// Set Link parameter as NULL
db.AddInParameter(cmdUpdateRepositoryItem, "@repoLink", DbType.String, DBNull.Value);
}
else
{
// Link Update
if (repoVo.Link != String.Empty)
{
db.AddInParameter(cmdUpdateRepositoryItem, "@repoLink", DbType.String, repoVo.Link);
}
else
{
db.AddInParameter(cmdUpdateRepositoryItem, "@repoLink", DbType.String, DBNull.Value);
}
// Set File parameter as NULL
db.AddInParameter(cmdUpdateRepositoryItem, "@repoFile", DbType.String, DBNull.Value);
}
db.ExecuteNonQuery(cmdUpdateRepositoryItem);
blResult = true;
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "RepositoryDao.cs:UpdateRepositoryItem(RepositoryVo repoVo)");
object[] objects = new object[1];
objects[0] = repoVo;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(blResult);
}
