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;
}
