public static List <AccountModel> GetBoardMembers(BoardMembersModel boardMembersModel, string token)
{
var client = new RestClient(BaseUrl);
var request = InitRequest("/boards/boardMembers/" + token, Method.POST, boardMembersModel);
IRestResponse <BoardMembersModel> response = client.Execute <BoardMembersModel>(request);
return(response.Data.Members);
}
//
// GET: /FrontPage/
public ActionResult BoardMembers(RenderModel renderModel)
{
var model = new BoardMembersModel()
{
Header = CurrentPage.GetPropertyValue <string>("header"),
BodyText = CurrentPage.GetPropertyValue <IHtmlString>("bodyText"),
BoardMembers = GetBoardMembers()
};
return(View(model));
}
public BoardMembersModel MembersList([FromBody] BoardsMembersList model, string token, long boardId)
{
var session = IsTokenExpired(token);
var boardToSee = _readOnlyRepository.GetById <Board>(boardId);
if (boardToSee != null)
{
var memberS = new BoardMembersModel();
foreach (var member in boardToSee.Members)
{
var memberToAdd = new AccountModel();
memberToAdd.Id = member.Id;
memberToAdd.FirstName = member.FirstName;
memberToAdd.LastName = member.LastName;
memberS.Members.Add(memberToAdd);
}
return(memberS);
}
throw new BadRequestException("You can't see the members of this Board");
}
public ActionResult Create(BoardMembersModel model, string command, FormCollection fm)
{
var currentLoggedUserId = Convert.ToInt64(Membership.GetUser().ProviderUserKey);
var CurrentUserRoleID = objContext.UserRoles.Where(x => x.UserID == currentLoggedUserId).FirstOrDefault().RoleID;
ViewBag.LiTitle = "Board Member Listing";
var EncryptBMID = EncryptDecrypt.Encrypt(model.BoardMemberID.ToString());
var rvd = new RouteValueDictionary();
rvd.Add("Column", Request.QueryString["Column"] != null ? Request.QueryString["Column"].ToString() : "CreateDate");
rvd.Add("Direction", Request.QueryString["Direction"] != null ? Request.QueryString["Direction"].ToString() : "Descending");
rvd.Add("pagesize", Request.QueryString["pagesize"] != null ? Request.QueryString["pagesize"].ToString() : Models.Common._pageSize.ToString());
rvd.Add("page", Request.QueryString["page"] != null ? Request.QueryString["page"].ToString() : Models.Common._currentPage.ToString());
ViewBag.Title = ViewBag.PageTitle = (model.BoardMemberID > 0 ? "Edit " : "Add ") + " Board Member Details ";
ViewBag.Submit = model.BoardMemberID > 0 ? "Update" : "Save";
ViewBag.CreateDate = DateTime.Now.ToShortDateString();
ViewBag.UserCreateDate = DateTime.Now.ToShortDateString();
//model.RightSections = GetAllRightSections();
#region System Change Log
DataTable dtOld;
var oldresult = (from a in objContext.BoardOfMembers
where a.BoardMemberID == model.BoardMemberID
select a).ToList();
dtOld = Models.Common.LINQResultToDataTable(oldresult);
#endregion
var objDBContent = new db_KISDEntities();
var objctBM = new BoardOfMember();
ViewBag.IsActiveInd = Models.Common.GetStatusListBoolean(!string.IsNullOrEmpty(fm["IsActiveInd"]) ? Convert.ToString(fm["IsActiveInd"]) : "0");
ViewBag.BoardMemberID = model.BoardMemberID;
ViewBag.isValid = "1";
//ViewBag.RolesList = GetAllUserType(currentLoggedUserId);
var file = Request.Files.Count > 0 ? Request.Files[0] : null;
if (string.IsNullOrEmpty(command))
{
var InnerImagesTitle = Models.Common.GetInnerImages();
ViewBag.InnerImagesTitle = InnerImagesTitle;//get all the inner image titles
if (model.BoardMemberID > 0)
{
objctBM = objDBContent.BoardOfMembers.Where(x => x.BoardMemberID == model.BoardMemberID).FirstOrDefault();
}
else
{
objctBM = new BoardOfMember();
}
var count = objDBContent.BoardOfMembers.Where(x => x.URLTxt.ToLower().Trim() == model.URLTxt.ToLower().Trim() && x.BoardMemberID != model.BoardMemberID && x.IsDeletedInd == false).Count();
count += objContext.Contents.Where(x => x.PageURLTxt.ToLower().Trim() == model.URLTxt.ToLower().Trim() && x.IsDeletedInd == false).Count();
count += objContext.Departments.Where(x => x.URLTxt.ToLower().Trim() == model.URLTxt.ToLower().Trim() && x.IsDeletedInd == false).Count();
count += objContext.ExceptionOpportunities.Where(x => x.URLTxt.ToLower().Trim() == model.URLTxt.ToLower().Trim() && x.IsDeletedInd == false).Count();
count += objContext.GalleryListings.Where(x => x.URLTxt.ToLower().Trim() == model.URLTxt.ToLower().Trim() && x.IsDeletedInd == false).Count();
count += objContext.NewsEvents.Where(x => x.PageURLTxt.ToLower().Trim() == model.URLTxt.ToLower().Trim() && x.IsDeletedInd == false).Count();
if (model.URLTxt.Trim().ToLower() == "error404")// Check for duplicate url and error404 url
{
count = count + 1;
}
if (count > 0)
{
if (model.URLTxt.ToLower().Trim() == "error404")//if user types url 'error404' below validation msg should display
{
ModelState.AddModelError("URLTxt", model.URLTxt + " URL is not allowed.");
}
else
{
ModelState.AddModelError("URLTxt", model.URLTxt + " URL already exists.");
}
ViewBag.isValid = "0";
return(View(model));
}
if (file != null && file.ContentLength > 0)
{
#region Cropped Image
var croppedfile = new FileInfo(Server.MapPath(TempData["CroppedImage"].ToString()));
var fileName = croppedfile.Name;
croppedfile = null;
var sourcePath = Server.MapPath(TempData["CroppedImage"].ToString());
var targetPath = Request.PhysicalApplicationPath + "WebData\\";
System.IO.File.Copy(Path.Combine(sourcePath.Replace(fileName, ""), fileName), Path.Combine(targetPath + "images\\", fileName), true);
try
{
Models.Common.DeleteImage(Server.MapPath(TempData["CroppedImage"].ToString()));
}
catch
{
}
objctBM.ImageURLTxt = "~/WebData/images/" + fileName;
var fileExtension = fileName.Substring(fileName.LastIndexOf("."), fileName.Length - fileName.LastIndexOf("."));
var strPath = Request.PhysicalApplicationPath + "WebData\\images\\" + fileName;
var myImage = CreateImageThumbnail(strPath, 100);
myImage.Save(Request.PhysicalApplicationPath + "WebData\\thumbnails_Small\\" + fileName,
fileExtension.ToLower() == ".png" ?
System.Drawing.Imaging.ImageFormat.Png :
fileExtension.ToLower() == ".gif" ?
System.Drawing.Imaging.ImageFormat.Gif :
System.Drawing.Imaging.ImageFormat.Jpeg
);
myImage.Dispose();
var myLargeImage = CreateImageThumbnail(strPath, 400);
myLargeImage.Save(Request.PhysicalApplicationPath + "WebData\\thumbnails\\" + fileName,
fileExtension.ToLower() == ".png" ?
System.Drawing.Imaging.ImageFormat.Png :
fileExtension.ToLower() == ".gif" ?
System.Drawing.Imaging.ImageFormat.Gif :
System.Drawing.Imaging.ImageFormat.Jpeg
);
myLargeImage.Dispose();
TempData["CroppedImage"] = null;
#endregion
}
objctBM.BOMCreateDate = Convert.ToDateTime(model.strBOMCreateDate + " " + DateTime.Now.Hour + ":" + DateTime.Now.Minute + ":" + DateTime.Now.Second);
objctBM.ContactInfoTxt = model.ContactInfoTxt;
objctBM.CreateDate = DateTime.Now;
objctBM.DescriptionTxt = model.DescriptionTxt;
objctBM.DisplayOrderNbr = model.DisplayOrderNbr;
objctBM.NameTxt = model.NameTxt;
objctBM.PageMetaDescriptionTxt = model.PageMetaDescriptionTxt;
objctBM.PageMetaTitleTxt = model.PageMetaTitleTxt;
objctBM.RightSectionAbstractTxt = model.RightSectionAbstractTxt;
objctBM.RightSectionTitleTxt = model.PageMetaTitleTxt;
objctBM.BannerImageID = model.BannerImageID;
objctBM.BannerImageAbstractTxt = model.BannerImageAbstractTxt;
objctBM.AltBannerImageTxt = model.AltBannerImageTxt;
objctBM.TermTxt = model.TermTxt;
objctBM.TitleTxt = model.TitleTxt;
objctBM.URLTxt = model.URLTxt;
objctBM.StatusInd = Convert.ToBoolean(fm["IsActiveInd"]);
objctBM.IsDeletedInd = false;
objctBM.CreateDate = model.BoardMemberID > 0 ? objctBM.CreateDate : model.BOMCreateDate;
objctBM.CreateByID = model.BoardMemberID > 0 ? objctBM.CreateByID : Convert.ToInt64(Membership.GetUser().ProviderUserKey);
objctBM.LastModifyByID = Convert.ToInt64(Membership.GetUser().ProviderUserKey);
objctBM.LastModifyDate = DateTime.Now;
try
{
if (model.BoardMemberID == 0)
{
objDBContent.BoardOfMembers.Add(objctBM);
}
objDBContent.SaveChanges();
var newID = objctBM.BoardMemberID;
#region System Change Log
SystemChangeLog objSCL = new SystemChangeLog();
long userid = Convert.ToInt64(Membership.GetUser().ProviderUserKey);
User objuser = objContext.Users.Where(x => x.UserID == userid).FirstOrDefault();
objSCL.NameTxt = objuser.FirstNameTxt + " " + objuser.LastNameTxt;
objSCL.UsernameTxt = objuser.UserNameTxt;
objSCL.UserRoleID = (short)objContext.UserRoles.Where(x => x.UserID == objuser.UserID).First().RoleID;
objSCL.ModuleTxt = "Board Members";
objSCL.LogTypeTxt = model.BoardMemberID > 0 ? "Update" : "Add";
objSCL.NotesTxt = "Board Member Details" + (model.BoardMemberID > 0 ? " updated for " : " added for ") + objctBM.TitleTxt;
objSCL.LogDateTime = DateTime.Now;
objContext.SystemChangeLogs.Add(objSCL);
objContext.SaveChanges();
objSCL = objContext.SystemChangeLogs.OrderByDescending(x => x.ChangeLogID).FirstOrDefault();
var newResult = (from x in objContext.BoardOfMembers
where x.BoardMemberID == newID
select x);
DataTable dtNew = Models.Common.LINQResultToDataTable(newResult);
foreach (DataColumn col in dtNew.Columns)
{
if (model.BoardMemberID > 0)
{
if (dtOld.Rows[0][col.ColumnName].ToString() != dtNew.Rows[0][col.ColumnName].ToString())
{
SystemChangeLogDetail objSCLD = new SystemChangeLogDetail();
objSCLD.ChangeLogID = objSCL.ChangeLogID;
objSCLD.FieldNameTxt = col.ColumnName.ToString();
objSCLD.OldValueTxt = dtOld.Rows[0][col.ColumnName].ToString();
objSCLD.NewValueTxt = dtNew.Rows[0][col.ColumnName].ToString();
objContext.SystemChangeLogDetails.Add(objSCLD);
objContext.SaveChanges();
}
}
else
{
SystemChangeLogDetail objSCLD = new SystemChangeLogDetail();
objSCLD.ChangeLogID = objSCL.ChangeLogID;
objSCLD.FieldNameTxt = col.ColumnName.ToString();
objSCLD.OldValueTxt = "";
objSCLD.NewValueTxt = dtNew.Rows[0][col.ColumnName].ToString();
objContext.SystemChangeLogDetails.Add(objSCLD);
objContext.SaveChanges();
}
}
#endregion
TempData["Message"] = "Board Member details " + ((model.BoardMemberID == 0) ? "saved" : "updated") + " successfully.";
}
catch (Exception ex)
{
TempData["Message"] = "Some error occured. Please try after some time.";
}
}
return(RedirectToAction("Index", "BoardMembers", rvd));
}
public ActionResult Create(string bmid)
{
#region Check Tab is Accessible or Not
db_KISDEntities objContext = new db_KISDEntities();
var userId = objContext.Users.Where(x => x.UserNameTxt == User.Identity.Name).Select(x => x.UserID).FirstOrDefault();
var RoleID = objContext.UserRoles.Where(x => x.UserID == userId).Select(x => x.RoleID).FirstOrDefault();
var HasTabAccess = GetAccessibleTabAccess(Convert.ToInt32(ModuleType.SchoolBoard), Convert.ToInt32(userId));
if (!(HasTabAccess || RoleID == Convert.ToInt32(UserType.SuperAdmin) ||
RoleID == Convert.ToInt32(UserType.Admin))) //if tab not accessible then redirect to home
{
return(RedirectToAction("Index", "Home"));
}
#endregion
var currentLoggedUserId = Convert.ToInt64(Membership.GetUser().ProviderUserKey);
var CurrentUserRoleID = objContext.UserRoles.Where(x => x.UserID == currentLoggedUserId).FirstOrDefault().RoleID;
ViewBag.LiTitle = "Board Member Listing";
bmid = !string.IsNullOrEmpty(Convert.ToString(bmid)) ? EncryptDecrypt.Decrypt(bmid) : "0";
var BoardMemberId = Convert.ToInt64(bmid);
var objModel = new BoardMembersModel();
ViewBag.Title = ViewBag.PageTitle = (BoardMemberId > 0 ? "Edit " : "Add ") + " Board Member Details ";
ViewBag.Submit = BoardMemberId > 0 ? "Update" : "Save";
ViewBag.UserCreateDate = DateTime.Now.ToShortDateString();
ViewBag.UserID = bmid;
string isActive = "True";
Session["Edit/Delete"] = "Edit";
ViewBag.UserTypeID = 0;
objModel.strBOMCreateDate = DateTime.Now.ToShortDateString();
if (BoardMemberId > 0)
{
var objBOMContext = objContext.BoardOfMembers.Find(BoardMemberId);
if (objBOMContext != null)
{
objModel.BoardMemberID = objBOMContext.BoardMemberID;
objModel.StatusInd = objBOMContext.StatusInd.Value;
objModel.BOMCreateDate = objBOMContext.BOMCreateDate.HasValue ? objBOMContext.BOMCreateDate.Value : DateTime.Now;
objModel.ContactInfoTxt = objBOMContext.ContactInfoTxt;
objModel.BannerImageID = objBOMContext.BannerImageID;
objModel.AltBannerImageTxt = objBOMContext.AltBannerImageTxt;
objModel.BannerImageAbstractTxt = objBOMContext.BannerImageAbstractTxt;
objModel.CreateByID = objBOMContext.CreateByID;
objModel.CreateDate = objBOMContext.CreateDate.HasValue ? objBOMContext.CreateDate.Value : DateTime.Now;
objModel.DescriptionTxt = objBOMContext.DescriptionTxt;
objModel.DisplayOrderNbr = objBOMContext.DisplayOrderNbr;
objModel.ImageURLTxt = objBOMContext.ImageURLTxt;
objModel.IsDeletedInd = objBOMContext.IsDeletedInd;
objModel.LastModifyByID = objBOMContext.LastModifyByID;
objModel.LastModifyDate = objBOMContext.LastModifyDate.HasValue ? objBOMContext.LastModifyDate.Value : DateTime.Now;
objModel.NameTxt = objBOMContext.NameTxt;
objModel.PageMetaDescriptionTxt = objBOMContext.PageMetaDescriptionTxt;
objModel.PageMetaTitleTxt = objBOMContext.PageMetaTitleTxt;
objModel.RightSectionAbstractTxt = objBOMContext.RightSectionAbstractTxt;
objModel.RightSectionTitleTxt = objBOMContext.RightSectionTitleTxt;
objModel.TitleTxt = objBOMContext.TitleTxt;
objModel.TermTxt = objBOMContext.TermTxt;
objModel.URLTxt = objBOMContext.URLTxt;
objModel.strBOMCreateDate = objBOMContext.BOMCreateDate.HasValue ? objBOMContext.BOMCreateDate.Value.ToShortDateString() : DateTime.Now.ToShortDateString();
isActive = objBOMContext.StatusInd.ToString();
}
}
else
{
objModel.StatusInd = true;
objModel.BOMCreateDate = DateTime.Now;
}
ViewBag.IsActiveInd = Models.Common.GetStatusListBoolean(isActive);
var InnerImagesTitle = Models.Common.GetInnerImages();
ViewBag.InnerImagesTitle = InnerImagesTitle;//get all the inner image titles
return(View(objModel));
}
