private void buttonAdd_Click(object sender, EventArgs e) { Workshop ws = new Workshop(); int OrgID = -1; if (Account.AccountType == 2) { OrgEmployee emp = new OrgEmployee(); OrgID = emp.GetOrgIdByEmpId(Account.AccountId); } else if (Account.AccountType == 1) { OrgID = Account.AccountId; } ws.AddWorkshop( textBoxTitle.Text, dateTimePickerDate.Value, textBoxDuration.Text, textBoxPresenter.Text, int.Parse(numericUpDownSeats.Text), textBoxLocation.Text, richTextBoxDesc.Text, OrgID); MessageBox.Show("Data Inserted successfully."); ClearControls(); }
private void LoadData() { OrgEmployee emp = new OrgEmployee(); int OrgID = Account.AccountId; DataTable data = emp.GetAllEmpInOrg(OrgID); if (data.Rows.Count != 0) { dataGridView1.DataSource = data; } }
private void UpdateBtn_Click(object sender, EventArgs e) { int Id = Account.AccountId; OrgEmployee emp = new OrgEmployee(); int result = emp.UpdateEmpinfo(Id, FNametextBox.Text, LNametextBox.Text, PhonetextBox.Text, EmailtextBox.Text, PasswordtextBox.Text); if (result != 0) { MessageBox.Show("Data Updated Successfully."); MyProfile_Click(); } }
private void buttonAddNewEmp_Click(object sender, EventArgs e) { OrgEmployee oe = new OrgEmployee(); oe.AddEmp(FName_textbox.Text, LName_textbox.Text, Phone_textbox.Text, Email_textbox.Text, Password_textbox.Text, Account.AccountId); MessageBox.Show("Data Inserted successfully."); FName_textbox.Text = ""; LName_textbox.Text = ""; Phone_textbox.Text = ""; Email_textbox.Text = ""; Password_textbox.Text = ""; }
private void ViewAudience_Load(object sender, EventArgs e) { Audience aud = new Audience(); String Query = ""; int OrgID = -1; if (Account.AccountType == 2) { OrgEmployee emp = new OrgEmployee(); OrgID = emp.GetOrgIdByEmpId(Account.AccountId); } else if (Account.AccountType == 1) { OrgID = Account.AccountId; } switch (Account.AccountType) { case 1: Query = "Select DISTINCT Audience.ID,FName,LName,Email,Phone from Audience " + "join Registration on Registration.AudienceID = Audience.ID " + "where Registration.OrganaizerID=" + OrgID; break; case 2: Query = "Select DISTINCT Audience.ID,FName,LName,Email,Phone from Audience " + "join Registration on Registration.AudienceID = Audience.ID " + "where Registration.OrganaizerID=" + OrgID; break; case 3: Query = "Select * from Audience"; break; } DataTable data = aud.GetAllAudience(Query); if (data.Rows.Count != 0) { dataGridView1.DataSource = data; } }
private void Load_workshopTitle(object sender, EventArgs e) { if (Account.AccountType == 2) { OrgEmployee emp = new OrgEmployee(); OrgID = emp.GetOrgIdByEmpId(Account.AccountId); } else if (Account.AccountType == 1) { OrgID = Account.AccountId; } Workshop workshop = new Workshop(); Table = workshop.GetWorkshopTitle(OrgID); foreach (DataRow row in Table.Rows) { TitleList.Items.Add(row["Title"]); } }
private void ViewWorkshop_Load(object sender, EventArgs e) { Workshop ws = new Workshop(); String Query = ""; int OrgID = -1; if (Account.AccountType == 2) { OrgEmployee emp = new OrgEmployee(); OrgID = emp.GetOrgIdByEmpId(Account.AccountId); } else if (Account.AccountType == 1) { OrgID = Account.AccountId; } switch (Account.AccountType) { case 1: case 2: Query = "Select * from Workshop where OrgID=" + OrgID; break; case 3: Query = "Select * from Workshop"; break; } DataTable data = ws.GetAllWorkshop(Query); if (data.Rows.Count != 0) { dataGridView1.DataSource = data; } }