public async Task <IActionResult> GetMasters(Syncfusion.JavaScript.DataManager dataManagerObj, string value)
{
dynamic DataSource = new System.Dynamic.ExpandoObject();
Syncfusion.JavaScript.DataSources.DataOperations operation = new Syncfusion.JavaScript.DataSources.DataOperations();
switch (value)
{
case "Country":
DataSource = await _masterService.GetAllCountries();
return(Json(operation.Execute(DataSource, dataManagerObj)));
case "Modules":
DataSource = await _masterService.GetAllMasterDetailsbyIds(new List <int>() { 12, 10 });
return(Json(operation.Execute(DataSource, dataManagerObj)));
case "SecurityQuestion":
DataSource = await _masterService.GetAllMasterDetailsbyIds(new List <int>() { ModuleConstantHelper.SecurityModule });
return(Json(operation.Execute(DataSource, dataManagerObj)));
default:
return(null);
}
}
public ActionResult DataEmpleado(Syncfusion.JavaScript.DataManager dm)
{
DataResultEmpleado result = new DataResultEmpleado();
Syncfusion.JavaScript.DataSources.DataOperations dataOperations = new Syncfusion.JavaScript.DataSources.DataOperations();
result.result = context.Empleados.Include(e => e.Departamento).Include(e => e.Sexo).Include(e => e.EstadoCivil).ToList();
if (dm.Sorted != null && dm.Sorted.Count > 0) //Sorting
{
result.result = dataOperations.PerformSorting(result.result, dm.Sorted);
}
if (dm.Where != null && dm.Where.Count > 0) //Filtering
{
result.result = dataOperations.PerformWhereFilter(result.result, dm.Where, dm.Where[0].Operator);
if (!dm.RequiresCounts)
{
return(Json(result.result));
}
}
result.count = context.Empleados.Include(e => e.Departamento).Include(e => e.Sexo).Include(e => e.EstadoCivil).AsQueryable().Count();
if (dm.Skip != 0)
{
result.result = dataOperations.PerformSkip(result.result, dm.Skip);
}
if (dm.Take != 0)
{
result.result = dataOperations.PerformTake(result.result, dm.Take);
}
return(Json(new { result = result.result, count = result.count }, JsonRequestBehavior.AllowGet));
}
public ActionResult DataSource(Syncfusion.JavaScript.DataManager dm)
{
DataResult result = new DataResult();
Syncfusion.JavaScript.DataSources.DataOperations dataOperations = new Syncfusion.JavaScript.DataSources.DataOperations();
result.result = context.Albums.Include(a => a.Artista).Include(a => a.Genero).ToList();
if (dm.Sorted != null && dm.Sorted.Count > 0) //Sorting
{
result.result = dataOperations.PerformSorting(result.result, dm.Sorted);
}
if (dm.Where != null && dm.Where.Count > 0) //Filtering
{
result.result = dataOperations.PerformWhereFilter(result.result, dm.Where, dm.Where[0].Operator);
if (!dm.RequiresCounts)
{
return(Json(result.result));
}
}
result.count = context.Albums.Include(a => a.Artista).Include(a => a.Genero).AsQueryable().Count();
if (dm.Skip != 0)
{
result.result = dataOperations.PerformSkip(result.result, dm.Skip);
}
if (dm.Take != 0)
{
result.result = dataOperations.PerformTake(result.result, dm.Take);
}
if (dm.Search != null)
{
result.result = dataOperations.PerformSearching(result.result, dm.Search);
}
return(Json(new { result = result.result, count = result.count }, JsonRequestBehavior.AllowGet));
}
public ActionResult GetBuses(Syncfusion.JavaScript.DataManager dm /*, string compCode*/)
{
db.Configuration.ProxyCreationEnabled = false;
IEnumerable data;
int count = 0;
if (User.IsInRole("Super Administrator"))
{
data = db.A_Buses.ToList();
count = db.A_Buses.ToList().Count();
}
else
{
var userid = User.Identity.GetUserId();
var logginUser = db.View_Users.FirstOrDefault(o => o.UserId == userid);
data = db.A_Buses.Where(o => o.Company == logginUser.Company_Id).ToList();
count = db.A_Buses.Where(o => o.Company == logginUser.Company_Id).ToList().Count();
}
DataOperations operation = new DataOperations();
//Performing filtering operation
if (dm.Where != null)
{
data = operation.PerformWhereFilter(data, dm.Where, "and");
IEnumerable <object> filtered = (IEnumerable <object>)data;
count = filtered.Count();
}
//Performing search operation
if (dm.Search != null)
{
data = operation.PerformSearching(data, dm.Search);
IEnumerable <object> searched = (IEnumerable <object>)data;
count = searched.Count();
}
//Performing sorting operation
if (dm.Sorted != null)
{
data = operation.PerformSorting(data, dm.Sorted);
}
//Performing paging operations
if (dm.Skip != 0)
{
data = operation.PerformSkip(data, dm.Skip);
}
if (dm.Take != 0)
{
data = operation.PerformTake(data, dm.Take);
}
return(Json(new { result = data, count = count }, JsonRequestBehavior.AllowGet));
}
public ActionResult BatchDataSource(Syncfusion.JavaScript.DataManager dm)
{
IEnumerable DataSource = OrderRepository.GetComplexRecords().ToList();
BatchDataResult result = new BatchDataResult();
DataOperations obj = new DataOperations();
if (dm.Skip != 0)
{
DataSource = obj.PerformSkip(DataSource, dm.Skip);
}
if (dm.Take != 0)
{
DataSource = obj.PerformTake(DataSource, dm.Take);
}
result.result = DataSource;
result.count = OrderRepository.GetComplexRecords().Count();
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult GetBookings(Syncfusion.JavaScript.DataManager dm /*, string compCode*/)
{
db.Configuration.ProxyCreationEnabled = false;
IEnumerable data = db.View_Stage_Booking_Final.OrderByDescending(O => O.Boarding_Time).ToList();
int count = db.View_Stage_Booking_Final.ToList().Count();
DataOperations operation = new DataOperations();
//Performing filtering operation
if (dm.Where != null)
{
data = operation.PerformWhereFilter(data, dm.Where, "and");
IEnumerable <object> filtered = (IEnumerable <object>)data;
count = filtered.Count();
}
//Performing search operation
if (dm.Search != null)
{
data = operation.PerformSearching(data, dm.Search);
IEnumerable <object> searched = (IEnumerable <object>)data;
count = searched.Count();
}
//Performing sorting operation
if (dm.Sorted != null)
{
data = operation.PerformSorting(data, dm.Sorted);
}
//Performing paging operations
if (dm.Skip != 0)
{
data = operation.PerformSkip(data, dm.Skip);
}
if (dm.Take != 0)
{
data = operation.PerformTake(data, dm.Take);
}
return(Json(new { result = data, count = count }, JsonRequestBehavior.AllowGet));
}
public ActionResult GetNOK(Syncfusion.JavaScript.DataManager dm, int?EmployeeID)
{
db.Configuration.ProxyCreationEnabled = false;
IEnumerable data = db.Employee_NOK.Where(o => o.Employee_ID == EmployeeID).ToList();
int count = db.Employee_NOK.Where(o => o.Employee_ID == EmployeeID).ToList().Count();
DataOperations operation = new DataOperations();
//Performing filtering operation
if (dm.Where != null)
{
data = operation.PerformWhereFilter(data, dm.Where, "and");
IEnumerable <object> filtered = (IEnumerable <object>)data;
count = filtered.Count();
}
//Performing search operation
if (dm.Search != null)
{
data = operation.PerformSearching(data, dm.Search);
IEnumerable <object> searched = (IEnumerable <object>)data;
count = searched.Count();
}
//Performing sorting operation
if (dm.Sorted != null)
{
data = operation.PerformSorting(data, dm.Sorted);
}
//Performing paging operations
if (dm.Skip != 0)
{
data = operation.PerformSkip(data, dm.Skip);
}
if (dm.Take != 0)
{
data = operation.PerformTake(data, dm.Take);
}
return(Json(new { result = data, count = count }, JsonRequestBehavior.AllowGet));
}
public ActionResult DataSource(Syncfusion.JavaScript.DataManager dataManager)
{
List <Invoice> data = GetInvoiceData();
return(Json(data));
}
public ActionResult GetEmployes(Syncfusion.JavaScript.DataManager dm /*, string compCode*/)
{
db.Configuration.ProxyCreationEnabled = false;
IEnumerable data;
int count = 0;
if (User.IsInRole("Super Administrator"))
{
data = db.A_Employees.Select(o => new { o.Company, o.CreatedBy, o.CreationDate, o.Date_Of_Birth, o.EditedBy, o.EditionDate, o.Email, o.Employee_ID, o.Gender, o.Name, o.Nationality, o.NIN_No, o.Phone, o.Telephone, o.Title, o.User_Id }).ToList();
count = db.A_Employees.ToList().Count();
}
else
{
var userid = User.Identity.GetUserId();
var logginUser = db.View_Users.FirstOrDefault(o => o.UserId == userid);
data = db.A_Employees.Where(o => o.Company == logginUser.Company_Id).Select(o => new { o.Company, o.CreatedBy, o.CreationDate, o.Date_Of_Birth, o.EditedBy, o.EditionDate, o.Email, o.Employee_ID, o.Gender, o.Name, o.Nationality, o.NIN_No, o.Phone, o.Telephone, o.Title, o.User_Id }).ToList();
count = db.A_Employees.Where(o => o.Company == logginUser.Company_Id).ToList().Count();
}
//var muserrole = User.IsInRole("HSIPClient");
//if (muserrole)
//{
// int? facility_id = new UserManagement().getCurrentuserFacility();
// List<fo_complaint> m = new List<fo_complaint>();
// var _data = db.View_fo_complaint_AffectedSites.Where(e => e.FacilityCode == facility_id.ToString() && e.FinalSubmission != 1 && e.DeletedRecord != true && e.e_reg_complaint_status != 3).OrderByDescending(o => o.e_reg_date_recieved).ToList();
// count = db.View_fo_complaint_AffectedSites.Where(e => e.FacilityCode == facility_id.ToString() && e.FinalSubmission != 1 && e.DeletedRecord != true && e.e_reg_complaint_status != 3).ToList().Count();
// foreach (var n in _data)
// {
// fo_complaint x = new fo_complaint();
// x.AffectedSites = n.AffectedSites;
// x.Brief_Feedback_Desc = n.Brief_Feedback_Desc;
// x.Communicated_By_Lev1 = n.Communicated_By_Lev1;
// x.Communicated_By_Lev1Date = n.Communicated_By_Lev1Date;
// x.Communicated_By_Lev1Title = n.Communicated_By_Lev1Title;
// x.Communicated_By_Lev2 = n.Communicated_By_Lev2;
// x.Communicated_By_Lev2Date = n.Communicated_By_Lev2Date;
// x.Communicated_By_Lev2Email = n.Communicated_By_Lev2Email;
// x.Communicated_By_Lev2Title = n.Communicated_By_Lev2Title;
// x.ComplainantDistrict = n.ComplainantDistrict;
// x.ComplainantEmail = n.ComplainantEmail;
// x.ComplainantFacilityCode = n.ComplainantFacilityCode;
// x.ComplainantMobile = n.ComplainantMobile;
// x.ComplainantName = n.ComplainantName;
// x.ComplainantPhone = n.ComplainantPhone;
// x.ComplainantTitle = n.ComplainantTitle;
// x.DeletedRecord = n.DeletedRecord;
// x.Email_letter_attached = n.Email_letter_attached;
// x.e_reg_affected_sites = n.e_reg_affected_sites;
// x.e_reg_communication_mode = n.e_reg_communication_mode;
// x.e_reg_complaint_accuteness = n.e_reg_complaint_accuteness;
// x.e_reg_complaint_category = n.e_reg_complaint_category;
// x.e_reg_complaint_code = n.e_reg_complaint_code;
// x.e_reg_complaint_details = n.e_reg_complaint_details;
// x.e_reg_complaint_No = n.e_reg_complaint_No;
// x.e_reg_complaint_status = n.e_reg_complaint_status;
// x.e_reg_complaint_Title = n.e_reg_complaint_Title;
// x.e_reg_contact_person_id = n.e_reg_contact_person_id;
// x.e_reg_date_complaint = n.e_reg_date_complaint;
// x.e_reg_date_recieved = n.e_reg_date_recieved;
// x.e_reg_date_resolved = n.e_reg_date_resolved;
// x.e_reg_expected_date_resolution = n.e_reg_expected_date_resolution;
// x.e_reg_MAUL_Staff = n.e_reg_MAUL_Staff;
// x.e_reg_product_category = n.e_reg_product_category;
// x.Feedback = n.Feedback;
// x.Feedback_Communicated = n.Feedback_Communicated;
// x.Feedback_Date = n.Feedback_Date;
// x.IP = n.IP;
// x.is_quality_issue = n.is_quality_issue;
// x.No_Feedback_Reason = n.No_Feedback_Reason;
// x.Prod_Samples_Provided = n.Prod_Samples_Provided;
// x.Sup_Doc_Evidence_Rec = n.Sup_Doc_Evidence_Rec;
// x.FinalSubmission = n.FinalSubmission;
// x.ComplainantCategory = n.ComplainantCategory;
// m.Add(x);
// }
// data = m;
//}
//else if (User.IsInRole("SCTO"))
//{
// var Username = User.Identity.Name;
// var person = db.AspNetUsers.FirstOrDefault(o => o.UserName == Username);
// var contact = db.fo_contact_person.FirstOrDefault(o => o.cp_name.Trim() == person.Name.Trim());
// var RFSOfacilities = new UserManagement().getUserFacilityList();
// var _data = db.View_fo_complaint_AffectedSites.Where(e => (RFSOfacilities.Any(p => e.FacilityCode.Trim() == p.ToString().Trim())) && e.FinalSubmission == 1 && e.DeletedRecord != true && e.e_reg_complaint_status == 1 && (e.Level1_Assignment.Contains(contact.cp_code.ToString()) || e.Level2_Assignment.Contains(contact.cp_code.ToString()))).OrderByDescending(o => o.e_reg_date_recieved).ToList();
// count = db.View_fo_complaint_AffectedSites.Where(e => (RFSOfacilities.Any(p => e.FacilityCode.Trim() == p.ToString().Trim())) && e.FinalSubmission == 1 && e.DeletedRecord != true && e.e_reg_complaint_status == 1 && (e.Level1_Assignment.Contains(contact.cp_code.ToString()) || e.Level2_Assignment.Contains(contact.cp_code.ToString()))).ToList().Count();
// List<fo_complaint> m = new List<fo_complaint>();
// foreach (var n in _data)
// {
// fo_complaint x = new fo_complaint();
// x.AffectedSites = n.AffectedSites;
// x.Brief_Feedback_Desc = n.Brief_Feedback_Desc;
// x.Communicated_By_Lev1 = n.Communicated_By_Lev1;
// x.Communicated_By_Lev1Date = n.Communicated_By_Lev1Date;
// x.Communicated_By_Lev1Title = n.Communicated_By_Lev1Title;
// x.Communicated_By_Lev2 = n.Communicated_By_Lev2;
// x.Communicated_By_Lev2Date = n.Communicated_By_Lev2Date;
// x.Communicated_By_Lev2Email = n.Communicated_By_Lev2Email;
// x.Communicated_By_Lev2Title = n.Communicated_By_Lev2Title;
// x.ComplainantDistrict = n.ComplainantDistrict;
// x.ComplainantEmail = n.ComplainantEmail;
// x.ComplainantFacilityCode = n.ComplainantFacilityCode;
// x.ComplainantMobile = n.ComplainantMobile;
// x.ComplainantName = n.ComplainantName;
// x.ComplainantPhone = n.ComplainantPhone;
// x.ComplainantTitle = n.ComplainantTitle;
// x.DeletedRecord = n.DeletedRecord;
// x.Email_letter_attached = n.Email_letter_attached;
// x.e_reg_affected_sites = n.e_reg_affected_sites;
// x.e_reg_communication_mode = n.e_reg_communication_mode;
// x.e_reg_complaint_accuteness = n.e_reg_complaint_accuteness;
// x.e_reg_complaint_category = n.e_reg_complaint_category;
// x.e_reg_complaint_code = n.e_reg_complaint_code;
// x.e_reg_complaint_details = n.e_reg_complaint_details;
// x.e_reg_complaint_No = n.e_reg_complaint_No;
// x.e_reg_complaint_status = n.e_reg_complaint_status;
// x.e_reg_complaint_Title = n.e_reg_complaint_Title;
// x.e_reg_contact_person_id = n.e_reg_contact_person_id;
// x.e_reg_date_complaint = n.e_reg_date_complaint;
// x.e_reg_date_recieved = n.e_reg_date_recieved;
// x.e_reg_date_resolved = n.e_reg_date_resolved;
// x.e_reg_expected_date_resolution = n.e_reg_expected_date_resolution;
// x.e_reg_MAUL_Staff = n.e_reg_MAUL_Staff;
// x.e_reg_product_category = n.e_reg_product_category;
// x.Feedback = n.Feedback;
// x.Feedback_Communicated = n.Feedback_Communicated;
// x.Feedback_Date = n.Feedback_Date;
// x.IP = n.IP;
// x.is_quality_issue = n.is_quality_issue;
// x.No_Feedback_Reason = n.No_Feedback_Reason;
// x.Prod_Samples_Provided = n.Prod_Samples_Provided;
// x.Sup_Doc_Evidence_Rec = n.Sup_Doc_Evidence_Rec;
// x.FinalSubmission = n.FinalSubmission;
// x.ComplainantCategory = n.ComplainantCategory;
// m.Add(x);
// }
// data = m;
//}
//else if (User.IsInRole("ComplaintHandling") || User.IsInRole("MonitoringAndEvaluationOfficer"))
//{
// var Username = User.Identity.Name;
// var person = db.AspNetUsers.FirstOrDefault(o => o.UserName == Username);
// var contact = db.fo_contact_person.FirstOrDefault(o => o.cp_name.Trim() == person.Name.Trim());
// data = db.fo_complaint.Where(o => o.FinalSubmission == 1 && o.DeletedRecord != true && o.e_reg_complaint_status == 1 && (o.Level1_Assignment.Contains(contact.cp_code.ToString()) || o.Level2_Assignment.Contains(contact.cp_code.ToString()))).OrderByDescending(o => o.e_reg_date_recieved).ToList();
// count = db.fo_complaint.Where(o => o.FinalSubmission == 1 && o.DeletedRecord != true && o.e_reg_complaint_status == 1 && (o.Level1_Assignment.Contains(contact.cp_code.ToString()) || o.Level2_Assignment.Contains(contact.cp_code.ToString()))).ToList().Count();
//}
//else
//{
// data = db.fo_complaint.Where(o => o.FinalSubmission == 1 && o.DeletedRecord != true && o.e_reg_complaint_status != 3).OrderByDescending(o => o.e_reg_date_recieved).ToList();
// count = db.fo_complaint.Where(o => o.FinalSubmission == 1 && o.DeletedRecord != true && o.e_reg_complaint_status != 3).ToList().Count();
//}
DataOperations operation = new DataOperations();
//Performing filtering operation
if (dm.Where != null)
{
data = operation.PerformWhereFilter(data, dm.Where, "and");
IEnumerable <object> filtered = (IEnumerable <object>)data;
count = filtered.Count();
}
//Performing search operation
if (dm.Search != null)
{
data = operation.PerformSearching(data, dm.Search);
IEnumerable <object> searched = (IEnumerable <object>)data;
count = searched.Count();
}
//Performing sorting operation
if (dm.Sorted != null)
{
data = operation.PerformSorting(data, dm.Sorted);
}
//Performing paging operations
if (dm.Skip != 0)
{
data = operation.PerformSkip(data, dm.Skip);
}
if (dm.Take != 0)
{
data = operation.PerformTake(data, dm.Take);
}
return(Json(new { result = data, count = count }, JsonRequestBehavior.AllowGet));
}
