public MasjidRenovationRequest(MasjidRenovationRequestModel _obj)
{
Id = _obj.Id;
ShortDescription = _obj.ShortDescription;
UserId = _obj.UserId;
Location = _obj.Location;
Area = _obj.Area;
MasjidId = _obj.MasjidId;
ConstructionCost = _obj.ConstructionCost;
ExistingFloors = _obj.ExistingFloors;
AmountNeeded = _obj.AmountNeeded;
Engineer = _obj.Engineer;
Elevation = _obj.Elevation;
Paln = _obj.Paln;
Doc1 = _obj.Doc1;
Doc2 = _obj.Doc2;
Doc3 = _obj.Doc3;
Pic1 = _obj.Pic1;
Pic2 = _obj.Pic2;
Pic3 = _obj.Pic3;
RequestSubmitId = _obj.RequestSubmitId;
Status = _obj.Status;
CreatedDate = _obj.CreatedDate;
RequestTypeId = _obj.RequestTypeId;
}
public ActionResult ARMasjidRenovation(MasjidRenovationRequestModel model)
{
if (model != null)
{
UserRegistrationBs obj = new UserRegistrationBs();
var UserId = obj.UserRegistrationList().Where(x => x.UserName == User.Identity.Name).FirstOrDefault().Id;
var UserTypeId = obj.UserRegistrationList().Where(x => x.UserName == User.Identity.Name).FirstOrDefault().UserTypeId;
_RequestApproveModel.UserId = Convert.ToInt32(UserId);
_RequestApproveModel.RequestSubmitId = Convert.ToInt32(model.RequestSubmitId);
_RequestApproveModel.UserTypeId = Convert.ToInt32(UserTypeId);
_RequestApproveModel.IsApproved = model.Status ?? false;
if (model.AlreadyExistsInMemberOpinion && model.MemberOpinionId != 0)
{
_RequestApproveModel.Id = model.MemberOpinionId;
}
int i = _RequestApproveBs.Save(_RequestApproveModel);
if (i > 0 && _RequestApproveModel.Id != 0)
{
TempData["agree"] = "You have Disagreed on this request";
}
else
{
TempData["agree"] = "You have agreed on this request";
}
}
return(RedirectToAction("GetMasjidRenovationRequestDetails", "RequestList", new { Id = _RequestApproveModel.RequestSubmitId }));
}
public int Save(MasjidRenovationRequestModel model)
{
MasjidRenovationRequest _tbl_mrr = new MasjidRenovationRequest(model);
_RequestSubmitModel.ShortDesc = model.ShortDescription;
_RequestSubmitModel.UserId = model.UserId;
_RequestSubmitModel.CreatedDate = Convert.ToDateTime(System.DateTime.Now);
_RequestSubmitModel.RequestTypeId = model.RequestTypeId;
RequestSubmit _requestSubmit = new RequestSubmit(_RequestSubmitModel);
if (_tbl_mrr.Id != null && _tbl_mrr.Id != 0)
{
_tbl_mrr.CreatedDate = Convert.ToDateTime(System.DateTime.Now);
//_tblList.CreatedBy = 1;
_tbl_MRR.Update(_tbl_mrr);
}
else
{
_requestSubmit = _RequestSubmit.Insert(_requestSubmit);
_tbl_mrr.RequestSubmitId = _requestSubmit.Id;
_tbl_mrr.CreatedDate = Convert.ToDateTime(System.DateTime.Now);
//_tblList.CreatedBy = 1;
_tbl_mrr = _tbl_MRR.Insert(_tbl_mrr);
}
return(_tbl_mrr.Id);
}
public MasjidRenovationRequestModel GetByRequestSubmitIdBoard(int id, int userid)
{
MasjidRenovationRequestModel varList = new MasjidRenovationRequestModel();
var MRRbyId = _tbl_MRR.GetAll().Where(x => x.RequestSubmitId == id).FirstOrDefault();
MRRbyId = MRRbyId ?? new MasjidRenovationRequest();
varList = new MasjidRenovationRequestModel
{
Id = MRRbyId.Id,
ShortDescription = MRRbyId.ShortDescription,
UserId = MRRbyId.UserId,
UserName = (MRRbyId.User != null) ? MRRbyId.User.UserName : string.Empty,
Location = MRRbyId.Location,
Area = MRRbyId.Area,
MasjidId = MRRbyId.MasjidId,
MasjidName = (MRRbyId.Masjid != null) ? MRRbyId.Masjid.Name : string.Empty,
ConstructionCost = MRRbyId.ConstructionCost,
ExistingFloors = MRRbyId.ExistingFloors,
AmountNeeded = MRRbyId.AmountNeeded,
Engineer = MRRbyId.Engineer,
Elevation = MRRbyId.Elevation,
Paln = MRRbyId.Paln,
Doc1 = MRRbyId.Doc1,
Doc2 = MRRbyId.Doc2,
Doc3 = MRRbyId.Doc3,
Pic1 = MRRbyId.Pic1,
Pic2 = MRRbyId.Pic2,
Pic3 = MRRbyId.Pic3,
RequestSubmitId = MRRbyId.RequestSubmitId,
Status = MRRbyId.Status,
CreatedDate = MRRbyId.CreatedDate,
RequestTypeId = MRRbyId.RequestTypeId,
RequestTypeName = (MRRbyId.RequestType != null) ? MRRbyId.RequestType.Name : string.Empty,
};
RequestCommentBs obj = new RequestCommentBs();
var BoardComments = obj.BoardCommentList(id).ToList();
varList.BoardCommentList = BoardComments;
var PannelComments = obj.PanelCommentList(id).ToList();
varList.PanelCommentList = PannelComments;
RequestApproveRejectBs obj1 = new RequestApproveRejectBs();
varList.ApprovedList = obj1.ApproveRejectDisplay(id).ToList();
varList.AlreadyExistsInMemberOpinion = varList.ApprovedList == null ? false : varList.ApprovedList.Where(m => m.UserTypeId == userid && m.RequestSubmitId == MRRbyId.RequestSubmitId).Any();
if (varList.AlreadyExistsInMemberOpinion)
{
varList.MemberOpinionId = varList.ApprovedList.Where(m => m.UserTypeId == userid && m.RequestSubmitId == MRRbyId.RequestSubmitId).FirstOrDefault().Id;
varList.IsAgreed = varList.ApprovedList.Where(m => m.UserTypeId == userid && m.RequestSubmitId == MRRbyId.RequestSubmitId).FirstOrDefault().IsApproved;
varList.LikeStatus = varList.ApprovedList.Where(m => m.UserTypeId == userid && m.RequestSubmitId == MRRbyId.RequestSubmitId).FirstOrDefault().LikeStatus;
}
PanelInvolveBs panelobject = new PanelInvolveBs();
varList.PannelMemberInvolved = panelobject.InvolveList(id).ToList();
return(varList);
}
public MasjidRenovationRequestBs()
{
_tbl_MRR = new GenericPattern <MasjidRenovationRequest>();
_MasjidRenovationRequestModel = new MasjidRenovationRequestModel();
_RequestSubmit = new GenericPattern <RequestSubmit>();
_RequestSubmitModel = new RequestSubmitModel();
}
public MasjidRenovationRequestModel GetMasjidRenovationById(int id)
{
MasjidRenovationRequestModel _MasjidRenovationRequestModel = new MasjidRenovationRequestModel();
var MRRbyId = _tbl_MRR.GetAll().Where(x => x.RequestSubmitId == id).FirstOrDefault();
MRRbyId = MRRbyId ?? new MasjidRenovationRequest();
_MasjidRenovationRequestModel = new MasjidRenovationRequestModel
{
Id = MRRbyId.Id,
ShortDescription = MRRbyId.ShortDescription,
UserId = MRRbyId.UserId,
UserName = (MRRbyId.User != null) ? MRRbyId.User.UserName : string.Empty,
Location = MRRbyId.Location,
Area = MRRbyId.Area,
MasjidId = MRRbyId.MasjidId,
MasjidName = (MRRbyId.Masjid != null) ? MRRbyId.Masjid.Name : string.Empty,
ConstructionCost = MRRbyId.ConstructionCost,
ExistingFloors = MRRbyId.ExistingFloors,
AmountNeeded = MRRbyId.AmountNeeded,
Engineer = MRRbyId.Engineer,
Elevation = MRRbyId.Elevation,
Paln = MRRbyId.Paln,
Doc1 = MRRbyId.Doc1,
Doc2 = MRRbyId.Doc2,
Doc3 = MRRbyId.Doc3,
Pic1 = MRRbyId.Pic1,
Pic2 = MRRbyId.Pic2,
Pic3 = MRRbyId.Pic3,
RequestSubmitId = MRRbyId.RequestSubmitId,
Status = MRRbyId.Status,
CreatedDate = MRRbyId.CreatedDate,
RequestTypeId = MRRbyId.RequestTypeId,
RequestTypeName = (MRRbyId.RequestType != null) ? MRRbyId.RequestType.Name : string.Empty,
};
RequestCommentBs obj = new RequestCommentBs();
var BoardComments = obj.BoardCommentList(id).ToList();
_MasjidRenovationRequestModel.BoardCommentList = BoardComments;
var PannelComments = obj.PanelCommentList(id).ToList();
_MasjidRenovationRequestModel.PanelCommentList = PannelComments;
RequestApproveRejectBs obj1 = new RequestApproveRejectBs();
_MasjidRenovationRequestModel.ApprovedList = obj1.ApproveRejectDisplay(id).ToList();
PanelInvolveBs panelobject = new PanelInvolveBs();
_MasjidRenovationRequestModel.PannelMemberInvolved = panelobject.InvolveList(id).ToList();
return(_MasjidRenovationRequestModel);
}
public MasjidRenovationRequestModel GetDetails(MasjidRenovationRequestModel model)
{
model = model ?? new MasjidRenovationRequestModel();
if (model.Id != 0)
{
model.MasjidLists = MasjidList();
model.RequestTypeLists = RequestTypeList();
model.UserLists = UserList();
model.MasjidRenovationRequestLists = MasjidRenovationRequestList();
}
model.MasjidRenovationRequestLists = MasjidRenovationRequestList();
return(model);
}
public ActionResult CommentOnMasjidRenovation(MasjidRenovationRequestModel model)
{
UserRegistrationBs obj = new UserRegistrationBs();
var UserId = obj.UserRegistrationList().Where(x => x.UserName == User.Identity.Name).FirstOrDefault().Id;
var UserTypeId = obj.UserRegistrationList().Where(x => x.UserName == User.Identity.Name).FirstOrDefault().UserTypeId;
if (model != null)
{
_RequestCommentModel.UserId = Convert.ToInt32(UserId);
_RequestCommentModel.RequestSubmitId = Convert.ToInt32(model.RequestSubmitId);
_RequestCommentModel.Comment = model.Comment;
_RequestCommentModel.CreatedDate = Convert.ToDateTime(System.DateTime.Now);
_RequestCommentModel.UserTypeId = Convert.ToInt32(UserTypeId);
_RequestCommentBs.Save(_RequestCommentModel);
}
return(Json("_RequestComentModel", JsonRequestBehavior.AllowGet));
}
public ActionResult Create(int?id)
{
if (id != null)
{
_MRRModel = _MRRBs.GetById(Convert.ToInt32(id));
_MRRModel.UserLists = _MRRBs.UserList().ToList();
_MRRModel.MasjidLists = _MRRBs.MasjidList().ToList();
_MRRModel.RequestTypeLists = _MRRBs.RequestTypeList().ToList();
return(View(_MRRModel));
}
else
{
_MRRModel.MasjidLists = _MRRBs.MasjidList().ToList();
_MRRModel.UserLists = _MRRBs.UserList().ToList();
_MRRModel.RequestTypeLists = _MRRBs.RequestTypeList().ToList();
}
return(View(_MRRModel));
}
public MasjidRenovationRequestModel GetById(int id)
{
MasjidRenovationRequestModel _MasjidRenovationRequestModel = new MasjidRenovationRequestModel();
var MRRbyId = _tbl_MRR.GetById(id);
MRRbyId = MRRbyId ?? new MasjidRenovationRequest();
_MasjidRenovationRequestModel = new MasjidRenovationRequestModel
{
Id = MRRbyId.Id,
ShortDescription = MRRbyId.ShortDescription,
UserId = MRRbyId.UserId,
UserName = (MRRbyId.User != null) ? MRRbyId.User.UserName : string.Empty,
Location = MRRbyId.Location,
Area = MRRbyId.Area,
MasjidId = MRRbyId.MasjidId,
MasjidName = (MRRbyId.Masjid != null) ? MRRbyId.Masjid.Name : string.Empty,
ConstructionCost = MRRbyId.ConstructionCost,
ExistingFloors = MRRbyId.ExistingFloors,
AmountNeeded = MRRbyId.AmountNeeded,
Engineer = MRRbyId.Engineer,
Elevation = MRRbyId.Elevation,
Paln = MRRbyId.Paln,
Doc1 = MRRbyId.Doc1,
Doc2 = MRRbyId.Doc2,
Doc3 = MRRbyId.Doc3,
Pic1 = MRRbyId.Pic1,
Pic2 = MRRbyId.Pic2,
Pic3 = MRRbyId.Pic3,
RequestSubmitId = MRRbyId.RequestSubmitId,
//RequestSubmitName= (item.RequestSubmit != null) ? item.RequestSubmit.Name : string.Empty,
Status = MRRbyId.Status,
CreatedDate = MRRbyId.CreatedDate,
RequestTypeId = MRRbyId.RequestTypeId,
RequestTypeName = (MRRbyId.RequestType != null) ? MRRbyId.RequestType.Name : string.Empty,
};
_MasjidRenovationRequestModel.RequestCommentList = new RequestCommentBs().BoardCommentList(id);
_MasjidRenovationRequestModel.ApprovedList = new RequestApproveRejectBs().ApproveRejectDisplay(id);
return(_MasjidRenovationRequestModel);
}
public ActionResult ARMasjidRenovation(MasjidRenovationRequestModel model)
{
if (model != null)
{
UserRegistrationBs obj = new UserRegistrationBs();
var UserId = obj.UserRegistrationList().Where(x => x.UserName == User.Identity.Name).FirstOrDefault().Id;
var UserTypeId = obj.UserRegistrationList().Where(x => x.UserName == User.Identity.Name).FirstOrDefault().UserTypeId;
_RequestApproveModel.UserId = Convert.ToInt32(UserId);
_RequestApproveModel.RequestSubmitId = Convert.ToInt32(model.RequestSubmitId);
_RequestApproveModel.UserTypeId = Convert.ToInt32(UserTypeId);
var IsAgreed = new RequestApproveRejectBs().ApproveRejectDisplay(_RequestApproveModel.RequestSubmitId).ToList();
if (IsAgreed.Where(x => x.UserTypeId == UserTypeId && x.UserId == UserId).Count() != 0)
{
_RequestApproveModel.Id = IsAgreed.Where(x => x.UserTypeId == UserTypeId && x.UserId == UserId).FirstOrDefault().Id;
}
if (model.Status != null)
{
_RequestApproveModel.IsApproved = model.Status;
}
if (model.LikeStatus != null)
{
_RequestApproveModel.LikeStatus = model.LikeStatus;
}
int InvolveUserTypId;
if (model.IsObjectClicked == true)
{
PanelInvolvementModel _PanelInvolvementModelObj = new PanelInvolvementModel();
switch (UserTypeId)
{
case 6:
InvolveUserTypId = 15;
_PanelInvolvementModelObj = new PanelInvolvementModel(model, UserId, (Int32)InvolveUserTypId);
break;
case 7:
InvolveUserTypId = 13;
_PanelInvolvementModelObj = new PanelInvolvementModel(model, UserId, (Int32)InvolveUserTypId);
break;
case 8:
InvolveUserTypId = 11;
_PanelInvolvementModelObj = new PanelInvolvementModel(model, UserId, (Int32)InvolveUserTypId);
break;
case 12:
InvolveUserTypId = 14;
_PanelInvolvementModelObj = new PanelInvolvementModel(model, UserId, (Int32)InvolveUserTypId);
break;
default:
_PanelInvolvementModelObj = new PanelInvolvementModel(model, UserId, (Int32)UserTypeId);
break;
}
_PanelInvolvementModelObj.IsObject = model.IsObject;
_PanelInvolveBs.Save(_PanelInvolvementModelObj);
}
else
{
_RequestApproveBs.Save(_RequestApproveModel);
}
}
return(Json(true, JsonRequestBehavior.AllowGet));
}
public ActionResult Create(MasjidRenovationRequestModel model, HttpPostedFileBase[] Files)
{
int result = 0;
if (model != null)
{
UserRegistrationBs obj = new UserRegistrationBs();
var id = obj.UserRegistrationList().Where(x => x.UserName == User.Identity.Name).FirstOrDefault().Id;
model.RequestTypeId = 4;
if (Files != null)
{
model.Paln = new byte[Files[0].ContentLength];
Files[0].InputStream.Read(model.Paln, 0, Files[0].ContentLength);
}
if (Files[1] != null)
{
model.Elevation = new byte[Files[1].ContentLength];
Files[1].InputStream.Read(model.Elevation, 0, Files[1].ContentLength);
}
if (Files[2] != null)
{
model.Doc1 = new byte[Files[2].ContentLength];
Files[2].InputStream.Read(model.Doc1, 0, Files[2].ContentLength);
}
if (Files[3] != null)
{
model.Doc2 = new byte[Files[3].ContentLength];
Files[3].InputStream.Read(model.Doc2, 0, Files[3].ContentLength);
}
if (Files[4] != null)
{
model.Doc3 = new byte[Files[4].ContentLength];
Files[4].InputStream.Read(model.Doc3, 0, Files[4].ContentLength);
}
if (Files[5] != null)
{
model.Pic1 = new byte[Files[5].ContentLength];
Files[5].InputStream.Read(model.Pic1, 0, Files[5].ContentLength);
}
if (Files[6] != null)
{
model.Pic2 = new byte[Files[6].ContentLength];
Files[6].InputStream.Read(model.Pic2, 0, Files[6].ContentLength);
}
if (Files[7] != null)
{
model.Pic3 = new byte[Files[7].ContentLength];
Files[7].InputStream.Read(model.Pic3, 0, Files[7].ContentLength);
}
model.UserId = id;
result = _MRRBs.Save(model);
}
if (result > 0)
{
_MRRModel.MasjidLists = _MRRBs.MasjidList().ToList();
_MRRModel.UserLists = _MRRBs.UserList().ToList();
_MRRModel.RequestTypeLists = _MRRBs.RequestTypeList().ToList();
TempData["message"] = "Request Submitted Successfully";
}
return(RedirectToAction("Index", "UserRequest", new { area = "User" }));
}
public MasjidRenovationRequestController()
{
_MRRModel = new MasjidRenovationRequestModel();
_MRRBs = new MasjidRenovationRequestBs();
}
