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 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) { 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 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!"); } }