public ActionResult MediaSummary(int Id)
{
using (MovingTacticsEntities db = new MovingTacticsEntities())
{
List <MediaViewModel> mediaModel = new List <MediaViewModel>();
var mediaQuery = (from survey in db.Survey
join response in db.Responses
on survey.SurveyId equals response.SurveyId
join question in db.SurveyQuestions
on response.QuestionId equals question.QuestionId
join media in db.SurveyMedias
on response.QuestionId equals media.QuestionId
where question.QuestionId == Id
select new
{
media.MediaContent,
question.QuestionId
}).ToList();
foreach (var query in mediaQuery)
{
MediaViewModel responseSummaryViewModel = new MediaViewModel
{
QuestionId = query.QuestionId,
MediaContent = query.MediaContent
};
mediaModel.Add(responseSummaryViewModel);
}
return(View(mediaModel));
}
}
public ActionResult SurveyResponses(int Id)
{
using (MovingTacticsEntities db = new MovingTacticsEntities())
{
List <SurveyResponseViewModel> model = new List <SurveyResponseViewModel>();
var query = (from survey in db.Survey
join surveyResponses in db.SurveyResponses
on survey.SurveyId equals surveyResponses.SurveyId
join member in db.Members
on surveyResponses.MemberId equals member.MemberId
where survey.SurveyId == Id
select new
{
survey.SurveyTitle,
member.MemberName,
surveyResponses.DateCreated,
surveyResponses.TimeCreated,
surveyResponses.SurveyResponseId
}).ToList();
foreach (var item in query)
{
SurveyResponseViewModel responseModel = new SurveyResponseViewModel
{
SurveyResponseId = item.SurveyResponseId,
Survey = item.SurveyTitle,
Member = item.MemberName,
DateCreated = item.DateCreated,
TimeCreated = item.TimeCreated
};
model.Add(responseModel);
}
return(View(model));
}
}
public static void AddUserToRole(string UserGuid, string RoleGuid)
{
using (MovingTacticsEntities dbContext = new MovingTacticsEntities())
{
var IdentityManager = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(new MovingTacticsDbContext()));
IdentityManager.AddToRole(UserGuid, RoleGuid);
}
}
public UnitOfWork(MovingTacticsEntities dbContext)
{
_dbContext = dbContext;
Members = new MembersRepositoryEngine(_dbContext);
SurveyTypes = new SurveyCategoryRepositoryEngine(_dbContext);
Survey = new SurveyRepositoryEngine(_dbContext);
SurveyQuestions = new SurveyQuestionsRepositoryEngine(_dbContext);
SurveyOptionsType = new SurveyOptionTypeRepositoryEngine(_dbContext);
SurveyOptions = new SurveyOptionsRepositoryEngine(_dbContext);
SurveyFeedback = new SurveyFeedbackRepositoryEngine(_dbContext);
}
public ActionResult SurveyFeedback(int Id, SurveyViewModel model)
{
//var surveyModule = unitOfWork.SurveyFeedback.SurveyView(Id);
using (MovingTacticsEntities db = new MovingTacticsEntities())
{
model.SurveyQuestions = db.SurveyQuestions.Where(x => x.SurveyId == Id).ToList();
model.SurveyOptions = db.SurveyOptions.Where(x => x.SurveyId == Id).ToList();
model.Survey = db.Survey.FirstOrDefault(x => x.SurveyId == Id);
return(View(model));
}
}
public static int FindMemberId(string EmailAddress)
{
using (MovingTacticsEntities dbContext = new MovingTacticsEntities())
{
var userLambda = dbContext.Members.Join(dbContext.AspNetUsers, Members => Members.EmailAddress, AspUser => AspUser.Email, (Members, AspUser) =>
new { Members, AspUser }).Where(x => x.Members.EmailAddress == EmailAddress);
var Memberuid = userLambda.FirstOrDefault().Members.MemberId;
return(Memberuid);
}
}
public static Members GenericUserIdentityHelper(string UserEmail)
{
using (MovingTacticsEntities dbContext = new MovingTacticsEntities())
{
var UserInfo = from user in dbContext.Members
join IdentityUser in dbContext.AspNetUsers
on user.EmailAddress equals IdentityUser.Email
where user.EmailAddress == UserEmail
select user;
return((Members)UserInfo.FirstOrDefault());
}
}
public static void CreateUserPermission(string UserRole, string GlobalId)
{
using (MovingTacticsEntities dbContext = new MovingTacticsEntities())
{
AspNetRole permission = new AspNetRole
{
Id = GlobalId.ToString(),
Name = UserRole
};
dbContext.AspNetRoles.Add(permission);
dbContext.SaveChanges();
}
}
public ActionResult ResponseSummary(int Id)
{
using (MovingTacticsEntities db = new MovingTacticsEntities())
{
List <ResponseSummaryViewModel> responseForm = new List <ResponseSummaryViewModel>();
var queryForm = (from survey in db.Survey
join surveyResponses in db.SurveyResponses
on survey.SurveyId equals surveyResponses.SurveyId
join member in db.Members
on surveyResponses.MemberId equals member.MemberId
join response in db.Responses
on surveyResponses.SurveyResponseId equals response.SurveyResponseId
join question in db.SurveyQuestions
on response.QuestionId equals question.QuestionId
where surveyResponses.SurveyResponseId == Id
select new
{
survey.SurveyTitle,
member.MemberName,
surveyResponses.DateCreated,
surveyResponses.TimeCreated,
surveyResponses.SurveyResponseId,
question.QuestionBody,
question.QuestionId,
response.ResponseValue
}).ToList();
foreach (var query in queryForm)
{
ResponseSummaryViewModel responseSummaryViewModel = new ResponseSummaryViewModel
{
QuestionId = query.QuestionId,
Question = query.QuestionBody,
ResponseValue = query.ResponseValue,
Member = query.MemberName,
Survey = query.SurveyTitle
};
responseForm.Add(responseSummaryViewModel);
}
return(View(responseForm));
}
}
public ActionResult Index()
{
List <ResponseViewModel> ListModel = new List <ResponseViewModel>();
using (MovingTacticsEntities dbContext = new MovingTacticsEntities())
{
var query = (from survey in dbContext.Survey
join surveyQuestion in dbContext.SurveyQuestions
on survey.SurveyId equals surveyQuestion.SurveyId
join response in dbContext.Responses
on surveyQuestion.QuestionId equals response.QuestionId
join member in dbContext.Members
on response.MemberId equals member.MemberId
select new
{
survey.SurveyTitle,
surveyQuestion.QuestionBody,
response.ResponseValue,
response.Comment,
member.MemberName
}).ToList();
foreach (var item in query)
{
ResponseViewModel model = new ResponseViewModel
{
Question = item.QuestionBody,
ResponseValue = item.ResponseValue,
Comment = item.Comment,
Survey = item.SurveyTitle,
Member = item.MemberName
};
ListModel.Add(model);
}
return(View(ListModel));
}
}
public SurveyOptionTypeRepositoryEngine(MovingTacticsEntities dbContext) : base(dbContext)
{
}
public SurveyCategoryRepositoryEngine(MovingTacticsEntities dbContext) : base(dbContext)
{
}
public MembersRepositoryEngine(MovingTacticsEntities dbContext) : base(dbContext)
{
}
public SurveyQuestionsRepositoryEngine(MovingTacticsEntities dbContext) : base(dbContext)
{
}
public SurveyFeedbackRepositoryEngine(MovingTacticsEntities dbContext) : base(dbContext)
{
}
public GenericRepository(MovingTacticsEntities _dbContext)
{
dbContext = _dbContext;
}
public ActionResult SurveyFeedbackForm(FormCollection formCollection)
{
using (MovingTacticsEntities db = new MovingTacticsEntities())
{
int ResponseID = 0;
int SurveyResponseId = 0;
var x = Request.Form["SurveyId"];//Getting Survey Id from the form hidden field.
#region Survey Responses
SurveyResponses surveyResponses = new SurveyResponses
{
SurveyId = Int32.Parse(x.ToString()),
MemberId = GlobalMTHelper.GetMemberId(),
DateCreated = DateTime.Now.ToLongDateString(),
TimeCreated = DateTime.Now.ToLongTimeString(),
};
db.SurveyResponses.Add(surveyResponses);
db.SaveChanges();
SurveyResponseId = surveyResponses.SurveyResponseId;
#endregion
for (int i = 1; i < formCollection.Keys.Count; i++)
{
#region Getting Values for each question in the form collection and taking them one by one
var formTest = formCollection.GetValues(i);
var formKey = formCollection.GetKey(i);
//string value = formCollection[i];
//string[] variable = value.Split(',');
#endregion
#region Check If theres a comment value in Array
var option = formTest.Count() > 1 ? formTest[1].ToString() == string.Empty ? null : formTest[1].ToString() : null;
#endregion
#region Storing the responses for each question
Response response = new Response
{
QuestionId = Convert.ToInt32(formKey),
MemberId = GlobalMTHelper.GetMemberId(),
SurveyId = Int32.Parse(x.ToString()),
ResponseValue = formTest[0].ToString(),
Comment = option,
YesQuestionCount = 10,
DateCreated = DateTime.Now.ToLongDateString(),
SurveyResponseId = SurveyResponseId
};
db.Responses.Add(response);
db.SaveChanges();
ResponseID = response.ResponseId;
#endregion
#region Checking File count According to question
var FileCount = Request.Files.GetMultiple(formKey).Count();
var CheckFiles = Request.Files.GetMultiple(formKey);
#endregion
#region Media
// the count of the files and looping it
for (int v = 0; v < FileCount; v++)
{
//going through each file and checking if its null
var file = CheckFiles[v];
if (file != null && file.ContentLength > 0)
{
#region Saving media files for each response question
SurveyMedia media = new SurveyMedia
{
QuestionId = Convert.ToInt32(formKey),
MemberId = GlobalMTHelper.GetMemberId(),
SurveyId = Int32.Parse(x.ToString()),
ResponseId = ResponseID,
DateCreated = DateTime.Now.ToLongDateString()
};
using (var reader = new System.IO.BinaryReader(file.InputStream))
{
media.MediaContent = reader.ReadBytes(file.ContentLength);
}
db.SurveyMedias.Add(media);
db.SaveChanges();
#endregion
}
}
#endregion
}
return(RedirectToAction("Index"));
}
}
