private void btnSubmit_Click(object sender, EventArgs e) { try { tbl_QueryProp objtbl_QueryProp = new tbl_QueryProp(); if (MessageCode > 0) { objtbl_QueryProp.MessageCode = MessageCode; } else { objtbl_QueryProp.MessageCode = 0; } tbl_QueryBAL objtbl_QueryBAL = new tbl_QueryBAL(); objtbl_QueryProp.Address = txtAddress.Text; objtbl_QueryProp.ContactNo = txtContactNo.Text; //objtbl_QueryProp.Date = dtpDate.Value; objtbl_QueryProp.Email = txtEmail.Text; objtbl_QueryProp.SenderMessage = txtMessage.Text; objtbl_QueryProp.SenderName = txtName.Text; objtbl_QueryProp.Subject = txtSubject.Text; objtbl_QueryProp.Surname = ""; objtbl_QueryProp.Status = false; objtbl_QueryProp.Date = DateTime.Today; objtbl_QueryBAL.InsertUpdate_Data(objtbl_QueryProp); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public DataSet FillData(string strSearch) { DataSet dsData = new DataSet(); try { int PageCount = 0; tbl_QueryProp objtbl_QueryProp = new tbl_QueryProp(); objtbl_QueryProp.PageNo = Convert.ToInt32(txtCurPage.Text); objtbl_QueryProp.RecordCount = Convert.ToInt32(20); tbl_QueryBAL Objtbl_QueryBAL = new tbl_QueryBAL(); dsData = Objtbl_QueryBAL.Select_Data(objtbl_QueryProp, ref PageCount); lblTotalPageCount.Text = Convert.ToString(PageCount); FillGrid(dsData); return(dsData); } catch (Exception ex) { MessageBox.Show(Convert.ToString(ex.Message)); this.objEventLoging.AppErrlog("Error In AnantMatrimony.frmMemberMaster.FillData() " + ex.ToString()); } return(dsData); }
private void UnreadMessage() { tbl_QueryProp objtbl_QueryProp = new tbl_QueryProp(); tbl_QueryBAL objtbl_QueryBAL = new tbl_QueryBAL(); DataSet dsData = objtbl_QueryBAL.CountUnreadMessage(objtbl_QueryProp); lnkQueryMessage.Text = "Unread Message ( " + Convert.ToString(dsData.Tables[0].Rows[0]["messCode"]) + " )"; }
private void FillData(int MessCode) { try { int PageCount = 0; tbl_QueryProp objtbl_QueryProp = new tbl_QueryProp(); objtbl_QueryProp.MessageCode = MessCode; tbl_QueryBAL objtbl_QueryBAL = new tbl_QueryBAL(); DataSet dsData = objtbl_QueryBAL.Select_Data(objtbl_QueryProp, ref PageCount); txtName.Text = Convert.ToString(dsData.Tables[0].Rows[0]["Surname"]) + " " + Convert.ToString(dsData.Tables[0].Rows[0]["SenderName"]); txtContactNo.Text = Convert.ToString(dsData.Tables[0].Rows[0]["ContactNo"]); txtEmail.Text = Convert.ToString(dsData.Tables[0].Rows[0]["Email"]); txtAddress.Text = Convert.ToString(dsData.Tables[0].Rows[0]["Address"]); txtSubject.Text = Convert.ToString(dsData.Tables[0].Rows[0]["Subject"]); txtMessage.Text = Convert.ToString(dsData.Tables[0].Rows[0]["SenderMessage"]); dtpDate.Value = Convert.ToDateTime(dsData.Tables[0].Rows[0]["Date"]); objtbl_QueryProp.Address = txtAddress.Text; objtbl_QueryProp.ContactNo = txtContactNo.Text; objtbl_QueryProp.Date = dtpDate.Value; objtbl_QueryProp.Email = txtEmail.Text; objtbl_QueryProp.SenderMessage = txtMessage.Text; objtbl_QueryProp.SenderName = txtName.Text; objtbl_QueryProp.Subject = txtSubject.Text; objtbl_QueryProp.Surname = ""; objtbl_QueryProp.Status = true; //objtbl_QueryProp.Date = DateTime.Today; objtbl_QueryBAL.InsertUpdate_Data(objtbl_QueryProp); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public DataSet SeaarchData(string sSearchBy, string sSearchVal) { DataSet ds = new DataSet(); try { tbl_QueryProp objtbl_QueryProp = new tbl_QueryProp(); objtbl_QueryProp.SearchBy = sSearchBy; objtbl_QueryProp.SearchVal = sSearchVal; objtbl_QueryProp.PageNo = 1; objtbl_QueryProp.RecordCount = 10000; tbl_QueryBAL Objtbl_QueryBAL = new tbl_QueryBAL(); int PageCount = 0; ds = Objtbl_QueryBAL.Search_Data(objtbl_QueryProp); } catch (Exception ex) { MessageBox.Show(Convert.ToString(ex.Message)); this.objEventLoging.AppErrlog("Error In AnantMatrimony.frmMemberMaster.SeaarchData() " + ex.ToString()); } return(ds); }