public void FillGrid(string strCond, string AorB) { try { tbl_MemberMasterBAL objtbl_MemberMasterBAL = new tbl_MemberMasterBAL(); DataSet dsdata = objtbl_MemberMasterBAL.GET_REGISTERED_MEMBER(strCond); if (dsdata.Tables[0].Rows.Count > 0) { FieldLength = new int[] { 120, 0, 150, 0, 80, 0, 50, 0, 0 }; if (AorB == "A") { objGlobal.FillListView(LvwDetails_A, dsdata.Tables[0], FieldLength); lblTotalCnt_A.Text = "Total : " + dsdata.Tables[0].Rows.Count; } else { objGlobal.FillListView(LvwDetails_B, dsdata.Tables[0], FieldLength); lblTotalCnt_B.Text = "Total : " + dsdata.Tables[0].Rows.Count; } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public DataSet FillData(string strSearch) { DataSet dsData = new DataSet(); try { int PageCount = 0; tbl_MemberMasterProp Objtbl_MemberMasterProp = new tbl_MemberMasterProp(); Objtbl_MemberMasterProp.MemberCode = 0; Objtbl_MemberMasterProp.PageNo = Convert.ToInt32(txtCurPage.Text); Objtbl_MemberMasterProp.RecordCount = Convert.ToInt32(20); tbl_MemberMasterBAL Objtbl_MemberMasterBAL = new tbl_MemberMasterBAL(); if (sSearchVal != "" && sSearchType != "") { Objtbl_MemberMasterProp.SearchBy = sSearchType; Objtbl_MemberMasterProp.SearchVal = sSearchVal; dsData = Objtbl_MemberMasterBAL.Search_Data(Objtbl_MemberMasterProp, ref PageCount); } else { dsData = Objtbl_MemberMasterBAL.Select_Data(Objtbl_MemberMasterProp, ref PageCount); lblTotalPageCount.Text = Convert.ToString(PageCount); } FillGrid(dsData); } catch (Exception ex) { MessageBox.Show(Convert.ToString(ex.Message)); this.objEventLoging.AppErrlog("Error In AnantMatrimony.frmMemberMaster.FillData() " + ex.ToString()); } return(dsData); }
public void FillList() { try { string strCond = "", Caste_Sel = ""; //if (dtpFromDate.Value.ToShortDateString() != dtpToDate.Value.ToShortDateString()) //{ strCond += " AND MS.EndDate BETWEEN '" + dtpFromDate.Value.ToString("dd/MMM/yyyy") + "' AND '" + dtpToDate.Value.ToString("dd/MMM/yyyy") + "'"; //} if (strCond == "") { MessageBox.Show("Please select Something", "Selection Validation", MessageBoxButtons.OK, MessageBoxIcon.Hand); return; } tbl_MemberMasterBAL objtbl_MemberMasterBAL = new tbl_MemberMasterBAL(); DataSet dsdata = objtbl_MemberMasterBAL.GET_ExpiredMembership(strCond); if (dsdata.Tables[0].Rows.Count > 0) { lblTotalCnt.Text = "Total : " + Convert.ToString(dsdata.Tables[0].Rows.Count); FieldLength = new int[] { 150, 200, 100, 120, 120, 0, 100, 0, 100, 0, 0, 80, 80, 80, 0 }; objGlobal.FillListView(LvwDetails, dsdata.Tables[0], FieldLength); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btnSearch_Click(object sender, EventArgs e) { try { if (ddlSearchBy.SelectedIndex == 0) { MessageBox.Show("Please select Search Type", "Search Type Validation", MessageBoxButtons.OK, MessageBoxIcon.Error); ddlSearchBy.Focus(); return; } if (txtSearchValue.Text.Trim() == "") { MessageBox.Show("Please enter Search Value", "Search Value Validation", MessageBoxButtons.OK, MessageBoxIcon.Error); txtSearchValue.Focus(); return; } Cursor = Cursors.WaitCursor; pnlSearch.Enabled = false; tbl_MemberMasterBAL Objtbl_MemberMasterBAL = new tbl_MemberMasterBAL(); Objtbl_MemberMasterBAL.InsertSearchLog(txtSearchValue.Text, ddlSearchBy.Text, DateTime.Now, Global.intUserId); DataSet ds = new DataSet(); ds = SeaarchData(ddlSearchBy.Text, txtSearchValue.Text); FillGrid(ds); Cursor = Cursors.Default; } catch (Exception ex) { MessageBox.Show(Convert.ToString(ex.Message)); this.objEventLoging.AppErrlog("Error In AnantMatrimony.frmMemberMaster.btnSearch_Click() " + ex.ToString()); } }
public void FillGrid() { try { string strCondi = ""; //strSql = " SELECT TOP 1000 MemberCode,ProfileId,MobileNo,MobileNo_Rel,MobileNo1,MobileNo1_Rel,LandlineNo,MobileNo2_Rel,LandlineNo1,LandlineNo1_Rel FROM tbl_membermaster WHERE isnull(MobileNo_Rel,'')='' "; strCondi += " AND MM.Gender =" + (rbtnMale.Checked == true ? "0" : "1"); if (Convert.ToString(ddlPAgeFrom.SelectedValue) != Convert.ToString(ddlPAgeTo.SelectedValue)) { strCondi += " AND Convert(varchar(4),MM.DateOfBirth,111) Between " + ddlPAgeFrom.Text + " AND " + ddlPAgeTo.Text + ""; } if (Convert.ToInt32(ddlCaste.SelectedValue) > 0) { strCondi += " AND MM.Caste = " + ddlCaste.SelectedValue; } tbl_MemberMasterBAL objMembermaster = new tbl_MemberMasterBAL(); DataSet dtDetails = objMembermaster.GET_Delete_Photos_List(strCondi); if (dtDetails.Tables[0].Rows.Count > 0) { lblTotalCnt.Text = "Total : " + Convert.ToString(dtDetails.Tables[0].Rows.Count); FieldLength = new int[] { 150, 200, 100, 120, 170, 80, 0 }; objGlobal.FillListView(LvwDetails, dtDetails.Tables[0], FieldLength); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void FillMemberData() { try { int PageCount = 0; tbl_MemberMasterProp Objtbl_MemberMasterProp = new tbl_MemberMasterProp(); Objtbl_MemberMasterProp.MemberCode = 0; Objtbl_MemberMasterProp.PageNo = 1; Objtbl_MemberMasterProp.RecordCount = 1; tbl_MemberMasterBAL Objtbl_MemberMasterBAL = new tbl_MemberMasterBAL(); DataSet dsData = Objtbl_MemberMasterBAL.Select_Data(Objtbl_MemberMasterProp, ref PageCount); DataRow dr = dsData.Tables[0].NewRow(); dr["MemberName"] = "--- Primary ---"; dr["MemberCode"] = 0; dsData.Tables[0].Rows.InsertAt(dr, 0); lblTotalPage.Text = Convert.ToString(PageCount); ddlParentCode.DataSource = dsData.Tables[0]; ddlParentCode.DataTextField = "MemberName"; ddlParentCode.DataValueField = "MemberCode"; ddlParentCode.DataBind(); } catch (Exception ex) { throw ex; } }
private void btnSearch_ProfileHistory_Click(object sender, EventArgs e) { try { tbl_MemberMasterProp Objtbl_MemberMasterProp = new tbl_MemberMasterProp(); Objtbl_MemberMasterProp.MemberCode = 0; Objtbl_MemberMasterProp.ProfileID = txtProfileId_ProfileHistory.Text; // ProfileID; Objtbl_MemberMasterProp.isLogedin = true; Objtbl_MemberMasterProp.LoginCode = 0; tbl_MemberMasterBAL Objtbl_MemberMasterBAL = new tbl_MemberMasterBAL(); DataSet dsMemberMaster = Objtbl_MemberMasterBAL.Load_MemberDetails(Objtbl_MemberMasterProp); if (dsMemberMaster.Tables[0].Rows.Count > 0) { lblBirthYear.Text = Convert.ToString(dsMemberMaster.Tables[0].Rows[0]["DateOfBirth"]); lblName.Text = Convert.ToString(dsMemberMaster.Tables[0].Rows[0]["MemberName"]); lblCast.Text = Convert.ToString(dsMemberMaster.Tables[0].Rows[0]["Caste"]); } int MemberCode = Objtbl_MemberMasterBAL.GetMemberCode(txtProfileId_ProfileHistory.Text); LvwDetails.Clear(); if (rbtnDetails.Checked) { strSql = " Select MM.ProfileID,MM.MemberName,convert(nvarchar,MM.DateofBirth,103) as DateofBirth,MM.MobileNo,MM.MobileNo1,MM.LandlineNo,"; strSql += " SM.StateCity,Convert(varchar(4),MM.DateOfBirth,111) as BornYear, Cas.Caste,CASE WHEN MM.Gender = 0 then 'MALE' else 'FEMALE' END AS Gender, "; strSql += " PL.VisitDate"; strSql += " from tbl_MemberMaster MM "; strSql += " inner join dbo.tbl_StateCity SM on SM.StateCityCode=MM.StateCity "; strSql += " LEFT OUTER JOIN dbo.tbl_Caste AS Cas ON MM.Caste = Cas.CasteCode "; strSql += " INNER JOIN tbl_ProfilevisitLog_new PL ON PL.profileid= MM.profileid"; strSql += " WHERE MM.isActive IN (1 ,2) and PL.MemberCode = " + MemberCode + " order by PL.VisitDate DESC "; //strSql += " WHERE MM.isActive IN (1 ,2) and PL.profileid='" + txtProfileId_VisitLog.Text + "' order by PL.VisitDate DESC "; DataTable dtDetails = objDb.GetDataTable(strSql); if (dtDetails.Rows.Count > 0) { lblTotalCnt.Text = "Total : " + Convert.ToString(dtDetails.Rows.Count); FieldLength = new int[] { 150, 200, 100, 120, 0, 0, 100, 80, 80, 0, 150 }; objGlobal.FillListView(LvwDetails, dtDetails, FieldLength); LvwDetails.CheckBoxes = false; } } else if (rbtnSummary.Checked) { strSql = " SELECT count(*) as Count,Profileid from tbl_ProfilevisitLog_new where MemberCode=" + MemberCode + " group by Profileid order by count(*) desc "; DataTable dtDetails = objDb.GetDataTable(strSql); if (dtDetails.Rows.Count > 0) { lblTotalCnt.Text = "Total : " + Convert.ToString(dtDetails.Rows.Count); FieldLength = new int[] { 150, 200 }; objGlobal.FillListView(LvwDetails, dtDetails, FieldLength); LvwDetails.CheckBoxes = false; } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void FillGrid() { try { LvwDetails.Items.Clear(); string strCondi = ""; //strSql = " SELECT TOP 1000 MemberCode,ProfileId,MobileNo,MobileNo_Rel,MobileNo1,MobileNo1_Rel,LandlineNo,MobileNo2_Rel,LandlineNo1,LandlineNo1_Rel FROM tbl_membermaster WHERE isnull(MobileNo_Rel,'')='' "; strCondi += " AND MM.Gender =" + (rdbtnMale.Checked == true ? "0" : "1"); if (Convert.ToString(ddlPAgeFrom.SelectedValue) != Convert.ToString(ddlPAgeTo.SelectedValue)) { strCondi += " AND Convert(varchar(4),MM.DateOfBirth,111) Between " + ddlPAgeFrom.Text + " AND " + ddlPAgeTo.Text + ""; } if (Convert.ToInt32(ddlCaste.SelectedValue) > 0) { strCondi += " AND MM.Caste = " + ddlCaste.SelectedValue; } if (ddlUpdateStatus.Text.ToUpper() == "NOT SEND LIST") { strCondi += " and Married= -1 "; } else if (ddlUpdateStatus.Text.ToUpper() == "SEND LIST") { strCondi += " and Married= 0 "; } else if (ddlUpdateStatus.Text.ToUpper() == "YES LIST") { strCondi += " and Married= 1 "; } else if (ddlUpdateStatus.Text.ToUpper() == "NO LIST") { strCondi += " and Married= 2 "; } if (txtProfileId.Text.Trim() != "") { strCondi += " AND profileid='" + txtProfileId.Text.Trim() + "'"; } tbl_MemberMasterBAL objMembermaster = new tbl_MemberMasterBAL(); DataSet dtDetails = objMembermaster.GetMarriedConfirmationList(strCondi); if (dtDetails.Tables[0].Rows.Count > 0) { lblTotalCnt.Text = "Total : " + Convert.ToString(dtDetails.Tables[0].Rows.Count); FieldLength = new int[] { 150, 200, 100, 120, 170, 80, 50, 50, 0 }; objGlobal.FillListView(LvwDetails, dtDetails.Tables[0], FieldLength); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btnSearch_Click(object sender, EventArgs e) { try { tbl_MemberMasterProp Objtbl_MemberMasterProp = new tbl_MemberMasterProp(); Objtbl_MemberMasterProp.MemberCode = 0; Objtbl_MemberMasterProp.ProfileID = txtSearchValue.Text; // ProfileID; Objtbl_MemberMasterProp.isLogedin = true; Objtbl_MemberMasterProp.LoginCode = 0; tbl_MemberMasterBAL Objtbl_MemberMasterBAL = new tbl_MemberMasterBAL(); DataSet dsMemberMaster = Objtbl_MemberMasterBAL.Load_MemberDetails(Objtbl_MemberMasterProp); if (dsMemberMaster.Tables[0].Rows.Count > 0) { lblBirthYear.Text = Convert.ToString(dsMemberMaster.Tables[0].Rows[0]["DateOfBirth"]); lblName.Text = Convert.ToString(dsMemberMaster.Tables[0].Rows[0]["MemberName"]); lblCast.Text = Convert.ToString(dsMemberMaster.Tables[0].Rows[0]["Caste"]); //tbl_MemberMasterBAL Objtbl_MemberMasterBAL = new tbl_MemberMasterBAL(); int MemberCode = Objtbl_MemberMasterBAL.GetMemberCode(txtSearchValue.Text); LvwDetails.Clear(); lblTotalCnt.Text = ""; strSql = " select mm.membercode,MM.ProfileID,MM.MemberName,convert(nvarchar,MM.DateofBirth,103) as DateofBirth,MM.MobileNo,MM.MobileNo1,MM.LandlineNo, "; strSql += " SM.StateCity,Convert(varchar(4),MM.DateOfBirth,111) as BornYear, Cas.Caste,CASE WHEN MM.Gender = 0 then 'MALE' else 'FEMALE' END AS Gender, "; strSql += " CASE WHEN dbo.isYetMember(mm.MemberCode, 0) <= 0 THEN 'FREE' ELSE 'PAID' END AS Membership"; strSql += " from tbl_BookmarkList bm"; strSql += " inner join tbl_MemberMaster mm on mm.membercode=bm.membercode "; strSql += " left join dbo.tbl_StateCity SM on SM.StateCityCode=MM.StateCity "; strSql += " LEFT OUTER JOIN dbo.tbl_Caste AS Cas ON MM.Caste = Cas.CasteCode "; strSql += " WHERE MM.isActive IN (1 ,2) and bm.BookmarkedProfile like '%" + MemberCode + "%'"; DataTable dtDetails = objDb.GetDataTable(strSql); if (dtDetails.Rows.Count > 0) { lblTotalCnt.Text = "Total : " + Convert.ToString(dtDetails.Rows.Count); FieldLength = new int[] { 0, 120, 200, 100, 120, 0, 0, 100, 80, 80, 80, 80 }; objGlobal.FillListView(LvwDetails, dtDetails, FieldLength); LvwDetails.CheckBoxes = false; } else { MessageBox.Show("Data not found", txtSearchValue.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void BlockProfile() { try { tbl_MemberMasterProp objtbl_MemberMasterProp = new tbl_MemberMasterProp(); objtbl_MemberMasterProp.isActive = 4; tbl_MemberMasterBAL objtbl_MemberMasterBAL = new tbl_MemberMasterBAL(); DataSet dsData = objtbl_MemberMasterBAL.Profile_Summary(objtbl_MemberMasterProp); lnkBlockedProfile.Text = "Blocked Profile Records ( " + Convert.ToString(dsData.Tables[0].Rows[0]["MemCount"]).PadLeft(3, '0') + " )"; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void NewRegisteredAccount() { try { tbl_MemberMasterProp objtbl_MemberMasterProp = new tbl_MemberMasterProp(); objtbl_MemberMasterProp.isActive = 0; tbl_MemberMasterBAL objtbl_MemberMasterBAL = new tbl_MemberMasterBAL(); DataSet dsData = objtbl_MemberMasterBAL.Profile_Summary(objtbl_MemberMasterProp); lnkNewRegistered.Text = "New/Unapproved Records ( " + Convert.ToString(dsData.Tables[0].Rows[0]["MemCount"]).PadLeft(3, '0') + " )"; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void DeleteData(int MemberCode) { try { tbl_MemberMasterProp Objtbl_MemberMasterProp = new tbl_MemberMasterProp(); Objtbl_MemberMasterProp.MemberCode = MemberCode; tbl_MemberMasterBAL Objtbl_MemberMasterBAL = new tbl_MemberMasterBAL(); Objtbl_MemberMasterBAL.Delete_Data(Objtbl_MemberMasterProp); FillData(); } catch (Exception ex) { throw ex; } }
private void EditData(int MemberCode) { try { tbl_MemberMasterProp Objtbl_MemberMasterProp = new tbl_MemberMasterProp(); Objtbl_MemberMasterProp.MemberCode = MemberCode; int PageCount = 0; tbl_MemberMasterBAL Objtbl_MemberMasterBAL = new tbl_MemberMasterBAL(); DataSet dsData = Objtbl_MemberMasterBAL.Select_Data(Objtbl_MemberMasterProp, ref PageCount); txtMemberName.Text = Convert.ToString(dsData.Tables[0].Rows[0]["MemberName"]); txtCurrentAddress.Text = Convert.ToString(dsData.Tables[0].Rows[0]["CurrentAddress"]); ddlCountryCode.SelectedValue = Convert.ToString(dsData.Tables[0].Rows[0]["CountryCode"]); FillStateCode(Convert.ToInt32(ddlCountryCode.SelectedValue)); ddlStateCode.SelectedValue = Convert.ToString(dsData.Tables[0].Rows[0]["StateCode"]); FillCityCode(Convert.ToInt32(ddlStateCode.SelectedValue)); ddlCityCode.SelectedValue = Convert.ToString(dsData.Tables[0].Rows[0]["CityCode"]); txtPermanentAddress.Text = Convert.ToString(dsData.Tables[0].Rows[0]["PermanentAddress"]); txtContactNo.Text = Convert.ToString(dsData.Tables[0].Rows[0]["ContactNo"]); txtEmailID.Text = Convert.ToString(dsData.Tables[0].Rows[0]["EmailID"]); txtDOB.Text = Convert.ToString(dsData.Tables[0].Rows[0]["DOB"]); ddlQualificationCode.SelectedValue = Convert.ToString(dsData.Tables[0].Rows[0]["QualificationCode"]); ddlOccupationCode.SelectedIndex = Convert.ToInt32(dsData.Tables[0].Rows[0]["OccupationCode"]); ddlMaritalStatus.SelectedIndex = Convert.ToInt32(dsData.Tables[0].Rows[0]["MaritalStatusCode"]); ddlGender.SelectedIndex = Convert.ToInt32(dsData.Tables[0].Rows[0]["Gender"]); ddlNativePlace.SelectedIndex = Convert.ToInt32(dsData.Tables[0].Rows[0]["NativePlaceCode"]); ddlNationality.SelectedIndex = Convert.ToInt32(dsData.Tables[0].Rows[0]["NationalityCode"]); ddlPhysicallyChallanged.SelectedIndex = Convert.ToInt32(dsData.Tables[0].Rows[0]["PhysicalChallangedCode"]); ddlRelationshipCode.SelectedIndex = Convert.ToInt32(dsData.Tables[0].Rows[0]["RelationshipCode"]); ddlParentCode.SelectedValue = Convert.ToString(dsData.Tables[0].Rows[0]["ParentCode"]); tdUploadedFile.Visible = true; imgPhotos.ImageUrl = "~/MembersPhotos/" + Convert.ToString(dsData.Tables[0].Rows[0]["PhotoPath"]).Split('.')[0] + ".jpg"; ViewState["PhotoPath"] = Convert.ToString(dsData.Tables[0].Rows[0]["PhotoPath"]); ViewState["EditCode"] = MemberCode; } catch (Exception ex) { throw ex; } }
public void FillGrid(string strCond) { try { tbl_MemberMasterBAL objtbl_MemberMasterBAL = new tbl_MemberMasterBAL(); DataSet dsdata = objtbl_MemberMasterBAL.GetMarriedConfirmationList(strCond); if (dsdata.Tables[0].Rows.Count > 0) { FieldLength = new int[] { 120, 150, 0, 150, 0, 80, 80, 0, 0 }; objGlobal.FillListView(LvwDetails, dsdata.Tables[0], FieldLength); lblTotalCnt_A.Text = "Total : " + dsdata.Tables[0].Rows.Count; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void FillData() { try { int PageCount = 0; tbl_MemberMasterProp Objtbl_MemberMasterProp = new tbl_MemberMasterProp(); Objtbl_MemberMasterProp.MemberCode = 0; Objtbl_MemberMasterProp.PageNo = Convert.ToInt32(1); Objtbl_MemberMasterProp.RecordCount = Convert.ToInt32(20); tbl_MemberMasterBAL Objtbl_MemberMasterBAL = new tbl_MemberMasterBAL(); DataSet dsData = Objtbl_MemberMasterBAL.Select_Data(Objtbl_MemberMasterProp, ref PageCount); rptData.DataSource = dsData.Tables[0]; rptData.DataBind(); } catch (Exception ex) { throw ex; } }
private void btnPrint_Click(object sender, EventArgs e) { try { tbl_MemberMasterBAL Objtbl_MemberMasterBAL = new tbl_MemberMasterBAL(); int MemberCode = Objtbl_MemberMasterBAL.GetMemberCode(txtSearchValue.Text); strSql = " select mm.membercode,MM.ProfileID,MM.MemberName,convert(nvarchar,MM.DateofBirth,103) as DateofBirth,MM.MobileNo,MM.MobileNo1,MM.LandlineNo, "; strSql += " SM.StateCity,Convert(varchar(4),MM.DateOfBirth,111) as BornYear, Cas.Caste,CASE WHEN MM.Gender = 0 then 'MALE' else 'FEMALE' END AS Gender, "; strSql += " CASE WHEN dbo.isYetMember(mm.MemberCode, 0) <= 0 THEN 'FREE' ELSE 'PAID' END AS Membership"; strSql += " from tbl_BookmarkList bm"; strSql += " inner join tbl_MemberMaster mm on mm.membercode=bm.membercode "; strSql += " left join dbo.tbl_StateCity SM on SM.StateCityCode=MM.StateCity "; strSql += " LEFT OUTER JOIN dbo.tbl_Caste AS Cas ON MM.Caste = Cas.CasteCode "; strSql += " WHERE MM.isActive IN (1 ,2) and bm.BookmarkedProfile like '%" + MemberCode + "%'"; DataTable dtDetails = objDb.GetDataTable(strSql); if (dtDetails.Rows.Count > 0) { dtDetails.TableName = "dsBookmarklog"; frmReportViewer objReportViewer = new frmReportViewer(); ReportDocument cryRpt = new ReportDocument(); string strPath = ""; strPath = Application.StartupPath + @"\REPORTS\BookmarkLog.rpt"; cryRpt.Load(strPath); cryRpt.SetDataSource(dtDetails); objReportViewer.RptViewer.ReportSource = cryRpt; objReportViewer.RptViewer.Refresh(); objReportViewer.ShowDialog(); objReportViewer.Focus(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public DataSet SeaarchData(string sSearchBy, string sSearchVal) { DataSet ds = new DataSet(); try { tbl_MemberMasterProp Objtbl_MemberMasterProp = new tbl_MemberMasterProp(); Objtbl_MemberMasterProp.SearchBy = sSearchBy; Objtbl_MemberMasterProp.SearchVal = sSearchVal; Objtbl_MemberMasterProp.PageNo = 1; Objtbl_MemberMasterProp.RecordCount = 10000; tbl_MemberMasterBAL Objtbl_MemberMasterBAL = new tbl_MemberMasterBAL(); int PageCount = 0; ds = Objtbl_MemberMasterBAL.Search_Data(Objtbl_MemberMasterProp, ref PageCount); } catch (Exception ex) { MessageBox.Show(Convert.ToString(ex.Message)); this.objEventLoging.AppErrlog("Error In AnantMatrimony.frmMemberMaster.SeaarchData() " + ex.ToString()); } return(ds); }
private void btnPrint_Click(object sender, EventArgs e) { try { string strCondi = ""; //strSql = " SELECT TOP 1000 MemberCode,ProfileId,MobileNo,MobileNo_Rel,MobileNo1,MobileNo1_Rel,LandlineNo,MobileNo2_Rel,LandlineNo1,LandlineNo1_Rel FROM tbl_membermaster WHERE isnull(MobileNo_Rel,'')='' "; strCondi += " AND MM.Gender =" + (rdbtnMale.Checked == true ? "0" : "1"); if (Convert.ToString(ddlPAgeFrom.SelectedValue) != Convert.ToString(ddlPAgeTo.SelectedValue)) { strCondi += " AND Convert(varchar(4),MM.DateOfBirth,111) Between " + ddlPAgeFrom.Text + " AND " + ddlPAgeTo.Text + ""; } if (Convert.ToInt32(ddlCaste.SelectedValue) > 0) { strCondi += " AND MM.Caste = " + ddlCaste.SelectedValue; } tbl_MemberMasterBAL objMembermaster = new tbl_MemberMasterBAL(); DataSet dtDetails = objMembermaster.GET_UPLOAD_PHOTO_PENDING(strCondi); if (dtDetails.Tables[0].Rows.Count > 0) { frmReportViewer objReportViewer = new frmReportViewer(); ReportDocument cryRpt = new ReportDocument(); string strPath = ""; strPath = Application.StartupPath + @"\REPORTS\PhotoUploadPending.rpt"; cryRpt.Load(strPath); cryRpt.SetDataSource(dtDetails.Tables[0]); objReportViewer.RptViewer.ReportSource = cryRpt; objReportViewer.RptViewer.Refresh(); objReportViewer.ShowDialog(); objReportViewer.Focus(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btnSubmit_Click(object sender, EventArgs e) { try { string Caste_Sel = "", Education_Sel = "", Country_Sel = "", State_Sel = "", MaritalStatus_Sel = "", Height_Sel = "", strWeight_Sel = "", StrManglik = "", Incom_Sel = ""; for (int cnt = 0; cnt < LvwCaste.Items.Count; cnt++) { if (LvwCaste.Items[cnt].Checked) { if (Caste_Sel == "") { Caste_Sel = LvwCaste.Items[cnt].SubItems[LvwCaste.Columns.Count - 1].Text; } else { Caste_Sel += "," + LvwCaste.Items[cnt].SubItems[LvwCaste.Columns.Count - 1].Text; } } } if (Caste_Sel == "") { MessageBox.Show("Please select any caste", "Caste Selection Validation", MessageBoxButtons.OK, MessageBoxIcon.Hand); return; } Country_Sel = ""; for (int cnt = 0; cnt < LvwCountry.Items.Count; cnt++) { if (LvwCountry.Items[cnt].SubItems[LvwCountry.Columns.Count - 1].Text != "-1") { if (LvwCountry.Items[cnt].Checked) { if (Country_Sel == "") { Country_Sel = LvwCountry.Items[cnt].SubItems[LvwCountry.Columns.Count - 1].Text; } else { Country_Sel += "," + LvwCountry.Items[cnt].SubItems[LvwCountry.Columns.Count - 1].Text; } } } } for (int cnt = 0; cnt < LvwEducation.Items.Count; cnt++) { if (LvwEducation.Items[cnt].SubItems[LvwEducation.Columns.Count - 1].Text != "-1") { if (LvwEducation.Items[cnt].Checked) { if (Education_Sel == "") { Education_Sel = LvwEducation.Items[cnt].SubItems[LvwEducation.Columns.Count - 1].Text; } else { Education_Sel += "," + LvwEducation.Items[cnt].SubItems[LvwEducation.Columns.Count - 1].Text; } } } } for (int cnt = 0; cnt < LvwMaritalStatus.Items.Count; cnt++) { if (LvwMaritalStatus.Items[cnt].SubItems[LvwMaritalStatus.Columns.Count - 1].Text != "-1") { if (LvwMaritalStatus.Items[cnt].Checked) { if (MaritalStatus_Sel == "") { MaritalStatus_Sel = LvwMaritalStatus.Items[cnt].SubItems[LvwMaritalStatus.Columns.Count - 1].Text; } else { MaritalStatus_Sel += "," + LvwMaritalStatus.Items[cnt].SubItems[LvwMaritalStatus.Columns.Count - 1].Text; } } } } for (int cnt = 0; cnt < LvwState.Items.Count; cnt++) { if (LvwState.Items[cnt].SubItems[LvwState.Columns.Count - 1].Text != "-1") { if (LvwState.Items[cnt].Checked) { if (State_Sel == "") { State_Sel = LvwState.Items[cnt].SubItems[LvwState.Columns.Count - 1].Text; } else { State_Sel += "," + LvwState.Items[cnt].SubItems[LvwState.Columns.Count - 1].Text; } } } } for (int cnt = 0; cnt < LvwHeight.Items.Count; cnt++) { if (LvwHeight.Items[cnt].SubItems[LvwHeight.Columns.Count - 1].Text != "-1") { if (LvwHeight.Items[cnt].Checked) { if (Height_Sel == "") { Height_Sel = LvwHeight.Items[cnt].SubItems[LvwHeight.Columns.Count - 1].Text; } else { Height_Sel += "," + LvwHeight.Items[cnt].SubItems[LvwHeight.Columns.Count - 1].Text; } } } } for (int cnt = 0; cnt < LvwManglic.Items.Count; cnt++) { if (LvwManglic.Items[cnt].SubItems[LvwManglic.Columns.Count - 1].Text != "-1") { if (LvwManglic.Items[cnt].Checked) { if (StrManglik == "") { StrManglik = LvwManglic.Items[cnt].SubItems[LvwManglic.Columns.Count - 1].Text; } else { StrManglik += "," + LvwManglic.Items[cnt].SubItems[LvwManglic.Columns.Count - 1].Text; } } } } for (int cnt = 0; cnt < LvwIncome.Items.Count; cnt++) { if (LvwIncome.Items[cnt].SubItems[LvwIncome.Columns.Count - 1].Text != "-1") { if (LvwIncome.Items[cnt].Checked) { if (Incom_Sel == "") { Incom_Sel = LvwIncome.Items[cnt].SubItems[LvwIncome.Columns.Count - 1].Text; } else { Incom_Sel += "," + LvwIncome.Items[cnt].SubItems[LvwIncome.Columns.Count - 1].Text; } } } } string strSql = ""; strSql = " Select MemberCode from tbl_MemberMaster MM where MM.isActive IN (1 ,2) AND MM.Gender =" + (rdbtnMale.Checked == true ? "0" : "1"); strSql += " AND Convert(varchar(4),MM.DateOfBirth,111) Between " + ddlPAgeFrom.Text + " AND " + ddlPAgeTo.Text + ""; if (State_Sel != "") { strSql += " AND MM.StateCity IN (" + State_Sel + ")"; } if (MaritalStatus_Sel != "") { strSql += " AND MM.MaritalStatus IN (" + MaritalStatus_Sel + ") "; } if (Education_Sel != "") { strSql += " AND MM.Education IN (" + Education_Sel + ")"; } if (Country_Sel != "") { strSql += " AND MM.VisaCountry IN (" + Country_Sel + ")"; } if (Caste_Sel != "") { strSql += " AND MM.Caste IN (" + Caste_Sel + ")"; } if (Height_Sel != "") { strSql += " AND MM.Height IN (" + Height_Sel + ")"; } if (strWeight_Sel != "") { strSql += " AND MM.Weight IN (" + strWeight_Sel + ")"; } if (StrManglik != "") { strSql += " AND MM.Manglik IN (" + StrManglik + ")"; } if (txtFromWeight.Text != "" && txtToWeight.Text != "") { strSql += " AND Weight BETWEEN " + txtFromWeight.Text + " AND " + txtToWeight.Text + ""; } if (Incom_Sel != "") { strSql += " AND AnnualIncome IN (" + Incom_Sel + ")"; } if (txtFromDate.Text != txtToDate.Text) { strSql += " AND RegisterDate between '" + txtFromDate.Value.ToString("dd/MMM/yyyy") + "' and '" + txtToDate.Value.ToString("dd/MMM/yyyy") + "'"; } strSql += " ORDER BY MemberCode DESC"; //if (State_Sel == "") //{ // MessageBox.Show("Please select any State", "State Selection Validation", MessageBoxButtons.OK, MessageBoxIcon.Hand); // return; //} string strMemberCode = ""; DataTable dt = objDb.GetDataTable(strSql); if (dt.Rows.Count > 0) { for (int cnt = 0; cnt < dt.Rows.Count; cnt++) { if (strMemberCode == "") { strMemberCode = Convert.ToString(dt.Rows[cnt]["MemberCode"]); } else { strMemberCode += "," + Convert.ToString(dt.Rows[cnt]["MemberCode"]); } } } int PageCount = 0, RecordCount = 0; tbl_MemberMasterBAL objtbl_MemberMasterBAL = new tbl_MemberMasterBAL(); DataSet dsdata = objtbl_MemberMasterBAL.Load_ProfileList_New(strMemberCode); dsdata.Tables[0].TableName = "dsMainReport"; frmReportViewer objReportViewer = new frmReportViewer(); ReportDocument cryRpt = new ReportDocument(); string strPath = ""; if (rbtnFirstPage.Checked) { strPath = Application.StartupPath + @"\REPORTS\ProfileReport.rpt"; } else if (rbtnPhoneNumber.Checked) { strPath = Application.StartupPath + @"\REPORTS\MemberPhoneNumber.rpt"; } else if (rbtnEmail.Checked) { strPath = Application.StartupPath + @"\REPORTS\MemberEmailList.rpt"; } cryRpt.Load(strPath); cryRpt.SetDataSource(dsdata.Tables[0]); objReportViewer.RptViewer.ReportSource = cryRpt; objReportViewer.RptViewer.Refresh(); objReportViewer.ShowDialog(); objReportViewer.Focus(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btnSubmit_Click(object sender, EventArgs e) { try { string strCond = "", Caste_Sel = "", Country_Sel = "", State_Sel = "", MaritalStatus_Sel = ""; if (rdbtnMale.Checked) { strCond += " AND MM.Gender=0 "; } else if (rdbtnFemale.Checked) { strCond += " AND MM.Gender=1 "; } for (int cnt = 0; cnt < LvwCaste.Items.Count; cnt++) { if (LvwCaste.Items[cnt].Checked) { if (Caste_Sel == "") { Caste_Sel = LvwCaste.Items[cnt].SubItems[LvwCaste.Columns.Count - 1].Text; } else { Caste_Sel += "," + LvwCaste.Items[cnt].SubItems[LvwCaste.Columns.Count - 1].Text; } } } if (Caste_Sel != "") { strCond += " AND MM.Caste in (" + Caste_Sel + ")"; } if (Convert.ToString(ddlPAgeFrom.SelectedValue) != Convert.ToString(ddlPAgeTo.SelectedValue)) { strCond += " AND Convert(varchar(4),MM.DateOfBirth,111) Between " + ddlPAgeFrom.SelectedValue + " AND " + ddlPAgeTo.SelectedValue + " "; } for (int cnt = 1; cnt < LvwCountry.Items.Count; cnt++) { if (LvwCountry.Items[cnt].Checked) { if (Country_Sel == "") { Country_Sel = LvwCountry.Items[cnt].SubItems[LvwCountry.Columns.Count - 1].Text; } else { Country_Sel += "," + LvwCountry.Items[cnt].SubItems[LvwCountry.Columns.Count - 1].Text; } } } if (Country_Sel != "") { strCond += " AND MM.Country in (" + Country_Sel + ")"; } for (int cnt = 1; cnt < LvwState.Items.Count; cnt++) { if (LvwState.Items[cnt].Checked) { if (State_Sel == "") { State_Sel = LvwState.Items[cnt].SubItems[LvwState.Columns.Count - 1].Text; } else { State_Sel += "," + LvwState.Items[cnt].SubItems[LvwState.Columns.Count - 1].Text; } } } if (State_Sel != "") { strCond += " AND MM.StateCity in (" + State_Sel + ")"; } for (int cnt = 1; cnt < LvwMaritalStatus.Items.Count; cnt++) { if (LvwMaritalStatus.Items[cnt].Checked) { if (MaritalStatus_Sel == "") { MaritalStatus_Sel = LvwMaritalStatus.Items[cnt].SubItems[LvwMaritalStatus.Columns.Count - 1].Text; } else { MaritalStatus_Sel += "," + LvwMaritalStatus.Items[cnt].SubItems[LvwMaritalStatus.Columns.Count - 1].Text; } } } if (MaritalStatus_Sel != "") { strCond += " AND MM.MaritalStatus in (" + MaritalStatus_Sel + ")"; } if (dtpFromDate.Value.ToShortDateString() != dtpToDate.Value.ToShortDateString()) { strCond += " AND MM.RegisterDate BETWEEN '" + dtpFromDate.Value.ToString("dd/MMM/yyyy") + "' AND '" + dtpToDate.Value.ToString("dd/MMM/yyyy") + "'"; } if (strCond == "") { MessageBox.Show("Please select Something", "Selection Validation", MessageBoxButtons.OK, MessageBoxIcon.Hand); return; } tbl_MemberMasterBAL objtbl_MemberMasterBAL = new tbl_MemberMasterBAL(); DataSet dsdata = objtbl_MemberMasterBAL.GET_REGISTERED_MEMBER(strCond); if (dsdata.Tables[0].Rows.Count > 0) { frmReportViewer objReportViewer = new frmReportViewer(); ReportDocument cryRpt = new ReportDocument(); string strPath = ""; strPath = Application.StartupPath + @"\REPORTS\RegisterReport.rpt"; cryRpt.Load(strPath); cryRpt.SetDataSource(dsdata.Tables[0]); objReportViewer.RptViewer.ReportSource = cryRpt; objReportViewer.RptViewer.Refresh(); objReportViewer.ShowDialog(); objReportViewer.Focus(); } else { MessageBox.Show("No data found", "Data not found", MessageBoxButtons.OK, MessageBoxIcon.Hand); return; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
//private void FillMemberCode(int MemberCode) //{ // try // { // tbl_MemberMasterProp Objtbl_MemberMasterProp = new tbl_MemberMasterProp(); // Objtbl_MemberMasterProp.MemberCode = MemberCode; // int PageCount = 0; // tbl_MemberMasterBAL Objtbl_MemberMasterBAL = new tbl_MemberMasterBAL(); // DataSet dsData = Objtbl_MemberMasterBAL.Select_Data(Objtbl_MemberMasterProp, ref PageCount); // txtMemberName.Text = Convert.ToString(dsData.Tables[0].Rows[0]["MemberName"]); // txtCurrentAddress.Text = Convert.ToString(dsData.Tables[0].Rows[0]["CurrentAddress"]); // ddlCountryCode.SelectedValue = Convert.ToString(dsData.Tables[0].Rows[0]["CountryCode"]); // ddlStateCode.SelectedValue = Convert.ToString(dsData.Tables[0].Rows[0]["StateCode"]); // ddlCityCode.SelectedValue = Convert.ToString(dsData.Tables[0].Rows[0]["CityCode"]); // txtPermanentAddress.Text = Convert.ToString(dsData.Tables[0].Rows[0]["PermanentAddress"]); // txtContactNo.Text = Convert.ToString(dsData.Tables[0].Rows[0]["ContactNo"]); // txtEmailID.Text = Convert.ToString(dsData.Tables[0].Rows[0]["EmailID"]); // txtDOB.Text = Convert.ToString(dsData.Tables[0].Rows[0]["DOB"]); // ddlQualificationCode.SelectedValue = Convert.ToString(dsData.Tables[0].Rows[0]["QualificationCode"]); // ddlOccupationCode.SelectedIndex = Convert.ToInt32(dsData.Tables[0].Rows[0]["OccupationCode"]); // ddlMaritalStatus.SelectedIndex = Convert.ToInt32(dsData.Tables[0].Rows[0]["MaritalStatusCode"]); // ddlGender.SelectedIndex = Convert.ToInt32(dsData.Tables[0].Rows[0]["Gender"]); // ddlNativePlace.SelectedIndex = Convert.ToInt32(dsData.Tables[0].Rows[0]["NativePlaceCode"]); // ddlNationality.SelectedIndex = Convert.ToInt32(dsData.Tables[0].Rows[0]["NationalityCode"]); // ddlPhysicallyChallanged.SelectedIndex = Convert.ToInt32(dsData.Tables[0].Rows[0]["PhysicallyChallangedCode"]); // ddlRelationshipCode.SelectedIndex = Convert.ToInt32(dsData.Tables[0].Rows[0]["RelationshipCode"]); // ddlParentCode.SelectedValue = Convert.ToString(dsData.Tables[0].Rows[0]["ParentCode"]); // Objtbl_MemberMasterProp.PhotoPath = sFilename; // ViewState["EditCode"] = MemberCode; // } // catch (Exception ex) // { // throw ex; // } //} #endregion #region "--------------- Buttons Events ---------------" protected void imgbtnSave_Click(object sender, ImageClickEventArgs e) { string sSavePath = ""; string sFilename = ""; try { if (chkDeleteFilePath.Checked == false) { // Set constant values sSavePath = "../MembersPhotos/"; // If file field isn’t empty if (flFilePath.PostedFile != null && flFilePath.PostedFile.ContentLength > 0) { // Check file size (mustn’t be 0) HttpPostedFile myFile = flFilePath.PostedFile; int nFileLen = myFile.ContentLength; if (nFileLen == 0) { ShowGuidMessage(0, new Exception("No file was uploaded.")); return; } // Check file extension (must be JPG or pdf) if (System.IO.Path.GetExtension(myFile.FileName).ToLower() != ".jpg") { ShowGuidMessage(0, new Exception("The file must have an extension of JPG or pdf")); return; } // Read file into a data stream byte[] myData = new Byte[nFileLen]; myFile.InputStream.Read(myData, 0, nFileLen); // Make sure a duplicate file doesn’t exist. If it does, keep on appending an // incremental numeric until it is unique sFilename = System.IO.Path.GetFileName(myFile.FileName); int file_append = 0; while (System.IO.File.Exists(Server.MapPath(sSavePath + sFilename))) { file_append++; sFilename = System.IO.Path.GetFileNameWithoutExtension(myFile.FileName) + file_append.ToString() + System.IO.Path.GetExtension(myFile.FileName).ToLower(); } // Save the stream to disk System.IO.FileStream newFile = new System.IO.FileStream(Server.MapPath(sSavePath + sFilename), System.IO.FileMode.Create); newFile.Write(myData, 0, myData.Length); newFile.Close(); // Check whether the file is really a JPEG by opening it System.Drawing.Image.GetThumbnailImageAbort myCallBack = new System.Drawing.Image.GetThumbnailImageAbort(ThumbnailCallback); Bitmap myBitmap; try { myBitmap = new Bitmap(Server.MapPath(sSavePath + sFilename)); tdUploadedFile.Visible = true; tdUploadedFile.InnerHtml = "<a href=\"..\\" + sSavePath + sFilename + ">Download Attachment</a>"; // Displaying success information //tdError.InnerText = "File uploaded successfully!"; // Destroy objects myBitmap.Dispose(); } catch { // The file wasn't a valid jpg file System.IO.File.Delete(Server.MapPath(sSavePath + sFilename)); ShowGuidMessage(0, new Exception("The file wasn't a valid jpg file")); return; } } } if (sFilename == "" && Convert.ToInt32(ViewState["EditCode"]) > 0) { sFilename = Convert.ToString(ViewState["PhotoPath"]); } else if (sFilename == "" && Convert.ToInt32(ViewState["EditCode"]) <= 0) { sFilename = "noimage.jpg"; } else if (chkDeleteFilePath.Checked == true) { if (Convert.ToInt32(ViewState["EditCode"]) > 0) { System.IO.File.Delete(Server.MapPath(sSavePath + Convert.ToString(ViewState["PhotoPath"]))); } sFilename = "noimage.jpg"; } tbl_MemberMasterProp Objtbl_MemberMasterProp = new tbl_MemberMasterProp(); Objtbl_MemberMasterProp.MemberCode = Convert.ToInt32(ViewState["EditCode"]); Objtbl_MemberMasterProp.MemberName = txtMemberName.Text; Objtbl_MemberMasterProp.CurrentAddress = txtCurrentAddress.Text; Objtbl_MemberMasterProp.CountryCode = Convert.ToInt32(ddlCountryCode.SelectedValue); Objtbl_MemberMasterProp.StateCode = Convert.ToInt32(ddlStateCode.SelectedValue); Objtbl_MemberMasterProp.CityCode = Convert.ToInt32(ddlCityCode.SelectedValue); Objtbl_MemberMasterProp.PermanentAddress = txtPermanentAddress.Text; Objtbl_MemberMasterProp.ContactNo = txtContactNo.Text; Objtbl_MemberMasterProp.EmailID = txtEmailID.Text; Objtbl_MemberMasterProp.Password = "******"; Objtbl_MemberMasterProp.DOB = new DateTime(Convert.ToInt32(txtDOB.Text.Split('/')[2]), Convert.ToInt32(txtDOB.Text.Split('/')[1]), Convert.ToInt32(txtDOB.Text.Split('/')[0])); Objtbl_MemberMasterProp.QualificationCode = Convert.ToInt32(ddlQualificationCode.SelectedValue); Objtbl_MemberMasterProp.OccupationCode = Convert.ToInt32(ddlOccupationCode.Text); Objtbl_MemberMasterProp.MaritalStatusCode = Convert.ToInt32(ddlMaritalStatus.SelectedIndex); Objtbl_MemberMasterProp.Gender = Convert.ToBoolean(ddlGender.SelectedIndex); Objtbl_MemberMasterProp.NativePlaceCode = Convert.ToInt32(ddlNativePlace.SelectedValue); Objtbl_MemberMasterProp.NationalityCode = Convert.ToInt32(ddlNationality.SelectedValue); Objtbl_MemberMasterProp.PhysicalChallangedCode = Convert.ToInt32(ddlPhysicallyChallanged.SelectedIndex); Objtbl_MemberMasterProp.RelationshipCode = Convert.ToInt32(ddlRelationshipCode.SelectedIndex); Objtbl_MemberMasterProp.ParentCode = Convert.ToInt32(ddlParentCode.SelectedValue); Objtbl_MemberMasterProp.PhotoPath = sFilename; tbl_MemberMasterBAL Objtbl_MemberMasterBAL = new tbl_MemberMasterBAL(); Objtbl_MemberMasterBAL.InsertUpdate_Data(Objtbl_MemberMasterProp); ShowGuidMessage(1, null); mdlPopupNewEntry.Hide(); FillData(); } catch (Exception ex) { ShowGuidMessage(0, ex); //MessageBox.Show(ex.Message); } }
private void dgvDetails_CellClick(object sender, DataGridViewCellEventArgs e) { try { int intRowNo = e.RowIndex; string strCode = Convert.ToString(dgvDetails[(int)CI.MemberCode, e.RowIndex].Value); string ProfileId = Convert.ToString(dgvDetails[(int)CI.ProfileId, e.RowIndex].Value); if (e.ColumnIndex == (int)CI.Edit) { this.objEventLoging.AppClickLog("Search", "Edit", ProfileId, strCode, ""); //Global.strMemberCode = strCode; frmMemberMaster objMember = new frmMemberMaster(); if (Convert.ToString(dgvDetails[(int)CI.Status, e.RowIndex].Value) == "Active") { frmMemberMaster.isActiveStatus = 1; } else if (Convert.ToString(dgvDetails[(int)CI.Status, e.RowIndex].Value) == "Updated") { frmMemberMaster.isActiveStatus = 2; } frmMemberMaster.strMemberCode = strCode; objMember.ShowDialog(); txtCurPage.Text = "1"; FillData(""); ddlSearchBy.SelectedIndex = 0; txtSearchValue.Text = ""; } else if (e.ColumnIndex == (int)CI.Print) { this.objEventLoging.AppClickLog("Search", "Print", ProfileId, strCode, ""); //DataTable dsData = new DataTable(); //int PageCount = 0; //string strSql = "select MemberCode,ProfileID,ProfileCreatedBy,MemberName,Gender,DateofBirth,TimeofBirth,BirthPlace,MaritalStatus "; //strSql += " from tbl_membermaster where MemberCode=" + strCode; //dsData = objDb.GetDataTable(strSql); tbl_MemberMasterProp Objtbl_MemberMasterProp = new tbl_MemberMasterProp(); Objtbl_MemberMasterProp.MemberCode = 0; Objtbl_MemberMasterProp.ProfileID = ProfileId; // ProfileID; Objtbl_MemberMasterProp.isLogedin = true; Objtbl_MemberMasterProp.LoginCode = 0; tbl_MemberMasterBAL Objtbl_MemberMasterBAL = new tbl_MemberMasterBAL(); DataSet dsMemberMaster = Objtbl_MemberMasterBAL.Load_MemberDetails(Objtbl_MemberMasterProp); dsMemberMaster.Tables[0].TableName = "dsMemberMaster"; tbl_SibblingDetailsProp Objtbl_SibblingDetailsProp = new tbl_SibblingDetailsProp(); Objtbl_SibblingDetailsProp.MemberCode = Convert.ToInt32(dsMemberMaster.Tables[0].Rows[0]["MemberCode"]); tbl_SibblingDetailsBAL Objtbl_SibblingDetailsBAL = new tbl_SibblingDetailsBAL(); DataSet dsSibbling = Objtbl_SibblingDetailsBAL.Select_Data(Objtbl_SibblingDetailsProp); dsSibbling.Tables[0].TableName = "dsSibblingDtl"; tbl_MemberPhotosBAL objtbl_MemberPhotosBAL = new tbl_MemberPhotosBAL(); tbl_MemberPhotosProp objtbl_MemberPhotosProp = new tbl_MemberPhotosProp(); objtbl_MemberPhotosProp.MemberCode = Convert.ToInt32(strCode); DataSet dsMemberPhotos = objtbl_MemberPhotosBAL.Select_Data(objtbl_MemberPhotosProp); dsMemberPhotos.Tables[0].TableName = "dsMemberPhotos"; // dsMemberMaster.Tables.Add(dsSibbling.Tables[0]); //dsMemberMaster.Tables.Add(dsMemberPhotos.Tables[0]); frmReportViewer objReportViewer = new frmReportViewer(); ReportDocument cryRpt = new ReportDocument(); string strPath = Application.StartupPath + @"\REPORTS\MemberMaster.rpt"; cryRpt.Load(strPath); DataSet dstest = new DataSet(); dstest.Tables.Add(dsMemberMaster.Tables[0].Copy()); //dstest.Tables.Add(dsMemberPhotos.Tables[0].Copy()); cryRpt.Subreports["Sibbling"].SetDataSource(dsSibbling.Tables[0]); //cryRpt.Subreports["MemberPhotos"].SetDataSource(dsMemberPhotos.Tables[0]); cryRpt.SetDataSource(dstest); objReportViewer.RptViewer.ReportSource = cryRpt; objReportViewer.RptViewer.Refresh(); objReportViewer.ShowDialog(); objReportViewer.Focus(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btnSearch_Click(object sender, EventArgs e) { try { Cursor = Cursors.WaitCursor; string strCode = ""; if (txtProfileId.Text == "") { MessageBox.Show("Please Enter Profile Id", "Profile Id Validation", MessageBoxButtons.OK, MessageBoxIcon.Error); txtProfileId.Focus(); return; } if (txtProfileId.Text != "") { string strSQl = "select * from tbl_Membermaster where ProfileId='" + txtProfileId.Text.Trim() + "' "; DataTable dt = objDb.GetDataTable(strSQl); if (dt.Rows.Count > 0) { strCode = Convert.ToString(dt.Rows[0]["MemberCode"]); } else { MessageBox.Show("Please Enter valid Profile Id", "Valid Profile Id", MessageBoxButtons.OK, MessageBoxIcon.Error); txtProfileId.Focus(); return; } } tbl_MemberMasterProp Objtbl_MemberMasterProp = new tbl_MemberMasterProp(); Objtbl_MemberMasterProp.MemberCode = Convert.ToInt32(strCode); Objtbl_MemberMasterProp.ProfileID = ""; // ProfileID; Objtbl_MemberMasterProp.isLogedin = true; Objtbl_MemberMasterProp.LoginCode = 0; tbl_MemberMasterBAL Objtbl_MemberMasterBAL = new tbl_MemberMasterBAL(); DataSet dsMemberMaster = Objtbl_MemberMasterBAL.Load_MemberDetails(Objtbl_MemberMasterProp); dsMemberMaster.Tables[0].TableName = "dsMemberMaster"; tbl_SibblingDetailsProp Objtbl_SibblingDetailsProp = new tbl_SibblingDetailsProp(); Objtbl_SibblingDetailsProp.MemberCode = Convert.ToInt32(dsMemberMaster.Tables[0].Rows[0]["MemberCode"]); tbl_SibblingDetailsBAL Objtbl_SibblingDetailsBAL = new tbl_SibblingDetailsBAL(); DataSet dsSibbling = Objtbl_SibblingDetailsBAL.Select_Data(Objtbl_SibblingDetailsProp); dsSibbling.Tables[0].TableName = "dsSibblingDtl"; tbl_MemberPhotosBAL objtbl_MemberPhotosBAL = new tbl_MemberPhotosBAL(); tbl_MemberPhotosProp objtbl_MemberPhotosProp = new tbl_MemberPhotosProp(); objtbl_MemberPhotosProp.MemberCode = Convert.ToInt32(strCode); DataSet dsMemberPhotos = objtbl_MemberPhotosBAL.Select_Data(objtbl_MemberPhotosProp); dsMemberPhotos.Tables[0].TableName = "dsMemberPhotos"; // dsMemberMaster.Tables.Add(dsSibbling.Tables[0]); //dsMemberMaster.Tables.Add(dsMemberPhotos.Tables[0]); frmReportViewer objReportViewer = new frmReportViewer(); ReportDocument cryRpt = new ReportDocument(); string strPath = Application.StartupPath + @"\REPORTS\MemberMaster.rpt"; cryRpt.Load(strPath); DataSet dstest = new DataSet(); dstest.Tables.Add(dsMemberMaster.Tables[0].Copy()); //dstest.Tables.Add(dsMemberPhotos.Tables[0].Copy()); cryRpt.Subreports["Sibbling"].SetDataSource(dsSibbling.Tables[0]); //cryRpt.Subreports["MemberPhotos"].SetDataSource(dsMemberPhotos.Tables[0]); cryRpt.SetDataSource(dstest); objReportViewer.RptViewer.ReportSource = cryRpt; objReportViewer.RptViewer.Refresh(); objReportViewer.ShowDialog(); objReportViewer.Focus(); Cursor = Cursors.Default; } catch (Exception ex) { MessageBox.Show(Convert.ToString(ex.Message)); this.objEventLoging.AppErrlog("Error In AnantMatrimony.rfrmQuickReport.btnSearch_Click() " + ex.ToString()); } }
public void CreateEmailDesign(string[] ArrDesign, string[] ArrTo) { try { if (ArrTo.Length > 0 && ArrDesign.Length > 0) { string strHtml = ""; strHtml += " <html xmlns='http://www.w3.org/1999/xhtml'> "; strHtml += " <head> "; strHtml += " <meta http-equiv='Content-Type' content='text/html; charset=utf-8' /> "; strHtml += " <title></title> "; strHtml += " <link href='https://fonts.googleapis.com/css?family=Lato:400,500,600,700' rel='stylesheet' /> "; strHtml += " </head> "; strHtml += " <body style='font-family: ' lato',=Lato', sans-serif;background-color=sans-serif;background-color #ffffff;margin=#ffffff;margin 0px;padding=0px;padding 0px;width=0px;width 100%;font-size=100%;font-size 15px;font-weight=15px;font-weight 400;color=400;color #323232;line-height=#323232;line-height 18px;text-align:left;'=18px;text-align:left;'> "; strHtml += " <table width='700px' border='0' align='center' cellpadding='0' cellspacing='0' class='contentbg'> "; strHtml += " <tr><td valign='top'><table width='100%' border='0' cellspacing='0' cellpadding='0'><tr> "; strHtml += " <td valign='top' bgcolor='#FFFFFF'><table width='800' border='0' align='center' cellpadding='0' cellspacing='0'> "; strHtml += " <tr><td width='800' height='105' align='left' valign='top'><table width='800' border='0' cellspacing='0' cellpadding='0'> "; strHtml += " <tr><td valign='top' bgcolor='#ca3b3b' style='padding:35px;'><a href='#'><img src='http://www.anantmatrimony.com/images/logo.png' width='349' height='107' alt='logo' style='margin-left: auto;margin-right: auto;' /></a></td> "; strHtml += " </tr></table><table width='800' border='0' cellspacing='0' cellpadding='0'> "; strHtml += " <tr><td width='800' valign='top' style='padding:35px;text-align:center;font-size: 24px;font-weight: 600;color: #ca3b3b;'>Match with your profile</td> "; strHtml += " </tr></table></td></tr></table></td></tr></table></td></tr><tr><td> "; strHtml += " <table width='100%' border='0' cellspacing='0' cellpadding='0'><tr> <td valign='top' bgcolor='#ffffff'> "; strHtml += " <table width='540px' style='margin-left:160px;' border='0' align='center' cellpadding='0' cellspacing='0'> "; for (int cnt = 0; cnt < ArrDesign.Length; cnt++) { //<!--Loop Start--> tbl_MemberMasterBAL objtbl_MemberMasterBAL = new tbl_MemberMasterBAL(); DataSet dsdata = objtbl_MemberMasterBAL.Load_ProfileList_New(ArrDesign[cnt]); if (dsdata.Tables[0].Rows.Count > 0) { strHtml += " <tr> "; strHtml += " <td width='200' valign='top'> "; strHtml += " <table width='100%' border='0' cellspacing='0' cellpadding='0'> "; strHtml += " <tr> "; strHtml += " <td valign='top' width='100' style='color:#ca3b3b;line-height:24px;'>" + dsdata.Tables[0].Rows[0]["ProfileId"] + "</td> "; strHtml += " </tr> </table> </td> </tr> <tr> "; strHtml += " <td width='800' valign='top'> "; strHtml += " <table width='100%' border='0' cellspacing='0' cellpadding='0'> <tr> "; strHtml += " <td valign='top' width='100'><img src='http://www.anantmatrimony.com/MemberPhoto/" + Convert.ToString(dsdata.Tables[0].Rows[0]["PhotoFileName"]) + "' width='166' height='166' alt='sub image' style='display:block;' /></td> "; strHtml += " <td width='700' valign='top'> "; strHtml += " <table width='100%' border='0' cellspacing='0' cellpadding='0'> "; strHtml += " <tr> "; strHtml += " <td valign='top' width='300'> "; strHtml += " <table width='100%' border='0' cellspacing='0' cellpadding='0'> "; strHtml += " <tr> "; strHtml += " <td> "; strHtml += " <ul> "; strHtml += " <li style='list-style-type: none;line-height: 26px;'>Birth Year: " + Convert.ToString(dsdata.Tables[0].Rows[0]["BirthYear"]) + "</li> "; strHtml += " <li style='list-style-type: none;line-height: 26px;'>Caste: " + Convert.ToString(dsdata.Tables[0].Rows[0]["Caste"]) + "</li> "; strHtml += " <li style='list-style-type: none;line-height: 26px;'>Height: " + Convert.ToString(dsdata.Tables[0].Rows[0]["Height"]) + "</li> "; strHtml += " <li style='list-style-type: none;line-height: 26px;'>Weight: " + Convert.ToString(dsdata.Tables[0].Rows[0]["Weight"]) + "</li> "; strHtml += " <li style='list-style-type: none;line-height: 26px;'>Marital Status : " + Convert.ToString(dsdata.Tables[0].Rows[0]["MaritalStatus"]) + "</li> "; strHtml += " </ul> "; strHtml += " </td> "; strHtml += " <td width='400' valign='top'> "; strHtml += " <table width='100%' border='0' cellspacing='0' cellpadding='0'> "; strHtml += " <tr> "; strHtml += " <td valign='top' style='padding-left:30px;'> "; strHtml += " <table width='100%' border='0' cellspacing='0' cellpadding='0'> "; strHtml += " <tr> "; strHtml += " <td> "; strHtml += " <ul> "; strHtml += " <li style='list-style-type: none;line-height: 26px;'>Education: " + Convert.ToString(dsdata.Tables[0].Rows[0]["Education"]) + "</li> "; strHtml += " <li style='list-style-type: none;line-height: 26px;'>Degree: " + Convert.ToString(dsdata.Tables[0].Rows[0]["Degree"]) + "</li> "; strHtml += " <li style='list-style-type: none;line-height: 26px;'>State / City: " + Convert.ToString(dsdata.Tables[0].Rows[0]["StateCity"]) + "</li> "; strHtml += " <li style='list-style-type: none;line-height: 26px;'>Visa Status: " + Convert.ToString(dsdata.Tables[0].Rows[0]["VisaStatus"]) + "</li> "; strHtml += " <li style='list-style-type: none;line-height: 26px;'>Visa Country: " + Convert.ToString(dsdata.Tables[0].Rows[0]["VisaCountry"]) + "</li> "; strHtml += " </ul> "; strHtml += " </td> "; strHtml += " </tr> "; strHtml += " </table> "; strHtml += " </td> "; strHtml += " </tr> "; strHtml += " </table> "; strHtml += " </td> "; strHtml += " </tr> "; strHtml += " </table> "; strHtml += " </td> "; strHtml += " </tr> "; strHtml += " </table> "; //<!--Promotion End--> strHtml += " </td> "; strHtml += " </tr> "; strHtml += " </table> "; strHtml += " </td> "; strHtml += " </tr> "; //<!--Loop END--> //<!--Browse All--> } } strHtml += " <tr><td width='800' valign='top'><table width='650' border='0' cellspacing='0' cellpadding='0' style='padding-top:20px;'> "; strHtml += " <tr><td valign='top' width='500' style='color:#ca3b3b;line-height:24px;text-align:center;font-size:18px;padding-left:50px;'><b><a href='http://www.anantmatrimony.com' target='_blank' style='color:#ca3b3b;'>BROWSE ALL >></a></b></td> "; strHtml += " </tr></table></td></tr><tr> <td valign='top'> <table width='100%' border='0' cellspacing='0' cellpadding='0'> "; strHtml += " <tr> <td valign='top'> <table width='600' border='0' align='center' cellpadding='0' cellspacing='0'> <tr> <td valign='top' style='padding:20px 0px;'> "; strHtml += " <table width='500px' border='0' cellspacing='0' cellpadding='0'> <tr> <td width='800' valign='top'> <table width='100%' border='0' cellspacing='0' cellpadding='0'> "; strHtml += " <tr> <td class='footerheading' width='800' valign='top' style='padding-bottom:16px;text-align:center;font-size: 22px;font-weight: 600;color: #323232;line-height: 44px;'>For More Details, Call Us!</td> "; strHtml += " </tr> <tr> <td width='800' valign='top' style='padding-bottom:16px;border-bottom:1px solid #e8e8e8;font-size: 35px;font-weight: 600;color: #f54d56;line-height: 24px;text-align:center;'>9428412065/9998489093</td> "; strHtml += " </tr> </table> </td> </tr> </table> </td> </tr> </table> </td> </tr> <tr> <td valign='top'> <table width='800' border='0' align='center' cellpadding='0' cellspacing='0'> "; strHtml += " <tr> <td valign='top' style='padding-bottom:33px;'> <table width='100%' border='0' cellspacing='0' cellpadding='0'> <tr> <td width='800' valign='top'> "; strHtml += " <table width='800' border='0' cellspacing='0' cellpadding='0'> <tr> <td valign='top' style='padding-top:21px; padding-bottom:17px;'> "; strHtml += " <table width='100%' border='0' cellspacing='0' cellpadding='0'></table> </td> </tr> <tr> "; strHtml += " <td valign='top' style='font-size:13px;color:#989797;text-align:center; padding-right:84px;'> "; strHtml += " © 2003 - 2019 AnantMatrimony.com & Kankukanya.com. All Rights Reserved.<br /> </td> </tr> </table> </td> </tr> <tr> <td width='150' valign='top'> "; strHtml += " <table width='100%' border='0' cellspacing='0' cellpadding='0'></table> </td> <td width='150' valign='top'> <table width='100%' border='0' cellspacing='0' cellpadding='0'></table> "; strHtml += " </td></tr></table></td></tr></table></td></tr></table></td></tr> </table></td></tr></table></td></tr></table></body></html> "; txtMessageLog.Text = "Design Ready"; txtMessageLog.Text += Environment.NewLine; txtMessageLog.Text += "Total " + ArrTo.Length + " email going to send"; for (int cnt1 = 0; cnt1 < ArrTo.Length; cnt1++) { tbl_MemberMasterBAL objtbl_MemberMasterBAL = new tbl_MemberMasterBAL(); DataSet dsdata = objtbl_MemberMasterBAL.Load_ProfileList_New(ArrTo[cnt1]); objGlobal.SendMail(Convert.ToString(dsdata.Tables[0].Rows[0]["EmailId"]), "AnantMatrimony : Match with your profile", strHtml, true, "*****@*****.**", "Changeme@123"); txtMessageLog.Text += " >> Mail Number (" + (cnt1 + 1) + ") >> Mail sent on " + Convert.ToString(dsdata.Tables[0].Rows[0]["EmailId"]); txtMessageLog.Text += Environment.NewLine; } } MessageBox.Show("Mail Send", "Mail send", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btnSubmit_Click(object sender, EventArgs e) { try { string Caste_Sel = "", Education_Sel = "", Country_Sel = "", State_Sel = "", MaritalStatus_Sel = "", strHeight = "", strWeight = ""; tbl_MemberMasterSearchProp Objtbl_MemberMasterSearchProp = new tbl_MemberMasterSearchProp(); Objtbl_MemberMasterSearchProp.sMemberCode = -1; Objtbl_MemberMasterSearchProp.sGender = (rdbtnMale.Checked == true ? "0" : "1"); Objtbl_MemberMasterSearchProp.sAgeStart = ddlPAgeFrom.Text; Objtbl_MemberMasterSearchProp.sAgeUpto = ddlPAgeTo.Text; Objtbl_MemberMasterSearchProp.PageNo = 0; Objtbl_MemberMasterSearchProp.RecordCount = 0; Objtbl_MemberMasterSearchProp.sSqlCondition = true; for (int cnt = 0; cnt < LvwCaste.Items.Count; cnt++) { if (LvwCaste.Items[cnt].Checked) { if (Caste_Sel == "") { Caste_Sel = LvwCaste.Items[cnt].SubItems[LvwCaste.Columns.Count - 1].Text; } else { Caste_Sel += "," + LvwCaste.Items[cnt].SubItems[LvwCaste.Columns.Count - 1].Text; } } } Objtbl_MemberMasterSearchProp.sCaste = Caste_Sel; if (Caste_Sel == "") { MessageBox.Show("Please select any caste", "Caste Selection Validation", MessageBoxButtons.OK, MessageBoxIcon.Hand); return; } Country_Sel = ""; for (int cnt = 0; cnt < LvwCountry.Items.Count; cnt++) { if (LvwCountry.Items[cnt].SubItems[LvwCountry.Columns.Count - 1].Text != "-1") { if (LvwCountry.Items[cnt].Checked) { if (Country_Sel == "") { Country_Sel = LvwCountry.Items[cnt].SubItems[LvwCountry.Columns.Count - 1].Text; } else { Country_Sel += "," + LvwCountry.Items[cnt].SubItems[LvwCountry.Columns.Count - 1].Text; } } } } Objtbl_MemberMasterSearchProp.sCountry = Country_Sel; //if (Country_Sel == "") //{ // MessageBox.Show("Please select any Country", "Country Selection Validation", MessageBoxButtons.OK, MessageBoxIcon.Hand); // return; //} for (int cnt = 0; cnt < LvwEducation.Items.Count; cnt++) { if (LvwEducation.Items[cnt].SubItems[LvwEducation.Columns.Count - 1].Text != "-1") { if (LvwEducation.Items[cnt].Checked) { if (Education_Sel == "") { Education_Sel = LvwEducation.Items[cnt].SubItems[LvwEducation.Columns.Count - 1].Text; } else { Education_Sel += "," + LvwEducation.Items[cnt].SubItems[LvwEducation.Columns.Count - 1].Text; } } } } Objtbl_MemberMasterSearchProp.sEducation = Education_Sel; //if (Education_Sel == "") //{ // MessageBox.Show("Please select any Education", "Education Selection Validation", MessageBoxButtons.OK, MessageBoxIcon.Hand); // return; //} for (int cnt = 0; cnt < LvwMaritalStatus.Items.Count; cnt++) { if (LvwMaritalStatus.Items[cnt].SubItems[LvwMaritalStatus.Columns.Count - 1].Text != "-1") { if (LvwMaritalStatus.Items[cnt].Checked) { if (MaritalStatus_Sel == "") { MaritalStatus_Sel = LvwMaritalStatus.Items[cnt].SubItems[LvwMaritalStatus.Columns.Count - 1].Text; } else { MaritalStatus_Sel += "," + LvwMaritalStatus.Items[cnt].SubItems[LvwMaritalStatus.Columns.Count - 1].Text; } } } } Objtbl_MemberMasterSearchProp.sMaritalStatus = MaritalStatus_Sel; //if (MaritalStatus_Sel == "") //{ // MessageBox.Show("Please select any Marital Status", "Marital Status Selection Validation", MessageBoxButtons.OK, MessageBoxIcon.Hand); // return; //} for (int cnt = 0; cnt < LvwState.Items.Count; cnt++) { if (LvwState.Items[cnt].SubItems[LvwState.Columns.Count - 1].Text != "-1") { if (LvwState.Items[cnt].Checked) { if (State_Sel == "") { State_Sel = LvwState.Items[cnt].SubItems[LvwState.Columns.Count - 1].Text; } else { State_Sel += "," + LvwState.Items[cnt].SubItems[LvwState.Columns.Count - 1].Text; } } } } Objtbl_MemberMasterSearchProp.sStateCity = State_Sel; //Objtbl_MemberMasterSearchProp.sSqlCondition //if (State_Sel == "") //{ // MessageBox.Show("Please select any State", "State Selection Validation", MessageBoxButtons.OK, MessageBoxIcon.Hand); // return; //} int PageCount = 0, RecordCount = 0; tbl_MemberMasterBAL objtbl_MemberMasterBAL = new tbl_MemberMasterBAL(); DataSet dsdata = objtbl_MemberMasterBAL.Load_ProfileList(Objtbl_MemberMasterSearchProp, ref PageCount, ref RecordCount); dsdata.Tables[0].TableName = "dsMainReport"; frmReportViewer objReportViewer = new frmReportViewer(); ReportDocument cryRpt = new ReportDocument(); string strPath = ""; if (rbtnFirstPage.Checked) { strPath = Application.StartupPath + @"\REPORTS\ProfileReport.rpt"; } else if (rbtnEmail.Checked) { strPath = Application.StartupPath + @"\REPORTS\MemberEmailList.rpt"; } else if (rbtnPhoneNumber.Checked) { strPath = Application.StartupPath + @"\REPORTS\MemberPhoneNumber.rpt"; } cryRpt.Load(strPath); cryRpt.SetDataSource(dsdata.Tables[0]); objReportViewer.RptViewer.ReportSource = cryRpt; objReportViewer.RptViewer.Refresh(); objReportViewer.ShowDialog(); objReportViewer.Focus(); } catch (Exception ex) { MessageBox.Show(ex.Message); return; } }