public int Delete(Board entity) { int i = 0; string[] addParams = { Board_Constant.BOARD_ID }; i = _BoardRepository.ExecuteNonQuery(entity, addParams, Board_Constant.SPROC_BOARDMST_DEL); return i; }
public int AddEdit(Board entity) { int i = 0; User objUser = null; if (eSchoolSession.IsInSession(SessionKeys.CurrentUser)) objUser = (User)eSchoolSession.GetDirectValue(SessionKeys.CurrentUser); if (string.IsNullOrEmpty(entity.BoardID)) { entity.BoardID = Utility.GeneratorUniqueId(ID_PREFIX_CONSTANTS.BOARD_ID_PREFIX); if (objUser != null && !string.IsNullOrEmpty(objUser.UserID)) { entity.CreatedByID = objUser.UserID; entity.ModifiedByID = objUser.UserID; } else { entity.CreatedByID = "1"; entity.ModifiedByID = "1"; } } else { if (objUser != null && !string.IsNullOrEmpty(objUser.UserID)) entity.ModifiedByID = objUser.UserID; else entity.ModifiedByID = "1"; } ////Upload Image to DB //if (entity.BoardLogoFile != null && !string.IsNullOrEmpty(entity.BoardLogoFile.FileName) // && Utility.IsImage(entity.BoardLogoFile)) //{ // using (MemoryStream ms = new MemoryStream()) // { // entity.BoardLogoFile.InputStream.CopyTo(ms); // byte[] array = ms.GetBuffer(); // entity.BoardLogo = array; // } //} string[] addParams = { Board_Constant.BOARD_ID, Board_Constant.BOARD_NAME , Board_Constant.BOARD_CODE , Board_Constant.BOARD_ADDRESS, Board_Constant.BOARD_CONTACT_NO , Board_Constant.BOARD_FAX_NO , Board_Constant.BOARD_EMAIL_ADDRESS , Board_Constant.BOARD_CONTACT_PERSON_NAME , Board_Constant.BOARD_CONTACT_PERSON_DESIGNATION , Board_Constant.BOARD_CONTACT_PERSON_CONTACTNO , Board_Constant.BOARD_CONTACT_PERSON_CELL_NO , Board_Constant.BOARD_CONTACT_PERSON_EMAIL_ADDRESS , Board_Constant.BOARD_LOGO , Board_Constant.CREATED_BY_ID, Board_Constant.MODIFIED_BY_ID }; i = _BoardRepository.ExecuteNonQuery(entity, addParams, Board_Constant.SPROC_BOARDMST_UPS); return i; }
public int UpdateLogo(Board entity) { int i = 0; User objUser = null; if (eSchoolSession.IsInSession(SessionKeys.CurrentUser)) objUser = (User)eSchoolSession.GetDirectValue(SessionKeys.CurrentUser); if (objUser != null && !string.IsNullOrEmpty(objUser.UserID)) entity.ModifiedByID = objUser.UserID; else entity.ModifiedByID = "1"; string[] addParams = { Board_Constant.BOARD_ID, Board_Constant.BOARD_LOGO , Board_Constant.CREATED_BY_ID, Board_Constant.MODIFIED_BY_ID }; i = _BoardRepository.ExecuteNonQuery(entity, addParams, Board_Constant.SPROC_BOARDMST_UPS_LOGO); return i; }
public object GetScalar(Board entity) { throw new NotImplementedException(); }
public IEnumerable<Board> GetAll(Board entity) { string[] addParams = { Constants.PAGEINDEX, Constants.PAGESIZE, Constants.SORTEXP }; return _BoardRepository.GetAll(entity, addParams, Board_Constant.SPROC_BOARDMST_LSTALL); }
public Board Get(Board entity) { string[] addParams = { Board_Constant.BOARD_ID }; return _BoardRepository.Get(entity, addParams, Board_Constant.SPROC_BOARDMST_SEL); }