private void LoadDataGrid(bool IsResetPageIndex, bool IsSort, string strFieldName = "", string strFieldValue = "")
{
objSubscribe = new tblSubscribe();
objDataTable = objSubscribe.LoadGridData(ddlFields.SelectedValue, txtSearch.Text.Trim());
//'Reset PageIndex of gridviews
if (IsResetPageIndex)
{
if (dgvGridView.PageCount > 0)
{
dgvGridView.PageIndex = 0;
}
}
dgvGridView.DataSource = null;
dgvGridView.DataBind();
lblCount.Text = 0.ToString();
hdnSelectedIDs.Value = "";
//'Check for data into datatable
if (objDataTable.Rows.Count <= 0)
{
DInfo.ShowMessage("No data found", Enums.MessageType.Information);
return;
}
else
{
if (ddlPerPage.SelectedItem.Text.ToLower() == "all")
{
dgvGridView.AllowPaging = false;
}
else
{
dgvGridView.AllowPaging = true;
dgvGridView.PageSize = Convert.ToInt32(ddlPerPage.SelectedItem.Text);
}
lblCount.Text = objDataTable.Rows.Count.ToString();
objDataTable = SortDatatable(objDataTable, ViewState["SortColumn"].ToString(), (appFunctions.Enum_SortOrderBy)ViewState["SortOrder"], IsSort);
dgvGridView.DataSource = objDataTable;
dgvGridView.DataBind();
}
objSubscribe = null;
}
private bool Delete(int intPKID)
{
bool retval = false;
objSubscribe = new tblSubscribe();
var _with1 = objSubscribe;
if (_with1.LoadByPrimaryKey(intPKID))
{
_with1.MarkAsDeleted();
_with1.Save();
}
retval = true;
objSubscribe = null;
return retval;
}
protected void dgvGridView_RowCommand(object sender, System.Web.UI.WebControls.GridViewCommandEventArgs e)
{
if (e.CommandName == "IsActive")
{
objSubscribe = new tblSubscribe();
if (objSubscribe.LoadByPrimaryKey(Convert.ToInt32(e.CommandArgument.ToString())))
{
if (objSubscribe.AppIsActive == true)
{
objSubscribe.AppIsActive = false;
}
else if (objSubscribe.AppIsActive == false)
{
objSubscribe.AppIsActive = true;
}
objSubscribe.Save();
LoadDataGrid(false, false);
}
objSubscribe = null;
}
}
public bool SaveSubscriber()
{
objCommon = new clsCommon();
if (objCommon.IsRecordExists("tblSubscribe", tblSubscribe.ColumnNames.AppEmail, tblSubscribe.ColumnNames.AppSubscribeID, txtUserEmail.Text))
{
DisplayInfoSubScribe.ShowMessage("Email address already exist", Enums.MessageType.Error);
return(false);
}
objCommon = null;
tblSubscribe objNewsLetterSubScriber = new tblSubscribe();
objNewsLetterSubScriber.AddNew();
objNewsLetterSubScriber.AppEmail = txtUserEmail.Text.Trim();
objNewsLetterSubScriber.AppIsActive = true;
objNewsLetterSubScriber.AppCreatedDate = GetDateTime();
objNewsLetterSubScriber.Save();
SendMail(objNewsLetterSubScriber.s_AppSubscribeID);
objNewsLetterSubScriber = null;
return(true);
}
