private void btAddAuthor_Click(object sender, EventArgs e)
{
string AuthorName = tbAuthorName.Text;
string AuthorAddress = tbAuthorAddress.Text;
string AuthorPhone = tbAuthorPhone.Text;
string AuthorEmail = tbAuthorEmail.Text;
string AuthorReg = AuthorName + "" + AuthorPhone + "" + AuthorEmail;
LMS Register = new LMS();
int val = Register.InstertAuthor(AuthorReg, AuthorName, AuthorAddress, AuthorPhone, AuthorEmail);
if (val == 1)
{
MessageBox.Show("New Author Added");
}
}
private void btAddPublisher_Click(object sender, EventArgs e)
{
string PublisherName = tbPublisherName.Text;
string PublisherYear = tbPublisherYear.Text;
string PublisherHouse = tbPublisherHouse.Text;
string PublisherEdition = tbPublisherEdition.Text;
string PublisherReg = PublisherName + "" + PublisherYear + "" + PublisherEdition + "" + PublisherHouse;
LMS Register = new LMS();
int val = Register.InsertPublisher(PublisherReg, PublisherName, PublisherYear, PublisherHouse, PublisherEdition);
if (val == 1)
{
MessageBox.Show("New Publisher Added");
}
}
private void btUpdatePublisher_Click(object sender, EventArgs e)
{
string Reg = cbPublisherRegs.Text;
string Name = tbEditPublisherName.Text;
string Year = tbEditPublisherYear.Text;
string House = tbPublisherEditHouse.Text;
string Edition = tbPublisherEditEdition.Text;
LMS UpdatePublisher = new LMS();
int val = UpdatePublisher.UpdatePublisher(ID, Name, Year, House, Edition);
if (val == 1)
{
MessageBox.Show("Data Updated");
}
}
private void rbEditPublisher_CheckedChanged(object sender, EventArgs e)
{
if (rbEditPublisher.Checked == true)
{
cbPublisherRegs.Visible = true;
lblPublisheEditID.Visible = true;
lblPublisherEditEdition.Visible = true;
lblPublisherEditHouse.Visible = true;
lblPublisherEdition.Visible = false;
lblPublisherEditName.Visible = true;
lblPublisherEditYear.Visible = true;
lblPublisherReg.Visible = false;
lblPublisherName.Visible = false;
lblPublisherYear.Visible = false;
lblPublishingHouse.Visible = false;
btUpdatePublisher.Visible = true;
btAddPublisher.Visible = false;
tbEditPublisherName.Visible = true;
tbEditPublisherYear.Visible = true;
tbPublisherEditEdition.Visible = true;
tbPublisherEditHouse.Visible = true;
tbPublisherEdition.Visible = false;
tbPublisherHouse.Visible = false;
tbPublisherReg.Visible = false;
tbPublisherName.Visible = false;
tbPublisherYear.Visible = false;
LMS UpdatePublisher = new LMS();
DataTable dt = UpdatePublisher.GettingPublisherTable();
DGPublisher.DataSource = dt;
if (DGPublisher.Rows.Count > 1)
{
for (int i = 0; i < DGPublisher.Rows.Count; i++)
{
PublisherReg.Add(Convert.ToString(DGPublisher.Rows[i].Cells[1].Value));
PublisherName.Add(Convert.ToString(DGPublisher.Rows[i].Cells[2].Value));
PublisherYear.Add(Convert.ToString(DGPublisher.Rows[i].Cells[3].Value));
PublisherHouse.Add(Convert.ToString(DGPublisher.Rows[i].Cells[4].Value));
PublisherEdition.Add(Convert.ToString(DGPublisher.Rows[i].Cells[5].Value));
IDs.Add(Convert.ToInt32(DGPublisher.Rows[i].Cells[0].Value));
cbPublisherRegs.Items.Add(PublisherReg[i]);
}
}
}
}
private void rbEditAuthor_CheckedChanged(object sender, EventArgs e)
{
if (rbEditAuthor.Checked == true)
{
lblAuthorName.Visible = false;
lblAuthorReg.Visible = false;
lblAuthorAddress.Visible = false;
lblAuthorPhone.Visible = false;
lblAuthorEmail.Visible = false;
btAddAuthor.Visible = false;
tbAuthorEmail.Visible = false;
tbAuthorReg.Visible = false;
tbAuthorName.Visible = false;
tbAuthorAddress.Visible = false;
tbAuthorPhone.Visible = false;
lblAuthorEditAddress.Visible = true;
lblAuthorEditEmail.Visible = true;
lblAuthorEditReg.Visible = true;
lblAuthorEditName.Visible = true;
lblAuthorEditPhone.Visible = true;
btUpdateAuthor.Visible = true;
tbEditAuthorAddress.Visible = true;
tbEditAuthorEmail.Visible = true;
tbEditAuthorName.Visible = true;
tbEditAuthorPhone.Visible = true;
cbAuthorRegs.Visible = true;
LMS UpdateAuthor = new LMS();
DataTable dt = UpdateAuthor.GettingAuthorTable();
DGAuthor.DataSource = dt;
if (DGAuthor.Rows.Count > 1)
{
for (int i = 0; i < DGAuthor.Rows.Count; i++)
{
AuthorReg.Add(Convert.ToString(DGAuthor.Rows[i].Cells[1].Value));
AuthorName.Add(Convert.ToString(DGAuthor.Rows[i].Cells[2].Value));
AuthorAddress.Add(Convert.ToString(DGAuthor.Rows[i].Cells[3].Value));
AuthorPhone.Add(Convert.ToString(DGAuthor.Rows[i].Cells[4].Value));
AuthorEmail.Add(Convert.ToString(DGAuthor.Rows[i].Cells[5].Value));
IDs.Add(Convert.ToInt32(DGAuthor.Rows[i].Cells[0].Value));
cbAuthorRegs.Items.Add(AuthorReg[i]);
}
}
}
}
private void btSignup_Click(object sender, EventArgs e)
{
LMS Main = new LMS();
string RegistrationID = tbRegisterID.Text;
string UserName = tbUserName.Text;
string Password = tbPassword.Text;
string Name = tbName.Text;
string Phone = tbPhone.Text;
string Email = tbEmail.Text;
string Issued = "No";
string Gender = Convert.ToString(cbGender.SelectedValue);
int val = Main.InsertMember(RegistrationID, Name, UserName, Password, Email, Issued);
if (val == 1)
{
MessageBox.Show("Data Added");
}
}
private void tbLogin_Click(object sender, EventArgs e)
{
#region AdminSelectFromComboBox
if (cbRoleSelect.SelectedIndex == 0)
{
btMemberSignUP.Visible = false;
if (tbUserName.Text == "mawaat" || tbPassword.Text == "mawaat")
{
WelcomeAdmin WelcomForm = new WelcomeAdmin();
this.Hide();
WelcomForm.Show();
}
}
#endregion
#region MemberSelectedFromComboxBox
if (cbRoleSelect.SelectedIndex == 1)
{
WelcomeMember MemberPage = new WelcomeMember();
btMemberSignUP.Visible = true;
string Username = tbUserName.Text;
string Password = tbPassword.Text;
List <string> LoginUserName = new List <string>();
List <string> LoginPassword = new List <string>();
LMS Login = new LMS();
DataTable dt = Login.GettingMemberTable();
dgUserName.DataSource = dt;
if (dgUserName.Rows.Count > 1)
{
for (int i = 0; i < dgUserName.Rows.Count; i++)
{
LoginUserName.Add(Convert.ToString(dgUserName.Rows[i].Cells[3].Value));
LoginPassword.Add(Convert.ToString(dgUserName.Rows[i].Cells[4].Value));
if (Username == LoginUserName[i] && Password == LoginPassword[i])
{
this.Hide();
MemberPage.Show();
}
}
}
}
#endregion
}
private void tbUserName_TextChanged(object sender, EventArgs e)
{
List <string> Usernames = new List <string>();
string UserName = tbUserName.Text;
LMS Main = new LMS();
DataTable dt = Main.GettingMemberTable();
DGMember.DataSource = dt;
if (DGMember.Rows.Count > 1)
{
for (int i = 0; i < DGMember.Rows.Count; i++)
{
Usernames.Add(Convert.ToString(DGMember.Rows[i].Cells[3].Value));
if (UserName == Usernames[0])
{
MessageBox.Show("Username exist kindly change it");
tbUserName.Text = tbUserName.Text + "0";
}
}
}
}
private void btnLogin_Click(object sender, EventArgs e)
{
//String s = "Select * From Profile_Master Where Pro_User_Id='" + textUserID.Text + "' and Pro_User_Password='******'";
SqlDataAdapter sda = new SqlDataAdapter("Select * From Profile_Master Where Pro_User_Id='" + textUserID.Text + "' and Pro_User_Password='******'", con);
DataTable dt = new DataTable();
sda.Fill(dt);
if (dt.Rows.Count == 1)
{
LMS obj = new LMS();
obj.Show();
this.Hide();
con.Close();
}
else
{
MessageBox.Show("Invalid UserID or Password...", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
