private void btnLogin_Click(object sender, EventArgs e)
{
userControl11.inputs_ftl_1();
ft_login_form21.input_ftl_2();
string Username, Company_Name, Password, Password_hint, pin_Number;
Username = userControl11.username;
Company_Name = userControl11.companyname;
Password = ft_login_form21.password;
Password_hint = ft_login_form21.passwordhint;
pin_Number = ft_login_form21.pinnumber;
DB_Connection dB_Connection = new DB_Connection();
string qry = "INSERT INTO Usertb (Username,Company_Name,Password,Password_hint,Pin_Number) VALUES ('" + Username + "','" + Company_Name + "','" + Password + "','" + Password_hint + "','" + pin_Number + "')";
string qry2 = "Select * From Usertb";
dB_Connection.InsertData(qry);
DataTable dt = dB_Connection.getDataGrid(qry2);
if (dt.Rows.Count != 0)
{
GMS_1v gMS_1V = new GMS_1v();
gMS_1V.ShowDialog();
Console.WriteLine(qry);
}
}
private void checklogin(string qry)
{
try
{
DB_Connection dB_Connection = new DB_Connection();
DataTable dt = dB_Connection.getDataGrid(qry);
if (dt.Rows.Count == 1)
{
GMS_1v gMS_1V = new GMS_1v();
gMS_1V.Show();
((Form)this.TopLevelControl).Hide();
}
else
{
MessageBox.Show("Your Username or Password is incorrect! Check your username , password and try again!");
Username_tb_lg.Text = "";
Password_tb_lg.Text = "";
}
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void FillGridView(string qry)
{
string members_qry = "SELECT * FROM Members";
DB_Connection dB_Connection = new DB_Connection();
dataGridViewpackages.DataSource = dB_Connection.getDataGrid(qry);
}
private void btn_update_Click(object sender, EventArgs e)
{
MessageBox.Show("Are you sure that you want to update this member ?");
string NIC_forqr = textBoxNIC.Text;
string Name_forqr = textboxName.Text;
string mail_db = memEmail_tb.Text;
Id = textbox_Members_Id.Text;
string NIC = textBoxNIC.Text;
string name = textboxName.Text;
string Gender = textboxGender.Text;
string Body_Type = textboxBodyType.Text;
string Email = memEmail_tb.Text;
string Address = richTextBoxAddress.Text;
string Mobile_Number = textboxMobileNumber.Text;
string Health_Condition = richTextBoxHealthCondition.Text;
string Emergency_Contact_Name = textboxEmergencyContactName.Text;
string Emergency_Contact_Number = (textboxEmergencyContactPhoneNumber.Text);
string qrimgpath = Application.StartupPath.Substring(0, Application.StartupPath.Length - 10) + "\\Images\\Member QR\\" + Id + "memQR.jpg";
DB_Connection dB_Connection = new DB_Connection();
string query = "UPDATE Members SET NICorDL='" + NIC + "', MemberName='" + name + "' , Gender='" + Gender + "' , Body_Type='" + Body_Type + "' , Address='" + Address + "' , Mobile_Number='" + Mobile_Number + "' , Health_Condition='" + Health_Condition + "' , Emergency_Contact_Name='" + Emergency_Contact_Name + "' , Emergency_Contact_Number='" + Emergency_Contact_Number + "', Member_dp='" + Member_dp_path + "' , Email = '" + Email + "' , QR_img_path='" + qrimgpath + "' WHERE Id='" + Id + "'";
dB_Connection.update(query);
if (NIC_forqr != NIC || Name_forqr != name || Email != mail_db)
{
QRmailSender qRmailSender = new QRmailSender();
string qrsubject = (Id.ToString() + NIC + name).ToString();
qRmailSender.qrgen(qrsubject, qrimgpath);
qRmailSender.Emailgen(name, "member");
qRmailSender.Emailsend(Email, qrimgpath);
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
MessageBox.Show("Are you sure that you want to Delete this member details ?");
Id = textbox_Staff_Members_Id.Text;
DB_Connection dB_Connection = new DB_Connection();
string query = "DELETE FROM Staff_Member Where Id='" + Id + "'";
dB_Connection.Delete(query);
}
private void btnDelete_emod_Click(object sender, EventArgs e)
{
MessageBox.Show("Are you sure that you want to Delete this Equipment details ?");
equipId = txtmodeid.Text;
DB_Connection dB_Connection = new DB_Connection();
string query = "DELETE FROM Equipment Where Equip_ID='" + equipId + "'";
dB_Connection.Delete(query);
}
public void Emailgen(string name, string type)
{
DB_Connection dB_Connection = new DB_Connection();
string qry = "Select Company_Name from Usertb";
SqlDataReader dr = dB_Connection.getData(qry);
dr.Read();
subject = dr["Company_Name"].ToString();
body = "Welcome to " + subject + " Hi " + name + "!" + " You are now " + type + " of " + subject + "Now you can mark your attendence using this QR code";
}
private void button1_Click(object sender, EventArgs e)
{
string name = txtequipname.Text;
string type = txtequiptype.Text;
string price = txtamount.Text;
DB_Connection dB_Connection = new DB_Connection();
string insertqry = "INSERT INTO Equipment (Equip_Name,Equip_Type,Equip_Amount,Equip_img1,Equip_img2,Equip_img3,Equip_img4) VALUES('" + name + "','" + type + "','" + price + "','" + equip_imgpath1 + "','" + equip_imgpath2 + "','" + equip_imgpath3 + "','" + equip_imgpath4 + "')";
Console.WriteLine(insertqry);
dB_Connection.InsertData(insertqry);
}
private void textbox_Members_Id_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
if (textbox_Members_Id.Text != "")
{
try
{
Id = textbox_Members_Id.Text;
int id = int.Parse(textbox_Members_Id.Text);
DB_Connection dB_Connection = new DB_Connection();
SqlConnection con = new SqlConnection(dB_Connection.connectionstring);
con.Open();
string qry = "SELECT * FROM Members Where Id=@Id ";
SqlCommand cmd = new SqlCommand(qry, con);
cmd.Parameters.AddWithValue("@Id", id);
SqlDataReader da = dB_Connection.getDatausing_a(cmd);
if (da.HasRows)
{
while (da.Read())
{
textBoxNIC.Text = da.GetValue(1).ToString();
textboxName.Text = da.GetValue(2).ToString();
textboxGender.Text = da.GetValue(4).ToString();
textboxBodyType.Text = da.GetValue(5).ToString();
richTextBoxAddress.Text = da.GetValue(6).ToString();
textboxMobileNumber.Text = da.GetValue(7).ToString();
richTextBoxHealthCondition.Text = da.GetValue(8).ToString();
textboxEmergencyContactName.Text = da.GetValue(9).ToString();
textboxEmergencyContactPhoneNumber.Text = da.GetValue(10).ToString();
pictureBox1.Image = new Bitmap(da.GetValue(11).ToString());
Member_dp_path = da.GetValue(11).ToString();
memEmail_tb.Text = da.GetValue(12).ToString();
}
con.Close();
}
else
{
MessageBox.Show("There is no member by member id:" + id + "\nTry again with another Id");
}
}
catch (SqlException ex)
{
MessageBox.Show(ex.ToString());
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
}
public reset_admin()
{
InitializeComponent();
string idqry = "SELECT * FROM Usertb WHERE Id = (SELECT MAX(Id) from Usertb ) ";
DB_Connection dB_Connection = new DB_Connection();
SqlDataReader dr = dB_Connection.getData(idqry);
if (dr.HasRows)
{
dr.Read();
string id = dr["Id"].ToString();
}
}
private void btnupdate_emod_Click(object sender, EventArgs e)
{
MessageBox.Show("Are you sure that you want to update this Equipment ?");
equipId = txtmodeid.Text;
string Name = txtmodename.Text;
string Type = txtmodetype.Text;
string Amount = txtmodeamount.Text;
DB_Connection dB_Connection = new DB_Connection();
string query = "UPDATE Equipment SET Equip_Name='" + Name + "', Equip_Type='" + Type + "', Equip_Amount='" + Amount + "', Equip_img1='" + equip_imgpath1 + "',Equip_img2='" + equip_imgpath2 + "',Equip_img3='" + equip_imgpath3 + "',Equip_img4='" + equip_imgpath4 + "' WHERE Equip_ID='" + equipId + "'";
dB_Connection.update(query);
}
private void fillpackagecombo()
{
string qry = "Select * from Packages";
DB_Connection dB_Connection = new DB_Connection();
SqlDataReader dr = dB_Connection.getData(qry);
if (dr.HasRows)
{
while (dr.Read())
{
string pack_name = dr["Package_Name"].ToString();
Package_cb.Items.Add(pack_name);
}
}
}
private void dataGridView_Equipments_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
Equipment_View_dialoguebox eVD = new Equipment_View_dialoguebox();
dataGridView_Equipments.CurrentRow.Selected = true;
string id = dataGridView_Equipments.Rows[e.RowIndex].Cells["Equip_ID"].Value.ToString();
eVD.lbl_eid.Text = dataGridView_Equipments.Rows[e.RowIndex].Cells["Equip_ID"].Value.ToString();
eVD.lbl_ename.Text = dataGridView_Equipments.Rows[e.RowIndex].Cells["Equip_Name"].Value.ToString();
eVD.lbl_etype.Text = dataGridView_Equipments.Rows[e.RowIndex].Cells["Equip_Type"].Value.ToString();
eVD.lbl_eprice.Text = dataGridView_Equipments.Rows[e.RowIndex].Cells["Equip_Amount"].Value.ToString();
string qry = "SELECT Equip_img1,Equip_img2,Equip_img3,Equip_img4 From Equipment Where Equip_ID = '" + id + "' ";
Console.WriteLine(qry);
DB_Connection dB_Connection = new DB_Connection();
SqlDataReader dr = dB_Connection.getData(qry);
if (dr.HasRows)
{
dr.Read();
string Equip_img1 = dr["Equip_img1"].ToString();
string Equip_img2 = dr["Equip_img2"].ToString();
string Equip_img3 = dr["Equip_img3"].ToString();
string Equip_img4 = dr["Equip_img4"].ToString();
if (Equip_img1 != null)
{
eVD.equippicbox1.Image = new Bitmap(Equip_img1);
}
if (Equip_img2 != null)
{
eVD.equippicbox2.Image = new Bitmap(Equip_img2);
}
if (Equip_img3 != null)
{
eVD.equippicbox3.Image = new Bitmap(Equip_img3);
}
if (Equip_img4 != null)
{
eVD.equippicbox4.Image = new Bitmap(Equip_img4);
}
}
eVD.ShowDialog();
}
private void btnAP_Add_Click(object sender, EventArgs e)
{
string package_name, duration, fee, qry;
package_name = Package_Name_tb.Text;
duration = Duration_tb.Text;
fee = Fee_tb.Text;
qry = "INSERT INTO Packages(Package_Name,Duration,Fee) VALUES('" + package_name + "','" + duration + "','" + fee + "')";
DB_Connection dB_Connection = new DB_Connection();
DialogResult dialog = MessageBox.Show("Are you sure that you want to add this package?", "Add Package", MessageBoxButtons.YesNo);
if (dialog == DialogResult.Yes)
{
dB_Connection.InsertData(qry);
}
}
private void dataGridView_StaffMembers_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
Staff_Member_View_dialogbox smv_d = new Staff_Member_View_dialogbox();
dataGridView_StaffMembers.CurrentRow.Selected = true;
smv_d.lbl_smid_v.Text = dataGridView_StaffMembers.Rows[e.RowIndex].Cells["Id"].Value.ToString();
string id = dataGridView_StaffMembers.Rows[e.RowIndex].Cells["Id"].Value.ToString();
string qry = "Select Capture_path,QR_img_path from Staff_Member Where Id='" + id + "'";
DB_Connection dB_Connection = new DB_Connection();
SqlDataReader dr = dB_Connection.getData(qry);
dr.Read();
string Capture_path = dr["Capture_path"].ToString();
string QR_img_path = dr["QR_img_path"].ToString();
if (Capture_path != null || Capture_path != "")
{
smv_d.Staff_member_dp_picturebox.Image = new Bitmap(Capture_path);
}
if (QR_img_path != null)
{
smv_d.Staff_member_qr_picturebox.Image = new Bitmap(QR_img_path);
}
smv_d.lbl_nod_v.Text = dataGridView_StaffMembers.Rows[e.RowIndex].Cells["NIC"].Value.ToString();
smv_d.lbl_smn_v.Text = dataGridView_StaffMembers.Rows[e.RowIndex].Cells["Name"].Value.ToString();
smv_d.lbl_jt_v.Text = dataGridView_StaffMembers.Rows[e.RowIndex].Cells["Job_Type"].Value.ToString();
smv_d.lbl_pq_v.Text = dataGridView_StaffMembers.Rows[e.RowIndex].Cells["Professional_qualifications"].Value.ToString();
smv_d.lbl_dob_v.Text = dataGridView_StaffMembers.Rows[e.RowIndex].Cells["DOB"].Value.ToString();
smv_d.lbl_jd_v.Text = dataGridView_StaffMembers.Rows[e.RowIndex].Cells["Joined_date"].Value.ToString();
smv_d.lbl_al_v.Text = dataGridView_StaffMembers.Rows[e.RowIndex].Cells["Address_living"].Value.ToString();
smv_d.lbl_mnpu_v.Text = dataGridView_StaffMembers.Rows[e.RowIndex].Cells["Mobile_no_public"].Value.ToString();
smv_d.lbl_mnpri_v.Text = dataGridView_StaffMembers.Rows[e.RowIndex].Cells["Mobile_no_private"].Value.ToString();
smv_d.lbl_ha_v.Text = dataGridView_StaffMembers.Rows[e.RowIndex].Cells["Home_address"].Value.ToString();
smv_d.lbl_ecnum_v.Text = dataGridView_StaffMembers.Rows[e.RowIndex].Cells["Emergency_Contact_Name"].Value.ToString();
smv_d.lbl_ecn_v.Text = dataGridView_StaffMembers.Rows[e.RowIndex].Cells["Emergency_Contact_Number"].Value.ToString();
smv_d.lbl_mail_v.Text = dataGridView_StaffMembers.Rows[e.RowIndex].Cells["Email"].Value.ToString();
smv_d.lbl_gender_v.Text = dataGridView_StaffMembers.Rows[e.RowIndex].Cells["Gender"].Value.ToString();
smv_d.ShowDialog();
}
private void textBox1_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
if (memberid_tb.Text != "")
{
try
{
int id = int.Parse(memberid_tb.Text);
DB_Connection dB_Connection = new DB_Connection();
SqlConnection con = new SqlConnection(dB_Connection.connectionstring);
con.Open();
string qry = "SELECT * FROM Members Where Id=@Id ";
SqlCommand cmd = new SqlCommand(qry, con);
cmd.Parameters.AddWithValue("@Id", id);
SqlDataReader da = dB_Connection.getDatausing_a(cmd);
if (da.HasRows)
{
while (da.Read())
{
lbl_mname.Text = da.GetValue(2).ToString();
lbl_package_name.Text = da.GetValue(15).ToString();
string qrypack = "Select * From Packages where Package_Name='" + lbl_package_name.Text + "'";
DB_Connection dB_Connection1 = new DB_Connection();
SqlDataReader da2 = dB_Connection1.getData(qrypack);
da2.Read();
lbl_fee.Text = da2["Fee"].ToString();
}
con.Close();
}
else
{
MessageBox.Show("There is no Staff Member by member id:" + id + "\nTry again with another Id");
}
}
catch (SqlException ex)
{
MessageBox.Show(ex.ToString());
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
}
private void button1_Click_1(object sender, EventArgs e)
{
string type = "StaffMember";
string NIC_No = txt_boxNIC.Text;
string name = txt_boxName.Text;
string Dob = this.dateTimePickerDOB.Text;
string joinDte = this.dateTimePickerJoinedDate.Text;
string jobType = txt_boxJobtype.Text;
string homeAdrss = txt_boxHomeAddress.Text;
string Adrs_Lvg = txt_boxAddressLivg.Text;
string PrivtNo = txt_boxPN.Text;
string PubNo = txt_boxPubN.Text;
string EmergConName = txt_boxEmergencyContactNme.Text;
string EmergConNo = (txt_boxEmergencyContactPNo.Text);
string ProQuli = txt_boxProQuli.Text;
string Gendr = txt_boxGender.Text;
string Email = txt_boxMail.Text;
string qrimgpath = Application.StartupPath.Substring(0, Application.StartupPath.Length - 10) + "\\Images\\Staff QR\\" + staffmem_id + "memQR.jpg";
string qrsubject = (staffmem_id + NIC_No + name).ToString();
DB_Connection dB_Connection = new DB_Connection();
string insrtqry = "INSERT INTO Staff_Member (Capture_path,QR_img_path,NIC,Name,Gender,Job_Type,Professional_qualifications,DOB,Joined_date,Address_Living,Mobile_no_public,Mobile_no_private,Home_Address,Emergency_Contact_Name,Emergency_Contact_Number,Email) VALUES('" + staffmem_imgpath + "','" + NIC_No + "','" + name + "','" + Gendr + "','" + jobType + "','" + ProQuli + "','" + Dob + "','" + joinDte + "','" + Adrs_Lvg + "','" + PubNo + "','" + PrivtNo + "','" + homeAdrss + "','" + EmergConName + "','" + EmergConNo + "','" + Email + "' )";
Console.WriteLine(insrtqry);
dB_Connection.InsertData(insrtqry);
QRmailSender qRmailSender = new QRmailSender();
qRmailSender.qrgen(qrsubject, qrimgpath);
if (Email != null)
{
DialogResult dialog = MessageBox.Show("This Staff member has not provided an Email Address! So, You can print the QR code. Do you want to print it ?", "Print QR Code", MessageBoxButtons.YesNo);
if (dialog == DialogResult.Yes)
{
string filename = qrimgpath;
var p = new Process();
p.StartInfo.FileName = filename;
p.StartInfo.Verb = "print";
p.Start();
}
}
else
{
qRmailSender.Emailgen(name, type);
qRmailSender.Emailsend(Email, qrimgpath);
}
}
private void btn_update_Click(object sender, EventArgs e)
{
DialogResult dialog = MessageBox.Show("Are you sure that you want to change this?", "Reset Administrator", MessageBoxButtons.YesNo);
if (dialog == DialogResult.Yes)
{
string Username = un_tb.Text;
string Company_name = cn_tb.Text;
string Password = p_tb.Text;
string Password_Hint = ph_tb.Text;
string Pin_Number = pn_tb.Text;
string Email = e_tb.Text;
string qry = "UPDATE Usertb SET Username='******', Company_Name='" + Company_name + "', Password='******', Password_Hint='" + Pin_Number + "' WHERE Id='" + id + "'";
DB_Connection dB_Connection = new DB_Connection();
dB_Connection.update(qry);
}
}
public Addstaff()
{
InitializeComponent();
string idqry = "SELECT * FROM Staff_Member WHERE Id = (SELECT MAX(Id) from Staff_Member ) ";
DB_Connection dB_Connection = new DB_Connection();
SqlDataReader dr = dB_Connection.getData(idqry);
if (dr.HasRows)
{
dr.Read();
string num = dr["Id"].ToString();
int num_1 = int.Parse(num);
labelSMID.Text = "Member id : " + (num_1 + 1).ToString();
staffmem_id = num_1 + 1;
}
else
{
labelSMID.Text = 1.ToString();
}
}
public AddEquipments()
{
InitializeComponent();
string idqry = "SELECT * FROM Equipment WHERE Equip_ID = (SELECT MAX(Equip_ID) from Equipment ) ";
DB_Connection dB_Connection = new DB_Connection();
SqlDataReader dr = dB_Connection.getData(idqry);
if (dr.HasRows)
{
dr.Read();
string num = dr["Equip_ID"].ToString();
int num_1 = int.Parse(num);
labelEID.Text = (num_1 + 1).ToString();
equip_id = num_1 + 1;
}
else
{
labelEID.Text = "1";
}
}
public AddMembers()
{
InitializeComponent();
fillpackagecombo();
Gender_cb.Items.AddRange(new object[] { "Male", "Female" });
string idqry = "SELECT * FROM Members WHERE Id = (SELECT MAX(Id) from Members ) ";
DB_Connection dB_Connection = new DB_Connection();
SqlDataReader dr = dB_Connection.getData(idqry);
if (dr.HasRows)
{
dr.Read();
string num = dr["Id"].ToString();
int num_1 = int.Parse(num);
labelMID.Text = "Member id : " + (num_1 + 1).ToString();
mem_id = num_1 + 1;
}
else
{
labelMID.Text = 1.ToString();
}
}
private void btn_update_Click(object sender, EventArgs e)
{
MessageBox.Show("Are you sure that you want to update this member ?");
Id = textbox_Staff_Members_Id.Text;
string NIC_forqr = textBoxNIC.Text;
string Name_forqr = textboxName.Text;
string NIC = textBoxNIC.Text;
string Name = textboxName.Text;
string JobType = textboxJobType.Text;
string p_qualifications = txt_boxProQuli.Text;
string Address_living = txt_boxAddressLivg.Text;
string PN_private = txt_boxPN_private.Text;
string PN_public = txt_boxPubN.Text;
string Home_Address = home_Address_tb.Text;
string EmergencyContactName = txt_boxEmergencyContactNme.Text;
string EmergencyContactPN = txt_boxEmergencyContactPNo.Text;
string Email = txt_boxMail.Text;
string Gender = txt_boxGender.Text;
string qrimgpath = Application.StartupPath.Substring(0, Application.StartupPath.Length - 10) + "\\Images\\Member QR\\" + Id + "memQR.jpg";
DB_Connection dB_Connection = new DB_Connection();
string query = "UPDATE Staff_Member SET Capture_path ='" + Staff_Member_dp_path + "', QR_img_path='" + qrimgpath + "', NIC = '" + NIC + "', Name = '" + Name + "' , Job_Type='" + JobType + "', Professional_qualifications='" + p_qualifications + "', Address_living='" + Address_living + "', Mobile_no_public='" + PN_public + "', Mobile_no_private='" + PN_private + "', Home_address='" + Email + "', Emergency_Contact_Name='" + EmergencyContactName + "', Emergency_Contact_Number='" + EmergencyContactPN + "', Email='" + Email + "', Gender='" + Gender + "' ";
dB_Connection.update(query);
QRmailSender qRmailSender = new QRmailSender();
if (NIC_forqr != NIC || Name_forqr != Name || Email != mail_db)
{
string qrsubject = (Id.ToString() + NIC + Name).ToString();
qRmailSender.qrgen(qrsubject, qrimgpath);
qRmailSender.Emailgen(Name, "member");
qRmailSender.Emailsend(Email, qrimgpath);
}
}
private void btn_show_pwhint_Click(object sender, EventArgs e)
{
try
{
DB_Connection dB_Connection = new DB_Connection();
string qry = "Select Password_Hint From Usertb";
SqlDataReader dr = dB_Connection.getData(qry);
if (dr.HasRows)
{
dr.Read();
pw_hint_lbl.Text = "Password Hint is : " + dr["Password_Hint"].ToString();
pw_hint_lbl.Show();
}
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public Login()
{
InitializeComponent();
DB_Connection dB_Connection = new DB_Connection();
string qry = "Select * from Usertb";
DataTable dt = dB_Connection.getDataGrid(qry);
if (dt.Rows.Count != 0)
{
loginForm1.Show();
}
else
{
this.panel1.Controls.Clear();
ft_wrapper ft_Wrapper = new ft_wrapper()
{
Dock = DockStyle.Fill, TopLevel = false, TopMost = true
};
ft_Wrapper.FormBorderStyle = FormBorderStyle.None;
this.panel1.Controls.Add(ft_Wrapper);
ft_Wrapper.Show();
}
}
private void FillGridView(string qry)
{
DB_Connection dB_Connection = new DB_Connection();
dataGridView_Members.DataSource = dB_Connection.getDataGrid(qry);
}
private void button1_Click(object sender, EventArgs e)
{
string type = "Member";
string NIC = textBoxNIC.Text;
string name = textboxName.Text;
string DOB = this.dateTimePicker1.Text;
string Gender = Gender_cb.Text;
string Body_Type = textboxBodyType.Text;
string Address = richTextBoxAddress.Text;
string Mobile_Number = textboxMobileNumber.Text;
string Health_Condition = richTextBoxHealthCondition.Text;
string Emergency_Contact_Name = textboxEmergencyContactName.Text;
string Emergency_Contact_Number = (textboxEmergencyContactPhoneNumber.Text);
string joineddate = DateTime.Now.Date.ToString("MM/dd/yyyy");
string Email = memEmail_tb.Text;
string qrimgpath = Application.StartupPath.Substring(0, Application.StartupPath.Length - 10) + "\\Images\\Member QR\\" + mem_id + "memQR.jpg";
Console.WriteLine(qrimgpath);
string packageName = Package_cb.Text;
string qrsubject = (mem_id + NIC + name).ToString();
if (packageName != "")
{
//Insert Data to members table
DB_Connection dB_Connection = new DB_Connection();
string insertqry = "INSERT INTO Members(NICorDL,MemberName,DOB,Gender,Body_Type,Address,Mobile_Number,Health_Condition,Emergency_Contact_Name,Emergency_Contact_Number,Member_dp,Email,QR_img_path,Joined_Date,Package_name) VALUES('" + NIC + "','" + name + "','" + DOB + "','" + Gender + "','" + Body_Type + "','" + Address + "'," + Mobile_Number + ",'" + Health_Condition + "','" + Emergency_Contact_Name + "','" + Emergency_Contact_Number + "','" + mem_imgpath + "','" + Email + "','" + qrimgpath + "','" + joineddate + "','" + packageName + "')";
dB_Connection.InsertData(insertqry);
//get data from package table
DB_Connection dB_Connection1 = new DB_Connection();
string qrypack = "Select * From Packages where Package_Name='" + packageName + "'";
SqlDataReader da2 = dB_Connection1.getData(qrypack);
da2.Read();
//calculation
string amount = da2["Fee"].ToString();
DateTime date = DateTime.Now.Date;
string days = da2["Duration"].ToString();
Console.WriteLine(date.AddDays(int.Parse(days)));
string due_date = date.AddDays(int.Parse(days)).ToString("MM/dd/yyyy");
//Insert Data to Payments table
DB_Connection dB_Connection2 = new DB_Connection();
string qryinsertpay = "INSERT INTO Payment(mem_id,Name,package,due_date,amount,paid) VALUES('" + mem_id + "','" + name + "','" + packageName + "','" + due_date + "','" + amount + "','0')";
Console.WriteLine(qryinsertpay);
dB_Connection2.InsertData(qryinsertpay);
QRmailSender qRmailSender = new QRmailSender();
qRmailSender.qrgen(qrsubject, qrimgpath);
if (Email != null)
{
DialogResult dialog = MessageBox.Show("This member has not provided an Email Address! So, You can print the QR code. Do you want to print it ?", "Print QR Code", MessageBoxButtons.YesNo);
if (dialog == DialogResult.Yes)
{
string filename = qrimgpath;
var p = new Process();
p.StartInfo.FileName = filename;
p.StartInfo.Verb = "print";
p.Start();
}
}
else
{
qRmailSender.Emailgen(name, type);
qRmailSender.Emailsend(Email, qrimgpath);
}
}
else
{
MessageBox.Show("Select package or check if you have added packages to the system!", "Warning!");
}
}
private void txtmodeid_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
if (txtmodeid.Text != "")
{
try
{
equipId = txtmodeid.Text;
int id = int.Parse(txtmodeid.Text);
DB_Connection dB_Connection = new DB_Connection();
SqlConnection con = new SqlConnection(dB_Connection.connectionstring);
con.Open();
string qry = "SELECT * FROM Equipment Where Equip_ID=@Id ";
SqlCommand cmd = new SqlCommand(qry, con);
cmd.Parameters.AddWithValue("@Id", id);
SqlDataReader da = dB_Connection.getDatausing_a(cmd);
if (da.HasRows)
{
while (da.Read())
{
txtmodename.Text = da.GetValue(1).ToString();
txtmodetype.Text = da.GetValue(2).ToString();
txtmodeamount.Text = da.GetValue(3).ToString();
if (da.GetValue(5).ToString() != null)
{
picbmodequip1.Image = new Bitmap(da.GetValue(5).ToString());
equip_imgpath1 = da.GetValue(5).ToString();
}
if (da.GetValue(6).ToString() != null)
{
picbmodequip2.Image = new Bitmap(da.GetValue(6).ToString());
equip_imgpath2 = da.GetValue(6).ToString();
}
if (da.GetValue(7).ToString() != null)
{
picbmodequip3.Image = new Bitmap(da.GetValue(7).ToString());
equip_imgpath3 = da.GetValue(7).ToString();
}
if (da.GetValue(8).ToString() != null)
{
picbmodequip4.Image = new Bitmap(da.GetValue(8).ToString());
equip_imgpath4 = da.GetValue(8).ToString();
}
}
con.Close();
}
else
{
MessageBox.Show("There is no Equipment by id:" + id + "\nTry again with another Id");
}
}
catch (SqlException ex)
{
MessageBox.Show(ex.ToString());
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
}
private void textbox_Members_Id_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
if (textbox_Staff_Members_Id.Text != "")
{
try
{
Id = textbox_Staff_Members_Id.Text;
int id = int.Parse(textbox_Staff_Members_Id.Text);
DB_Connection dB_Connection = new DB_Connection();
SqlConnection con = new SqlConnection(dB_Connection.connectionstring);
con.Open();
string qry = "SELECT * FROM Staff_Member Where Id=@Id ";
SqlCommand cmd = new SqlCommand(qry, con);
cmd.Parameters.AddWithValue("@Id", id);
SqlDataReader da = dB_Connection.getDatausing_a(cmd);
if (da.HasRows)
{
while (da.Read())
{
textBoxNIC.Text = da.GetValue(3).ToString();
textboxName.Text = da.GetValue(4).ToString();
textboxJobType.Text = da.GetValue(5).ToString();
txt_boxProQuli.Text = da.GetValue(6).ToString();
txt_boxAddressLivg.Text = da.GetValue(9).ToString();
txt_boxPN_private.Text = da.GetValue(10).ToString();
txt_boxPubN.Text = da.GetValue(11).ToString();
home_Address_tb.Text = da.GetValue(12).ToString();
txt_boxEmergencyContactNme.Text = da.GetValue(13).ToString();
txt_boxEmergencyContactPNo.Text = da.GetValue(14).ToString();
txt_boxMail.Text = da.GetValue(15).ToString();
mail_db = da.GetValue(15).ToString();
txt_boxGender.Text = da.GetValue(16).ToString();
if (da.GetValue(1).ToString() != "")
{
pictureBox1.Image = new Bitmap(da.GetValue(1).ToString());
Staff_Member_dp_path = da.GetValue(1).ToString();
}
}
con.Close();
}
else
{
MessageBox.Show("There is no Staff Member by member id:" + id + "\nTry again with another Id");
}
}
catch (SqlException ex)
{
MessageBox.Show(ex.ToString());
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
}
