private bool SaveData() { objCommon = new clsCommon(); if (objCommon.IsRecordExists("tblSubCategory", tblSubCategory.ColumnNames.AppSubCategory, tblSubCategory.ColumnNames.AppSubCategoryID, txtSubCategoryName.Text, hdnPKID.Value, tblSubCategory.ColumnNames.AppCategoryID + "=" + ddlCategory.SelectedValue)) { DInfo.ShowMessage("Sub Category Name alredy exits.", Enums.MessageType.Error); return(false); } objSubCategory = new tblSubCategory(); if (!string.IsNullOrEmpty(hdnPKID.Value) && hdnPKID.Value != "") { objSubCategory.LoadByPrimaryKey(Convert.ToInt32(hdnPKID.Value)); } else { objSubCategory.AddNew(); objSubCategory.s_AppCreatedBy = Session[appFunctions.Session.UserID.ToString()].ToString(); objSubCategory.AppDisplayOrder = objCommon.GetNextDisplayOrder("tblSubCategory", tblSubCategory.ColumnNames.AppDisplayOrder, tblSubCategory.ColumnNames.AppCategoryID + "=" + ddlCategory.SelectedValue); // objSubCategory.s_AppCreatedDate = FormatDateString(DateTime.Now.ToString(strInputDateFormat), strInputDateFormat, strOutputDateFormat); objSubCategory.AppCreatedDate = DateTime.Now; } objSubCategory.s_AppSubCategory = txtSubCategoryName.Text; objSubCategory.s_AppCategoryID = ddlCategory.SelectedValue; objSubCategory.AppIsActive = chkIsActive.Checked; objSubCategory.Save(); intPkId = objSubCategory.AppSubCategoryID; objSubCategory = null; objCommon = null; return(true); }
public async Task <string> AddUpdateSubCategory(SubCategoryDomainModel subCategory) { string status = ""; if (subCategory.subCat_id > 0) { tblSubCategory subCategoryToUpdate = await subCategoryRepository.SingleOrDefault(s => s.subCat_id == subCategory.subCat_id); if (subCategoryToUpdate != null) { subCategoryToUpdate.subCat_id = subCategory.subCat_id; subCategoryToUpdate.name = subCategory.name; subCategoryToUpdate.cat_id = subCategory.cat_id; await subCategoryRepository.Update(subCategoryToUpdate); status = "updated"; } } else { tblSubCategory subCategoryToAdd = new tblSubCategory(); subCategoryToAdd.subCat_id = subCategory.subCat_id; subCategoryToAdd.name = subCategory.name; subCategoryToAdd.cat_id = subCategory.cat_id; await subCategoryRepository.Insert(subCategoryToAdd); status = "added"; } return(status); }
protected void dgvGridView_RowCommand(object sender, System.Web.UI.WebControls.GridViewCommandEventArgs e) { if (!string.IsNullOrEmpty(e.CommandArgument.ToString())) { objCommon = new clsCommon(); if (e.CommandName == "Up") { LinkButton inkButton = (LinkButton)e.CommandSource; GridViewRow drCurrent = (GridViewRow)inkButton.Parent.Parent; if (drCurrent.RowIndex > 0) { GridViewRow drUp = dgvGridView.Rows[drCurrent.RowIndex - 1]; objCommon.SetDisplayOrder("tblSubCategory", tblSubCategory.ColumnNames.AppSubCategoryID, tblSubCategory.ColumnNames.AppDisplayOrder, (int)dgvGridView.DataKeys[drCurrent.RowIndex].Values[0], (int)dgvGridView.DataKeys[drCurrent.RowIndex].Values[1], (int)dgvGridView.DataKeys[drUp.RowIndex].Values[0], (int)dgvGridView.DataKeys[drUp.RowIndex].Values[1]); LoadDataGrid(false, false); objCommon = null; } } else if (e.CommandName == "Down") { LinkButton lnkButton = (LinkButton)e.CommandSource; GridViewRow drCurrent = (GridViewRow)lnkButton.Parent.Parent; if (drCurrent.RowIndex < dgvGridView.Rows.Count - 1) { GridViewRow drUp = dgvGridView.Rows[drCurrent.RowIndex + 1]; objCommon.SetDisplayOrder("tblSubCategory", tblSubCategory.ColumnNames.AppSubCategoryID, tblSubCategory.ColumnNames.AppDisplayOrder, (int)dgvGridView.DataKeys[drCurrent.RowIndex].Values[0], (int)dgvGridView.DataKeys[drCurrent.RowIndex].Values[1], (int)dgvGridView.DataKeys[drUp.RowIndex].Values[0], (int)dgvGridView.DataKeys[drUp.RowIndex].Values[1]); LoadDataGrid(false, false); objCommon = null; } } else if (e.CommandName == "IsActive") { objSubCategory = new tblSubCategory(); if (objSubCategory.LoadByPrimaryKey(Convert.ToInt32(e.CommandArgument.ToString()))) { if (objSubCategory.AppIsActive == true) { objSubCategory.AppIsActive = false; } else if (objSubCategory.AppIsActive == false) { objSubCategory.AppIsActive = true; } objSubCategory.Save(); LoadDataGrid(false, false, "", ""); } objSubCategory = null; } } }
private void SetValuesToControls() { if (!string.IsNullOrEmpty(hdnPKID.Value) && hdnPKID.Value != "") { objSubCategory = new tblSubCategory(); if (objSubCategory.LoadByPrimaryKey(Convert.ToInt32(hdnPKID.Value))) { ddlCategory.SelectedValue = objSubCategory.s_AppCategoryID; txtSubCategoryName.Text = objSubCategory.AppSubCategory; chkIsActive.Checked = objSubCategory.AppIsActive; } objSubCategory = null; } }
private void LoadDataGrid(bool IsResetPageIndex, bool IsSort, string strFieldName = "", string strFieldValue = "") { objSubCategory = new tblSubCategory(); objDataTable = objSubCategory.LoadGridData(ddlFields.SelectedValue, txtSearch.Text.Trim(), ddlCategory.SelectedValue); //'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(); } objSubCategory = null; }
private bool Delete(int intPKID) { bool retval = false; objSubCategory = new tblSubCategory(); var _with1 = objSubCategory; if (_with1.LoadByPrimaryKey(intPKID)) { _with1.MarkAsDeleted(); _with1.Save(); } retval = true; objSubCategory = null; return(retval); }
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 dgvCategory_RowDataBound(object sender, GridViewRowEventArgs e) { DataControlRowType itemType = e.Row.RowType; switch (itemType) { case DataControlRowType.DataRow: string strID = dgvCategory.DataKeys[e.Row.RowIndex].Values[0].ToString(); Label lbl = (Label)e.Row.FindControl("lblCategory"); tblSubCategory objSubCategory = new tblSubCategory(); objCommon = new clsCommon(); lbl.Text = ": " + objCommon.JoinWithComma(objSubCategory.GetAllSubCategoryProductWise(hdnPKID.Value, strID), tblSubCategory.ColumnNames.AppSubCategory, Enums.Enum_DataType.sString); objCommon = null; objSubCategory = null; break; } }
private void SetSubCategoryValuesToControls() { if (!string.IsNullOrEmpty(hdnSubCategoryId.Value) && hdnSubCategoryId.Value != "") { objSizeSubCategory = new tblSizeSubCategory(); if (objSizeSubCategory.LoadByPrimaryKey(Convert.ToInt32(hdnSubCategoryId.Value))) { tblSubCategory objTemp = new tblSubCategory(); if (objTemp.LoadByPrimaryKey(objSizeSubCategory.AppSubCategoryID)) { ddlCategory.SelectedValue = objTemp.s_AppCategoryID; objCommon = new clsCommon(); // objCommon.FillDropDownList(ddlSubCategory, "tblSubCategory ", tblSubCategory.ColumnNames.AppSubCategory, tblSubCategory.ColumnNames.AppSubCategoryID, "--Select Sub Category--", tblSubCategory.ColumnNames.AppSubCategory, appFunctions.Enum_SortOrderBy.Asc, tblSubCategory.ColumnNames.AppCategoryID + "=" + ddlCategory.SelectedValue); objCommon = null; // ddlSubCategory.SelectedValue = objSizeSubCategory.s_AppSubCategoryID; } objTemp = null; } objSizeSubCategory = null; } }
void IRepo <tblSubCategory> .remove(tblSubCategory entity) { throw new NotImplementedException(); }
public IEnumerable <tblSubCategory> find(tblSubCategory v) { var filteredList = subCategoriesList.Where(current => current.SubCategory_Name == v.SubCategory_Name); return(filteredList); }
private void SetValuesToControls() { if (!string.IsNullOrEmpty(hdnPKID.Value) && hdnPKID.Value != "") { tblProduct objproduct = new tblProduct(); if (objproduct.LoadByPrimaryKey(Convert.ToInt32(hdnPKID.Value))) { lblProductCode.Text = objproduct.AppProductCode; lblProductName.Text = objproduct.AppProductName; lblProductTag.Text = objproduct.AppProductTag; divDescription.InnerHtml = objproduct.AppDescription; if (objproduct.s_AppIsColor != "") { if (objproduct.AppIsColor) { lblIsColor.Text = "Yes"; } } if (objproduct.s_AppIsSize != "") { if (objproduct.AppIsSize) { lblIsSize.Text = "Yes"; } } divMetaKeyWord.InnerHtml = objproduct.AppMetaKeyWord; divMetaDescription.InnerHtml = objproduct.AppMetaDescription; tblSubCategory objSubCategory = new tblSubCategory(); objDataTable = objSubCategory.GetAllCategoryProductWise(objproduct.s_AppProductID); dgvCategory.DataSource = null; dgvCategory.DataBind(); if (objDataTable.Rows.Count > 0) { divCategory.Style.Add("display", "block"); dgvCategory.DataSource = objDataTable; dgvCategory.DataBind(); } else { divCategory.Style.Add("display", "none"); } objSubCategory = null; tblProductColor objProductColor = new tblProductColor(); objDataTable = objProductColor.LoadGridData(objproduct.s_AppProductID, "0"); dgvColor.DataSource = null; dgvColor.DataBind(); if (objDataTable.Rows.Count > 0) { divColor.Style.Add("display", "block"); dgvColor.DataSource = objDataTable; dgvColor.DataBind(); } else { divColor.Style.Add("display", "none"); } objProductColor = null; tblRelatedProduct objRelatedProduct = new tblRelatedProduct(); objDataTable = objRelatedProduct.LoadRelatedProduct(objproduct.s_AppProductID); dgvRelatedProduct.DataSource = null; dgvRelatedProduct.DataBind(); if (objDataTable.Rows.Count > 0) { divRelatedProduct.Style.Add("display", "block"); dgvRelatedProduct.DataSource = objDataTable; dgvRelatedProduct.DataBind(); } else { divRelatedProduct.Style.Add("display", "none"); } objRelatedProduct = null; tblProductProperty objProductProperty = new tblProductProperty(); objDataTable = objProductProperty.LoadGridData(hdnPKID.Value); dgvProperty.DataSource = null; dgvProperty.DataBind(); if (objDataTable.Rows.Count > 0) { divProperty.Style.Add("display", "block"); dgvProperty.DataSource = objDataTable; dgvProperty.DataBind(); } else { divProperty.Style.Add("display", "none"); } objProductProperty = null; } objproduct = null; } }
public void SetupStaticMenu(ref StringBuilder targetString) { tblCategory objCategory = new tblCategory(); DataTable dtCategory = objCategory.LoadAllCategory(); if (dtCategory.Rows.Count > 0) { string PageName = ""; PageName = GetAlias("Products.aspx"); tblSubCategory objSubCategory = new tblSubCategory(); DataTable dtSubCategory = objSubCategory.LoadAllSubCategory(); objSubCategory = null; foreach (DataRow Row in dtCategory.Rows) { targetString.Append("<li>"); targetString.Append("<a href='" + PageName + generateUrl(Row[tblCategory.ColumnNames.AppCategory].ToString()) + "'>" + Row[tblCategory.ColumnNames.AppCategory].ToString() + "</a>"); targetString.Append("<a class=\"plus\">+</a>"); DataRow[] Subdr = dtSubCategory.Select(tblSubCategory.ColumnNames.AppCategoryID + "=" + Row[tblCategory.ColumnNames.AppCategoryID], tblSubCategory.ColumnNames.AppDisplayOrder + " Asc"); if (Subdr.Length > 0) { targetString.Append("<div class=\"megapanel\">"); targetString.Append(" <div class=\"row\">"); targetString.Append(" <div class=\"col2\">"); targetString.Append(" <div class=\"h_nav\">"); targetString.Append(" <h4>"); targetString.Append(Row[tblCategory.ColumnNames.AppCategory].ToString()); targetString.Append("</h4>"); int i = 0; targetString.Append("<ul>"); foreach (DataRow SubRow in Subdr) { targetString.Append("<li>"); //if (i == Subdr.Length - 1) //{ // targetString.Append(" last"); //} //targetString.Append(" \">"); targetString.Append("<a href='" + PageName + generateUrl(Row[tblCategory.ColumnNames.AppCategory].ToString()) + "/" + generateUrl(SubRow[tblSubCategory.ColumnNames.AppSubCategory].ToString()) + "'>" + SubRow[tblSubCategory.ColumnNames.AppSubCategory].ToString() + "</a>"); targetString.Append("</li>"); i++; } targetString.Append("</ul>"); targetString.Append("</div>"); targetString.Append("</div>"); tblExclusive objExclusive = new tblExclusive(); DataTable dt = objExclusive.LoadTop2Data(Row[tblCategory.ColumnNames.AppCategoryID].ToString()); if (dt.Rows.Count > 0) { foreach (DataRow dtRow in dt.Rows) { //targetString.Append("<a href='" + projectPrefix + Row["appAlias"].ToString() + "'>"); //if (Row["appMenuItemType"].ToString() == "Home") //{ // targetString.Append("<img src=\"" + projectPrefix + "Images/home.png\" width=\"16px\" style=\"padding:2px 0px;\" />"); //} targetString.Append("<a href='" + dtRow[tblExclusive.ColumnNames.AppLink].ToString() + "'>"); targetString.Append("<div class=\"col2\"><div class=\"h_nav\"><h4>"); if (dtRow[tblExclusive.ColumnNames.AppTitle].ToString() != "") { targetString.Append(dtRow[tblExclusive.ColumnNames.AppTitle].ToString()); } else { targetString.Append("Exclusive"); } targetString.Append("</h4><div class=\"menuimg\"><img src=\"" + strServerURL + "admin/" + dtRow[tblExclusive.ColumnNames.AppImage].ToString() + "\" /></div></div></div>"); targetString.Append("</a>"); //targetString.Append("<div class=\"col2\"><div class=\"h_nav\"><h4>Exclusive</h4><img src=\"" + strServerURL + "images/222.jpg\" width=\"100%\" /></div></div>"); } } objExclusive = null; targetString.Append("</div>"); targetString.Append("</div>"); } targetString.Append("</li>"); } } dtCategory = null; objCategory = null; //string PageName = ""; //if (Enums.Enums_Type.Solution == intEnum) //{ // tblSolution objSolution = new tblSolution(); // objData = objSolution.GetAllSolution(); // objSolution = null; // PageName = GetAlias("SolutionDetails.aspx"); //} //else if (Enums.Enums_Type.Product == intEnum) //{ // tblProduct objProduct = new tblProduct(); // objData = objProduct.GetAllProduct(); // objProduct = null; // PageName = GetAlias("ProductDetails.aspx"); //} //if (objData.Rows.Count > 0) //{ // targetString.Append("<ul class=\"dropdown-menu\" > "); // foreach (DataRow row in objData.Rows) // { // targetString.Append("<li><a href='" + PageName + generateUrl(row["appPage"].ToString()) + "'>" + row["appPage"].ToString() + "</a></li>"); // } // targetString.Append("</ul>"); //} //objData = null; }