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