public static Funding ConvertFundingFromDto(FundingDTO fundingDTO)
{
return(new Funding
{
UserCode = fundingDTO.UserCode,//den einai ths klashs einai tou antikeimenou
ProjectCode = fundingDTO.ProjectCode,
PackageCode = fundingDTO.PackageCode,
NumberOfPackages = Convert.ToInt32(fundingDTO.NumberOfPackages)
});
}
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
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 static List <Funding> LoadFromXlFunding(string pathFunding) // SHEET FUNDING
{
List <Funding> Fundings = new List <Funding>();
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("Funding");
for (int row = 1; row <= sheet.LastRowNum; row++)
{
if (sheet.GetRow(row) != null)
{
FundingDTO fundingdto = new FundingDTO
{
UserCode = sheet.GetRow(row).GetCell(0).StringCellValue,
ProjectCode = sheet.GetRow(row).GetCell(1).StringCellValue,
PackageCode = sheet.GetRow(row).GetCell(2).StringCellValue,
NumberOfPackages = sheet.GetRow(row).GetCell(3).NumericCellValue // vazei double
};
Funding funding = new Funding();
funding = Converter.ConvertFundingFromDto(fundingdto);
Fundings.Add(funding);
}
}
using (StreamWriter file = File.CreateText(pathFunding))
{
JsonSerializer serializer = new JsonSerializer();
//serialize object directly into file stream
serializer.Serialize(file, Fundings);
}
return(Fundings);
////////PANTA TRY CATCH SE OLES TIS ME8ODOUS
}
public string AddFund(FundingDTO fund)
{
return(_context.AddFund(fund));
}
