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