/// <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);
}
*/
}
