protected void AddUser(object sender, EventArgs e)
{
Group = CurrentUser.AllGroups.Find(x => x.GroupId == int.Parse(groupId.SelectedValue));
if(!IsValidGroup()) return;
Details payingUser = new DetailsCollection((List<Details>)Session[Local.CurrentMembers.ToString()])
[groupMemberList.SelectedIndex];
MembershipUser loggedInUser = new UtilityFunctions().GetThisUser();
if (loggedInUser == null ||
!loggedInUser.IsOnline ||
loggedInUser.ProviderUserKey != payingUser.User.ProviderUserKey)
{
// Enter clicks button.
this.Page.Form.DefaultButton = payButton.UniqueID;
payLogin.Visible = true;
// Databind paying user name in password confirmation screen.
LoadGroupMembers(
payingUserSelection,
new DetailsCollection((List<Details>)Session[Local.CurrentMembers.ToString()]).GetUsers());
payingUserSelection.SelectedIndex = groupMemberList.SelectedIndex;
Session[Local.Group.ToString()] = Group;
return;
}
InsertGroupMember(payingUser);
}
public bool Insert()
{
List<SqlParameter> parameters = new List<SqlParameter>();
AddParameters(parameters);
SqlParameter returnType = AddParameter(Property.RetVal, SqlDbType.Int);
returnType.Direction = ParameterDirection.ReturnValue;
parameters.Add(returnType);
bool success = new UtilityFunctions().Insert(Transactions.InsertMedical, parameters);
MedicalId = (int)returnType.Value;
return success;
}
public Details(MembershipUser user, DataRow row)
: this(user)
{
Extract(row);
DataRowCollection achievementRows = new UtilityFunctions().
RunQuery(
Transactions.GetAchievements,
AddParameter(
Property.DetailsId,
DetailsId)).Rows;
if (achievementRows.Count > 0)
{
new Achievements(this, achievementRows[0]);
}
foreach (DataRow medicalRow in new UtilityFunctions().
RunQuery(
Transactions.GetMedical,
AddParameter(
Property.DetailsId,
DetailsId)).Rows)
{
new Medical(this, medicalRow);
}
foreach(DataRow equipmentRow in new UtilityFunctions().
RunQuery(
Transactions.GetEquipment,
AddParameter(
Property.DetailsId,
DetailsId)).Rows)
{
new Equipment(this, equipmentRow);
}
foreach (DataRow nextOfKinRow in new UtilityFunctions().
RunQuery(
Transactions.GetNextOfKin,
AddParameter(
Property.DetailsId,
DetailsId)).Rows)
{
new NextOfKin(this, nextOfKinRow);
}
}
public bool Insert()
{
List<SqlParameter> parameters = new List<SqlParameter>();
AddParameters(parameters);
SqlParameter returnType = AddParameter(Property.RetVal, SqlDbType.Int);
returnType.Direction = ParameterDirection.ReturnValue;
parameters.Add(returnType);
bool success = new UtilityFunctions().Insert(Transactions.InsertTrainingMethod, parameters);
TrainingMethodId = (int)returnType.Value;
Achievements.TrainingMethodCollection.Add(this);
return success;
}
public void Generate()
{
DataRowCollection rows = new UtilityFunctions().RunQuery(Transactions.GetRunning).Rows;
if (rows.Count == 0)
{
IsRunning = true;
DownTill = DateTime.Now;
Description = string.Empty;
Insert();
return;
}
Extract(rows[0]);
}
public bool Insert()
{
List<SqlParameter> parameters = new List<SqlParameter>();
AddParameters(parameters);
SqlParameter returnType = AddParameter(Property.RetVal, SqlDbType.Int);
returnType.Direction = ParameterDirection.ReturnValue;
parameters.Add(returnType);
bool success = new UtilityFunctions().Insert(Transactions.InsertOccupation, parameters);
OccupationId = (int)returnType.Value;
Details.OccupationCollection.Add(this);
return success;
}
public bool Insert()
{
PlaneCollection.LastUpdated = DateTime.Now;
List<SqlParameter> parameters = new List<SqlParameter>();
AddParameters(parameters);
SqlParameter returnType = AddParameter(Property.RetVal, SqlDbType.Int);
returnType.Direction = ParameterDirection.ReturnValue;
parameters.Add(returnType);
bool success = new UtilityFunctions().Insert(Transactions.InsertFlight, parameters);
FlightId = (int) returnType.Value;
AddFlightsToStaticCollection();
return success;
}
private void Initialise()
{
CurrentUser = new UtilityFunctions().GetUserDetails();
GetRunning();
BindGroup();
SetAdminVisibility();
DataBindings();
ClientScript.RegisterStartupScript(
typeof(Page),
"LoadFlights",
"<script type='text/javascript'>LoadFlights('repeaterContainer');</script>");
ClientScript.RegisterStartupScript(
typeof(Page),
"LoadGroups",
"<script type='text/javascript'>LoadGroups('Groups');</script>");
}
public bool Insert()
{
List<SqlParameter> parameters = new List<SqlParameter>();
AddParameters(parameters);
SqlParameter returnType = AddParameter(Property.RetVal, SqlDbType.Int);
returnType.Direction = ParameterDirection.ReturnValue;
parameters.Add(returnType);
bool success = new UtilityFunctions().Insert(Transactions.InsertDetail, parameters);
DetailsId = (int) returnType.Value;
if (Achievements != null)
{
Achievements.Insert();
}
Medicals.ForEach(x => x.Insert());
Equipments.ForEach(x => x.Insert());
NextOfKins.ForEach(x => x.Insert());
PlaneCollection.Users.Add(this);
return success;
}
public bool Insert(Flight parent)
{
Created = DateTime.Now;
Updated = DateTime.Now;
AddFlight(parent);
List<SqlParameter> parameters = new List<SqlParameter>();
AddParameters(parameters);
SqlParameter returnType = AddParameter(Property.RetVal, SqlDbType.Int);
returnType.Direction = ParameterDirection.ReturnValue;
parameters.Add(returnType);
bool success = new UtilityFunctions().Insert(Transactions.InsertGroup, parameters);
GroupId = (int)returnType.Value;
return success;
}
public bool Insert()
{
List<SqlParameter> parameters = new List<SqlParameter>();
AddParameters(parameters);
SqlParameter returnType = AddParameter(Property.RetVal, SqlDbType.Int);
returnType.Direction = ParameterDirection.ReturnValue;
parameters.Add(returnType);
bool success = new UtilityFunctions().Insert(Transactions.InsertAchievement, parameters);
AchievementsId = (int)returnType.Value;
Ratings.ForEach(x => x.Insert());
return success;
}
