public async Task <IActionResult> Details([FromQuery] Guid id) { var notice = await _noticeRepository.GetAsync(id); if (notice == null) { return(NotFound(new ApiResult <dynamic>(new { Id = ErrorCodes.InvalidNoticeId }))); } var user = await _userManager.FindByIdAsync(notice.AppUserId); var userInfo = new UserInfo { Username = user?.UserName, Email = user?.Email, Name = user?.Name }; var result = new NoticeDetails { Notice = notice, User = userInfo }; return(Ok(new ApiResult <NoticeDetails> { Result = result })); }
protected void BtnUploadExcel(object sender, EventArgs e) { _objCommon = new Common(); try { var objClsOledbdatalayer = new ClsOleDBDataWrapper(); var path = MapPath(fulUploadExcel.FileName); fulUploadExcel.SaveAs(path); var excelSheets = objClsOledbdatalayer.CountTotalSheets(path); if (excelSheets.Length <= 0) { return; } foreach (string t in excelSheets) { DataSet ds = objClsOledbdatalayer.getdata(path, t); if (ds.Tables[0].Rows.Count > 0) { for (var j = 0; j <= ds.Tables[0].Rows.Count - 1; j++) { var errMsg = ""; _objNoticeDetails = new NoticeDetails { NoticeUrl = ds.Tables[0].Rows[j]["NoticeUrl"].ToString(), NoticeTitle = ds.Tables[0].Rows[j]["NoticeTitle"].ToString(), NoticeSubject = ds.Tables[0].Rows[j]["NoticeSubject"].ToString(), NoticeMetaTag = ds.Tables[0].Rows[j]["NoticeMetaTag"].ToString(), NoticeShortDesc = ds.Tables[0].Rows[j]["NoticeShortDesc"].ToString(), NoticeMetaDesc = ds.Tables[0].Rows[j]["NoticeMetaDesc"].ToString(), NoticeDesc = ds.Tables[0].Rows[j]["NoticeDesc"].ToString(), NoticeStatus = ds.Tables[0].Rows[j]["NoticeStatus"].ToString() == "True" ? true : false, RealtedCollegeId = Convert.ToInt16( ds.Tables[0].Rows[j]["RealtedCollegeId"].ToString()), NoticeImage = ds.Tables[0].Rows[j]["NoticeImage"].ToString(), NoticeTypeId = Convert.ToInt16(ds.Tables[0].Rows[j]["NoticeTypeId"].ToString()) }; var result = NewsArticleNoticeProvider.Instance.InsertNoticeDetails(_objNoticeDetails, LoggedInUserId, out errMsg); } } } } catch (Exception ex) { var err = ex.Message; if (ex.InnerException != null) { err = err + " :: Inner Exception :- " + ex.ToString(); } const string addInfo = "Error while executing in BtnUploadExcel at page AddNoticeDetails.aspx.cs :: -> "; var objPub = new ClsExceptionPublisher(); objPub.Publish(err, addInfo); } }
public IActionResult Create(CreateNoticeViewModel noticeViewModel) { if (ModelState.IsValid) { if (_noticeQueries.ShowNotice(noticeViewModel.NoticeStart, noticeViewModel.NoticeEnd)) { ModelState.AddModelError("", "Notice Already Exits Between Selected Dates"); return(View(noticeViewModel)); } var noticeMappedobject = _mapper.Map <Notice>(noticeViewModel); noticeMappedobject.Status = true; noticeMappedobject.CreatedOn = DateTime.Now; noticeMappedobject.CreatedBy = Convert.ToInt32(HttpContext.Session.GetString(AllSessionKeys.UserId)); _unitOfWorkEntityFramework.NoticeCommand.AddNotice(noticeMappedobject); var noticeDetails = new NoticeDetails() { Notice = noticeMappedobject, NoticeBody = HttpUtility.HtmlDecode(noticeViewModel.NoticeBody), NoticeDetailsId = 0, NoticeId = noticeMappedobject.NoticeId }; _unitOfWorkEntityFramework.NoticeDetailsCommand.AddNoticeDetails(noticeDetails); var result = _unitOfWorkEntityFramework.Commit(); if (result) { _notificationService.SuccessNotification("Message", "The Notice was added Successfully!"); } } return(RedirectToAction("Create")); }
public void DeleteNoticeDetails(NoticeDetails noticeDetails) { _frapperDbContext.Entry(noticeDetails).State = EntityState.Deleted; }
public void UpdateNoticeDetails(NoticeDetails noticeDetails) { _frapperDbContext.Entry(noticeDetails).State = EntityState.Modified; }
public void AddNoticeDetails(NoticeDetails noticeDetails) { _frapperDbContext.NoticeDetails.Add(noticeDetails); }
public abstract int UpdateNoticeDetails(NoticeDetails objNoticeDetails, int modifiedBy, out string errmsg);
public abstract int InsertNoticeDetails(NoticeDetails objNoticeDetails, int createdBy, out string errmsg);
private void InsertUpdateNotice() { try { var errMsg = ""; var fileName = this.FlUpload.UploadedImageName; if (fileName != null) { hdnFileName.Value = fileName; } _objNoticeDetails = new NoticeDetails { NoticeShortDesc = txtNoticeShortDesc.Text.Trim().TrimEnd('-'), NoticeUrl = txtNoticeUrl.Text.Trim().TrimEnd('-'), NoticeTitle = txtNoticeTitle.Text.Trim().TrimEnd('-'), NoticeSubject = txtNoticeSubject.Text.Trim().TrimEnd('-'), NoticeMetaTag = txtNoticeTag.Text.Trim().TrimEnd('-'), NoticeMetaDesc = txtMetaDesc.Text.Trim().TrimEnd('-'), NoticeDesc = fckNoticeDesc.FckValue.Trim().TrimEnd('-'), NoticeStatus = chkNoticeStatus.Checked, RealtedCollegeId = Convert.ToInt16(ddlRelatedCollege.SelectedValue), NoticeImage = hdnFileName.Value, NoticeTypeId = Convert.ToInt16(ddlNoticeType.SelectedValue) }; if (btnSave.Text == "Save") { var result = NewsArticleNoticeProvider.Instance.InsertNoticeDetails(_objNoticeDetails, LoggedInUserId, out errMsg); if (result <= 0) { return; } Response.Redirect("NoticeMaster.aspx"); } else { _objNoticeDetails.NoticeId = Convert.ToInt16(Request.QueryString["NoticeId"]); var result = NewsArticleNoticeProvider.Instance.UpdateNoticeDetails(_objNoticeDetails, LoggedInUserId, out errMsg); if (result <= 0) { return; } btnSave.Text = "Update"; Response.Redirect("NoticeMaster.aspx"); } } catch (Exception ex) { var err = ex.Message; if (ex.InnerException != null) { err = err + " :: Inner Exception :- " + ex.ToString(); } const string addInfo = "Error while executing in InsertUpdateNotice at page AddNoticeDetails.aspx.cs :: -> "; var objPub = new ClsExceptionPublisher(); objPub.Publish(err, addInfo); } }