/// <summary> /// Kiểm tra và thêm mới FaqAnswers /// </summary> /// <param name="entity">Entity</param> /// <returns>Int32: ID của FaqAnswers Mới Thêm Vào</returns> public static Int32 Add(FaqAnswersEntity entity) { checkLogic(entity); checkDuplicate(entity, false); checkFK(entity); return FaqAnswersDAL.Add(entity); }
/// <summary> /// Kiểm tra và chỉnh sửa FaqAnswers /// </summary> /// <param name="entity">FaqAnswersEntity</param> /// <returns>bool:kết quả thực hiện</returns> public static bool Edit(FaqAnswersEntity entity) { checkExist(entity.PK_iFaqAnswerID); checkLogic(entity); checkDuplicate(entity, true); checkFK(entity); return FaqAnswersDAL.Edit(entity); }
protected void btnOK_Click(object sender, EventArgs e) { try { if (Session["UserID"] == null) Response.Redirect("~/"); FaqEntity oFAQ = new FaqEntity(); oFAQ.FK_iFaqCateID = Convert.ToInt32(ddlLoaiCauHoi.SelectedValue); oFAQ.sQuestion = txtCauhoi.Text; // FaqAnswersEntity oFAQAnswer = new FaqAnswersEntity(); oFAQAnswer.sContent = txtCautraloi.Text; // if (Session["UserID"] != null) { int userID = Convert.ToInt32(Session["UserID"]); oFAQ.FK_iUserID = userID; if (btnOK.CommandName == "Edit") { int faqID = Convert.ToInt32(btnOK.CommandArgument); int faqanswerID = Convert.ToInt32(btnReset.CommandArgument); oFAQ.PK_iFaqID = faqID; oFAQAnswer.PK_iFaqAnswerID = faqanswerID; oFAQAnswer.FK_iFaqID = faqID; FaqBRL.Edit(oFAQ); FaqAnswersBRL.Edit(oFAQAnswer); btnOK.CausesValidation = true; } else { int faqAddID = FaqBRL.Add(oFAQ); oFAQAnswer.FK_iFaqID = faqAddID; FaqAnswersBRL.Add(oFAQAnswer); } lblThongbao.Text = "Cập nhật thành công"; btnOK.Text = "Thêm"; //Nạp lại dữ liệu pnEdit.Visible = false; Response.Redirect(Request.Url.ToString()); } } catch (Exception ex) { Response.Write("<script language=\"javascript\">alert('" + ex.Message + "');location='Default.aspx?page=FAQManager';</script>"); } }
/// <summary> /// Kiểm tra logic Entity /// </summary> /// <param name="entity">FaqAnswersEntity: entity</param> private static void checkLogic(FaqAnswersEntity entity) { if (entity.FK_iFaqID < 0) throw new Exception(EX_FK_IFAQID_INVALID); if (String.IsNullOrEmpty(entity.sContent)) throw new Exception(EX_SCONTENT_EMPTY); }
/// <summary> /// Kiểm tra tồn tại khóa ngoại /// </summary> /// <param name="entity">FaqAnswersEntity:entity</param> private static void checkFK(FaqAnswersEntity entity) { FaqEntity oFaq = FaqDAL.GetOne(entity.FK_iFaqID); if (oFaq==null) { throw new Exception("Không tìm thấy :FK_iFaqID"); } }
/// <summary> /// Kiểm tra trùng lặp bản ghi /// </summary> /// <param name="entity">FaqAnswersEntity: FaqAnswersEntity</param> private static void checkDuplicate(FaqAnswersEntity entity,bool checkPK) { /* Example List<FaqAnswersEntity> list = FaqAnswersDAL.GetAll(); if (list.Exists( delegate(FaqAnswersEntity oldEntity) { bool result =oldEntity.FIELD.Equals(entity.FIELD, StringComparison.OrdinalIgnoreCase); if(checkPK) result=result && oldEntity.PK_iFaqAnswerID != entity.PK_iFaqAnswerID; return result; } )) { list.Clear(); throw new Exception(EX_FIELD_EXISTED); } */ }