public PasswordDatabaseRepository(string filename)
{
_filename = filename;
//if (File.Exists(filename))
//{
_dataService = new FileDataRepository(filename);
//}
}
public PasswordDatabaseRepository(string filename)
{
_filename = filename;
//if (File.Exists(filename))
//{
_dataService = new FileDataRepository(filename);
//}
}
public void FDRepository_get_data_first_element_equal_csharp()
{
FileSpecs fs = new FileSpecs {
Name = "sysName", Path = @"C:\Users\leonardebarnes\Documents\AuditTestData1.xlsx"
};
FileDataRepository fdr = new FileDataRepository(fs);
FileData fd = fdr.GetAllData();
Assert.IsTrue(fd[0][0] == "csharp");
}
public SaveApplicationDataCommand(
TaskListViewModel taskListViewModel,
DoneListViewModel doneListViewModel,
SettingsViewModel settingsViewModel,
FileDataRepository fileDataRepository,
BackupRepository backupRepository)
{
_taskListViewModel = taskListViewModel;
_doneListViewModel = doneListViewModel;
_settingsViewModel = settingsViewModel;
_fileDataRepository = fileDataRepository;
_backupRepository = backupRepository;
}
public JsonResult FacebookMessage(string amount, string betActionID, HttpPostedFileBase uplFile)
{
int amountInt = 0; Int32.TryParse(amount, out amountInt);
IBetDataRepository _repositoryB = new BetDataRepository();
BetData bet = new BetData();
bet.Username = User.Identity.Name;
bet.User2ID = 0;
bet.BetActionID = Convert.ToInt16(betActionID);
bet.BetValue = amountInt;
string extension = String.Empty;
if (uplFile != null && uplFile.ContentLength > 0)
{
extension = uplFile.FileName.Substring(uplFile.FileName.IndexOf(".") + 1, uplFile.FileName.Length - uplFile.FileName.IndexOf(".") - 1).ToLower();
bet.FileExtension = extension;
}
bet = _repositoryB.Insert(bet);
if (uplFile != null && uplFile.ContentLength > 0)
{
int tmpuserID = WebSecurity.GetUserId(User.Identity.Name);
var fileName = bet.Guid.ToString() + "_" + tmpuserID + "." + extension;//Path.GetFileName(uplFile.FileName);
var path = Path.Combine(Server.MapPath("~/upload/policies/"), fileName);
uplFile.SaveAs(path);
IFileDataRepository repositoryF = new FileDataRepository();
FileData file = new FileData();
file.BetGuid = bet.Guid;
file.FileTypeID = 207; //POLICY
file.FileExtension = extension;
file.FilePath = path;
file.InsertUserID = tmpuserID;
repositoryF.Insert(file);
}
//ZAPIŠEMO HISTORY!!!
new EventData(bet.Guid, WebSecurity.GetUserId(User.Identity.Name), Convert.ToInt16(betActionID)).Add();
string hostName = System.Configuration.ConfigurationManager.AppSettings["HostName"];
return(Json(new { success = true, host = hostName, guid = bet.Guid, action = betActionID }, JsonRequestBehavior.AllowGet));
}
internal async Task <StoreFileResponse> GetOrCreateFileAsync(StoreFileCommand request,
IGuidGenerator guidGenerator, IDbConnection connection)
{
// Load File
var fileAggregateFactory = new FileAggregateFactory();
var fileRepository = new FileRepository();
var fileDataRepository = new FileDataRepository();
FileData fileDataToStore;
if (request.FilePath != null)
{
fileDataToStore =
await fileDataRepository.LoadFileAsync(connection, guidGenerator, fileRepository, request.FilePath);
}
else if (request.Binary != null)
{
fileDataToStore =
await fileDataRepository.LoadFileAsync(connection, guidGenerator, fileRepository, request.Binary);
}
else
{
throw new ArgumentException(nameof(request));
}
if (fileDataToStore.IsNew)
{
// Store File first
await fileRepository.InsertAsync(connection, new FileEntity
{
Binary = fileDataToStore.Binary,
Extension = fileDataToStore.Extension,
FileId = fileDataToStore.FileId,
Md5Hash = fileDataToStore.Md5Hash,
Name = fileDataToStore.Name,
Size = fileDataToStore.Size,
IsImage = fileDataToStore.IsImage
});
var aggregate = fileAggregateFactory.CreateFile(fileDataToStore);
await this.SaveAndDispatchAsync(aggregate);
return(new StoreFileResponse(fileDataToStore.FileId, false));
}
return(new StoreFileResponse(fileDataToStore.FileId, true));
}
public ActionResult PostCreditInfo(string Id, int Type, int NextActivity, int NextStatus, HttpPostedFileBase uplFile)
{
BetDataRepository _repositoryB = new BetDataRepository();
Guid tmpGuid = Guid.Parse(Id);
_repositoryB.VoucherUpdateStatus(tmpGuid, NextStatus);
string extension = String.Empty;
if (uplFile != null && uplFile.ContentLength > 0)
{
extension = uplFile.FileName.Substring(uplFile.FileName.IndexOf(".") + 1, uplFile.FileName.Length - uplFile.FileName.IndexOf(".") - 1).ToLower();
int tmpuserID = WebSecurity.GetUserId(User.Identity.Name);
var fileName = tmpGuid.ToString() + "_" + tmpuserID + "." + extension;//Path.GetFileName(uplFile.FileName);
var path = Path.Combine(Server.MapPath("~/upload/credit-notes/"), fileName);
uplFile.SaveAs(path);
IFileDataRepository repositoryF = new FileDataRepository();
FileData file = new FileData();
file.BetGuid = tmpGuid;
file.FileTypeID = 208; //CREDIT NOTE
file.FileExtension = extension;
file.FilePath = path;
file.InsertUserID = tmpuserID;
repositoryF.Insert(file);
}
//ZAPIŠEMO HISTORY!!!
new EventData(Guid.Parse(Id), WebSecurity.GetUserId(User.Identity.Name), !String.IsNullOrEmpty(extension) ? 209: NextActivity).Add();
List <BetData> bets = new List <BetData>();
bets = _repositoryB.SelectVouchers(WebSecurity.GetUserId(User.Identity.Name));
ViewBag.ActiveLink = 0;
return(RedirectToAction("Index"));
}
public ActionResult SupportMePlaceBet(HttpPostedFileBase uplFile)
{
int amount = 0; Int32.TryParse(Request["hfAmount"], out amount);
string name = Request["tbName"];
string email = Request["tbEmail"];
//DO THE MAGIC HERE
IUserDataRepository _repositoryU = new UserDataRepository();
UserData user = new UserData();
user = _repositoryU.FindByUsername(email);
if (user == null)
{
user = new UserData();
user.FullName = name;
if (String.IsNullOrEmpty(name) || name == null)
{
user.FullName = email;
}
user.Email = email;
user = _repositoryU.Insert(user);
}
IBetDataRepository _repositoryB = new BetDataRepository();
BetData bet = new BetData();
bet.Username = User.Identity.Name;
bet.User2ID = user.UserID;
bet.BetActionID = 115;
bet.BetValue = amount;
string extension = String.Empty;
if (uplFile != null && uplFile.ContentLength > 0)
{
extension = uplFile.FileName.Substring(uplFile.FileName.IndexOf(".") + 1, uplFile.FileName.Length - uplFile.FileName.IndexOf(".") - 1).ToLower();
bet.FileExtension = extension;
}
bet = _repositoryB.Insert(bet);
if (uplFile != null && uplFile.ContentLength > 0)
{
int tmpuserID = WebSecurity.GetUserId(User.Identity.Name);
var fileName = bet.Guid.ToString() + "_" + tmpuserID + "." + extension;//Path.GetFileName(uplFile.FileName);
var path = Path.Combine(Server.MapPath("~/upload/policies/"), fileName);
uplFile.SaveAs(path);
IFileDataRepository repositoryF = new FileDataRepository();
FileData file = new FileData();
file.BetGuid = bet.Guid;
file.FileTypeID = 207; //POLICY
file.FileExtension = extension;
file.FilePath = path;
file.InsertUserID = tmpuserID;
repositoryF.Insert(file);
}
//ZAPIŠEMO HISTORY!!!
new EventData(bet.Guid, WebSecurity.GetUserId(User.Identity.Name), 115).Add();
string hostName = System.Configuration.ConfigurationManager.AppSettings["HostName"];
string inviteUrl = hostName + "Home/Invited/" + bet.Guid + "/" + bet.BetActionID;
string mailBody = "Hi " + name + ",<br><br>";
mailBody += User.Identity.Name + " is hoping you can confirm his driving skills and bet €" + amount.ToString() + " on that.<br><br>";
mailBody += "Join SupportFriend, the social insurance provider and get up to 80% discount on your car insurance, now! <br><br>";
mailBody += inviteUrl;
//Code.BasicMailing.SendEmail(email, "", User.Identity.Name + " needs your support on SupportFriend", mailBody);
return(Content("<li>" + email + "</li>"));
//return RedirectToAction("Index", "Dashboard");
//return View("Support-Me");
}
