public async Task <Select2Result> GetSalesPerson()
{
using (_unitOfWorkManager.Current.SetTenantId(_session.TenantId))
{
Select2Result sr = new Select2Result();
{
string SliderQuery = "SELECT * FROM [dbo].[View_SalesPersonSlider] where TenantId = " + _session.TenantId;
DataTable viewtable = new DataTable();
ConnectionAppService db = new ConnectionAppService();
SqlConnection con = new SqlConnection(db.ConnectionString());
con.Open();
SqlCommand cmd = new SqlCommand(SliderQuery, con);
using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
{
sda.Fill(viewtable);
}
con.Close();
var Account = (from DataRow dr in viewtable.Rows
select new datadto
{
Id = Convert.ToInt32(dr["Id"]),
Name = Convert.ToString(dr["Name"])
});
sr.select2data = Account.ToArray();
}
return(sr);
}
}
public async Task <Select2Result> GetTargetType()
{
Select2Result sr = new Select2Result();
var src = (from c in _TargetTypeRepository.GetAll() select c).ToArray();
if (src.Length > 0)
{
var srcarray = (from c in src select new datadto {
Id = c.Id, Name = c.Name
}).ToArray();
sr.select2data = srcarray;
}
return(sr);
}
public async Task <Select2Result> GetCountry()
{
Select2Result sr = new Select2Result();
var country = (from c in _countryRepository.GetAll() select c).ToArray();
if (country.Length > 0)
{
var countryarray = (from c in country select new datadto {
Id = c.Id, Name = c.CountryName
}).ToArray();
sr.select2data = countryarray;
}
return(sr);
}
public async Task <Select2Result> GetPayments()
{
Select2Result sr = new Select2Result();
var Payments = (from c in _PaymentRepository.GetAll() select c).ToArray();
if (Payments.Length > 0)
{
var PaymentsArray = (from c in Payments select new datadto {
Id = c.Id, Name = c.Name
}).ToArray();
sr.select2data = PaymentsArray;
}
return(sr);
}
public async Task <Select2Result> GetTenantType()
{
Select2Result sr = new Select2Result();
var src = (from c in _TenantTypeRepositary.GetAll() where c.IsDeleted == false select c).ToArray();
if (src.Length > 0)
{
var srcarray = (from c in src select new datadto {
Id = c.Id, Name = c.Name
}).ToArray();
sr.select2data = srcarray;
}
return(sr);
}
public async Task <Select2Result> GetTitle()
{
Select2Result sr = new Select2Result();
var title = (from c in _TitleRepository.GetAll() select c).ToArray();
if (title.Length > 0)
{
var titleDtos = (from c in title select new datadto {
Id = c.Id, Name = c.Name
}).ToArray();
sr.select2data = titleDtos;
}
return(sr);
}
public async Task <Select2Result> GetProductSubGroup()
{
using (_unitOfWorkManager.Current.SetTenantId(_session.TenantId))
{
Select2Result sr = new Select2Result();
var productSubGroup = (from c in _ProductSubGroupRepository.GetAll() select c).ToArray();
if (productSubGroup.Length > 0)
{
var productSubGrouparray = (from c in productSubGroup select new datadto {
Id = c.Id, Name = c.ProductSubGroupName
}).ToArray();
sr.select2data = productSubGrouparray;
}
return(sr);
}
}
public async Task <Select2Result> GetContactType()
{
using (_unitOfWorkManager.Current.SetTenantId(_session.TenantId))
{
Select2Result sr = new Select2Result();
var src = (from c in _CustomerTypeRepositary.GetAll() where c.Company == false select c).ToArray();
if (src.Length > 0)
{
var srcarray = (from c in src select new datadto {
Id = c.Id, Name = c.Title
}).ToArray();
sr.select2data = srcarray;
}
return(sr);
}
}
public async Task <Select2Result> GetCompanyContact(Select2ResultInput input)
{
using (_unitOfWorkManager.Current.SetTenantId(_session.TenantId))
{
Select2Result sr = new Select2Result();
var contact = (from c in _NewContactRepository.GetAll() where c.CompanyId == input.Id select c).ToArray();
if (contact.Length > 0)
{
var contactarray = (from c in contact select new datadto {
Id = c.Id, Name = c.Name
}).ToArray();
sr.select2data = contactarray;
}
return(sr);
}
}
public async Task <Select2Result> GetQuotationMilestone()
{
using (_unitOfWorkManager.Current.SetTenantId(_session.TenantId))
{
Select2Result sr = new Select2Result();
var milestone = (from c in _MilestoneRepository.GetAll() where c.IsQuotation == true select c).ToArray();
if (milestone.Length > 0)
{
var milestonearray = (from c in milestone select new datadto {
Id = c.Id, Name = c.Name
}).ToArray();
sr.select2data = milestonearray;
}
return(sr);
}
}
public async Task <Select2Result> GetPriceLevel()
{
using (_unitOfWorkManager.Current.SetTenantId(_session.TenantId))
{
Select2Result sr = new Select2Result();
var src = (from c in _PriceLevelRepository.GetAll() where c.IsDeleted == false select c).ToArray();
if (src.Length > 0)
{
var srcarray = (from c in src select new datadto {
Id = c.Id, Name = c.PriceLevelName
}).ToArray();
sr.select2data = srcarray;
}
return(sr);
}
}
public async Task <Select2Result> GetQuotationTitle()
{
using (_unitOfWorkManager.Current.SetTenantId(_session.TenantId))
{
Select2Result sr = new Select2Result();
var quotationtitle = (from c in _TitleOfQuotationRepository.GetAll() select c).ToArray();
if (quotationtitle.Length > 0)
{
var quotationtitleDtos = (from c in quotationtitle select new datadto {
Id = c.Id, Name = c.Code
}).ToArray();
sr.select2data = quotationtitleDtos;
}
return(sr);
}
}
public async Task <Select2Result> GetReason()
{
using (_unitOfWorkManager.Current.SetTenantId(_session.TenantId))
{
Select2Result sr = new Select2Result();
var reason = (from c in _ReasonRepository.GetAll() select c).ToArray();
if (reason.Length > 0)
{
var reasonDtos = (from c in reason select new datadto {
Id = c.Id, Name = c.Name
}).ToArray();
sr.select2data = reasonDtos;
}
return(sr);
}
}
public async Task <Select2Result> GetEnquiry(string Input)
{
using (_unitOfWorkManager.Current.SetTenantId(_session.TenantId))
{
Select2Result sr = new Select2Result();
var inquiry = (from c in _EnquiryRepository.GetAll().Where(t => t.Title.Contains(Input)) select c).ToArray();
if (inquiry.Length > 0)
{
var productDtos = (from c in inquiry select new datadto {
Id = c.Id, Name = c.Title
}).ToArray();
sr.select2data = productDtos;
}
return(sr);
}
}
public async Task <Select2Result> GetService()
{
using (_unitOfWorkManager.Current.SetTenantId(_session.TenantId))
{
Select2Result sr = new Select2Result();
var service = (from c in _ServiceRepository.GetAll() select c).ToArray();
if (service.Length > 0)
{
var serviceDtos = (from c in service select new datadto {
Id = c.Id, Name = c.ServiceCode
}).ToArray();
sr.select2data = serviceDtos;
}
return(sr);
}
}
public async Task <Select2Result> GetDelivery()
{
using (_unitOfWorkManager.Current.SetTenantId(_session.TenantId))
{
Select2Result sr = new Select2Result();
var delivery = (from c in _DeliveryRepository.GetAll() select c).ToArray();
if (delivery.Length > 0)
{
var deliveryDtos = (from c in delivery select new datadto {
Id = c.Id, Name = c.DeliveryName
}).ToArray();
sr.select2data = deliveryDtos;
}
return(sr);
}
}
public async Task <Select2Result> GetPacking()
{
using (_unitOfWorkManager.Current.SetTenantId(_session.TenantId))
{
Select2Result sr = new Select2Result();
var packing = (from c in _PackingRepository.GetAll() select c).ToArray();
if (packing.Length > 0)
{
var packingDtos = (from c in packing select new datadto {
Id = c.Id, Name = c.PackingName
}).ToArray();
sr.select2data = packingDtos;
}
return(sr);
}
}
public async Task <Select2Result> GetFreight()
{
using (_unitOfWorkManager.Current.SetTenantId(_session.TenantId))
{
Select2Result sr = new Select2Result();
var freight = (from c in _FreightRepository.GetAll() select c).ToArray();
if (freight.Length > 0)
{
var freightDtos = (from c in freight select new datadto {
Id = c.Id, Name = c.FreightName
}).ToArray();
sr.select2data = freightDtos;
}
return(sr);
}
}
public async Task <Select2Result> GetStatus()
{
using (_unitOfWorkManager.Current.SetTenantId(_session.TenantId))
{
Select2Result sr = new Select2Result();
var status = (from c in _QuotationStatusRepository.GetAll() select c).ToArray();
if (status.Length > 0)
{
var statusDtos = (from c in status select new datadto {
Id = c.Id, Name = c.QuotationStatusName
}).ToArray();
sr.select2data = statusDtos;
}
return(sr);
}
}
public async Task <Select2Result> GetDashboardSelect()
{
using (_unitOfWorkManager.Current.SetTenantId(_session.TenantId))
{
Select2Result sr = new Select2Result();
var selectArray = new List <datadto>();
if (PermissionChecker.IsGranted("Pages.Tenant.Dashboard"))
{
selectArray.Add(new datadto {
Id = 1, Name = "Default"
});
}
if (PermissionChecker.IsGranted("Pages.Tenant.Dashboard.SalesDashboard"))
{
selectArray.Add(new datadto {
Id = 2, Name = "Sales Dashboard"
});
}
if (PermissionChecker.IsGranted("Pages.Tenant.Leads.Leads"))
{
selectArray.Add(new datadto {
Id = 3, Name = "Lead Kanban"
});
}
if (PermissionChecker.IsGranted("Pages.Tenant.Leads.Leads.Gridview"))
{
selectArray.Add(new datadto {
Id = 4, Name = "Lead Grid"
});
}
if (PermissionChecker.IsGranted("Pages.Tenant.Quotation.Quotations"))
{
selectArray.Add(new datadto {
Id = 5, Name = "Quotation Grid"
});
}
sr.select2data = selectArray.ToArray();
return(sr);
}
}
public async Task <Select2Result> GetMileStoneMileStatus(Select2ResultInput input)
{
using (_unitOfWorkManager.Current.SetTenantId(_session.TenantId))
{
Select2Result sr = new Select2Result();
var milestonestatus = (from c in _MileStoneStatusDetailRepository.GetAll() where c.MileStoneId == input.Id select c);
if (milestonestatus.Count() > 0)
{
var milestonestatusarray = (from c in milestonestatus select new datadto {
Id = c.MileStoneStatusId
}).ToArray();
foreach (var lis in milestonestatusarray)
{
lis.Name = (from r in _MileStoneStatusRepository.GetAll() where r.Id == lis.Id select r.Name).FirstOrDefault();
}
sr.select2data = milestonestatusarray;
}
return(sr);
}
}
public async Task <Select2Result> GetSalesman()
{
using (_unitOfWorkManager.Current.SetTenantId(_session.TenantId))
{
Select2Result sr = new Select2Result();
{
var Account = (from c in UserManager.Users
join userrole in _userRoleRepository.GetAll() on c.Id equals userrole.UserId
join role in _RoleRepository.GetAll() on userrole.RoleId equals role.Id
where role.DisplayName == "Sales Executive"
select c).ToArray();
var Accounts = (from c in Account select new datadto {
Id = (int)c.Id, Name = c.UserName
}).ToArray();
sr.select2data = Accounts;
}
return(sr);
}
}
public async Task <Select2Result> GetCompetitor()
{
using (_unitOfWorkManager.Current.SetTenantId(_session.TenantId))
{
Select2Result sr = new Select2Result();
var company = (from c in _NewCompanyRepository.GetAll()
join r in _CustomerTypeRepositary.GetAll() on c.CustomerTypeId equals r.Id
where r.Title == "Competitor"
select c).ToArray();
if (company.Length > 0)
{
var srcarray = (from c in company select new datadto {
Id = c.Id, Name = c.Name
}).ToArray();
sr.select2data = srcarray;
}
return(sr);
}
}
