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);
}
}
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 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());
}
}
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);
}
}