// GET: SuggetionList
public ActionResult Index()
{
DataTable dtExistingRecord = new DataTable();
DataTable dtNewRecord = new DataTable();
UserDetails objUserDetails = new UserDetails();
ContactSuggestions objContactSuggestion = new ContactSuggestions();
dtExistingRecord = objUserDetails.GetBulkNotificationData().Tables[0];
dtNewRecord = objUserDetails.GetBulkNotificationData().Tables[1];
IList <ResendNotification> itemsResendNotification = dtExistingRecord.AsEnumerable().Select(row =>
new ResendNotification
{
UID = row.Field <int>("UID"),
DeviceUID = row.Field <int>("DeviceUID"),
Text = row.Field <string>("Text"),
NotificationType = row.Field <string>("NotificationType"),
NotificationTitle = row.Field <string>("NotificationTitle"),
Location = row.Field <int?>("LocationId") == null? "": getlocationName(row.Field <int>("LocationId")),
Sent = row.Field <bool>("Sent"),
Target = row.Field <int?>("Target"),
ScheduleTIme = row.Field <DateTime?>("ScheduleTIme"),
ConfirmTime = row.Field <DateTime?>("ConfirmTime"),
SubCategory = row.Field <int?>("SubCategoryId"),
Microcategory = row.Field <int?>("MicrocategoryId"),
TimeSent = row.Field <DateTime?>("TimeSent"),
IsDone = row.Field <bool?>("IsDone"),
IsDismissed = row.Field <bool?>("IsDismissed"),
RequestID = row.Field <int?>("RequestID"),
RedirectTo = row.Field <string>("RedirectTo"),
SentNotificationBy = row.Field <int?>("SentNotificationBy"),
ContactId = row.Field <int>("ContactId")
}).ToList();
IList <SentNotification> itemsSentNotification = dtExistingRecord.AsEnumerable().Select(row =>
new SentNotification
{
ContactId = row.Field <int>("ContactId"),
Name = row.Field <string>("ContactName"),
Number = row.Field <string>("ContactNumber"),
SourceId = row.Field <int>("SourceId"),
Source = Convert.ToString(GetSourceById(row.Field <int>("SourceId")).Rows[0]["Name"]),
SourceNo = Convert.ToString(GetSourceById(row.Field <int>("SourceId")).Rows[0]["Mobile"]),
HomeLocation = row.Field <string>("LocationId1"),
WorkLocation = row.Field <string>("LocationId2"),
CollegeSchoolLocation = row.Field <string>("LocationId3"),
ProfeDetails = row.Field <string>("Comments"),
AllowedRequestSuggestion = row.Field <bool>("AllowProvideSuggestion")
}).ToList();
objContactSuggestion.ResendNotificationList = itemsResendNotification;
objContactSuggestion.SentNotificationList = itemsSentNotification;
//FillCategoryDrodown();
//FillSubCate(Category);
//FillMicroCate(SubCategory);
//City();
//BindSource();
//FillContact(Source);
//PlatformBind();
//GetAreaDropdown(CityName,);
return(View(objContactSuggestion));
}
