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