/// <summary>
/// This method registers the organisers of different society.
/// </summary>
/// <param name="organiser">An object of Organiser Class.</param>
/// <returns>It returns true if the organiser is registered otherwise false.</returns>
public static bool AddNewOrganiser(Organiser organiser)
{
sql = "INSERT INTO Login(Name,Password,SocietyID,Username) VALUES(@name,@password,@societyID,@username)";
Connect.ConnectEMS();
string[] s = { "@name", "@password", "@societyID", "@username" };
try
{
c = new Connect(sql, s, organiser.Name, organiser.Password, (int)organiser.Society, organiser.Username);
return true;
}
catch(Exception ex)
{
return false;
}
}
public static Organiser GetOrganiserDetails(string username,string password)
{
DataTable organiserDataTable = OrganiserRepository.GetOrganiserDetails(username, password);
if (organiserDataTable.Rows.Count > 0)
{
DataRow organiserRow = organiserDataTable.Rows[0];
Organiser organiser = new Organiser
{
Name = organiserRow["Name"].ToString(),
Password = organiserRow["Password"].ToString(),
Username = organiserRow["Username"].ToString(),
Society = (SocietyType)Enum.Parse(typeof(SocietyType),organiserRow["SocietyID"].ToString())
};
return organiser;
}
else
{
return null;
}
}
public static Organiser GetOrganiserDetails(string username, string password)
{
DataTable organiserDataTable = OrganiserRepository.GetOrganiserDetails(username, password);
if (organiserDataTable.Rows.Count > 0)
{
DataRow organiserRow = organiserDataTable.Rows[0];
Organiser organiser = new Organiser
{
Name = organiserRow["Name"].ToString(),
Password = organiserRow["Password"].ToString(),
Username = organiserRow["Username"].ToString(),
Society = (SocietyType)Enum.Parse(typeof(SocietyType), organiserRow["SocietyID"].ToString())
};
return(organiser);
}
else
{
return(null);
}
}
protected void btnRegister_Click(object sender, EventArgs e)
{
Organiser organiser = new Organiser
{
Name = txtbxName.Text,
Username = txtbxUsername.Text,
Password = txtbxPassword.Text,
Society = (SocietyType)Enum.Parse(typeof(SocietyType), drpdwnlstSocieties.SelectedItem.Text)
};
bool organiserRegistered = Organiser.AddNewOrganiser(organiser);
if (organiserRegistered)
{
lblResult.Text = "Registered Successfully";
lblResult.ForeColor = Color.Green;
}
else
{
lblResult.Text = "Error! Please try again";
lblResult.ForeColor = Color.Red;
}
}
public static bool AddNewOrganiser(Organiser organiser)
{
return OrganiserRepository.AddNewOrganiser(organiser);
}
public static bool AddNewOrganiser(Organiser organiser)
{
return(OrganiserRepository.AddNewOrganiser(organiser));
}
