protected void lkbtnSave_Click(object sender, EventArgs e) { int nActionResult = 0; FAQs objFAQObj = new FAQs(); objFAQObj.Data = SetData(); string sAction = GetQuerryString(Constants.ACTION); if (sAction == Constants.ACTION_EDIT) { //Is Edit int nItemID = ConvertData.ConvertToInt(Request.QueryString[Constants.ACTION_ID]); nActionResult = objFAQObj.Update(nItemID); if (nActionResult > 0) MessageBoxss.Show(MessagesAlert.UPDATE_SUCCESSFUL); else MessageBoxss.Show(MessagesAlert.UPDATE_UNSUCCESSFUL); } else { // Is Insert nActionResult = objFAQObj.Insert(); if (nActionResult > 0) { string sURL = Constants.ROOT + Pages.BackEnds.ADMIN + "?" + Constants.PAGE + "=" + Pages.BackEnds.STR_FAQ + "&" + Constants.MESS_ID + "=" + Constants.MESSAGE_INSERT; Response.Redirect(sURL); } else { txtcontent.Focus(); } } }
/// <summary> /// UpdatefAQs - sửa thông tin fAQs /// </summary> /// <param name="fAQs"></param> /// <returns></returns> public bool UpdateFAQs(FAQs fAQs) { SqlParameter[] paramList = new SqlParameter[5]; paramList[0] = new SqlParameter("@FaqId", SqlDbType.Int); paramList[0].Value = fAQs.FaqId; paramList[1] = new SqlParameter("@Question", SqlDbType.NVarChar, 512); paramList[1].Value = fAQs.Question; paramList[2] = new SqlParameter("@Answer", SqlDbType.NVarChar, 512); paramList[2].Value = fAQs.Answer; paramList[3] = new SqlParameter("@FaqIndex", SqlDbType.Int); paramList[3].Value = fAQs.FaqIndex; paramList[4] = new SqlParameter("@StatusId", SqlDbType.NVarChar, 256); paramList[4].Value = fAQs.StatusId; if (db.executeUpdate("UpdateFAQs", paramList) == 0) { return(false); } else { return(true); } }
public async Task <IActionResult> Edit(int id, [Bind("Id,Question,Answer,Status")] FAQs fAQs) { if (id != fAQs.Id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(fAQs); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!FAQsExists(fAQs.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(fAQs)); }
protected void RptFAQ_ItemCommand(object source, RepeaterCommandEventArgs e) { string strCommand = e.CommandName; int nID = ConvertData.ConvertToInt(e.CommandArgument); FAQs objFAQ = new FAQs(); switch (strCommand) { case "Delete": int nDelete = objFAQ.DeleteById(nID); BindDataToGrid(1); break; case "Edit": string sEdit = Constants.ROOT + Pages.BackEnds.ADMIN + "?" + Constants.PAGE + "=" + Pages.BackEnds.STR_FAQ_ADD + "&" + Constants.ACTION + "=" + Constants.ACTION_EDIT + "&" + Constants.ACTION_ID + "=" + nID; Response.Redirect(sEdit); break; case "Active": int nActive = objFAQ.UpdateStatus(nID, EnumeType.INACTIVE); BindDataToGrid(1); break; case "Inactive": int nInactive = objFAQ.UpdateStatus(nID, EnumeType.ACTIVE); BindDataToGrid(1); break; } }
protected void btnSave_Click(object sender, EventArgs e) { // Lấy giá trị FAQs _obj = new FAQs(); _obj.FAQID = this.txtFaqId.Text == "" ? 0 : Convert.ToInt32(this.txtFaqId.Text); _obj.Title = this.txtTitle.Text; _obj.Description = this.ckEditor.Text; _obj.CreateDate = DateTime.Now; _obj.CreateUser = "******"; _obj.EditDate = DateTime.Now; _obj.EditUser = "******"; // Lưu xuống dữ liệu if (M_Mode.Mode == Modes.EDIT) { FAQs.Update(_obj); } else if (M_Mode.Mode == Modes.INSERT) { FAQs.Insert(_obj); } // Mở lại trang AboutUsManage Response.Redirect(@"~\App_WebAdmins\FAQManage.aspx"); }
protected void btnAddFaq_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(hiddenAnswer.Value) == false && string.IsNullOrEmpty(txtNewQuestion.Text) == false) { lblNewFaqError.Text = string.Empty; var faqModel = new FAQs(); faqModel.Add( HttpUtility.UrlDecode(txtNewQuestion.Text), HttpUtility.UrlDecode(hiddenAnswer.Value) ); rptFAQsList.DataSource = faqModel.FaqList; rptFAQsList.DataBind(); txtNewQuestion.Text = string.Empty; lblNewFaqError.Text = "New FAQ added"; lblNewFaqError.CssClass = "status--success"; } else { lblNewFaqError.Text = "Ensure that a value is entered for both question and answer"; lblNewFaqError.CssClass = "error-text"; } }
public ActionResult DeleteConfirmed(int id) { FAQs fAQs = db.FAQs.Find(id); db.FAQs.Remove(fAQs); db.SaveChanges(); return(RedirectToAction("Index")); }
protected void Page_Load(object sender, EventArgs e) { var model = new FAQs(); model.LoadData(); rptLaundryFaqs.DataSource = model.FaqList; rptLaundryFaqs.DataBind(); }
public ActionResult Edit([Bind(Include = "FAQ_ID,FAQ_QuestionEng,FAQ_QuestionAra,FAQ_AnswerEng,FAQ_AnswerAra,FAQ_Status,FAQ_CreattonUser,FAQ_CreationDate,FAQ_ModifiedUser,FAQ_ModifiedDate")] FAQs fAQs) { if (ModelState.IsValid) { fAQs.FAQ_ModifiedDate = DateTime.Now; db.Entry(fAQs).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(fAQs)); }
protected void rptFAQsList_ItemCommand(object source, RepeaterCommandEventArgs e) { var hiddenKeyField = (HiddenField)e.Item.FindControl("hiddenKey"); var key = Convert.ToInt32(hiddenKeyField.Value); var faqModel = new FAQs(); faqModel.Remove(key); rptFAQsList.DataSource = faqModel.FaqList; rptFAQsList.DataBind(); }
public async Task <IActionResult> Create([Bind("Id,Question,Answer")] FAQs fAQs) { if (ModelState.IsValid) { _context.Add(fAQs); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(fAQs)); }
public JsonResult Put(int id, [FromBody] FAQs innfaq) { if (ModelState.IsValid) { var faqdb = new FAQdb(_context); bool OK = faqdb.editlikes(id, innfaq); if (OK) { return(Json("OK")); } } return(Json("Kunne ikke endre faq i DB")); }
// GET: FAQ/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } FAQs fAQs = db.FAQs.Find(id); if (fAQs == null) { return(HttpNotFound()); } return(View(fAQs)); }
protected override void OnQueryChanged(string oldValue, string newValue) { base.OnQueryChanged(oldValue, newValue); if (string.IsNullOrWhiteSpace(newValue)) { ItemsSource = null; } else { ItemsSource = FAQs .Where(faq => faq.Question.ToLower().Contains(newValue.ToLower())).ToList <FAQ>(); } }
/// <summary> /// DeletefAQs - xoa thông tin fAQs /// </summary> /// <param name="fAQs"></param> /// <returns></returns> public bool DeleteFAQs(FAQs fAQs) { SqlParameter[] paramList = new SqlParameter[1]; paramList[0] = new SqlParameter("@FaqId", SqlDbType.Int); paramList[0].Value = fAQs.FaqId; if (db.executeUpdate("DeleteFAQs", paramList) == 0) { return(false); } else { return(true); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["user"] == null) { Response.Redirect("/Admin/Login.aspx"); } if (IsPostBack == false) { var faqModel = new FAQs(); faqModel.LoadData(); rptFAQsList.DataSource = faqModel.FaqList; rptFAQsList.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { // Lấy giá trị tham số ID string ID = Request.QueryString["ID"].ToString(); // Gán giá trị cho Mode if (string.IsNullOrEmpty(ID)) { M_Mode.Mode = Modes.INSERT; } else { M_Mode.Mode = Modes.EDIT; } if (!IsPostBack) { // Khởi tạo control this.txtFaqId.Enabled = false; if (M_Mode.Mode == Modes.EDIT) { // Gán tiêu đề this.Page.Title = "Cập nhập danh mục FAQ"; this.lbModeMessage.Text = "Cập nhập danh mục FAQ"; // Gán ID this.txtFaqId.Text = ID; // Gán giá trị lên các control nhập liệu FAQs _obj = new FAQs(); _obj.FAQID = Convert.ToInt32(ID); _obj = FAQs.GetByID(_obj); this.txtFaqId.Text = _obj.FAQID.ToString(); this.txtTitle.Text = _obj.Title; this.ckEditor.Text = _obj.Description; } else if (M_Mode.Mode == Modes.INSERT) { // Gán tiêu đề this.Page.Title = "Thêm mới danh mục FAQ"; this.lbModeMessage.Text = "Thêm mới danh mục FAQ"; } } }
public async Task <ResponseBase <FAQs> > save(RequestFAQs _data, Transaction trans) { var ob = new FAQs(); ob = JsonConvert.DeserializeObject <FAQs>(JsonConvert.SerializeObject(_data)); if (trans == Transaction.Delete) { return(new ResponseBase <FAQs>() { codigo = (int)HttpStatusCode.NotFound, estado = false, mensaje = $"La operación de eliminar pregunta no ha sido implementada.", datos = null }); } else { var data = await _dalc.set(ob, trans); if (data != null) { return(new ResponseBase <FAQs>() { codigo = (int)HttpStatusCode.OK, estado = true, mensaje = $"Operación realizada con exito", datos = data }); } else { return new ResponseBase <FAQs>() { codigo = (int)HttpStatusCode.InternalServerError, estado = false, mensaje = $"La operación solicitada no se pudo realizar.", datos = data } }; } } }
protected void Page_Load(object sender, EventArgs e) { // Load FAQ Model var faqModel = new FAQs(); faqModel.LoadData(); rptLaundryFaqs.DataSource = faqModel.FaqList; rptLaundryFaqs.DataBind(); // Load Hours of Operation Model var hoursModel = new HoursOfOperation(); hoursModel.LoadData(); rptHoursOfOperation.DataSource = hoursModel.Days; rptHoursOfOperation.DataBind(); // Load Pricing var pricingModel = new Models.Pricing(); pricingModel.LoadData(); if (pricingModel.Prices.Count > 0) { int firstIndex = Convert.ToInt32(Math.Ceiling((double)pricingModel.Prices.Count / 2)); var firstGroupPricing = pricingModel.Prices.GetRange(0, firstIndex); rptPricingLeft.DataSource = firstGroupPricing; rptPricingLeft.DataBind(); if (firstIndex < pricingModel.Prices.Count) { var secondGroupPricing = pricingModel.Prices.GetRange(firstIndex, pricingModel.Prices.Count - firstIndex); rptPricingRight.DataSource = secondGroupPricing; rptPricingRight.DataBind(); } } }
public bool editlikes(int id, FAQs innfaq) { FAQs forFAQ = _context.FAQs.FirstOrDefault(l => l.id == id); if (forFAQ == null) { return(false); } forFAQ.like = forFAQ.like + innfaq.like; forFAQ.dislike = forFAQ.dislike + innfaq.dislike; try { _context.SaveChanges(); } catch (Exception feil) { return(false); } return(true); }
protected void gView_RowCommand(object sender, GridViewCommandEventArgs e) { string id = e.CommandArgument.ToString(); if (e.CommandName == "btnEdit") { // Sửa ClientScript.RegisterStartupScript(this.GetType(), "OpenWindow", "window.open('FAQEdit.aspx?ID=" + id + "');", true); } else if (e.CommandName == "btnDelete") { // Xóa FAQs _obj = new FAQs(); _obj.FAQID = Convert.ToInt32(id); FAQs.Delete(_obj); // Load lại dữ liệu gView_Binding(); } }
/// <summary> /// Lấy dữ liệu lên GridView gvDescription /// </summary> private void gView_Binding() { gView.DataSource = FAQs.GetAll(); gView.DataBind(); }
private void GetData( int ItemID) { // Get data to view on UI Controls int nStatus = 0; FAQs objFAQ = new FAQs(); objFAQ.LoadById(ItemID); ddlCategory.SelectedValue = ConvertData.ConvertToString(objFAQ.Data.FAQCategoryID); nStatus = ConvertData.ConvertToInt(objFAQ.Data.Status); if (nStatus > 0) chkActive.Checked = true; else chkActive.Checked = false; txtQuestion.Text = objFAQ.Data.Question; txtcontent.Text = (ConvertData.ConvertToString(objFAQ.Data.Answer)); }
private void BindDataToGrid(int CurrentPageIndex) { int nItemView = 0; int nCategoryID = ConvertData.ConvertToInt(ddlFAQCat.SelectedValue); int nStatus = 1; int nPageSize = Constants.PAGESIZE; int nPageCount = Constants.PAGECOUNT; DataTable dtbFAQ = new DataTable(); FAQs objFAQ = new FAQs(); dtbFAQ = objFAQ.Search(nItemView,0, "", nCategoryID, nStatus, CurrentPageIndex, nPageSize, ref nPageCount); RptFAQ.DataSource = dtbFAQ; RptFAQ.DataBind(); }
/// <summary> /// DeletefAQs - xoa thông tin fAQs /// </summary> /// <param name="fAQs"></param> /// <returns></returns> public bool DeleteFAQs(FAQs fAQs) { return(fAQsDao.DeleteFAQs(fAQs)); }
/// <summary> /// UpdatefAQs - sửa thông tin fAQs /// </summary> /// <param name="fAQs"></param> /// <returns></returns> public bool UpdateFAQs(FAQs fAQs) { return(fAQsDao.UpdateFAQs(fAQs)); }
/// <summary> /// InsertfAQs - them thông tin fAQs /// </summary> /// <param name="fAQs"></param> /// <returns></returns> public bool InsertFAQs(FAQs fAQs) { return(fAQsDao.InsertFAQs(fAQs)); }
private eFAQs SetData() { eFAQs entityFAQ = this.FAQEntity(); FAQs objFAQ = new FAQs(); objFAQ.Data.FAQCategoryID = ConvertData.ConvertToInt(ddlCategory.SelectedValue); if (chkActive.Checked) objFAQ.Data.Status = 1; else objFAQ.Data.Status = 0; string sQuestion = ConvertData.ConvertToString(ConvertData.RemoveHTMLTag(txtQuestion.Text.Trim())); string sAnswer = ConvertData.ConvertToString(txtcontent.Text); objFAQ.Data.Question= sQuestion; objFAQ.Data.Answer = sAnswer; return objFAQ.Data; }
private eFAQs FAQEntity() { eFAQs entityFAQ = new eFAQs(); int nItemID = ConvertData.ConvertToInt(Request.QueryString[Constants.ACTION_ID]); string sQueery = ConvertData.ConvertToString(Request.QueryString[Constants.ACTION]); if (nItemID > 0 && sQueery == Constants.ACTION_EDIT) { FAQs objFAQ = new FAQs(); objFAQ.LoadById(nItemID); entityFAQ = objFAQ.Data; } return entityFAQ; }