public void load()
{
std_id.Text = student.creatid("student_info", "student_id", "KIST", 5);
btnSave.Text = button;
if (btnSave.Text == "update")
{
std_id.Text = student_info.student_id;
Class.Text = student_info.Class;
fname.Text = student_info.first_name;
lname.Text = student_info.last_name;
DOB.Text = student_info.date_of_birth;
admission_date.Text = student_info.admission_date;
address.Text = student_info.address;
birth_place.Text = student_info.birth_place;
transport.Text = student_info.transport;
phone_no.Text = student_info.phone;
email.Text = student_info.Email;
city.Text = student_info.city;
if (student_info.gender == male.Text)
{
//male.PerformClick();
male.Checked = true;
//female.Checked = false;
}
else if (student_info.gender == female.Text)
{
// female.PerformClick();
// male.Checked = false;
female.Checked = true;
}
}
}
public void load()
{
clear();
datagridview();
code.Text = book.creatid("libary_book_menu", "book_code", "BOOK", 5);
update.Enabled = false;
delete.Enabled = false;
}
private void save_Click(object sender, EventArgs e)
{
if (Class.Text == "" || student_id.Text == "")
{
// MessageBox.Show("fill-up all field");
message.show("Must fill all field", message.AlertType.info);
}
else
{
id newid = new id();
string memberid = newid.creatid("libary_member", "member_id", "libary", 7);
db.InUpDel("INSERT INTO `libary_member`(`member_id`, `class`, `student_id`, `student_name`, `membership_date`) VALUES ('" +
memberid + "','" + Class.Text + "','" + student_id.Text + "','" + student_Name.Text + "','" + membershipDate.Text + "')");
clear();
message.show("Add Successfull", message.AlertType.success);
datagrid();
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (name.Text == "" || designation.Text == "" || qualification.Text == "" || address.Text == "")
{
//MessageBox.Show("fill-up all data");
message.show("Must fill all field", message.AlertType.info);
}
else if (phone_no.TextLength != 10)
{
message.show("Enter atleast 10 number\nin phone number field", message.AlertType.error);
}
else
{
string staff_id = staff.creatid("staff_info", "staff_id", "Staff", 6);
db.InUpDel("INSERT INTO `staff_info`(`staff_id`, `designation`, `name`, `gender`, `address`, `phone`, `qualification`) VALUES ('" +
staff_id + "','" + designation.Text + "','" + name.Text + "','" + rediobutton() + "','" + address.Text + "','" + phone_no.Text + "','" + qualification.Text + "')");
message.show("Save Successfull", message.AlertType.success);
clear();
LoadDataGridView();
}
//MessageBox.Show(myid);
}
