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); }