private bool SaveSubCategoryData()
{
if (hdnPKID.Value != "")
{
objCommon = new clsCommon();
objPropertySubCategory = new tblPropertySubCategory();
objPropertySubCategory.AddNew();
objPropertySubCategory.s_AppCreatedBy = Session[appFunctions.Session.UserID.ToString()].ToString();
objPropertySubCategory.AppCreatedDate = DateTime.Now;
objPropertySubCategory.AppDisplayOrder = objCommon.GetNextDisplayOrder("tblPropertySubCategory", tblPropertySubCategory.ColumnNames.AppDisplayOrder, tblPropertySubCategory.ColumnNames.AppPropertyID + "=" + hdnPKID.Value);
objPropertySubCategory.s_AppPropertyID = hdnPKID.Value;
objPropertySubCategory.Save();
objPropertySubCategory = null;
objCommon = null;
return(true);
}
else
{
return(false);
}
}
public void LoadUnselectedCategories()
{
if (ddlCategory.SelectedIndex > 0)
{
objPropertySubCategory = new tblPropertySubCategory();
objDataTable = objPropertySubCategory.LoadUnSelectedCategories(hdnPKID.Value, ddlCategory.SelectedValue);
dgvUnSelectedCategories.DataSource = null;
dgvUnSelectedCategories.DataBind();
if (objDataTable.Rows.Count <= 0)
{
DInfoSubCategoryGrid.ShowMessage("No data found", Enums.MessageType.Information);
return;
}
else
{
dgvUnSelectedCategories.AllowPaging = false;
dgvUnSelectedCategories.DataSource = objDataTable;
dgvUnSelectedCategories.DataBind();
}
objPropertySubCategory = null;
}
else
{
dgvUnSelectedCategories.DataSource = null;
dgvUnSelectedCategories.DataBind();
}
}
protected void dgvSubCategory_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (!string.IsNullOrEmpty(e.CommandArgument.ToString()))
{
objCommon = new clsCommon();
if (e.CommandName == "Edit")
{
hdnSubCategoryId.Value = e.CommandArgument.ToString();
SetSubCategoryValuesToControls();
}
else if (e.CommandName == "Up")
{
LinkButton inkButton = (LinkButton)e.CommandSource;
GridViewRow drCurrent = (GridViewRow)inkButton.Parent.Parent;
if (drCurrent.RowIndex > 0)
{
GridViewRow drUp = dgvSubCategory.Rows[drCurrent.RowIndex - 1];
objCommon.SetDisplayOrder("tblPropertySubCategory", tblPropertySubCategory.ColumnNames.AppPropertySubCategoryID, tblPropertySubCategory.ColumnNames.AppDisplayOrder, (int)dgvSubCategory.DataKeys[drCurrent.RowIndex].Values[0], (int)dgvSubCategory.DataKeys[drCurrent.RowIndex].Values[1], (int)dgvSubCategory.DataKeys[drUp.RowIndex].Values[0], (int)dgvSubCategory.DataKeys[drUp.RowIndex].Values[1]);
LoadSubCategoryData(false, false);
objCommon = null;
}
}
else if (e.CommandName == "Down")
{
LinkButton lnkButton = (LinkButton)e.CommandSource;
GridViewRow drCurrent = (GridViewRow)lnkButton.Parent.Parent;
if (drCurrent.RowIndex < dgvSubCategory.Rows.Count - 1)
{
GridViewRow drUp = dgvSubCategory.Rows[drCurrent.RowIndex + 1];
objCommon.SetDisplayOrder("tblPropertySubCategory", tblPropertySubCategory.ColumnNames.AppPropertySubCategoryID, tblPropertySubCategory.ColumnNames.AppDisplayOrder, (int)dgvSubCategory.DataKeys[drCurrent.RowIndex].Values[0], (int)dgvSubCategory.DataKeys[drCurrent.RowIndex].Values[1], (int)dgvSubCategory.DataKeys[drUp.RowIndex].Values[0], (int)dgvSubCategory.DataKeys[drUp.RowIndex].Values[1]);
LoadSubCategoryData(false, false);
objCommon = null;
}
}
else if (e.CommandName == "IsActive")
{
objPropertySubCategory = new tblPropertySubCategory();
if (objPropertySubCategory.LoadByPrimaryKey(Convert.ToInt32(e.CommandArgument.ToString())))
{
if (objPropertySubCategory.AppIsActive == true)
{
objPropertySubCategory.AppIsActive = false;
}
else if (objPropertySubCategory.AppIsActive == false)
{
objPropertySubCategory.AppIsActive = true;
}
objPropertySubCategory.Save();
LoadSubCategoryData(false, false);
}
objPropertySubCategory = null;
}
}
}
private bool DeleteSubCategory(int intPKID)
{
bool retval = false;
objPropertySubCategory = new tblPropertySubCategory();
var _with1 = objPropertySubCategory;
if (_with1.LoadByPrimaryKey(intPKID))
{
_with1.MarkAsDeleted();
_with1.Save();
}
retval = true;
objPropertySubCategory = null;
return(retval);
}
public void LoadSubCategoryData(bool IsResetPageIndex, bool IsSort, string strFieldName = "", string strFieldValue = "")
{
objPropertySubCategory = new tblPropertySubCategory();
objDataTable = objPropertySubCategory.LoadGridData(hdnPKID.Value, ddlSerachCategory.SelectedValue, ddlSerachSubCategory.SelectedValue);
if (IsResetPageIndex)
{
if (dgvSubCategory.PageCount > 0)
{
dgvSubCategory.PageIndex = 0;
}
}
dgvSubCategory.DataSource = null;
dgvSubCategory.DataBind();
lblSubCategoryCount.Text = 0.ToString();
hdnSelectedIDs.Value = "";
if (objDataTable.Rows.Count <= 0)
{
DinfoBranchGrid.ShowMessage("No data found", Enums.MessageType.Information);
return;
}
else
{
if (ddlSubCategoryPerPage.SelectedItem.Text.ToLower() == "all")
{
dgvSubCategory.AllowPaging = false;
}
else
{
dgvSubCategory.AllowPaging = true;
dgvSubCategory.PageSize = Convert.ToInt32(ddlSubCategoryPerPage.SelectedItem.Text);
}
lblSubCategoryCount.Text = objDataTable.Rows.Count.ToString();
objDataTable = SortDatatable(objDataTable, ViewState["SortColumn"].ToString(), (appFunctions.Enum_SortOrderBy)ViewState["SortOrder"], IsSort);
dgvSubCategory.DataSource = objDataTable;
dgvSubCategory.DataBind();
}
objPropertySubCategory = null;
}
private void SetSubCategoryValuesToControls()
{
if (!string.IsNullOrEmpty(hdnSubCategoryId.Value) && hdnSubCategoryId.Value != "")
{
objPropertySubCategory = new tblPropertySubCategory();
if (objPropertySubCategory.LoadByPrimaryKey(Convert.ToInt32(hdnSubCategoryId.Value)))
{
tblSubCategory objTemp = new tblSubCategory();
if (objTemp.LoadByPrimaryKey(objPropertySubCategory.AppSubCategoryID))
{
ddlCategory.SelectedValue = objTemp.s_AppCategoryID;
objCommon = new clsCommon();
objCommon = null;
}
objTemp = null;
}
objPropertySubCategory = null;
}
}
protected void dgvUnSelectedCategories_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (!string.IsNullOrEmpty(e.CommandArgument.ToString()))
{
objCommon = new clsCommon();
if (e.CommandName == "IsAdd")
{
objPropertySubCategory = new tblPropertySubCategory();
objPropertySubCategory.AddNew();
objPropertySubCategory.AppDisplayOrder = objCommon.GetNextDisplayOrder("tblPropertySubCategory", tblPropertySubCategory.ColumnNames.AppDisplayOrder, tblPropertySubCategory.ColumnNames.AppPropertyID + "=" + hdnPKID.Value);
objPropertySubCategory.s_AppPropertyID = hdnPKID.Value;
objPropertySubCategory.s_AppSubCategoryID = e.CommandArgument.ToString();
objPropertySubCategory.AppIsActive = true;
objPropertySubCategory.Save();
objPropertySubCategory = null;
LoadUnselectedCategories();
LoadSubCategoryData(false, false);
objCommon = null;
}
}
}
