public void Delete(string value)
{
var dataDelete = new PortfolioDataModel();
dataDelete.PortfolioId = int.Parse(value);
PortfolioDataManager.Delete(dataDelete, SessionVariables.RequestProfile);
}
public static int Create(PortfolioDataModel data, RequestProfile requestProfile)
{
var sql = Save(data, "Create", requestProfile);
var newId = DBDML.RunScalarSQL("Portfolio.Insert", sql, DataStoreKey);
return(Convert.ToInt32(newId));
}
public static string Save(PortfolioDataModel data, string action, RequestProfile requestProfile)
{
var sql = "EXEC ";
switch (action)
{
case "Create":
sql += "dbo.PortfolioInsert " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId);
break;
case "Update":
sql += "dbo.PortfolioUpdate " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId);
break;
default:
break;
}
sql = sql + ", " + ToSQLParameter(data, PortfolioDataModel.DataColumns.PortfolioId);
sql = sql + ", " + ToSQLParameter(data, PortfolioDataModel.DataColumns.FundId);
sql = sql + ", " + ToSQLParameter(data, PortfolioDataModel.DataColumns.Name);
sql = sql + ", " + ToSQLParameter(data, PortfolioDataModel.DataColumns.Description);
sql = sql + ", " + ToSQLParameter(data, PortfolioDataModel.DataColumns.SortOrder);
return(sql);
}
private PortfolioViewModel GetViewModel(PortfolioDataModel dataModel)
{
var viewModel = new PortfolioViewModel()
{
Id = dataModel.Id,
FirstName = dataModel.FirstName,
LastName = dataModel.LastName,
PhoneNumber = dataModel.PhoneNumber,
Email = dataModel.Email,
Age = dataModel.Age,
EducationHighSchool = dataModel.EducationHighSchool,
EducationCollege = dataModel.EducationCollege,
Experience = dataModel.Experience,
ExperienceYears = dataModel.ExperienceYears,
AboutMe = dataModel.AboutMe,
Services = dataModel.Services,
Facebook = dataModel.Facebook,
Twitter = dataModel.Twitter,
};
Image img = Image.FromFile(dataModel.ImageLocation);
var barr = ImageToByteArray(img);
viewModel.Image = Convert.ToBase64String(barr);
return(viewModel);
}
public PortfolioDataModel GetById(string value)
{
var dataQuery = new PortfolioDataModel();
dataQuery.PortfolioId = int.Parse(value);
var result = PortfolioDataManager.GetEntityDetails(dataQuery, SessionVariables.RequestProfile, 1);
return(result[0]);
}
public static bool DoesExist(PortfolioDataModel data, RequestProfile requestProfile)
{
var doesExistRequest = new PortfolioDataModel();
doesExistRequest.ApplicationId = data.ApplicationId;
doesExistRequest.FundId = data.FundId;
doesExistRequest.Name = data.Name;
var list = GetEntityDetails(doesExistRequest, requestProfile, 0);
return(list.Count > 0);
}
public void ShouldSaveDataModelToMongoLab()
{
// Arrange
var portfolioDataModel = new PortfolioDataModel();
_mongoDbProvider.Update <PortfolioDataModel>("portfolio", portfolioDataModel).Returns(portfolioDataModel);
// Act
var result = _repositoryUnderTest.Save(portfolioDataModel);
// Assert
Assert.That(result, Is.EqualTo(portfolioDataModel));
}
public async Task <PortfolioDataList> GetPortfilo()
{
PortfolioDataList result = new PortfolioDataList();
PortfolioDataModel data = new PortfolioDataModel()
{
ImageURL = "img/portfolio/cabin.png",
Title = "Log Cabin",
Summary = "Lorem ipsum dolor sit amet, consectetur adipisicing elit. Mollitia neque assumenda ipsam nihil, molestias magnam, recusandae quos quis inventore quisquam velit asperiores, vitae? Reprehenderit soluta, eos quod consequuntur itaque. Nam."
};
result.Portfolios.Add(data);
data = new PortfolioDataModel()
{
ImageURL = "img/portfolio/cake.png",
Title = "Cakse",
Summary = "Lorem ipsum dolor sit amet, consectetur adipisicing elit. Mollitia neque assumenda ipsam nihil, molestias magnam, recusandae quos quis inventore quisquam velit asperiores, vitae? Reprehenderit soluta, eos quod consequuntur itaque. Nam."
};
result.Portfolios.Add(data);
data = new PortfolioDataModel()
{
ImageURL = "img/portfolio/circus.png",
Title = "Circus",
Summary = "Lorem ipsum dolor sit amet, consectetur adipisicing elit. Mollitia neque assumenda ipsam nihil, molestias magnam, recusandae quos quis inventore quisquam velit asperiores, vitae? Reprehenderit soluta, eos quod consequuntur itaque. Nam."
};
result.Portfolios.Add(data);
data = new PortfolioDataModel()
{
ImageURL = "img/portfolio/game.png",
Title = "Game",
Summary = "Lorem ipsum dolor sit amet, consectetur adipisicing elit. Mollitia neque assumenda ipsam nihil, molestias magnam, recusandae quos quis inventore quisquam velit asperiores, vitae? Reprehenderit soluta, eos quod consequuntur itaque. Nam."
};
result.Portfolios.Add(data);
data = new PortfolioDataModel()
{
ImageURL = "img/portfolio/safe.png",
Title = "Safe",
Summary = "Lorem ipsum dolor sit amet, consectetur adipisicing elit. Mollitia neque assumenda ipsam nihil, molestias magnam, recusandae quos quis inventore quisquam velit asperiores, vitae? Reprehenderit soluta, eos quod consequuntur itaque. Nam."
};
result.Portfolios.Add(data);
data = new PortfolioDataModel()
{
ImageURL = "img/portfolio/submarine.png",
Title = "Submarine",
Summary = "Lorem ipsum dolor sit amet, consectetur adipisicing elit. Mollitia neque assumenda ipsam nihil, molestias magnam, recusandae quos quis inventore quisquam velit asperiores, vitae? Reprehenderit soluta, eos quod consequuntur itaque. Nam."
};
result.Portfolios.Add(data);
await Task.CompletedTask;
return(result);
}
public static void Delete(PortfolioDataModel data, RequestProfile requestProfile)
{
const string sql = @"dbo.PortfolioDelete ";
var parameters =
new
{
AuditId = requestProfile.AuditId
, PortfolioId = data.PortfolioId
};
using (var dataAccess = new DataAccessBase(DataStoreKey))
{
dataAccess.Connection.Execute(sql, parameters, commandType: CommandType.StoredProcedure);
}
}
//public
public void UploadPortfolio(PortfolioBindingModel model, string Creator, string imageLocation)
{
try
{
PortfolioDataModel dataModel = new PortfolioDataModel
{
ImageLocation = imageLocation,
FirstName = model.FirstName,
LastName = model.LastName,
PhoneNumber = model.PhoneNumber,
Email = Creator,
Age = model.Age,
EducationHighSchool = model.EducationHighSchool,
EducationCollege = model.EducationCollege,
Experience = model.Experience,
ExperienceYears = model.ExperienceYears,
AboutMe = model.AboutMe,
Services = model.Services,
Facebook = model.FacebookAccount,
Twitter = model.TwitterAccount,
CVLocation = ""
};
using (var context = new PortfolioDatabase())
{
if (context.Portfolio_table != null)
{
if (context.Portfolio_table
.FirstOrDefault(u => u.Email == Creator) == null)
{
context.Portfolio_table.Add(dataModel);
context.SaveChanges();
}
}
else
{
context.Portfolio_table.Add(dataModel);
context.SaveChanges();
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public void UpdatePortfolio(PortfolioBindingModel model, string Creator, string ImageLocation)
{
try
{
PortfolioDataModel dataModel = new PortfolioDataModel
{
ImageLocation = ImageLocation,
FirstName = model.FirstName,
LastName = model.LastName,
PhoneNumber = model.PhoneNumber,
Email = Creator,
Age = model.Age,
EducationHighSchool = model.EducationHighSchool,
EducationCollege = model.EducationCollege,
Experience = model.Experience,
ExperienceYears = model.ExperienceYears,
AboutMe = model.AboutMe,
Services = model.Services,
Facebook = model.FacebookAccount,
Twitter = model.TwitterAccount,
CVLocation = ""
};
using (var context = new PortfolioDatabase())
{
var result = context.Portfolio_table.FirstOrDefault(p => p.Email == Creator);
if (ImageLocation == "")
{
dataModel.ImageLocation = result.ImageLocation;
}
context.Portfolio_table.Remove(result);
context.Portfolio_table.Add(dataModel);
context.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void ShouldSetupPortfolio()
{
var portfolioRepository = new PortfolioRepository(_mongoDbProvider);
const string dataBaseDir = "C:/dev/Phillip Buttrose/Guitars/Web/assets/projects";
Console.WriteLine("MigratePortfolio - purge");
portfolioRepository.Purge();
foreach (var directory in Directory.GetDirectories(dataBaseDir))
{
Console.WriteLine(string.Format("MigratePortfolio - load {0}", directory));
var jsonData = File.ReadAllText(Path.Combine(directory, "data.json"));
var portfolio = JsonConvert.DeserializeObject <Portfolio>(jsonData);
var adoutDataModel = new PortfolioDataModel
{
_id = new ObjectId(),
Category = portfolio.Category,
Classes = portfolio.Classes,
Client = portfolio.Client,
Date = portfolio.Date,
Description = portfolio.Description,
Ref = portfolio.Id,
Register = portfolio.Register,
Title = portfolio.Title,
SubTitle = portfolio.SubTitle,
Thumb = portfolioRepository.UploadFiles(directory, new List <string> {
portfolio.Thumb
}).FirstOrDefault(),
Images = portfolioRepository.UploadFiles(directory, portfolio.Images)
};
Console.WriteLine(string.Format("MigratePortfolio - save {0}", directory));
portfolioRepository.Save(adoutDataModel);
}
}
public IEnumerable <JObject> GetSourceEntityList(string value)
{
var sourceEntity = new JavaScriptSerializer().Deserialize <string>(value);
var listResult = new List <JObject>();
if (sourceEntity == "Portfolio")
{
var dataQuery = new PortfolioDataModel();
var entityItems = PortfolioDataManager.GetEntityDetails(dataQuery, SessionVariables.RequestProfile);
foreach (var obj in entityItems)
{
var jObject = new JObject();
jObject["Text"] = obj.Name;
jObject["EntityKey"] = obj.PortfolioId;
listResult.Add(jObject);
}
}
else if (sourceEntity == "CustodianAccount")
{
var dataQuery = new CustodianAccountDataModel();
var entityItems = CustodianAccountDataManager.GetEntityDetails(dataQuery, SessionVariables.RequestProfile);
foreach (var obj in entityItems)
{
var jObject = new JObject();
jObject["Text"] = obj.Name;
jObject["EntityKey"] = obj.CustodianAccountId;
listResult.Add(jObject);
}
}
return(listResult);
}
public void ShouldRetrieveDataModelFromMongoLab()
{
// Arrange
var newGuid = Guid.NewGuid().ToString().ToUpper();
var query = new QueryDocument {
{ "Ref", new BsonDocument {
{ "$eq", newGuid }
} }
};
var portfolioDataModel = new PortfolioDataModel();
_mongoDbProvider.Get <PortfolioDataModel>("portfolio", query).Returns(portfolioDataModel);
// Act
var result = _repositoryUnderTest.Get(new QueryDocument {
{ "Ref", new BsonDocument {
{ "$eq", newGuid }
} }
});
// Assert
Assert.That(result, Is.EqualTo(portfolioDataModel));
}
public static List <PortfolioDataModel> GetEntityDetails(PortfolioDataModel dataQuery, RequestProfile requestProfile, int returnAuditInfo = BaseDataManager.ReturnAuditInfoOnDetails)
{
const string sql = @"dbo.PortfolioSearch ";
var parameters =
new
{
AuditId = requestProfile.AuditId
, ApplicationId = requestProfile.ApplicationId
, ReturnAuditInfo = returnAuditInfo
, PortfolioId = dataQuery.PortfolioId
, FundId = dataQuery.FundId
, Name = dataQuery.Name
};
List <PortfolioDataModel> result;
using (var dataAccess = new DataAccessBase(DataStoreKey))
{
result = dataAccess.Connection.Query <PortfolioDataModel>(sql, parameters, commandType: CommandType.StoredProcedure).ToList();
}
return(result);
}
public static DataTable Search(PortfolioDataModel data, RequestProfile requestProfile)
{
var list = GetEntityDetails(data, requestProfile, 0);
return(list.ToDataTable());
}
public static void Update(PortfolioDataModel data, RequestProfile requestProfile)
{
var sql = Save(data, "Update", requestProfile);
DBDML.RunSQL("Portfolio.Update", sql, DataStoreKey);
}
public static string ToSQLParameter(PortfolioDataModel data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case PortfolioDataModel.DataColumns.PortfolioId:
if (data.PortfolioId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, PortfolioDataModel.DataColumns.PortfolioId, data.PortfolioId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, PortfolioDataModel.DataColumns.PortfolioId);
}
break;
case PortfolioDataModel.DataColumns.FundId:
if (data.FundId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, PortfolioDataModel.DataColumns.FundId, data.FundId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, PortfolioDataModel.DataColumns.FundId);
}
break;
case PortfolioDataModel.DataColumns.Fund:
if (!string.IsNullOrEmpty(data.Fund))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, PortfolioDataModel.DataColumns.Fund, data.Fund);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, PortfolioDataModel.DataColumns.Fund);
}
break;
case PortfolioDataModel.DataColumns.Name:
if (!string.IsNullOrEmpty(data.Name))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, PortfolioDataModel.DataColumns.Name, data.Name);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, PortfolioDataModel.DataColumns.Name);
}
break;
case PortfolioDataModel.DataColumns.Description:
if (!string.IsNullOrEmpty(data.Description))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, PortfolioDataModel.DataColumns.Description, data.Description);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, PortfolioDataModel.DataColumns.Description);
}
break;
case PortfolioDataModel.DataColumns.SortOrder:
if (data.SortOrder != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, PortfolioDataModel.DataColumns.SortOrder, data.SortOrder);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, PortfolioDataModel.DataColumns.SortOrder);
}
break;
default:
returnValue = BaseDataManager.ToSQLParameter(data, dataColumnName);
break;
}
return(returnValue);
}
