protected void dgvGridView_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (!string.IsNullOrEmpty(e.CommandArgument.ToString()))
{
objCommon = new clsCommon();
if (e.CommandName == "IsView")
{
objReviews = new tblReviews();
objDataTable = objReviews.LoadReviewByID(e.CommandArgument.ToString());
objReviews = null;
if (objDataTable.Rows.Count > 0)
{
hdnPKID.Value = e.CommandArgument.ToString();
lblUserName.Text = objDataTable.Rows[0][tblCustomer.ColumnNames.AppFirstName].ToString() + " " + objDataTable.Rows[0][tblCustomer.ColumnNames.AppLastName].ToString();
lblComment.Text = objDataTable.Rows[0][tblReviews.ColumnNames.AppComment].ToString();
lblDate.Text = objDataTable.Rows[0][tblReviews.ColumnNames.AppReviewDate].ToString();
lblRating.Text = objDataTable.Rows[0][tblReviews.ColumnNames.AppRating].ToString();
mpeReviewView.Show();
}
}
objCommon = null;
}
}
private bool Delete(int intPKID)
{
bool retval = false;
objReviews = new tblReviews();
var _with1 = objReviews;
if (_with1.LoadByPrimaryKey(intPKID))
{
tblReviews objReviewDetail = new tblReviews();
objReviewDetail.Where.AppReviewID.Value = _with1.AppReviewID;
objReviewDetail.Query.Load();
if (objReviewDetail.RowCount > 0)
{
objReviewDetail.DeleteAll();
objReviewDetail.Save();
}
objReviewDetail = null;
_with1.MarkAsDeleted();
_with1.Save();
}
retval = true;
objReviews = null;
return(retval);
}
protected void btnSave_Click(object sender, EventArgs e)
{
objReviews = new tblReviews();
objReviews.LoadByPrimaryKey(Convert.ToInt32(hdnPKID.Value));
objReviews.s_AppPublishedBy = Session[appFunctions.Session.UserID.ToString()].ToString();
objReviews.AppPublishedDate = GetDateTime();
objReviews.s_AppReviewStatus = Convert.ToInt32(Enums.Enum_ReviewStatus.Approved).ToString();
objReviews.Save();
LoadDataGrid(true, false);
}
public void LoadReviewList()
{
if (hdnProductDetailId.Value != "")
{
tblReviews objReviews = new tblReviews();
RptRating.DataSource = objReviews.LoadReviewsProductvise(hdnProductDetailId.Value);
RptRating.DataBind();
objReviews = null;
}
}
private void LoadDataGrid(bool IsResetPageIndex, bool IsSort)
{
objReviews = new tblReviews();
// objDataTable = objReviews.LoadPendingReviewGridData(ddlFields.SelectedValue, txtSearch.Text.Trim(), ddlUserName.SelectedValue, ddlProfessionalName.SelectedValue);
objDataTable = objReviews.LoadPendingReviewGridData(hdnProductDetailID.Value, "", Convert.ToInt32(ddlStatus.SelectedValue), txtStartDate.Text, txtEndDate.Text);
if (IsResetPageIndex)
{
if (dgvGridView.PageCount > 0)
{
dgvGridView.PageIndex = 0;
}
}
dgvGridView.DataSource = null;
dgvGridView.DataBind();
lblCount.Text = 0.ToString();
hdnSelectedIDs.Value = "";
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);
}//objDataTable.Rows[0][tblProduct.ColumnNames.AppProductID].ToString();
lblProductName.Text = objDataTable.Rows[0][tblProduct.ColumnNames.AppProductName].ToString();
lblCount.Text = objDataTable.Rows.Count.ToString();
if (IsSort)
{
objDataTable = SortDatatable(objDataTable, ViewState["SortColumn"].ToString(), (appFunctions.Enum_SortOrderBy)ViewState["SortOrder"], IsSort);
}
dgvGridView.DataSource = objDataTable;
dgvGridView.DataBind();
}
objReviews = null;
}
private void LoadDataGrid(bool IsResetPageIndex, bool IsSort)
{
objReviews = new tblReviews();
objDataTable = objReviews.LoadPendingCommentsDataAdmin(ddlFields.SelectedValue, txtSearch.Text);
if (IsResetPageIndex)
{
if (dgvGridView.PageCount > 0)
{
dgvGridView.PageIndex = 0;
}
}
dgvGridView.DataSource = null;
dgvGridView.DataBind();
lblCount.Text = 0.ToString();
hdnSelectedIDs.Value = "";
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();
if (IsSort)
{
objDataTable = SortDatatable(objDataTable, ViewState["SortColumn"].ToString(), (appFunctions.Enum_SortOrderBy)ViewState["SortOrder"], IsSort);
}
dgvGridView.DataSource = objDataTable;
dgvGridView.DataBind();
}
objReviews = null;
}
private bool Delete(int intPKID)
{
bool retval = false;
objReviews = new tblReviews();
var _with1 = objReviews;
if (_with1.LoadByPrimaryKey(intPKID))
{
_with1.MarkAsDeleted();
_with1.Save();
}
retval = true;
objReviews = null;
return(retval);
}
private bool Reject(int intPKID)
{
bool retval = false;
objReviews = new tblReviews();
if (objReviews.LoadByPrimaryKey(intPKID))
{
if (objReviews.RowCount > 0)
{
objReviews.s_AppRemark = txtRemark.Text;
objReviews.AppReviewStatus = Convert.ToInt32(Enums.Enum_ReviewStatus.Rejected);
objReviews.Save();
}
objReviews = null;
}
retval = true;
objReviews = null;
return(retval);
}
private bool Approve(int intPKID)
{
bool retval = false;
objReviews = new tblReviews();
if (objReviews.LoadByPrimaryKey(intPKID))
{
if (objReviews.RowCount > 0)
{
objReviews.s_AppPublishedBy = Session[appFunctions.Session.UserID.ToString()].ToString();
objReviews.AppPublishedDate = GetDateTime();
objReviews.AppRemark = "";
objReviews.AppReviewStatus = Convert.ToInt32(Enums.Enum_ReviewStatus.Approved);
objReviews.Save();
}
objReviews = null;
}
retval = true;
objReviews = null;
return(retval);
}
public bool Saveview()
{
// CheckSession();
objReviews = new tblReviews();
objReviews.AddNew();
objReviews.s_AppProductDetailID = hdnProductDetailId.Value;
objReviews.s_AppCustomerID = Session[appFunctions.Session.ClientUserID.ToString()].ToString();
objReviews.s_AppRating = RatingReview.CurrentRating.ToString();
objReviews.AppReviewStatus = Convert.ToInt32(Enums.Enum_ReviewStatus.Submitted);
objReviews.AppReviewDate = GetDateTime();
objReviews.s_AppComment = txtReview.Text;
objReviews.s_AppTitle = txtTitle.Text;
objReviews.Save();
objReviews = null;
return(true);
}
