/// <summary>
/// Gets the user feedbacks.
/// </summary>
/// <param name="userId">The user id.</param>
/// <param name="subscriptionid">The subscriptionid.</param>
/// <returns></returns>
/* internal IList<UserPOEMapping> GetUserFeedbacks(int userId, int subscriptionid)
* {
* using (var context = DataContextFactory.GetIntelliSetDataContext())
* {
* var results = context.GetUserFeedbacks(userId, subscriptionid);
* return results.SelectMany((a, b) => new List<UserPOEMapping>{
* new UserPOEMapping{
* UserPOEMappingId = a.MappingId.GetValueOrDefault(),
* AreaId = a.ZoneId.GetValueOrDefault(),
*
* //Designation = a.DesignationId.GetValueOrDefault(),
* User = new User{
* UserId = userId,
* FirstName = a.FirstName,
* LastName = a.LastName,
* EmailAddress = a.EmailID,
* Photo = a.Photo,
*
* Country = new Country{
* Id = a.CountryId,
* Name = Helper.GetCountryName(a.CountryId)
* },
* Area= new Zone{
* Id = a.ZoneId.GetValueOrDefault(),
* Name = Helper.GetAreaById(a.ZoneId.GetValueOrDefault())
* }
* },
* POE = new Util.Domain.POE() {
* POEId = a.POEId,
* Name = a.POEName,
* },
* Designation = new Designation{
* DesignationId = a.DesignationId.GetValueOrDefault(),
* Name = a.DesignationName,
* Level = a.LevelId.GetValueOrDefault()
* },
* FeedbackDetails = new Feedback{
* FeedbackId = a.FeedbackId.GetValueOrDefault(),
* RequestedBy = GetUserDetailsByMappingId(a.RequestedBy.GetValueOrDefault()),
* RequestedFor = GetUserDetailsByMappingId(a.RequestedFor.GetValueOrDefault()),
* RequestedFrom = GetUserDetailsByMappingId(a.RequestedFrom.GetValueOrDefault()),
* CreatedOnDtm = a.FeedbackCreatedOn.GetValueOrDefault(),
* UpdatedOnDtm = a.FeedbackUpdatedOn.GetValueOrDefault(),
* CreatedOn = a.FeedbackCreatedOn!=null?a.FeedbackCreatedOn.GetValueOrDefault().ToString("MMMM dd, yyyy"):"",
* UpdatedOn = a.FeedbackUpdatedOn!=null?a.FeedbackUpdatedOn.GetValueOrDefault().ToString("MMMM dd, yyyy"):"",
* FeedbackStatus = (FeedbackStatus)Enum.Parse(typeof(FeedbackStatus),a.FeedBackStatus.GetValueOrDefault().ToString()),
* FeedbackType = (FeedbackType)Enum.Parse(typeof(FeedbackType),a.FeedbackType.Value.ToString()),
* GroupName = a.GroupName
* },
*
* JobTitle = a.JobTitle
* }
* }).ToList();
* }
* }
*/
/// <summary>
/// Gets the received feedback.
/// </summary>
/// <param name="userId">The user id.</param>
/// <param name="subscriptionid">The subscriptionid.</param>
/// <returns></returns>
/* internal List<GetReceivedFeedbacksResult> GetReceivedFeedback(int userId, int subscriptionid)
* {
* using (var context = DataContextFactory.GetIntelliSetDataContext())
* {
* return context.GetReceivedFeedbacks(userId, subscriptionid).ToList();
* }
* }*/
/// <summary>
/// Gets the user details by mapping id.
/// </summary>
/// <param name="userMappingId">The user mapping id.</param>
/// <returns></returns>
internal UserPOEMapping GetUserDetailsByMappingId(int userMappingId)
{
using (var context = DataContextFactory.GetIntelliSetDataContext())
{
var userDetails = default(UserPOEMapping);
var result = context.GetUserDetailsByMappingId(userMappingId).FirstOrDefault();
if (result != null)
{
userDetails = new UserPOEMapping
{
User = new User
{
FirstName = result.FirstName,
LastName = result.LastName,
EmailAddress = result.EmailID,
Subscriptionid = result.SubscriptionID,
Country = new Country
{
Id = result.CountryId,
Name = Helper.GetCountryName(result.CountryId)
},
Area = new Zone
{
Id = result.ZoneId.GetValueOrDefault(),
Name = Helper.GetAreaById(result.ZoneId.GetValueOrDefault())
}
},
AreaId = result.ZoneId.GetValueOrDefault(),
POE = new Util.Domain.POE()
{
POEId = result.RoleId,
Name = result.RoleTitle
},
//Role = new Role
//{
// RoleId = result.RoleId,
// Title = result.RoleTitle,
Designation = new Designation
{
DesignationId = result.DesignationId,
Level = result.LevelId,
Name = result.DesignationName,
},
JobTitle = result.JobTitle
//}
};
}
return(userDetails);
}
}
public IList <UserPOEMapping> GetFeedbackGiven(int userId, int subscriptionid)
{
//Log("WCF-GetFeedbackGiven-IN");
var common = new Common.Common();
using (var context = DataContextFactory.GetIntelliSetDataContext())
{
var results = context.GetFeedbackGiven(userId, subscriptionid);
var outPut = new List <UserPOEMapping>();
//foreach (var b in results.GroupBy(item => item.GroupName).ToList())
//{
foreach (var a in results)
{
if (a.FeedbackType != null)
{
var userPoeMapping = new UserPOEMapping
{
UserPOEMappingId = a.RequestedFor.GetValueOrDefault(),
AreaId = a.ZoneId.GetValueOrDefault(),
User = new User
{
UserId = a.UserId.GetValueOrDefault(),
FirstName = a.FirstName,
LastName = a.LastName,
EmailAddress = a.EmailID,
// Photo = a.Photo,
Country = new Country
{
Id = a.CountryId.GetValueOrDefault(),
Name = Helper.GetCountryName(a.CountryId.GetValueOrDefault())
},
Area = new Zone
{
Id = a.ZoneId.GetValueOrDefault(),
Name = Helper.GetAreaById(a.ZoneId.GetValueOrDefault())
}
},
POE = new Util.Domain.POE()
{
POEId = a.POEId.GetValueOrDefault(),
Name = a.POEName,
},
Designation = new Designation
{
DesignationId = a.DesignationId.GetValueOrDefault(),
Name = a.JobTitle,
},
FeedbackDetails = new Feedback
{
FeedbackId = a.GroupName != null ? 0 : a.POEFeedbackId.GetValueOrDefault(),
RequestedBy =
common.GetUserDetailsByMappingId(a.RequestedBy.GetValueOrDefault()),
RequestedFor =
common.GetUserDetailsByMappingId(a.RequestedFor.GetValueOrDefault()),
RequestedFrom =
common.GetUserDetailsByMappingId(a.RequestedFrom.GetValueOrDefault()),
RequestedById = a.RequestedBy.GetValueOrDefault(),
RequestedForId = a.RequestedFor.GetValueOrDefault(),
RequestedFromId = a.RequestedFrom.GetValueOrDefault(),
CreatedOnDtm = a.CreatedOn.GetValueOrDefault(),
UpdatedOnDtm = a.UpdatedOn.GetValueOrDefault(),
CreatedOn =
a.CreatedOn != null
? a.CreatedOn.GetValueOrDefault().ToString("MMMM dd, yyyy")
: "",
UpdatedOn =
a.UpdatedOn != null
? a.UpdatedOn.GetValueOrDefault().ToString("MMMM dd, yyyy")
: "",
FeedbackStatus =
(FeedbackStatus)
Enum.Parse(typeof(FeedbackStatus),
a.FeedbackStatus.GetValueOrDefault().ToString()),
FeedbackType =
(FeedbackType)
Enum.Parse(typeof(FeedbackType), a.FeedbackType.Value.ToString(CultureInfo.InvariantCulture)),
GroupName = a.GroupName
},
JobTitle = a.JobTitle
};
outPut.Add(userPoeMapping);
//if (userPoeMapping.FeedbackDetails.GroupName != null)
//{
// userPoeMapping.Nooffbs = 1;
// break;
//}
}
}
//}
// Log("WCF-GetFeedbackGiven-OUT");
return(outPut);
}
}