/// <summary> /// Gets the details of a single category. /// </summary> /// <param name="categoryId">The id of the category to get.</param> /// <param name="userId">The id of the user performing the operation.</param> /// <returns>The details of the category. An instance of the <see cref="CategoryDetails"/> class.</returns> public async Task <CategoryDetails> GetCategoryAsync(string categoryId, string userId) { var categoryDocument = await this.categoriesRepository.GetCategoryAsync(categoryId, userId).ConfigureAwait(false); if (categoryDocument == null) { return(null); } var details = new CategoryDetails { Id = categoryDocument.Id, ImageUrl = categoryDocument.ImageUrl, Name = categoryDocument.Name, }; ((List <string>)details.Synonyms).AddRange(categoryDocument.Synonyms); ((List <CategoryItemDetails>)details.Items).AddRange(categoryDocument.Items.Select(i => new CategoryItemDetails { Id = i.Id, Type = i.Type, Preview = i.Preview, }).ToList()); return(details); }
public async Task GetCategoryReturnsCorrectText() { // arrange var fakeCategoriesRepository = new FakeCategoriesRepository(); fakeCategoriesRepository.CategoryDocuments.Add( new CategoryDocument { Id = "fakeid", Name = "fakename", UserId = "fakeuserid", ImageUrl = new Uri("https://www.edenimageurl.com/"), }); var service = new CategoriesService( fakeCategoriesRepository, new Mock <IImageSearchService>().Object, new Mock <ISynonymService>().Object, new Mock <IEventGridPublisherService>().Object); // act CategoryDetails result = await service.GetCategoryAsync("fakeid", "fakeuserid").ConfigureAwait(false); // assert Assert.IsNotNull(result); Assert.AreEqual("fakeid", result.Id); Assert.AreEqual("fakename", result.Name); Assert.AreEqual("https://www.edenimageurl.com/", result.ImageUrl.ToString()); }
// Get category details public static CategoryDetails GetCategoryDetails(string categoryId) { // get a configured DbCommand object DbCommand comm = GenericDataAccess.CreateCommand(); // set the stored procedure name comm.CommandText = "CatalogGetCategoryDetails"; // create a new parameter DbParameter param = comm.CreateParameter(); param.ParameterName = "@CategoryID"; param.Value = categoryId; param.DbType = DbType.Int32; comm.Parameters.Add(param); // execute the stored procedure DataTable table = GenericDataAccess.ExecuteSelectCommand(comm); // wrap retrieved data into a CategoryDetails object CategoryDetails details = new CategoryDetails(); if (table.Rows.Count > 0) { details.DepartmentId = Int32.Parse(table.Rows[0]["DepartmentID"].ToString()); details.Name = table.Rows[0]["Name"].ToString(); details.Description = table.Rows[0]["Description"].ToString(); } // return department details return(details); }
public async Task <IActionResult> PutCategoryDetails([FromRoute] int id, [FromBody] CategoryDetails categoryDetails) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != categoryDetails.id) { return(BadRequest()); } _context.Entry(categoryDetails).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!CategoryDetailsExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public int InsertCategorySetting(CategoryDetails obj, string user_code) { int result = 0; try { using (IDbConnection connection = IDbOpenConnection()) { var p = new DynamicParameters(); p.Add("@UserTypeCode", obj.User_Type_Code); p.Add("@category", obj.Category); p.Add("@kilometer", obj.Kilometer); p.Add("@lesscategory", obj.Less_than_Kilometer); p.Add("@greatercatergory", obj.Greater_than_kilometer); p.Add("@user_code", user_code); p.Add("@From_date", obj.Effective_From); p.Add("@To_date", obj.Effective_To); p.Add("@Result", 0, DbType.Int32, ParameterDirection.Output); connection.Query <int>("Sp_Hd_InsertCategorySetting", p, commandType: CommandType.StoredProcedure).SingleOrDefault(); result = p.Get <int>("@Result"); connection.Close(); } } catch (Exception ex) { throw ex; } return(result); }
public CategoryDetails GetCategory(long categoryId) { Category category = CategoryDao.Find(categoryId); CategoryDetails categoryDetails = new CategoryDetails(category.categoryId, category.name); return(categoryDetails); }
// Fill the page with data private void PopulateControls() { // Retrieve DepartmentID from the query string string departmentId = Request.QueryString["DepartmentID"]; // Retrieve CategoryID from the query string string categoryId = Request.QueryString["CategoryID"]; // If browsing a category... if (categoryId != null) { // Retrieve category details and display them CategoryDetails cd = CatalogBLO.GetCategoryDetails(categoryId); catalogTitleLabel.Text = cd.Name; catalogDescriptionLabel.Text = cd.Description; // Set the title of the page this.Title = ShopConfiguration.SiteName + " : Category : " + cd.Name; } // If browsing a department... else if (departmentId != null) { // Retrieve department details and display them DepartmentDetails dd = CatalogBLO.GetDepartmentDetails(departmentId); catalogTitleLabel.Text = dd.Name; catalogDescriptionLabel.Text = dd.Description; // Set the title of the page this.Title = ShopConfiguration.SiteName + " : Department : " + dd.Name; } }
private void btnUpdate_Click(object sender, EventArgs e) { if (txtCategoryName.Text == "") { MessageBox.Show("Please Enter Category Name", "", MessageBoxButtons.OK, MessageBoxIcon.Warning); txtCategoryName.Focus(); return; } CategoryDetails cd = new CategoryDetails(); cd.Id = Convert.ToInt32(txtId.Text); cd.CategoryName = txtCategoryName.Text; cd.AddedDate = System.DateTime.Now; bool isexists = blc.CheckCategory(txtCategoryName.Text); if (isexists) { MessageBox.Show("Category Already Exists in Database", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); txtCategoryName.Text = ""; txtCategoryName.Focus(); } else { int i = blc.UpdateCategory(cd); if (i > 0) { MessageBox.Show("Category Updated Successfully", "Record", MessageBoxButtons.OK, MessageBoxIcon.Information); txtCategoryName.Text = ""; txtCategoryName.Focus(); } } }
// Fill the page with data private void PopulateControls() { // Retrieve DepartmentID from the query string string departmentId = Request.QueryString["DepartmentID"]; // Retrieve CategoryID from the query string string categoryId = Request.QueryString["CategoryID"]; // If browsing a category... if (categoryId != null) { // Retrieve category and department details and display them CategoryDetails cd = CatalogAccess.GetCategoryDetails(categoryId); catalogTitleLabel.Text = HttpUtility.HtmlEncode(cd.Name); DepartmentDetails dd = CatalogAccess.GetDepartmentDetails(departmentId); catalogDescriptionLabel.Text = HttpUtility.HtmlEncode(cd.Description); // Set the title of the page this.Title = HttpUtility.HtmlEncode(BalloonShopConfiguration.SiteName + ": " + dd.Name + ": " + cd.Name); } // If browsing a department... else if (departmentId != null) { // Retrieve department details and display them DepartmentDetails dd = CatalogAccess.GetDepartmentDetails(departmentId); catalogTitleLabel.Text = HttpUtility.HtmlEncode(dd.Name); catalogDescriptionLabel.Text = HttpUtility.HtmlEncode(dd.Description); // Set the title of the page this.Title = HttpUtility.HtmlEncode(BalloonShopConfiguration.SiteName + ": " + dd.Name); } }
public async Task <dynamic> GetDocCategoriesForSpecificUser(string _DestroyPolicyID, string _OwnerID, string _DestroyID) { List <DSM_DocCategory> objDsmDocCategories = null; List <DSM_DestroyPolicy> dsmDestroyPolicies = null; List <DSM_DestroyPolicy> dsmDestroy = null; await Task.Run(() => _docCategoryService.GetDocCategories("", UserID, out objDsmDocCategories)); await Task.Run(() => _destroyPolicyService.GetDestroyPolicyBySearchParam(null, UserID, _OwnerID, null, null, null, null, out dsmDestroyPolicies)); await Task.Run(() => _docDestroyService.GetDestroyDetailsBySearchParam(_DestroyID, UserID, _OwnerID, null, null, null, null, out dsmDestroy)); if (_DestroyID == "") { var result = (from dc in dsmDestroyPolicies where dc.PolicyDetailStatus == 1 & dc.DocTypeID == "" & dc.OwnerID == _OwnerID join c in objDsmDocCategories on dc.DocCategoryID equals c.DocCategoryID select new { DestroyPolicyDtlID = dc.DestroyPolicyDtlID, DestroyPolicyID = dc.DestroyPolicyID, DocCategoryID = dc.DocCategoryID, DocCategoryName = c.DocCategoryName, IsSelected = false, TimeValue = (dc.TimeValue), TimeUnit = (dc.TimeUnit), ExceptionValue = (dc.ExceptionValue) }).ToList(); return(Json(new { Msg = "", result }, JsonRequestBehavior.AllowGet)); } else { var result = (from dpd in dsmDestroyPolicies where dpd.PolicyDetailStatus == 1 & dpd.DocTypeID == "" join d in dsmDestroy.Where(x => x.DestroyPolicyID == _DestroyPolicyID) on dpd.DocCategoryID equals d.DocCategoryID into Categories from d in Categories.DefaultIfEmpty() join dc in objDsmDocCategories on dpd.DocCategoryID equals dc.DocCategoryID into CategoryDetails from dc in CategoryDetails.DefaultIfEmpty() select new { DestroyPolicyDtlID = dpd.DestroyPolicyDtlID, DestroyPolicyID = dpd.DestroyPolicyID, DocCategoryID = dpd.DocCategoryID, DocCategoryName = dc.DocCategoryName, IsSelected = (d != null && d.IsSelected), TimeValue = (dpd.TimeValue), TimeUnit = (dpd.TimeUnit), ExceptionValue = (dpd.ExceptionValue) }).ToList(); return(Json(new { Msg = "", result }, JsonRequestBehavior.AllowGet)); } }
private void btnAddNewCategory_Click(object sender, EventArgs e) { if (txtCategoryName.Text == "") { MessageBox.Show("Please Enter Category Name", "", MessageBoxButtons.OK, MessageBoxIcon.Warning); txtCategoryName.Focus(); return; } CategoryDetails cd = new CategoryDetails(); cd.CategoryName = txtCategoryName.Text; bool isexists = blc.CheckCategory(txtCategoryName.Text); if (isexists) { MessageBox.Show("Category Name Already Exists", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); txtCategoryName.Text = ""; txtCategoryName.Focus(); } else { int i = blc.AddNewCategory(cd); if (i > 0) { LoadGrid(); MessageBox.Show("New Category Added Successfully", "Record", MessageBoxButtons.OK, MessageBoxIcon.Information); txtCategoryName.Text = ""; txtCategoryName.Focus(); } } }
public int UpdateCategory(CategoryDetails cd) { tblCategory tc = _db.tblCategories.Where(c => c.CategoryId == cd.CategoryId).FirstOrDefault(); tc.CategoryName = cd.CategoryName; return(_db.SaveChanges()); }
public async Task DeleteArticleFromCategory(CategoryDetails category, string articleId) { var dbCategory = await this.GetDbCategory(category.Id); dbCategory.Articles.Remove(articleId); await this.context.Categories.FindOneAndReplaceAsync(c => c.Id == category.Id, dbCategory); }
public void CreateNewCategory(CategoryDetails item) { try { db.BeginTransaction(); Category category = new Category(); category.Name = item.Name; category.Description = item.Description; category.IconId = item.IconId; category.CreatedOn = item.CreatedOn; category.Status = "Active"; int id = Convert.ToInt32(db.Insert("Category", "Id", true, category)); Fields fields; foreach (var field in item.FieldList) { fields = new Fields(); fields.CategoryId = id; fields.Name = field.Name; fields.DataType = field.DataType; fields.Mandatory = field.Mandatory; fields.Position = field.Position; db.Insert("Fields", "Id", true, fields); } db.CompleteTransaction(); } catch (Exception) { db.AbortTransaction(); } }
public static CategoryDetails GetOneCategory(string categoryID) { // Command nesnesi olustur DbCommand command = DataAccess.CreateCommand(); // Prosedur Cagır command.CommandText = "GetOneCategory"; // prosedur için parametre oluştur DbParameter param = command.CreateParameter(); param.ParameterName = "@CategoryID"; param.Value = categoryID; param.DbType = DbType.Int32; command.Parameters.Add(param); //prosedur calıştır DataTable dt = DataAccess.ExecuteSelectedCommand(command); CategoryDetails category = new CategoryDetails(); if (dt.Rows.Count > 0) { category.CategoryID = dt.Rows[0]["CategoryID"].ToString(); category.Name = dt.Rows[0]["Name"].ToString(); category.Description = dt.Rows[0]["Description"].ToString(); } return(category); }
public ActionResult CreateEdit(long Id = 0) { Category item = new Category(); if (Id > 0) { item = _categoryService.Get(Id); } else { CategoryDetails _itemDetails = new CategoryDetails { Language = GlobalContext.WebSite.Language }; item.Details.Add(_itemDetails); } if (GlobalContext.WebSite.IsMultiLangual) { foreach (var lang in SupportedCultures.Cultures) { var count = item.Details.Where(x => x.Language == lang.TwoLetterISOLanguageName).Count(); if (count <= 0) { CategoryDetails _itemDetails = new CategoryDetails { Language = lang.TwoLetterISOLanguageName }; item.Details.Add(_itemDetails); } } } return(View(item)); }
private void BindGridView() { string id = Request.QueryString["CategoryID"]; if (id == null) { DataTable dt = CatalogAccess.AdminGetAllProducts(); lblNotFound.Visible = true; lblNotFound.Text = "<h3> Tüm Ürünler Görüntüleniyor.. </h3>"; grid.DataSource = dt; grid.DataBind(); } else { CategoryDetails cd = CatalogAccess.GetOneCategory(id); DataTable dt = CatalogAccess.AdminGetAllProductsInCategory(id); if (dt.Rows.Count == 0) { lblNotFound.Visible = true; lblNotFound.Text = "<h3> Bu Kategoride Hiç Ürün Yok :( </h3>"; } lblCategory.Visible = true; lblCategory.Text = "<h4> Kagori: " + cd.Name + "</h4> "; grid.DataSource = dt; grid.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { string id = Request.QueryString["CategoryID"]; if (!Page.IsPostBack) { if (id == null) { DataTable catg = CatalogAccess.GetCategories(); CatgDropList.DataSource = catg; CatgDropList.DataTextField = catg.Columns["Name"].ToString(); CatgDropList.DataValueField = catg.Columns["CategoryID"].ToString(); CatgDropList.DataBind(); } else { CategoryDetails cd = CatalogAccess.GetOneCategory(id); DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("Name")); dt.Columns.Add(new DataColumn("CategoryID")); dt.Rows.Add(cd.Name, cd.CategoryID); CatgDropList.DataSource = dt; CatgDropList.DataTextField = dt.Columns["Name"].ToString(); CatgDropList.DataValueField = dt.Columns["CategoryID"].ToString(); CatgDropList.DataBind(); } BindGridView(); } }
protected void SaveEdit_Click(object sender, EventArgs e) { var newName = (CategoryDetails.FindControl("EditCategory") as TextBox).Text; if (string.IsNullOrEmpty(newName)) { Error_Handler_Control.ErrorSuccessNotifier.AddErrorMessage("Title cannot be empty"); return; } else if (newName.Length < 5 || newName.Length > 50) { Error_Handler_Control.ErrorSuccessNotifier.AddErrorMessage("Title must be between 5 and 50 symbols"); return; } var id = int.Parse(CategoryDetails.DataKey.Value.ToString()); LibrarySystemDbContext data = new LibrarySystemDbContext(); var category = data.Categories.FirstOrDefault(x => x.Id == id); category.Name = newName; data.SaveChanges(); CategoryDetails.DataSource = null; CategoryDetails.DataBind(); CategoriesGrid.DataBind(); }
public Category Get(CategoryDetails request) { var category = CategoryRepository.GetById(request.Id); if (category == null) throw HttpError.NotFound("Category does not exist: " + request.Id); return category; }
/// <summary> /// Updates an existing category /// </summary> public static bool UpdateCategory(int id, string title, int importance, string description, string imageUrl) { CategoryDetails record = new CategoryDetails(id, DateTime.Now, "", title, importance, description, imageUrl); bool ret = SiteProvider.Articles.UpdateCategory(record); BizObject.PurgeCacheItems("articles_categor"); return(ret); }
public int UpdateCategory(CategoryDetails cd) { tbl_category tc = _db.tbl_category.Where(c => c.Id == cd.Id).FirstOrDefault(); tc.CategoryName = cd.CategoryName; tc.AddedDate = cd.AddedDate; return(_db.SaveChanges()); }
public int InsertCategorySetting(CategoryDetails obj) { CurrentInfo _obj = new CurrentInfo(); int result = 0; string user_code = _obj.GetUserCode(); return(result = _objBLSetting.InsertCategorySetting(obj, user_code)); }
public Category EditCategory(Profile profile, Category category, CategoryDetails categoryDetails) { category.Name = categoryDetails.Name; category.Updated = DateTime.Now; category.ModifierId = profile.Id; return(category); }
public async Task AddArticleToCategory(CategoryDetails category, string articleId) { var dbCategory = await this.GetDbCategory(category.Id); dbCategory.Articles.Add(articleId); dbCategory.Articles = dbCategory.Articles.Distinct().ToList(); await this.context.Categories.FindOneAndReplaceAsync(c => c.Id == category.Id, dbCategory); }
// public ActionResult CategoryMaster() // { // CategoryDetails objCategoryModel = new CategoryDetails(); // objCategoryModel.IsAdd = "Add"; // objCategoryModel.IsActive = true; // return View(objCategoryModel); // } // // POST: SaveCategoryMaster // [HttpPost] // public ActionResult SaveCategoryMaster(CategoryDetails model) // { // ResponseDetail objResponse = new ResponseDetail(); // if (model != null) // { // if (InventorySession.LoginUser != null) // { // model.UserDetails = InventorySession.LoginUser; // } // objResponse = objProductManager.AddCategoryDetails(model); // } // return Json(objResponse,JsonRequestBehavior.AllowGet); // } // // GET: SubCategoryMaster // public ActionResult SubCategoryMaster() // { // List<SelectListItem> objCategoryList = new List<SelectListItem>(); // List<SelectListItem> objChildCategoryList = new List<SelectListItem>(); // var result = objProductManager.GetCategoryList("Y"); // SubCategoryDetails model = new SubCategoryDetails(); // bool f = true; // foreach(var item in result) // { // SelectListItem tempobj = new SelectListItem(); // //SelectListItem tempobj1 = new SelectListItem(); // tempobj.Text = item.CategoryName; // tempobj.Value = item.CategoryId.ToString(); // if (f == true) // { // f = false; // model.CategoryId = int.Parse(item.CategoryId.ToString()); // //model.SubCatId = int.Parse(item.ToString()); // } // objCategoryList.Add(tempobj); // } // ViewBag.ListCategory = objCategoryList; // // ViewBag.ListChildCategory = objCategoryList; // model.IsAdd = "Add"; // return View(model); // } // // POST: SaveSubCategoryMaster // [HttpPost] // public ActionResult SaveSubCategoryMaster(SubCategoryDetails model) // { // ResponseDetail objResponse = new ResponseDetail(); // if (model != null) // { // if (InventorySession.LoginUser != null) // { // model.UserDetails = InventorySession.LoginUser; // } // objResponse = objProductManager.AddSubCategoryDetails(model); // } // return Json(objResponse, JsonRequestBehavior.AllowGet); // } // [HttpPost] // public ActionResult GetFullSubCategoryList() // { // List<SubCategoryDetails> objList = objProductManager.GetSubcategoryDetails(0,""); // return Json(objList, JsonRequestBehavior.AllowGet); // } // [HttpPost] // public ActionResult GetFullCategoryList() // { // List<CategoryDetails> objList = objProductManager.GetCategoryList(""); // return Json(objList, JsonRequestBehavior.AllowGet); // } // // GET: ProductMaster // public ActionResult ProductMaster() // { // List<CategoryDetails> objCategoryDetails = objProductManager.GetCategoryList("Y"); // List<SelectListItem> ListCategoryDetails = new List<SelectListItem>(); // List<SelectListItem> ListSubCategoryDetails = new List<SelectListItem>(); // ProductDetails model = new ProductDetails(); // bool f = true; // foreach (var obj in objCategoryDetails) // { // SelectListItem objTemp = new SelectListItem(); // objTemp.Text = obj.CategoryName; // objTemp.Value = obj.CategoryId.ToString(); // if (f) // { // objTemp.Selected = true; // model.CategoryId = obj.CategoryId; // f = false; // } // ListCategoryDetails.Add(objTemp); // } // f = true; // List<SubCategoryDetails> objSubCategoryDetails = objProductManager.GetSubcategoryDetails(model.CategoryId,"Y"); // foreach (var obj in objSubCategoryDetails) // { // SelectListItem objTemp = new SelectListItem(); // objTemp.Text = obj.subCategoryName; // objTemp.Value = obj.SubCatId.ToString(); // if (f) // { // objTemp.Selected = true; // model.SubCatgeoryId = (int)obj.SubCatId; // f = false; // } // ListSubCategoryDetails.Add(objTemp); // } // ViewBag.ListCategory = ListCategoryDetails; // ViewBag.ListSubCategory = ListSubCategoryDetails; // List<SelectListItem> objBarcodeType = new List<SelectListItem>(); // objBarcodeType.Add(new SelectListItem { Text="System Generated",Value= "System Generated" }); // objBarcodeType.Add(new SelectListItem { Text = "Other", Value = "Other" }); // ViewBag.ListBarcodetype = objBarcodeType; // model.ProductBarcodeDetails = new BarcodeDetails(); // model.ProductBarcodeDetails.BarcodeType = "System Generated"; // model.ProductBarcodeDetails.Barcode = objProductManager.MaxBarCode().ToString(); // model.ProductCode = objProductManager.MaxProductCode(); // return View(model); // } // // POST: SaveProductMaster // [HttpPost] // public ActionResult SaveProductMaster(ProductDetails model,HttpPostedFileBase upload) // { // ResponseDetail objResponse = new ResponseDetail(); // try // { // if (upload != null) // { // var path = Server.MapPath("~/ProductImages"); // var paths = path.Split(':'); // if (paths != null || paths.Count() > 0) // { // path = paths[0] + ":\\" + "ProductImages"; // } // if (upload != null && upload.FileName != null) // { // if (!Directory.Exists(path)) // { // //DirectoryInfo dInfo = new DirectoryInfo(path); // //DirectorySecurity dSecurity = dInfo.GetAccessControl(); // //dSecurity.AddAccessRule(new FileSystemAccessRule(new SecurityIdentifier(WellKnownSidType.WorldSid, null), FileSystemRights.FullControl, InheritanceFlags.ObjectInherit | InheritanceFlags.ContainerInherit, PropagationFlags.NoPropagateInherit, AccessControlType.Allow)); // //dInfo.SetAccessControl(dSecurity); // Directory.CreateDirectory(path); // } // //string myfile = Guid.NewGuid() + "-" + BannerImage.FileName; // string myfile = Guid.NewGuid() + "-" + Path.GetFileName(upload.FileName); // var productImage = Path.Combine(path, myfile); // upload.SaveAs(productImage); // //model.BannerImage = "/BannerImage/" + myfile; // model.ProductImagePath = productImage; // } // } // if (InventorySession.LoginUser != null) // { // model.UserDetails = InventorySession.LoginUser; // } // objResponse = objProductManager.SaveProductMaster(model); // } // catch(Exception ex) // { // } // return Json(objResponse, JsonRequestBehavior.AllowGet); // } // // GET: CheckDuplicateMaster // [HttpPost] // public ActionResult CheckDuplicateMaster(CheckDuplicateModel model) // { // ResponseDetail objResponse = new ResponseDetail(); // objResponse = objProductManager.IsMasterExists(model); // return Json(objResponse,JsonRequestBehavior.AllowGet); // } //[HttpPost] // public ActionResult GetActiveListOfSubCat(CheckDuplicateModel model) // { // List<SubCategoryDetails> objSubCategoryDetails = objProductManager.GetSubcategoryDetails(0, "Y"); // return Json(objSubCategoryDetails, JsonRequestBehavior.AllowGet); // } public ActionResult CategoryMaster() { CategoryDetails objCategoryModel = new CategoryDetails(); objCategoryModel.IsAdd = "Add"; objCategoryModel.IsActive = true; return(View(objCategoryModel)); }
public int AddNewCategory(CategoryDetails cd) { tblCategory tc = new tblCategory(); tc.CategoryName = cd.CategoryName; _db.tblCategories.Add(tc); return(_db.SaveChanges()); }
/// <summary> /// Creates a new category /// </summary> public static int InsertCategory(string title, int importance, string description, string imageUrl) { CategoryDetails record = new CategoryDetails(0, DateTime.Now, BizObject.CurrentUserName, title, importance, description, imageUrl); int ret = SiteProvider.Articles.InsertCategory(record); BizObject.PurgeCacheItems("articles_categor"); return(ret); }
public Category CreateCategory(Profile profile, CategoryDetails category) { return(new Category() { Name = category.Name, Added = DateTime.Now, Updated = DateTime.Now, AdderId = profile.Id, ModifierId = profile.Id }); }
private void LoadCategory() { List <CategoryDetails> list = blcat.GetAllCategory(); CategoryDetails cd = new CategoryDetails(); cd.CategoryName = "Choose Category"; list.Insert(0, cd); cboCategory.DataSource = list; cboCategory.DisplayMember = "CategoryName"; cboCategory.ValueMember = "CategoryId"; cboCategory.SelectedIndex = 0; }
private void LoadCategory() { List <CategoryDetails> lsttb = blcat.GetAllCategory(); CategoryDetails pro = new CategoryDetails(); pro.CategoryName = "Choose Category"; lsttb.Insert(0, pro); cmbCategory.DataSource = lsttb; cmbCategory.DisplayMember = "CategoryName"; cmbCategory.ValueMember = "Id"; }
// Get category details public static CategoryDetails GetCategoryDetails(string categoryId) { // get a configured DbCommand object DbCommand comm = GenericDataAccess.CreateCommand(); // set the stored procedure name comm.CommandText = "CatalogGetCategoryDetails"; // create a new parameter DbParameter param = comm.CreateParameter(); param.ParameterName = "@CategoryID"; param.Value = categoryId; param.DbType = DbType.Int32; comm.Parameters.Add(param); // execute the stored procedure DataTable table = GenericDataAccess.ExecuteSelectCommand(comm); // wrap retrieved data into a CategoryDetails object CategoryDetails details = new CategoryDetails(); if (table.Rows.Count > 0) { details.DepartmentId = Int32.Parse(table.Rows[0]["DepartmentID"].ToString()); details.Name = table.Rows[0]["Name"].ToString(); details.Description = table.Rows[0]["Description"].ToString(); } // return department details return details; }
/// <summary> /// Creates a new category /// </summary> public override int InsertCategory(CategoryDetails category) { using (SqlConnection cn = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("tbh_Articles_InsertCategory", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = category.AddedDate; cmd.Parameters.Add("@AddedBy", SqlDbType.NVarChar).Value = category.AddedBy; cmd.Parameters.Add("@Title", SqlDbType.NVarChar).Value = category.Title; cmd.Parameters.Add("@Importance", SqlDbType.Int).Value = category.Importance; cmd.Parameters.Add("@ImageUrl", SqlDbType.NVarChar).Value = category.ImageUrl; cmd.Parameters.Add("@Description", SqlDbType.NVarChar).Value = category.Description; cmd.Parameters.Add("@CategoryID", SqlDbType.Int).Direction = ParameterDirection.Output; cn.Open(); int ret = ExecuteNonQuery(cmd); return (int)cmd.Parameters["@CategoryID"].Value; } }
/// <summary> /// Updates a category /// </summary> public override bool UpdateCategory(CategoryDetails category) { using (SqlConnection cn = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("tbh_Articles_UpdateCategory", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@CategoryID", SqlDbType.Int).Value = category.ID; cmd.Parameters.Add("@Title", SqlDbType.NVarChar).Value = category.Title; cmd.Parameters.Add("@Importance", SqlDbType.Int).Value = category.Importance; cmd.Parameters.Add("@ImageUrl", SqlDbType.NVarChar).Value = category.ImageUrl; cmd.Parameters.Add("@Description", SqlDbType.NVarChar).Value = category.Description; cn.Open(); int ret = ExecuteNonQuery(cmd); return (ret == 1); } }
// Get category details public static CategoryDetails GetCategoryDetails(string categoryId) { // get a configured OracleCommand object OracleCommand comm = GenericDataAccess.CreateCommand(); // set the stored procedure name comm.CommandText = "CatalogGetCategoryDetails"; // create a new parameter OracleParameter param = comm.Parameters.Add("CategoryID", OracleDbType.Int32); param.Direction = ParameterDirection.Input; param.Value = Int32.Parse(categoryId); comm.CommandType = CommandType.StoredProcedure; OracleParameter p2 = comm.Parameters.Add("cat_out", OracleDbType.RefCursor); p2.Direction = ParameterDirection.Output; // execute the stored procedure DataTable table = GenericDataAccess.ExecuteSelectCommand(comm); // wrap retrieved data into a CategoryDetails object CategoryDetails details = new CategoryDetails(); if (table.Rows.Count > 0) { details.DepartmentId = Int32.Parse(table.Rows[0]["DepartmentID"].ToString()); details.Name = table.Rows[0]["Name"].ToString(); details.Description = table.Rows[0]["Description"].ToString(); } // return department details return details; }
public static CategoryDetails GetCategoryDetails(string categoryId) { DbCommand comm = GenericDataAccess.CreateCommand(); comm.CommandText = "CatalogGetCategoryDetails"; DbParameter param = comm.CreateParameter(); param.ParameterName = "@CategoryID"; param.Value = categoryId; param.DbType = DbType.Int32; comm.Parameters.Add(param); DataTable table = GenericDataAccess.ExecuteSelectCommand(comm); CategoryDetails details = new CategoryDetails(); if (table.Rows.Count > 0) { DataRow dr = table.Rows[0]; details.DepartmentId = Int32.Parse(dr["DepartmentID"].ToString()); details.Name = dr["Name"].ToString(); details.Description = dr["Description"].ToString(); } return details; }