public string EditUser(int id, Member member)
{
using (var db = new CrowDoDB())
{
Member m = db.Members.Where(a => a.MemberId == id).FirstOrDefault();
if (m == null)
{
return("user not exists");
}
else
{
m.Username = member.Username;
m.Password = member.Password;
m.Address = member.Address;
m.Email = member.Email;
m.FirstName = member.FirstName;
m.LastName = member.LastName;
db.SaveChanges();
return("updated");
}
}
}
public double GetTotalReceivingFunds(string projectcode)
{
double result = 0.00;
using (var db = new CrowDoDB())
{
ProjectItem p = db.Projects.Where(item => item.ProjectCode.Equals(projectcode)).First();
List <Funding> projectFundings = db.Fundings
.Where(item => item.ProjectCode
.Equals(projectcode)).ToList();
foreach (var projectFunding in projectFundings)
{
var packagecode = projectFunding.PackageCode;
var package = db.PackagesAsking.Where(p => p.PackageCode.Equals(packagecode)).First();
int number = projectFunding.NumberOfPackages;
result += package.Cost * number;
}
p.TotalReceivingFunds = result;
db.SaveChanges();
return(result);
}
}
public string UpdateProject(Project proj)
{
using (var db = new CrowDoDB())
{
Project p = db.Projects.Where(proje => proje.ProjectID == proj.ProjectID).FirstOrDefault();
if (p == null)
{
return("not found");
}
else
{
p.Title = proj.Title;
p.StartDate = proj.StartDate;
p.Packages = proj.Packages;
p.NumOfViews = proj.NumOfViews;
p.Description = proj.Description;
p.EndDate = proj.EndDate;
db.SaveChanges();
return("Project is updated");
}
}
}
public void SaveDTOFundings()
{
Funding dbfund;
using (CrowDoDB db = new CrowDoDB())
{
foreach (FundingDto fund in AllExcellData.FundingList)
{
User user = db.Users.Where(x => x.Code.Equals(fund.User)).FirstOrDefault();
Console.WriteLine(user.Code);
if (user == null)
{
continue;
}
Project project = db.Projects.Where(x => x.Code.Equals(fund.Project)).FirstOrDefault();
Console.WriteLine(project.Code);
if (project == null)
{
continue;
}
Package package = db.Packages.Where(x => x.Code.Equals(fund.Package)).FirstOrDefault();
Console.WriteLine(package.Code);
if (package == null)
{
continue;
}
dbfund = new Funding()
{
NumPackages = fund.Quantity,
User = user,
Package = package,
Project = project
};
db.Fundings.Add(dbfund);
}
db.SaveChanges();
}
}
public string InactiveProject(ProjectItem project)
{
if (project.User.Status == true)
{
using (var db = new CrowDoDB())
{
ProjectItem proj = db.Projects.Where(item => item.Title
.Equals(project.Title)).FirstOrDefault();
if (proj == null)
{
return("NOT exists");
}
proj.Title = "Inactive";
db.SaveChanges();
}
return("The project has been inactive");
}
else
{
return("You are not logged in");
}
}
public string LoadFundingsToDB()
{
string filepath = @"C:\Users\User-SL\OneDrive\Υπολογιστής\fundings.json";
Fundings fundings = new Fundings(); //
using (StreamReader r = new StreamReader(filepath))
{
string json = r.ReadToEnd(); //
fundings.FundingList = JsonConvert.DeserializeObject <List <Funding> >(json); //
}
using (var db = new CrowDoDB()) //
{
fundings.FundingList.ForEach(funding =>
{ //
string projectcode = funding.ProjectCode;
ProjectItem project = db.Projects.Where(p => p.ProjectCode.Equals(projectcode)).First();
if (project != null)
{
funding.ProjectItem = project;
db.Fundings.Add(funding);
}
});
fundings.FundingList.ForEach(funding => //
{
string usercode = funding.UserCode;
User user = db.Users.Where(u => u.UserCode.Equals(usercode)).First();
if (user != null)
{
funding.User = user;
db.Fundings.Add(funding);
}
});
db.SaveChanges();
}
return("data transfered");
}
public string LogIn(string username, string password)
{
using (var db = new CrowDoDB())
{
var user = db.Members.Any(x => x.Username == username);
if (user == true)
{
if (db.Members.Any(x => x.Password == password))
{
return("logged in");
}
else
{
return("wrong password");
}
}
else
{
string name = UsernameOfUser(username);
if (name.Equals("not found"))
{
return("wrong username");
}
else
{
if (password.Equals("123456"))
{
return("Logged in");
}
else
{
return("incorrect password");
}
}
}
}
}
public string UpdateProject(int id, Project project)
{
using (var db = new CrowDoDB())
{
Project p = db.Projects.Where(a => a.ProjectId == id).FirstOrDefault();
if (p == null)
{
return("not exists");
}
else
{
p.Title = project.Title;
p.StartDate = project.StartDate;
p.Packages = project.Packages;
p.NumberOfRequested = project.NumberOfRequested;
p.Category = project.Category;
p.Description = project.Description;
p.EndDate = project.EndDate;
p.Media = project.Media;
db.SaveChanges();
return("updated");
}
}
}
