//Functions-------------------------------------------------------- //----------------------------------------------------------------- private void User_Right() { Community.DBLayer DBLayer = new Community.DBLayer(); SqlConnection con = new SqlConnection(Community.DBLayer.con_String); try { SqlCommand cmd = new SqlCommand("Select Write,Modify,[Delete] from tblPermission Where UserID =" + UserID + " And SecurityLevelID= " + SecurityLevelID, con); cmd.CommandType = CommandType.Text; con.Open(); SqlDataReader reader = cmd.ExecuteReader(); reader.Read(); if (reader.HasRows) { rNew = Convert.ToBoolean(reader.GetValue(0)); rEdit = Convert.ToBoolean(reader.GetValue(1)); rDelete = Convert.ToBoolean(reader.GetValue(2)); } reader.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { if (con.State == ConnectionState.Open) { con.Close(); } } //return chk_Right; }
private void Extra(string FCardNo) { Community.DBLayer DBLayer = new Community.DBLayer(); try { SqlConnection conn = new SqlConnection(Community.DBLayer.con_String); conn.Open(); SqlCommand cmd = new SqlCommand("Select *,tblFamily.Sign,tblFamily.Active,tblFamily.FCardNo,tblFamily.FamilyLeader FROM tblHelp INNER JOIN tblFamiy ON tblHelp.FCardNo = tblFamily.FCardNo WHERE tblHelp.FCardNo = '" + FCardNo + "'", conn); DataTable dt = new DataTable(); cmd.CommandType = CommandType.Text; SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = cmd; da.Fill(dt); conn.Close(); } catch (Exception ex) { MessageBox.Show("AN unknown error occured \n\n" + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }
private void btnDelete_Click(object sender, EventArgs e) { lbl.Text = Header + ">>Deleting Card"; Community.DBLayer DBLayer = new Community.DBLayer(); bool DELETE = DBLayer.CHK_B4_DELETE(txtFCardNo.Text); if (DELETE) { MessageBox.Show("Cannot be Deleted! 'Already in use'", "Unable to Delete", MessageBoxButtons.OK); lbl.Text = Header; } else { DialogResult result = MessageBox.Show("Are You Sure You Want to Delete", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { try { string FCardNo = txtFCardNo.Text; usp_SEL_FAMILYTableAdapter.Delete1(FCardNo); usp_SEL_FAMILYTableAdapter.Fill(comDataSet.usp_SEL_FAMILY); MessageBox.Show("Deleted Succesfully!", "Deleted", MessageBoxButtons.OK, MessageBoxIcon.Information); lbl.Text = Header; } catch (Exception ex) { MessageBox.Show(ex.Message); } } else { lbl.Text = Header; } } }
//private void btnPrint_Click(object sender, EventArgs e) //{ // int id = Convert.ToInt32(txtSerialNo.Text); // SqlConnection con = new SqlConnection(Community.DBLayer.con_String); // con.Open(); // SqlCommand cmd = new SqlCommand("Select * from tblHallBooking WHERE SerialNo =" + id, con); // DataTable dt = new DataTable(); // SqlDataAdapter da = new SqlDataAdapter(); // da.SelectCommand = cmd; // da.Fill(dt); // Reports.Hall_Booking.frmViewer frm = new MCKJ.Reports.Hall_Booking.frmViewer(); // Reports.Hall_Booking.rptHallBooking rpt = new MCKJ.Reports.Hall_Booking.rptHallBooking(); // frm.crystalReportViewer1.ReportSource = rpt; // rpt.SetDataSource(dt); // rpt.SetParameterValue("SerialNo", id.ToString("00000")); // rpt.SetParameterValue("SerialNo", id.ToString("00000"), rpt.Subreports[0].Name.ToString()); // frm.Show(); // con.Close(); //} private void txtFCardNo_Leave(object sender, EventArgs e) { try { if (txtFCardNo.Text != "") { int fcardno = Convert.ToInt32(txtFCardNo.Text); int x = 5 - txtFCardNo.Text.Length; string zeros = ""; for (int i = 0; i < x; i++) { zeros += "0"; } txtFCardNo.Text = zeros + txtFCardNo.Text; } } catch (FormatException) { MessageBox.Show("Only numbers are allowed!", "Only Numbers"); } string y = txtFCardNo.Text; Community.DBLayer DBLayer = new Community.DBLayer(); bool result = DBLayer.CheckFamily(txtFCardNo.Text); for (int x = 0; x < dgvHallBooking.Rows.Count - 1; x++) { dgvHallBooking.Rows[x].Cells[0].Value = null; } if (txtFCardNo.Text != "") { if (result) { Fill(txtFCardNo.Text); txtFName.Text = FName; txtHead.Text = Head; txtOrakh.Text = Orakh; if (txtFCardNo.Text == "") { txtFCardNo.Text = y; } } else { MessageBox.Show("Family CardNo doesnot exist! Please enter a Valid CardNo.", "Invalid CardNo.", MessageBoxButtons.OK, MessageBoxIcon.Stop); txtHead.Text = ""; } } usp_SEL_tblFamilyMemberTableAdapter.Fill(comDataSet.usp_SEL_tblFamilyMember, txtFCardNo.Text); }
private void GetReportByStatus() { if (cmbSearch.Text.Length <= 0) { MessageBox.Show("Please select status."); return; } Community.DBLayer DBLayer = new Community.DBLayer(); try { SqlConnection conn = new SqlConnection(Community.DBLayer.con_String); conn.Open(); SqlCommand cmd = new SqlCommand("usp_SEL_Family", conn); DataTable dt = new DataTable(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "usp_SEL_FAMILY_ByStatus"; SqlDataAdapter da = new SqlDataAdapter(); if (cmbSearch.Text != "Both") { cmd.Parameters.AddWithValue("@status", (cmbSearch.Text == "Active" ? true : false)); } da.SelectCommand = cmd; da.Fill(dt); MCKJ.Reports.Family_Card.frmViewer frm = new MCKJ.Reports.Family_Card.frmViewer(); MCKJ.Reports.Family_Card.rptFamilyCard rpt = new MCKJ.Reports.Family_Card.rptFamilyCard(); frm.crystalReportViewer1.ReportSource = rpt; rpt.SetDataSource(dt); rpt.SetParameterValue("Filter", "Family Cards"); frm.Show(); conn.Close(); } catch (Exception e) { MessageBox.Show(e.Message); } }
private void txtName_Leave(object sender, EventArgs e) { Community.DBLayer DBLayer = new Community.DBLayer(); string ID = txtFCardNo.Text; string Name = txtName.Text; bool result = DBLayer.TRANSFER(ID, Name); if (txtName.Text == "" || txtFCardNo.Text == "00000") { // MessageBox.Show("Please fill the field!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { if (result) { try { string valuee = txtName.SelectedValue.ToString(); SqlConnection con = new SqlConnection(DBLayer.CON_string); SqlCommand cmd = new SqlCommand("Select FatherName,HusbandName,Gender,LeaderRelation,DOB,AgeGroup FROM tblFamilyMember WHERE FamilyMemberID = " + valuee, con); con.Open(); cmd.CommandType = CommandType.Text; SqlDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { reader.Read(); txtFName.Text = reader.GetValue(0).ToString(); cmbGender.Text = reader.GetValue(2).ToString(); cmbRelation.Text = reader.GetValue(3).ToString(); cmbAgeGroup.Text = reader.GetValue(5).ToString(); DOB = reader.GetValue(4).ToString(); txtGFName.Text = reader.GetValue(1).ToString(); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Member Not Found!!!", "Unable to Search", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void txtFCardNo_Leave(object sender, EventArgs e) { //if (txtFCardNo.Text.Length != 5) //{ // txtFCardNo.Text = txtFCardNo.Text.PadLeft(5, '0'); //} try { if (txtFCardNo.Text != "") { int fcardno = Convert.ToInt32(txtFCardNo.Text); int x = 5 - txtFCardNo.Text.Length; string zeros = ""; for (int i = 0; i < x; i++) { zeros += "0"; } txtFCardNo.Text = zeros + txtFCardNo.Text; } } catch (FormatException) { MessageBox.Show("Only numbers are allowed!", "Only Numbers"); } string y = txtFCardNo.Text; Community.DBLayer DBLayer = new Community.DBLayer(); bool result = DBLayer.CheckFamily(txtFCardNo.Text); if (txtFCardNo.Text != "") { if (result) { usp_SEL_FAMILYTableAdapter.Leader(comDataSet.usp_SEL_FAMILY, txtFCardNo.Text); txtFName.Text = FName(txtFCardNo.Text, txtHead.Text); if (txtFCardNo.Text == "") { txtFCardNo.Text = y; } } else { MessageBox.Show("Family CardNo doesnot exist! Please enter a Valid CardNo.", "Invalid CardNo.", MessageBoxButtons.OK, MessageBoxIcon.Stop); txtHead.Text = ""; } } }
private void btnShow_Click(object sender, EventArgs e) { Community.DBLayer dbLayer = new Community.DBLayer(); try { DateTime startdate = Convert.ToDateTime(dtpFrom.Text); string time = startdate.TimeOfDay.ToString(); DateTime enddate = Convert.ToDateTime(dtpTo.Text); enddate = enddate.AddDays(1); SqlConnection con = new SqlConnection(Community.DBLayer.con_String); con.Open(); SqlCommand cmd = new SqlCommand("Select tblSecurity.UserName,LoginTime,LogoffTime FROM tblLoging INNER JOIN tblSecurity ON tblLoging.UserID = tblSecurity.UserID WHERE LoginTime >='" + startdate + "' AND LoginTime <= '" + enddate + "'", con); DataTable dt = new DataTable(); cmd.CommandType = CommandType.Text; SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = cmd; da.Fill(dt); MCKJ.Reports.Loging.frmViewer frm = new frmViewer(); MCKJ.Reports.Loging.rptLoging rpt = new rptLoging(); rpt.SetDataSource(dt); frm.crystalReportViewer1.ReportSource = rpt; frm.Show(); con.Close(); } catch (FormatException) { MessageBox.Show("Only Numbers are allowed!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void FillFamilyGrid(string spName) { Community.DBLayer dblayer = new Community.DBLayer(); SqlCommand cmd = new SqlCommand(); SqlConnection conn = new SqlConnection(dblayer.CON_string); cmd.Connection = conn; cmd.CommandText = spName; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@FCardNo", txtFCardNo.Text)); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); if (DGFamily.DataSource != null) { DGFamily.DataSource = null; } DGFamily.DataSource = dt; int rows = DGFamily.Rows.Count; for (int count = 0; count < rows; count++) { string SNo = Convert.ToDecimal(count + 1).ToString("000"); DGFamily.Rows[count].Cells[1].Value = SNo; DGFamily.RefreshEdit(); } if (DGFamily.RowCount == 0) { DGFamily.Enabled = false; } else { DGFamily.Enabled = true; } }
private void btnSearch_Click(object sender, EventArgs e) { try { StringBuilder query = new StringBuilder(); StringBuilder filter = new StringBuilder(); query.Append(@"SELECT tblHelp.ID, tblHelp.FCardNo, tblHelp.HeadofFamily, tblHelp.FName, tblHelp.Orakh, tblHelp.ReceiveDate, tblHelp.Status, tblHelp.Amount, tblHelp.CompleteDate, tblHelp.SerialNo, tblHelp.Remarks, tblAids.Aid, tblFamilyMember.MemberName, tblHelp.AidFrom FROM tblHelp INNER JOIN tblAids ON tblHelp.HelpType = tblAids.ID INNER JOIN tblFamilyMember ON tblHelp.Name = tblFamilyMember.FamilyMemberID "); bool isWhereIncluded = false; if (chkByAidType.Checked) { query.Append("where HelpType =" + cmbAidType.SelectedValue); isWhereIncluded = true; filter.Append("Aid Type=" + cmbAidType.Text + ","); } if (chkByFamilyCard.Checked) { if (!isWhereIncluded) { query.Append(" where "); isWhereIncluded = true; } else { query.Append(" AND "); } query.Append(" tblHelp.FCardNo='" + txtFamilyCardNo.Text.PadLeft(5, '0') + "'"); filter.Append("Family Card=" + txtFamilyCardNo.Text.PadLeft(5, '0') + ","); } if (chkByOrakh.Checked) { if (!isWhereIncluded) { query.Append(" where "); isWhereIncluded = true; } else { query.Append(" AND "); } query.Append(" tblHelp.Orakh='" + cmbOrakh.Text + "'"); filter.Append("Orakh=" + cmbOrakh.Text + ","); } if (chkByStatus.Checked) { if (!isWhereIncluded) { query.Append(" where "); isWhereIncluded = true; } else { query.Append(" AND "); } query.Append(" tblHelp.Status='" + cmbStatus.Text + "'"); filter.Append("Status=" + cmbStatus.Text + ","); } if (chkAidFrom.Checked) { query.Append("where AidFrom ='" + cmbAidFrom.Text + "'"); isWhereIncluded = true; filter.Append("Aid From=" + cmbAidFrom.Text + ","); } query.Append(" ORDER BY tblHelp.FCardNo Asc"); Community.DBLayer DBLayer = new Community.DBLayer(); DataTable dt = DBLayer.GetDataByQuery(query.ToString()); MCKJ.ComDataSet dsCom = new ComDataSet(); for (int i = 0; i < dt.Rows.Count; i++) { DataRow dr = dsCom.tblHelp.NewRow(); int index = dsCom.tblHelp.Rows.Count - 1; for (int j = 0; j < dsCom.tblHelp.Columns.Count; j++) { dr[dsCom.tblHelp.Columns[j].ColumnName] = dt.Rows[i][dsCom.tblHelp.Columns[j].ColumnName]; } dsCom.tblHelp.Rows.Add(dr); } MCKJ.Reports.FamilyAid.rptFamilyAid rptAidRpt = new rptFamilyAid(); MCKJ.Reports.FamilyAid.frmViewer frmViewer = new frmViewer(); rptAidRpt.SetDataSource(dsCom); frmViewer.crystalReportViewer1.ReportSource = rptAidRpt; string filterSettings = filter.ToString(); rptAidRpt.SetParameterValue("Filter", ""); if (filterSettings.Length > 0) { rptAidRpt.SetParameterValue("Filter", filterSettings.Substring(0, filterSettings.Length - 1)); } frmViewer.Show(); //if (chkByAidType.Checked == false && chkByFamilyCard.Checked == false && chkByOrakh.Checked == false && chkByStatus.Checked == false) //{ //} } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btnShow_Click(object sender, EventArgs e) { textBox1_Leave(sender, e); string Status = ""; string RenewalYear = ""; string FCardNo = textBox1.Text; string Head = ""; string Orakh = ""; string FName = ""; Community.DBLayer DBLayer = new Community.DBLayer(); try { SqlConnection conn = new SqlConnection(Community.DBLayer.con_String); conn.Open(); SqlCommand cmd = new SqlCommand("SELECT tblHelp.ID, tblHelp.FCardNo, tblHelp.HeadofFamily, tblHelp.FName, tblHelp.Orakh, tblHelp.ReceiveDate, tblHelp.Status, tblHelp.Amount,tblHelp.CompleteDate, tblHelp.SerialNo, tblHelp.Remarks, tblAids.Aid, tblFamilyMember.MemberName FROM tblHelp INNER JOIN tblAids ON tblHelp.HelpType = tblAids.ID INNER JOIN tblFamilyMember ON tblHelp.Name = tblFamilyMember.FamilyMemberID WHERE tblHelp.FCardNo = '" + FCardNo + "'", conn); DataTable dt = new DataTable(); cmd.CommandType = CommandType.Text; SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = cmd; SqlCommand Command1 = new SqlCommand("Select tblFamily.Active,tblFamily.FCardNo,tblFamily.FamilyLeader,tblFamily.Sign FROM tblFamily WHERE tblFamily.FCardNo = '" + FCardNo + "'", conn); Command1.CommandType = CommandType.Text; SqlDataReader cReader; cReader = Command1.ExecuteReader(); cReader.Read(); if (cReader.HasRows) { bool chk = false; if (cReader.GetValue(0) != DBNull.Value) { chk = Convert.ToBoolean(cReader.GetValue(0)); if (chk == true) { Status = "Active"; } else { Status = "Inactive"; } } else { Status = ""; } if (cReader.GetValue(2) != DBNull.Value) { Head = cReader.GetValue(2).ToString(); } else { Head = ""; } if (cReader.GetValue(3) != DBNull.Value) { Orakh = cReader.GetValue(3).ToString(); } else { Orakh = ""; } } else { Status = "Inactive"; Orakh = ""; Head = ""; } cReader.Close(); SqlCommand Command2 = new SqlCommand("Select RenewalYear FROM tblRenewal WHERE tblRenewal.FCardNo = '" + FCardNo + "' ORDER By ID desc", conn); Command2.CommandType = CommandType.Text; SqlDataReader cReader1; cReader1 = Command2.ExecuteReader(); cReader1.Read(); if (cReader1.HasRows) { bool chk = false; if (cReader1.GetValue(0) != DBNull.Value) { RenewalYear = cReader1.GetValue(0).ToString(); } else { RenewalYear = ""; } } else { RenewalYear = ""; } cReader1.Close(); SqlCommand Command3 = new SqlCommand("Select FatherName FROM tblFamilyMember WHERE tblFamilyMember.FCardNo = '" + FCardNo + "' AND MemberName = '" + Head + "'", conn); Command3.CommandType = CommandType.Text; SqlDataReader cReader2; cReader2 = Command3.ExecuteReader(); cReader2.Read(); if (cReader2.HasRows) { bool chk = false; if (cReader2.GetValue(0) != DBNull.Value) { FName = cReader2.GetValue(0).ToString(); } else { FName = ""; } } else { FName = ""; } cReader2.Close(); da.Fill(dt); MCKJ.Reports.Family_Card.frmViewer frm = new frmViewer(); MCKJ.Reports.Family_Card.rptStatus rpt = new rptStatus(); frm.crystalReportViewer1.ReportSource = rpt; rpt.SetDataSource(dt); rpt.SetParameterValue(0, RenewalYear); rpt.SetParameterValue(1, Status); rpt.SetParameterValue(2, FCardNo); rpt.SetParameterValue(3, Head); rpt.SetParameterValue(4, Orakh); rpt.SetParameterValue(5, FName); frm.Show(); conn.Close(); } catch (Exception ex) { MessageBox.Show("AN unknown error occured \n\n" + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } //string FCardNo = textBox1.Text; //Community.DBLayer DBLayer = new Community.DBLayer(); //try //{ // SqlConnection conn = new SqlConnection(Community.DBLayer.con_String); // conn.Open(); // SqlCommand cmd = new SqlCommand("Select *,tblFamily.Sign,tblFamily.Active,tblFamily.FCardNo,tblFamily.FamilyLeader FROM tblHelp INNER JOIN tblFamiy ON tblHelp.FCardNo = tblFamily.FCardNo WHERE tblHelp.FCardNo = '"+ FCardNo + "'", conn); // DataTable dt = new DataTable(); // cmd.CommandType = CommandType.Text; // SqlDataAdapter da = new SqlDataAdapter(); // da.SelectCommand = cmd; // da.Fill(dt); // MCKJ.Reports.Members.frmViewer frm = new MCKJ.Reports.Members.frmViewer(); // MCKJ.Reports.Members.rptMembers rpt = new MCKJ.Reports.Members.rptMembers(); // frm.crystalReportViewer1.ReportSource = rpt; // rpt.SetDataSource(dt); // rpt.SetParameterValue("Filter", "Male Members"); // frm.Show(); // conn.Close(); //} //catch (Exception ex) //{ // MessageBox.Show("AN unknown error occured \n\n" + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); //} }
private void Print_NIC() { try { string[] Query = { "", "", "", "" }; if (txtCMIC1.Text == "" && txtCMIC2.Text == "" && txtCMIC3.Text == "" && txtCMIC4.Text == "") { MessageBox.Show("Please enter atleast One Community ID Card Number", "Error", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { if (txtCMIC1.Text != "") { Query[0] = "RIGHT(tblNIC.NIC,5) = '" + txtCMIC1.Text + "'"; } if (txtCMIC2.Text != " - -") { Query[1] = "RIGHT(tblNIC.NIC,5) = '" + txtCMIC2.Text + "'"; } if (txtCMIC3.Text != " - -") { Query[2] = "RIGHT(tblNIC.NIC,5) = '" + txtCMIC3.Text + "'"; } if (txtCMIC4.Text != " - -") { Query[3] = "RIGHT(tblNIC.NIC,5) = '" + txtCMIC4.Text + "'"; } string QUERY = ""; for (int x = 0; x < 4; x++) { if (QUERY == "") { if (Query[x] != "") { QUERY += Query[x] + " "; } } else { if (Query[x] != "") { QUERY += " OR " + Query[x]; } } } int len = QUERY.Length; Community.DBLayer dblayer = new Community.DBLayer(); SqlConnection con = new SqlConnection(Community.DBLayer.con_String); string query = richTextBox1.Text; query = query.Replace("NIC = @NIC", QUERY); SqlCommand cmd = new SqlCommand(query, con); cmd.CommandType = CommandType.Text; DataTable dt = new DataTable(); con.Open(); SqlDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { con.Close(); SqlDataAdapter ada = new SqlDataAdapter(cmd); ada.Fill(dt); MCKJ.Reports.Members.frmViewer frm = new MCKJ.Reports.Members.frmViewer(); MCKJ.Reports.Members.rptNIC rpt = new MCKJ.Reports.Members.rptNIC(); MCKJ.Reports.Members.rptNIC_back rptBack = new MCKJ.Reports.Members.rptNIC_back(); rpt.SetDataSource(dt); rptBack.SetDataSource(dt); frm.crystalReportViewer1.ReportSource = rpt; frm._nicbackbuttonvisible = true; frm._rptNICback = rptBack; frm._rptNICfront = rpt; frm.Show(); } else { MessageBox.Show("No record to preview please enter other ID Card No.s", "No record", MessageBoxButtons.OK, MessageBoxIcon.Information); con.Close(); } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnSubmit_Click(object sender, EventArgs e) { Community.DBLayer dblayer = new Community.DBLayer(); if (CheckFields()) { try { string Gender = cmbGender.Text; DateTime IssueDate = Convert.ToDateTime(dpIssueDate.Text); string DOB = Year(); string Address = txtAddress.Text; string Area = cmbArea.Text; string BAddress = txtBAddress.Text; string BName = txtBName.Text; string BPhone = txtBPhone.Text; string City = cmbCity.Text; string Country = txtCountry.Text; string Designattion = txtDesignation.Text; string Email = txtEmail.Text; string Leader = txtFamilyLeader.Text; string FamilyName = txtFamilyName.Text; string Fax = txtFax.Text; string FCardNo = txtFCardNo.Text; string Mobile = txtMobile.Text; string Nukh = cmbNukh.Text; string Phone = txtPhone.Text; string Sign = cmbSign.Text; string TypeWork = cmbType.Text; string Village = cmbVillage.Text; string Website = txtWebsite.Text; string ParentFCardNo = txtParentFCardNo.Text.PadLeft(5, '0'); string RenewalDueFrom = txtRenewalDueFrom.Text; DialogResult Result = MessageBox.Show("Are you sure??", "Confirmation", MessageBoxButtons.YesNo); if (Result == DialogResult.Yes) { if (mode == 1) { bool result = dblayer.CheckFamily(txtFCardNo.Text); if (result) { MessageBox.Show("Family Card No already exist! Please insert new Card No", "Invalid Card No", MessageBoxButtons.OK, MessageBoxIcon.Stop); txtFCardNo.Focus(); } else { usp_SEL_FAMILYTableAdapter.Insert1(FCardNo, IssueDate, FamilyName, Leader, Gender, DOB, Country, City, Nukh, Sign, Village, Area, Address, Phone, Mobile, BName, TypeWork, Designattion, BAddress, BPhone, Fax, Email, Website, true, ParentFCardNo, RenewalDueFrom, DBLayer.GetUserID()); //usp_SEL_FAMILYTableAdapter.Fill(comDataSet.usp_SEL_FAMILY); MessageBox.Show("Saved Succesfully!", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); EmptyFields(); txtFCardNo.Focus(); } lbl.Text = Header; } else if (mode == 0) { if (chk_active == "True") { usp_SEL_FAMILYTableAdapter.Update1(FCardNo, IssueDate, FamilyName, Leader, Gender, DOB, Country, City, Nukh, Sign, Village, Area, Address, Phone, Mobile, BName, TypeWork, Designattion, BAddress, BPhone, Fax, Email, Website, true, ParentFCardNo, RenewalDueFrom, DBLayer.GetUserID()); } else { usp_SEL_FAMILYTableAdapter.Update1(FCardNo, IssueDate, FamilyName, Leader, Gender, DOB, Country, City, Nukh, Sign, Village, Area, Address, Phone, Mobile, BName, TypeWork, Designattion, BAddress, BPhone, Fax, Email, Website, false, ParentFCardNo, RenewalDueFrom, DBLayer.GetUserID()); } //usp_SEL_FAMILYTableAdapter.Fill(comDataSet.usp_SEL_FAMILY); MessageBox.Show("Updated Succesfully!", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); txtFCardNo.Enabled = true; grb1.Hide(); Disable_Btn(true); grbSearch.Show(); lbl.Text = Header; } } } catch (Exception ex) { MessageBox.Show(ex.Message); } this.AcceptButton = btnAdd; } }
private void btnAllMembers_Click(object sender, EventArgs e) { Community.DBLayer dblayer = new Community.DBLayer(); btnNonActiveMembers.Enabled = true; btnActiveMembers.Enabled = true; string x = txtFCardNo.Text; if (txtFCardNo.Text == "") { MessageBox.Show("Please Insert Family Card Number", "Family Card Required", MessageBoxButtons.OK, MessageBoxIcon.Stop); } else { bool result = dblayer.CheckFamily(txtFCardNo.Text); if (result) { btnView.Enabled = true; if (DBLayer.User_Right(UserID, SecurityLevelID, "[Modify]")) { btnEdit.Enabled = true; } else { btnEdit.Enabled = false; } if (DBLayer.User_Right(UserID, SecurityLevelID, "[Delete]")) { btnDelete.Enabled = true; } else { btnDelete.Enabled = false; } if (DBLayer.User_Right(UserID, SecurityLevelID, "[Write]")) { btnAdd.Enabled = true; } else { btnAdd.Enabled = false; } FillGrid_All(txtFCardNo.Text); //FillFamilyGrid("usp_SEL_tblAllFamilyMembers"); if (DGFamily.RowCount == 0) { DGFamily.Enabled = false; } else { DGFamily.Enabled = true; } //btnDelete.Enabled = true; if (txtFCardNo.Text == "") { txtFCardNo.Text = x; } } else { MessageBox.Show("Family CardNo doesnot exist! Please try Again.", "Invalid CardNo.", MessageBoxButtons.OK, MessageBoxIcon.Stop); btnDelete.Enabled = false; btnAdd.Enabled = false; btnEdit.Enabled = false; DGFamily.Enabled = false; btnView.Enabled = false; } } }
private void btnFCardNo_Click(object sender, EventArgs e) { txtFCardNo_Leave(sender, e); string x = txtFCardNo.Text; Community.DBLayer dblayer = new Community.DBLayer(); if (txtFCardNo.Text == "") { MessageBox.Show("Please Insert Family Card Number", "Family Card Required", MessageBoxButtons.OK, MessageBoxIcon.Stop); } else { if (Chk == 0) { bool result = dblayer.CheckFamily(txtFCardNo.Text); if (result) { usp_SEL_FAMILYTableAdapter.Leader(comDataSet.usp_SEL_FAMILY, txtFCardNo.Text); FillGrid(txtFCardNo.Text); //FillGrid(txtFCardNo.Text); btnView.Enabled = true; //User_Right(); if (DBLayer.User_Right(UserID, SecurityLevelID, "[Modify]")) { btnEdit.Enabled = true; } else { btnEdit.Enabled = false; } if (DBLayer.User_Right(UserID, SecurityLevelID, "[Delete]")) { btnDelete.Enabled = true; } else { btnDelete.Enabled = false; } if (DBLayer.User_Right(UserID, SecurityLevelID, "[Write]")) { btnAdd.Enabled = true; } else { btnAdd.Enabled = false; } Chk = 0; if (DGFamily.RowCount == 0) { DGFamily.Enabled = false; btnEdit.Enabled = false; btnDelete.Enabled = false; btnView.Enabled = false; } else { DGFamily.Enabled = true; } if (txtFCardNo.Text == "") { txtFCardNo.Text = x; } this.AcceptButton = btnAdd; } else { MessageBox.Show("Family CardNo doesnot exist! Please enter a Valid CardNo.", "Invalid CardNo.", MessageBoxButtons.OK, MessageBoxIcon.Stop); btnDelete.Enabled = false; btnAdd.Enabled = false; btnEdit.Enabled = false; DGFamily.Enabled = false; btnView.Enabled = false; txtOrakh.Text = ""; txtFamilyLeader.Text = ""; } } } }