/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// public double GetTotalAskingFunds(string projectcode) { double result = 0.00; using (var db = new CrowDoDB()) // { ProjectItem p = db.Projects.Where(item => item.ProjectCode.Equals(projectcode)).First(); string values1 = p.NumberOfRequestedPackages; string[] tokens1 = values1.Split(','); int[] noOfRequestedPacks = Array.ConvertAll <string, int>(tokens1, int.Parse); string values2 = p.PackageCode.ToUpper(); string[] tokens2 = values2.Split(','); int[] costs = new int[tokens2.Length]; List <PackageItemAsking> packages = db.PackagesAsking.ToList(); for (int i = 0; i < tokens2.Length; i++) { PackageItemAsking package = packages.Where(pack => pack.PackageCode.Equals(tokens2[i].Trim())).First(); if (package == null) { Console.WriteLine("The pack was not found"); continue; } costs[i] = package.Cost; result += costs[i] * noOfRequestedPacks[i]; } p.TotalAskingFunds = result; db.SaveChanges(); } return(result); }
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// public string AddFund(FundingDTO fund) { using (var db = new CrowDoDB()) { ProjectItem projectItem = db.Projects.Where(p => p.ProjectCode.Equals(fund.ProjectCode)).First(); if (projectItem == null) { return("no"); } User user = db.Users.Where(u => u.UserCode.Equals(fund.UserCode)).First(); if (user == null) { return("no"); } PackageItemAsking p = db.PackagesAsking.Where(pa => pa.PackageCode.Equals(fund.PackageCode)).First(); if (p == null) { return("no"); } Funding fundEnt = new Funding { User = user, ProjectItem = projectItem, PackageCode = fund.PackageCode, NumberOfPackages = 1, ProjectCode = fund.ProjectCode, UserCode = fund.UserCode }; double totalFund = p.Cost + projectItem.TotalReceivingFunds; if (totalFund <= projectItem.TotalAskingFunds) { projectItem.TotalReceivingFunds = totalFund; db.Fundings.Add(fundEnt); db.SaveChanges(); return("You have funded a new Project"); } else { return("This Project is maxed out on Funds"); } } }
public string LoadPackageItemReceivedToDB() { Packages packages = new Packages(); using (var db = new CrowDoDB()) { packages.PackageReceivedList.ForEach(pack => { int?projectid = pack.ProjectItemId; ProjectItem project = db.Projects.Where(p => p.ProjectItemId.Equals(projectid)).First(); if (project != null) { pack.ProjectItem = project; db.PackagesReceived.Add(pack); } }); packages.PackageReceivedList.ForEach(pack => { int?userid = pack.UserId; User user = db.Users.Where(u => u.UserId.Equals(userid)).First(); if (user != null) { pack.User = user; db.PackagesReceived.Add(pack); } }); packages.PackageReceivedList.ForEach(pack => { int?packageaskingid = pack.PackageItemAskingId; PackageItemAsking packageasking = db.PackagesAsking.Where(p => p.PackageItemAskingId.Equals(packageaskingid)).First(); if (packageasking != null) { pack.PackageItemAsking = packageasking; db.PackagesReceived.Add(pack); } }); db.SaveChanges(); } return("data transfered"); }
public static List <PackageItemAsking> LoadFromXlPackages(string pathPackages) // SHEET PACKAGES { List <PackageItemAsking> Packages = new List <PackageItemAsking>(); XSSFWorkbook hssfwb; using (FileStream file = new FileStream(@"C:\Users\User-SL\Documents\Training\demodataForCrowdo.xlsx", FileMode.Open, FileAccess.Read)) { hssfwb = new XSSFWorkbook(file); } ISheet sheet = hssfwb.GetSheet("Packages"); for (int row = 1; row <= sheet.LastRowNum; row++) { if (sheet.GetRow(row) != null) { PackageDTO packagedto = new PackageDTO { PackageCode = sheet.GetRow(row).GetCell(0).StringCellValue, Title = sheet.GetRow(row).GetCell(1).StringCellValue, Cost = sheet.GetRow(row).GetCell(2).NumericCellValue, Details = sheet.GetRow(row).GetCell(3).StringCellValue, Rewards = sheet.GetRow(row).GetCell(4).StringCellValue }; PackageItemAsking packageItem = new PackageItemAsking(); packageItem = Converter.ConvertPackageFromDto(packagedto); Packages.Add(packageItem); } } using (StreamWriter file = File.CreateText(pathPackages)) { JsonSerializer serializer = new JsonSerializer(); //serialize object directly into file stream serializer.Serialize(file, Packages); } return(Packages); ////////PANTA TRY CATCH SE OLES TIS ME8ODOUS }