public static void AddSponsor(string Username, int ProjectID)
{
if (!User.UsernameExists(Username))
{
throw new ArgumentException("Username wasn't valid");
}
if (Role.GetUserRole(Username) != "Sponsor")
{
throw new ArgumentException("User isn't a sponsor");
}
if (!Project.projectExists(ProjectID))
{
throw new ArgumentException("ProjectID wasn't valid");
}
SponsoredTableAdapter sponsoredAdapter = new SponsoredTableAdapter();
NuRacingDataSet.SponsoredDataTable sponsoredTable = sponsoredAdapter.GetDataByBoth(Username, ProjectID);
if (sponsoredTable.Rows.Count != 0)
{
throw new ArgumentException("User is already sponsoring that project");
}
NuRacingDataSet.SponsoredRow sponsoredRow = sponsoredTable.NewSponsoredRow();
sponsoredRow.User_UserName = Username;
sponsoredRow.Project_UID = ProjectID;
sponsoredTable.AddSponsoredRow(sponsoredRow);
sponsoredAdapter.Update(sponsoredTable);
}
static public void AddWorkType(int ProjectID, string Name)
{
if (!Project.projectExists(ProjectID))
{
throw new ArgumentException("ProjectID wasn't valid");
}
WorkTypeTableAdapter workTypeAdapter = new WorkTypeTableAdapter();
NuRacingDataSet.WorkTypeDataTable WorkTypeTable = workTypeAdapter.GetData();
NuRacingDataSet.WorkTypeRow WorkTypeRow = WorkTypeTable.NewWorkTypeRow();
WorkTypeRow.Project_UID = ProjectID;
WorkTypeRow.WorkType_Name = Name;
WorkTypeRow.WorkType_Status = "Planning";
WorkTypeRow.WorkType_StatusChangedDate = DateTime.Now;
WorkTypeTable.AddWorkTypeRow(WorkTypeRow);
workTypeAdapter.Update(WorkTypeTable);
}
public static void RemoveSponsor(string Username, int ProjectID)
{
if (!User.UsernameExists(Username))
{
throw new ArgumentException("Username wasn't valid");
}
if (!Project.projectExists(ProjectID))
{
throw new ArgumentException("ProjectID wasn't valid");
}
SponsoredTableAdapter sponsoredAdapter = new SponsoredTableAdapter();
NuRacingDataSet.SponsoredDataTable sponsoredTable = sponsoredAdapter.GetDataByBoth(Username, ProjectID);
foreach (NuRacingDataSet.SponsoredRow row in sponsoredTable.Rows)
{
row.Delete();
}
sponsoredAdapter.Update(sponsoredTable);
}
