public ActionResult EditCategory(tblCategory categoryModel, HttpPostedFileBase fileUpload) { if (ModelState.IsValid) { string pictureLink = ""; if (fileUpload != null) { Image img = Image.FromStream(fileUpload.InputStream); int width = Convert.ToInt32(ConfigurationManager.AppSettings["CategoryWidth"].ToString()); int height = Convert.ToInt32(ConfigurationManager.AppSettings["CategoryHeight"].ToString()); pictureLink = "/img/CategoryImage/" + Guid.NewGuid() + Path.GetExtension(fileUpload.FileName); Bitmap bm = new Bitmap(img, width, height); bm.Save(Server.MapPath(pictureLink)); } if (pictureLink == "") { categoryModel.PictureLink = "/img/CategoryImage/emptyCategory.jpg"; } else { categoryModel.PictureLink = pictureLink; } db.Entry(categoryModel).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Category")); } return(View(categoryModel)); }
public ActionResult EditCategory(Guid?categoryID) { List <SelectListItem> listLevelCategory = new List <SelectListItem>(); listLevelCategory.Add(new SelectListItem { Text = "Mức 1", Value = "1" }); listLevelCategory.Add(new SelectListItem { Text = "Mức 2", Value = "2" }); //listLevelCategory.Add(new SelectListItem { Text = "Mức 3", Value = "3" }); ViewData["ListLevelCategory"] = listLevelCategory; if (categoryID.HasValue && !categoryID.Value.Equals(Guid.Empty)) { tblCategory tblCategory = new tblCategory(); tblCategory = Service.GetCategoryByID((Guid)categoryID); return(View("Admin/EditCategory", tblCategory)); } else { tblCategory tblCategory = new tblCategory(); return(View("Admin/EditCategory", tblCategory)); } }
public ActionResult InsertUpdateCatelogy(tblCategory model) { var result = new Models.CustomJsonResult(); try { if (model != null && !string.IsNullOrEmpty(model.CategoryName)) { if (model.id > 0) { result.Result = _catelogyServices.UpdateCatelogy(model); result.Message = int.Parse(result.Result.ToString()) > 0 ? "Update catelogy success!" : "Action had error, please try again!"; } else { result.Result = _catelogyServices.InsertCatelogy(model); result.Message = int.Parse(result.Result.ToString()) > 0 ? "Create new catelogy success!" : "Action had error, please try again!"; } } else { result.Result = 0; result.Message = "Action had error, please try again!"; } } catch (Exception ex) { } return(Json(result, JsonRequestBehavior.AllowGet)); }
public IHttpActionResult PuttblCategory(string id, tblCategory tblCategory) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != tblCategory.CategoryID) { return(BadRequest()); } db.Entry(tblCategory).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!tblCategoryExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public long UpdateCatelogy(tblCategory category) { long result = 0; var key = "SelectByCatelogyID-" + category.id; try { using (var db = ContextFactory.UsTransportEntities()) { var _temp = db.tblCategories.Where(x => x.id == category.id).FirstOrDefault(); if (_temp != null) { db.Entry(_temp).CurrentValues.SetValues(category); if (db.SaveChanges() > 0) { result = _temp.id; MemoryCache.Default.Remove(key); } } result = category.id; } } catch (Exception ex) { SELog.WriteLog("CategoryService => UpdateCatelogy", ex); } return(result); }
public ActionResult FilterPostsByCatID(int?id, int?page) { if (id == null) { return(HttpNotFound()); } tblCategory category = db.tblCategories.Find(id); if (db.tblTags.FirstOrDefault(t => t.Tag_Title.Contains(category.Cat_Name)) != null) { db.tblTags.FirstOrDefault(t => t.Tag_Title.Contains(category.Cat_Name)).Tag_CountSearch++; db.SaveChanges(); } else { tblTag tag = new tblTag() { Tag_Title = category.Cat_Name, Tag_DateAdd = DateTime.Now, Tag_CountSearch = 1 }; db.tblTags.Add(tag); db.SaveChanges(); } ViewBag.Title = "Tìm kiếm code theo danh mục"; ViewBag.countPost = db.tblPosts.Where(t => t.Post_Cat == id && t.Post_Active == true && t.Post_Trash == false).Count(); IPagedList <tblPost> post = db.tblPosts.Where(t => t.Post_Cat == id && t.Post_Active == true && t.Post_Trash == false).OrderByDescending(t => t.Post_DateCreate).ToPagedList(page ?? 1, PAGE_SIZE); return(View("Index", post)); }
/// <summary> /// Return Affected Row Or Error If Exist /// </summary> /// <param name="request">Category Information</param> /// <returns>Affected Row Or Error If Exist</returns> public static GetCategoryResponse Category(GetCategoryResponse request) { GetCategoryResponse response = new GetCategoryResponse(); response.Error = new Handler.ErrorObject(); try { tblCategory Category = new tblCategory() { id = request.Category.id, name = request.Category.name, detail = request.Category.detail, idCategory = request.Category.CategoryID, createDate = request.Category.createDate, upDateDate = DateTime.Now, deleteDate = null, state = "Active" }; var result = CategoryData.Update.Category(Category); if (result.Item1.Error) { response.Error.InfoError(result.Item1); } else { response.Message = result.Item2; } } catch (Exception ex) { response.Error.InfoError(ex); } return(response); }
public tblCategory SelectByCatelogyID(int id) { tblCategory _item = new tblCategory(); try { var key = "SelectByCatelogyID-" + id; object HTML = MemoryCache.Default.Get(key); if (HTML != null) { return((tblCategory)HTML); } else { using (var db = ContextFactory.UsTransportEntities()) { _item = db.tblCategories.Where(x => x.id == id).FirstOrDefault(); } if (_item != null) { MemoryCache.Default.Add(key, _item, DateTimeOffset.UtcNow.AddMinutes(60)); } } } catch (Exception ex) { SELog.WriteLog("CategoryService => SelectByCatelogyID", ex); } return(_item); }
private bool SaveData() { objCommon = new clsCommon(); if (objCommon.IsRecordExists("tblCategory", tblCategory.ColumnNames.AppCategory, tblCategory.ColumnNames.AppCategoryID, txtCategoryName.Text, hdnPKID.Value)) { DInfo.ShowMessage("Category Name alredy exits.", Enums.MessageType.Error); return(false); } objCategory = new tblCategory(); if (!string.IsNullOrEmpty(hdnPKID.Value) && hdnPKID.Value != "") { objCategory.LoadByPrimaryKey(Convert.ToInt32(hdnPKID.Value)); } else { objCategory.AddNew(); objCategory.s_AppCreatedBy = Session[appFunctions.Session.UserID.ToString()].ToString(); objCategory.AppDisplayOrder = objCommon.GetNextDisplayOrder("tblCategory", tblCategory.ColumnNames.AppDisplayOrder); // objCategory.s_AppCreatedDate = FormatDateString(DateTime.Now.ToString(strInputDateFormat), strInputDateFormat, strOutputDateFormat); objCategory.AppCreatedDate = DateTime.Now; } objCategory.AppCategory = txtCategoryName.Text; objCategory.AppIsActive = chkIsActive.Checked; objCategory.Save(); intPkId = objCategory.AppCategoryID; objCategory = null; objCommon = null; return(true); }
public long UpdateCatelogy(tblCategory category) { long result = 0; try { using (var db = ContextFactory.UsTransportEntities()) { var _temp = db.tblCategories.Where(x => x.id == category.id).FirstOrDefault(); if (_temp != null) { db.Entry(_temp).CurrentValues.SetValues(category); if (db.SaveChanges() > 0) { result = _temp.id; } } result = category.id; } } catch (Exception ex) { string e = ex.Message; } return(result); }
public SPResponse ActiveInactiveCategory(int CategoryId) { tblCategory objcategory = new tblCategory(); SPResponse result = new SPResponse(); using (var context = new CommonDBContext()) { objcategory = context.tblCategories.Where(x => x.CategoryId == CategoryId).FirstOrDefault(); if (objcategory.IsActive == true) { objcategory.IsActive = false; } else { objcategory.IsActive = true; } context.tblCategories.AddOrUpdate(objcategory); context.SaveChanges(); result.ResponseCode = "00"; result.ResponseMessage = "Category Updated Successfully"; } return(result); }
public async Task <string> AddUpdateCategory(CategoryDomainModel category) { string status = ""; if (category.cat_id > 0) { tblCategory categoryToUpdate = await categoryRepository.SingleOrDefault(c => c.cat_id == category.cat_id); if (categoryToUpdate != null) { categoryToUpdate.cat_id = category.cat_id; categoryToUpdate.name = category.name; categoryToUpdate.mainCat_id = category.mainCat_id; await categoryRepository.Update(categoryToUpdate); status = "updated"; } } else { tblCategory categoryToAdd = new tblCategory(); categoryToAdd.cat_id = category.cat_id; categoryToAdd.name = category.name; categoryToAdd.mainCat_id = category.mainCat_id; await categoryRepository.Insert(categoryToAdd); status = "added"; } return(status); }
public IHttpActionResult PosttblCategory(tblCategory tblCategory) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.tblCategories.Add(tblCategory); try { db.SaveChanges(); } catch (DbUpdateException) { if (tblCategoryExists(tblCategory.CategoryID)) { return(Conflict()); } else { throw; } } return(CreatedAtRoute("DefaultApi", new { id = tblCategory.CategoryID }, tblCategory)); }
public IHttpActionResult GettblCategory(int id) { try { //tblCategory tblCategory = db.tblCategories.Find(id); //if (tblCategory == null) //{ // return NotFound(); //} //return Ok(tblCategory); var data = db.tblCategories.Where(w => w.ID == id).FirstOrDefault(); if (data == null) { return(Ok(new { code = 1, data = "Not found" })); } else { tblCategory model = new tblCategory(); model.ID = data.ID; model.Name = data.Name; model.Created = System.DateTime.Now; model.CreatedBy = data.CreatedBy; model.Updated = System.DateTime.Now; model.UpdatedBy = data.UpdatedBy; model.Active = Convert.ToBoolean(data.Active); return(Ok(new { code = 0, data = model })); } } catch (Exception ex) { return(InternalServerError(ex)); } }
public IHttpActionResult PosttblCategory(tblCategory tblCategory) { try { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var data = db.tblCategories.Where(w => w.Name == tblCategory.Name).FirstOrDefault(); if (data == null) { db.tblCategories.Add(tblCategory); db.SaveChanges(); return(Ok(new { code = 0, data = "Category added successfully." })); } else { return(Ok(new { code = 1, data = "Category already exists." })); } } catch (Exception ex) { return(InternalServerError(ex)); } }
public ActionResult AddCategory(string jsonData) { SPResponse result = new SPResponse(); var userDetails = (CustomerLoginDetail)Session["UserSession"]; string categoryId = ""; try { JavaScriptSerializer json_serializer = new JavaScriptSerializer(); json_serializer.MaxJsonLength = int.MaxValue; object[] objData = (object[])json_serializer.DeserializeObject(jsonData); tblCategory objcategory = new tblCategory(); foreach (Dictionary <string, object> item in objData) { objcategory.CategoryName = Convert.ToString(item["CategoryNm"]); objcategory.CreatedBy = userDetails.LoginId; objcategory.CreatedDate = DateTime.Now; categoryId = Convert.ToString(item["CategoryId"]); objcategory.IsActive = Convert.ToBoolean(item["IsActive"]); if (categoryId != "") { objcategory.CategoryId = Convert.ToInt32(categoryId); } else { } } result = COR.AddCategory(objcategory); } catch (Exception ex) { } return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult DeleteCategoryConfirmed(int id) { tblCategory categoryModel = db.tblCategory.Find(id); db.tblCategory.Remove(categoryModel); db.SaveChanges(); return(RedirectToAction("Category")); }
public ActionResult DeleteConfirmed(int id) { tblCategory tblCategory = db.tblCategories.Find(id); db.tblCategories.Remove(tblCategory); db.SaveChanges(); return(RedirectToAction("Index")); }
public void AddCategory(CategoryModel category) { tblCategory objtblCategory = new tblCategory(); objtblCategory.Caregory_Name = category.CategoryName; dbentity.tblCategories.Add(objtblCategory); dbentity.SaveChanges(); }
public JsonResult AJXUpdateForm() { int id = Request.Form["updateID"] != null?int.Parse(Request.Form["updateID"]) : -1; tblCategory item = _catelogyServices.SelectByCatelogyID(id); return(Json(RenderPartialViewToString("_CatelogyDetailForm", item), JsonRequestBehavior.AllowGet)); }
public ActionResult InsertCategory() { if (Session["UserID"] == null && Session["UserName"] == null) { return(RedirectToAction("Login", "Login")); } try { tblCategory newCat = new tblCategory(); newCat.CategoryName = Request.Form["CategoryName"]; if (ModelState.IsValid) { int fileSize = 0; string fileName = string.Empty; string mimeType = string.Empty; System.IO.Stream fileContent; if (Request.Files.Count > 0) { HttpPostedFileBase file = Request.Files[0]; fileSize = file.ContentLength; fileName = file.FileName; mimeType = file.ContentType; fileContent = file.InputStream; if (mimeType.ToLower() != "image/jpeg" && mimeType.ToLower() != "image/jpg" && mimeType.ToLower() != "image/png") { return(Json(new { Formatwarning = true, message = "Profile pic format must be JPEG or JPG or PNG." }, JsonRequestBehavior.AllowGet)); } #region Save And compress file //To save file, use SaveAs method file.SaveAs(Server.MapPath("~/CategoryImages/") + fileName); if (!ImageProcessing.InsertImages(Server.MapPath("~/CategoryImages/") + fileName)) { return(Json(new { success = false, message = "Error occur while uploading image." }, JsonRequestBehavior.AllowGet)); } #endregion } newCat.CategoryImage = fileName; newCat.CreatedDate = DateTime.Now; db.tblCategories.Add(newCat); db.SaveChanges(); } } catch (Exception ex) { return(Json(new { success = false, message = "Record Not inserted" }, JsonRequestBehavior.AllowGet)); } return(Json(new { success = true, message = "Record inserted" }, JsonRequestBehavior.AllowGet)); }
void Guncelle() { tblCategory cat = _db.tblCategories.First(x => x.ID == _secimId); cat.CategoryName = txtCname.Text; _db.SubmitChanges(); _m.Guncelle(true); Temizle(); }
public async Task <ActionResult> DeleteConfirmed(int id) { tblCategory tblcategory = await db.tblCategories.FindAsync(id); db.tblCategories.Remove(tblcategory); await db.SaveChangesAsync(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "CATEGORY_ID,CATEGORY_NAME")] tblCategory aobjtblCategory) { if (ModelState.IsValid) { db.sp_Update_tblCategory(aobjtblCategory.CATEGORY_ID, aobjtblCategory.CATEGORY_NAME); return(RedirectToAction("AllCategoryList")); } return(View(aobjtblCategory)); }
public ActionResult Delete(int id) { tblCategory tbl = db.tblCategories.Where(a => a.CategoryId == id).FirstOrDefault(); db.tblCategories.Remove(tbl); db.SaveChanges(); return(Json(new { success = true, message = "Deleted Sucessfully" }, JsonRequestBehavior.AllowGet)); }
public ActionResult Delete(int id) { using (KantipurDBEntities db = new KantipurDBEntities()) { tblCategory sm = db.tblCategories.Where(x => x.CategoryId == id).FirstOrDefault(); db.tblCategories.Remove(sm); db.SaveChanges(); return(Json(new { success = true, message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Create([Bind(Include = "CategoryId,Name")] tblCategory Category) { if (ModelState.IsValid) { db.tblCategories.Add(Category); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(Category)); }
public tblCategory GetCategoryById(int CategoryId) { tblCategory objcategory = new tblCategory(); using (var context = new CommonDBContext()) { objcategory = context.tblCategories.Where(x => x.CategoryId == CategoryId).FirstOrDefault(); } return(objcategory); }
//GET: Category/Edit/{id} public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tblCategory Category = db.tblCategories.Find(id); return(View(Category)); }
public ActionResult Edit([Bind(Include = "CategoryId, Name")] tblCategory Category) { if (ModelState.IsValid) { db.Entry(Category).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(Category)); }
public ActionResult CategoriesEdit(tblCategory tblCategory) { if (ModelState.IsValid) { db.Entry(tblCategory).State = EntityState.Modified; db.SaveChanges(); return RedirectToAction("Categories"); } return View(tblCategory); }