/// <summary>
/// This method inserts the details of the participant into the TT database and
/// returns the generated TTID on successful insertion and 0 otherwise.
/// </summary>
/// <param name="participant">An object of Participant class containing the details of the participant.</param>
/// <returns>It returns generated TTID.</returns>
public static int AddNewParticipant(Participant participant)
{
sql = "INSERT INTO Participants(Name,EmailID,ContactNo,PartnerID,StudentNo,Password,GenderID,BranchID,Year,CollegeID,TShirt,Accomodation)" +
"VALUES(@Name,@EmailID,@ContactNo,@PartnerID,@StudentNo,@Password,@GenderID,@BranchID,@Year,@CollegeID,@TShirt,@Accomodation)";
Connect.ConnectTT();
int ttID;
string[] s = { "@Name", "@EmailID", "@ContactNo", "@PartnerID", "@StudentNo", "@Password", "@GenderID", "@BranchID", "@Year", "CollegeID", "TShirt", "Accomodation" };
try
{
c = new Connect(sql, s, participant.Name, participant.EmailID, participant.ContactNo, participant.PartnerID, participant.StudentNo, participant.Password,
((int)participant.Gender), ((int)participant.Branch), participant.Year, participant.CollegeID, participant.WantTShirt, participant.WantAccomodation);
ttID = c.lastId;
}
catch (Exception ex)
{
ttID = 0;
}
return ttID;
}
/// <summary>
/// This method updates the details of the participant.
/// </summary>
/// <param name="participant">An object of Participant type.</param>
/// <returns>It returns true if the details are upadted otherwise false.</returns>
public static bool UpdateParticipantDetails(Participant participant)
{
sql = "UPDATE Participants SET Accomodation = @accomodation,BranchID=@branchID,CollegeID=@collegeID,ContactNo=@contactNo,EmailID=@emailID,"
+ "GenderID=@genderID,Name=@name,PartnerID=@partnerId,Password=@password,StudentNo=@studentNo,TShirt=@tshirt,Year=@year WHERE TTID=@ttid";
string[] s = { "@accomodation", "@branchID", "@collegeID", "@contactNo", "@emailID", "@genderID", "@name", "@partnerID", "@password", "@studentNo", "@tshirt", "@year", "@ttid" };
Connect.ConnectTT();
try
{
c = new Connect(sql, s, participant.WantAccomodation, ((int)participant.Branch), participant.CollegeID, participant.ContactNo, participant.EmailID,
((int)participant.Gender), participant.Name, participant.PartnerID, participant.Password, participant.StudentNo, participant.WantTShirt,
participant.Year, participant.TTID);
return true;
}
catch (Exception ex)
{
return false;
}
}
public static int AddNewParticipant(Participant participant)
{
return ParticipantRepository.AddNewParticipant(participant);
}
private static Participant InitializeParticipant(DataTable participantDataTable)
{
if (participantDataTable.Rows.Count > 0)
{
DataRow row = participantDataTable.Rows[0];
bool tshirt, accomodation;
if (row["TShirt"].ToString() == "1")
tshirt = true;
else
tshirt = false;
if (row["Accomodation"].ToString() == "1")
accomodation = true;
else
accomodation = false;
Participant participant = new Participant
{
Name = row["Name"].ToString(),
TTID = (int)row["TTID"],
PartnerID = (int)row["PartnerID"],
Password = row["Password"].ToString(),
WantTShirt = tshirt,
WantAccomodation = accomodation,
EmailID = row["EmailID"].ToString(),
ContactNo = row["ContactNo"].ToString(),
StudentNo = row["StudentNo"].ToString(),
Gender = (GenderType)Enum.Parse(typeof(GenderType), row["GenderID"].ToString()),
Branch = (BranchType)Enum.Parse(typeof(BranchType), row["BranchID"].ToString()),
Year = int.Parse(row["Year"].ToString()),
CollegeID = int.Parse(row["CollegeID"].ToString())
};
return participant;
}
else
{
return null;
}
}
public static bool UpdateParticipantDetails(Participant participant)
{
return ParticipantRepository.UpdateParticipantDetails(participant);
}
public static int InsertParticipantDetails(Participant participant)
{
return(ParticipantRepository.InsertParticipantDetails(participant));
}
public static bool UpdateParticipantDetails(Participant participant)
{
return(ParticipantRepository.UpdateParticipantDetails(participant));
}
