/// <summary> /// Kiểm tra và thêm mới Chitieu /// </summary> /// <param name="entity">Entity</param> /// <returns>Int32: ID của Chitieu Mới Thêm Vào</returns> public static Int32 Add(ChitieuEntity entity) { checkLogic(entity); checkDuplicate(entity, false); checkFK(entity); return ChitieuDAL.Add(entity); }
/// <summary> /// Kiểm tra và chỉnh sửa Chitieu /// </summary> /// <param name="entity">ChitieuEntity</param> /// <returns>bool:kết quả thực hiện</returns> public static bool Edit(ChitieuEntity entity) { checkExist(entity.PK_iChitieuID); checkLogic(entity); checkDuplicate(entity, true); checkFK(entity); return ChitieuDAL.Edit(entity); }
/// <summary> /// Kiểm tra logic Entity /// </summary> /// <param name="entity">ChitieuEntity: entity</param> private static void checkLogic(ChitieuEntity entity) { if (String.IsNullOrEmpty(entity.sNoidung)) throw new Exception(EX_SNOIDUNG_EMPTY); if (entity.iThuthu < 0) throw new Exception(EX_ITHUTHU_INVALID); if (entity.FK_iMucdoID < 0) throw new Exception(EX_FK_IMUCDOID_INVALID); if (entity.FK_iDanhmucchitieuID < 0) throw new Exception(EX_FK_IDANHMUCCHITIEUID_INVALID); }
/// <summary> /// Kiểm tra tồn tại khóa ngoại /// </summary> /// <param name="entity">ChitieuEntity:entity</param> private static void checkFK(ChitieuEntity entity) { MucdoEntity oMucdo = MucdoDAL.GetOne(entity.FK_iMucdoID); if (oMucdo==null) { throw new Exception("Không tìm thấy :FK_iMucdoID"); } DanhmucchitieuEntity oDanhmucchitieu = DanhmucchitieuDAL.GetOne(entity.FK_iDanhmucchitieuID); if (oDanhmucchitieu==null) { throw new Exception("Không tìm thấy :FK_iDanhmucchitieuID"); } }
/// <summary> /// Kiểm tra trùng lặp bản ghi /// </summary> /// <param name="entity">ChitieuEntity: ChitieuEntity</param> private static void checkDuplicate(ChitieuEntity entity,bool checkPK) { /* Example List<ChitieuEntity> list = ChitieuDAL.GetAll(); if (list.Exists( delegate(ChitieuEntity oldEntity) { bool result =oldEntity.FIELD.Equals(entity.FIELD, StringComparison.OrdinalIgnoreCase); if(checkPK) result=result && oldEntity.PK_iChitieuID != entity.PK_iChitieuID; return result; } )) { list.Clear(); throw new Exception(EX_FIELD_EXISTED); } */ }
protected void btnOK_Click(object sender, EventArgs e) { if (Page.IsValid) { try { Session["iDanhmucchitieuIndex"] = ddlDanhmucchitieu.SelectedIndex; ChitieuEntity oChiTieu = new ChitieuEntity(); oChiTieu.sNoidung = txtNoidung.InnerText; oChiTieu.iThuthu = Convert.ToInt16(txtIThutu.Text); oChiTieu.sYeucauvietgap = txtYeucauvietgap.InnerText; oChiTieu.sGhichu = txtGhichu.InnerText; oChiTieu.FK_iDanhmucchitieuID = Int16.Parse(ddlDanhmucchitieu.SelectedValue); oChiTieu.FK_iMucdoID = Int16.Parse(ddlMucdo.SelectedValue); if (btnOK.CommandName == "Edit") { int ChiTieuID = Convert.ToInt32(btnOK.CommandArgument); oChiTieu.PK_iChitieuID = ChiTieuID; ChitieuBRL.Edit(oChiTieu); btnOK.CausesValidation = true; lblThongbao.Text = "Cập nhật thành công"; } else { int ChiTieuAddID = ChitieuBRL.Add(oChiTieu); lblThongbao.Text = "Thêm thành công"; } //Nạp lại dữ liệu pnAdd.Visible = false; napGrvChitieu(); } catch (Exception ex) { Response.Write("<script language=\"javascript\">alert('" + ex.Message + "');location='Default.aspx?page=ChitieuManager';</script>"); } } }