/// <summary>
/// 查询城市信息
/// </summary>
/// <returns></returns>
public List <Model.City> QueryCityInfoList()
{
ServiceDao service = new ServiceDao();
List <Model.City> tmp = service.QueryCityList();
return(tmp);
}
private void btnSubmit_Click(object sender, EventArgs e)
{
int serviceId = 0;
int.TryParse(txtServiceId.Text, out serviceId);
var serviceObj = new Service
{
Id = serviceId,
Name = txtName.Text,
Type = (cmbType.SelectedItem as ServiceType).Id,
Cost = Convert.ToDouble(txtCost.Text),
Status = Convert.ToSByte(chkStatus.Checked),
CreatedOn = DateTime.Now,
CreeatedBy = App.LoggedInEmployee.Id,
ModifiedOn = DateTime.Now,
ModifiedBy = App.LoggedInEmployee.Id,
AllowMultiple = Convert.ToSByte(chkAllowMultiple.Checked)
};
var serviceDao = new ServiceDao();
int scid = serviceDao.SavePrintSeries(serviceObj);
if (serviceId == 0)
{
var sdDao = new StockDetailsDao();
var sdObj = new StockDetail
{
ServiceId = scid,
Stock = 0
};
sdDao.SaveStockDetail(sdObj);
}
ShowServices();
}
private void ShowServices()
{
var serviceDao = new ServiceDao();
dgvServices.AutoGenerateColumns = false;
dgvServices.DataSource = serviceDao.GetAllServices();
}
/// <summary>
/// 分页查询城市所有楼盘名称信息
/// </summary>
/// <param name="CityID"></param>
/// <param name="AreaID"></param>
/// <param name="tName"></param>
/// <param name="page"></param>
/// <returns></returns>
public List <Model.DataProject> PagingQueryProjectList(int CityID, int AreaID,
string tName, int page)
{
ServiceDao service = new ServiceDao();
return(service.PagingQueryProjectList(CityID, AreaID, tName, page));
}
public ServiceBLL(IDbConnection connection)
{
_services = new ServiceDao(connection);
_serviceImages = new ServiceImageDao(connection);
_serviceTypes = new ServiceTypeDao(connection);
Mapper = new MapperConfiguration(cfg =>
{
cfg.CreateMap <Service, ServiceVM>().AfterMap((m, vm) =>
{
vm.Images = _serviceImages.GetServiceImageByServiceId(m.Id).Select(x => new ServiceImageVM
{
Id = x.Id,
Image = x.Image,
IsDeleted = x.IsDeleted,
ServiceId = x.ServiceId
}).ToList();
vm.ServiceType = _serviceTypes.FindById(m.TypeId)?.TypeName;
});
cfg.CreateMap <ServiceVM, Service>();
cfg.CreateMap <ServiceType, ServiceTypeVM>();
cfg.CreateMap <ServiceTypeVM, ServiceType>();
cfg.CreateMap <ServiceImage, ServiceImageVM>();
cfg.CreateMap <ServiceImageVM, ServiceImage>();
}).CreateMapper();
}
private void PattiInForm_Load(object sender, EventArgs e)
{
var serviceDao = new ServiceDao();
cmbServiceID.DataSource = serviceDao.GetAllPoojas();
ShowPattiIn();
}
public void LoadReport()
{
dgvReport.AutoGenerateColumns = false;
var data = new ServiceDao().GetDcrReport(dtpFromDate.Value, dtpToDate.Value);
DateTime fromDate = dtpFromDate.Value;
DateTime toDate = dtpToDate.Value;
var startDate = new DateTime(fromDate.Year, fromDate.Month, fromDate.Day);
var endDate = new DateTime(toDate.Year, toDate.Month, toDate.Day);
if (startDate == endDate)
{
endDate.AddDays(1);
}
//MessageBox.Show("select s.Id, s.Name, s.Cost, sum(t.Quantity) as SoldQuantity, s.Type, sum(t.TotalCost) as TotalCollection, max(t.ServiceDailyNumber) as EndingNumber, min(t.ServiceDailyNumber) as StartingNumber from Services s left outer join Tokens t on ( s.Id = t.ServiceId and t.CreatedOn between " + startDate + " and " + endDate + " and t.Status=1 and s.Type not in(16) ) group by s.Id, s.Name");
var totals = new Service();
totals.Name = "Totals";
//totals.SoldQuantity = data.Sum(x => x.SoldQuantity);
totals.TotalCollection = data.Sum(x => x.TotalCollection);
data.Add(totals);
dgvReport.DataSource = data;
}
public async Task <IActionResult> DeleteService(int id)
{
var data = new ServiceDao().Delete(id);
var value = await new ServiceDao().GeList();
return(RedirectToAction("Services", value));
}
/// <summary>
/// 分页查询城市数据
/// </summary>
/// <param name="page"></param>
/// <returns></returns>
public List <Model.City> PagingQueryCityList(int page)
{
ServiceDao service = new ServiceDao();
List <Model.City> tmp = service.PagingQueryCityList(page);
return(tmp);
}
void FormSelectService_Load(object sender, EventArgs e)
{
_list = new ServiceDao().GetList();
gc_Service.DataSource = null;
gc_Service.DataSource = _list;
gc_Service.RefreshDataSource();
}
private void LoadPOCServiceGrid()
{
var serviceDao = new ServiceDao();
dataGridView1.AutoGenerateColumns = false;
dataGridView1.DataSource = serviceDao.GetAllServices();
}
private void ShowHundials()
{
var serviceDaoObj = new ServiceDao();
serviceId = serviceDaoObj.GetHundials();
var tokenDaoObj = new TokenDao();
dgvHundial.AutoGenerateColumns = false;
dgvHundial.DataSource = tokenDaoObj.GetHundialsDetails();
}
private void ShowMiscIncomes()
{
var serviceDaoObj = new ServiceDao();
serviceId = serviceDaoObj.GetMiscIncomes();
var tokenDaoObj = new TokenDao();
dgvMiscIncomes.AutoGenerateColumns = false;
dgvMiscIncomes.DataSource = tokenDaoObj.GetMiscIncomeDetails();
}
public ServiceBusiness(MardisContext mardisContext) : base(mardisContext)
{
_serviceDao = new ServiceDao(mardisContext);
_serviceDetailDao = new ServiceDetailDao(mardisContext);
_questionDao = new QuestionDao(mardisContext);
_questionDetailDao = new QuestionDetailDao(mardisContext);
_typePollDao = new TypePollDao(mardisContext);
_sequenceBusiness = new SequenceBusiness(mardisContext);
_typeServiceDao = new TypeServiceDao(mardisContext);
_customerDao = new CustomerDao(mardisContext);
}
private void GenerateBatchForm_Load(object sender, EventArgs e)
{
cdtval = DateTime.Now.ToString("yyyy-MM-dd");
var servceDao = new ServiceDao();
cmbServiceName.DataSource = servceDao.GetAllPoojasExceptPrasadam();
var batchDaoObject = new BatchDao();
dgvBatchTokens.AutoGenerateColumns = false;
dgvBatchTokens.DataSource = batchDaoObject.GetAllBatches();
}
public CampaignBusiness(MardisContext mardisContext) : base(mardisContext)
{
_campaignDao = new CampaignDao(mardisContext);
_sequenceBusiness = new SequenceBusiness(mardisContext);
_customerDao = new CustomerDao(mardisContext);
_taskCampaignDao = new TaskCampaignDao(mardisContext);
_statusTaskDao = new StatusTaskDao(mardisContext);
_campaignServicesDao = new CampaignServicesDao(mardisContext);
_serviceDao = new ServiceDao(mardisContext);
_branchDao = new BranchDao(mardisContext);
_userCanpaignDao = new UserCanpaignDao(mardisContext);
}
private void VIPPrasadamForm_Load(object sender, EventArgs e)
{
var empDao = new EmployeeDao();
cmbReferenceBy.DataSource = empDao.GetAllEmployees();
cmbReferenceBy.DisplayMember = "Name";
cmbReferenceBy.ValueMember = "Id";
var serviceDao = new ServiceDao();
cmbServiceID.DataSource = serviceDao.GetAllVIPPrasadam();
ShowVIPPrasadam();
}
public ServiceBusiness(MardisContext mardisContext, RedisCache distributedCache) : base(mardisContext)
{
_serviceDao = new ServiceDao(mardisContext);
_serviceDetailDao = new ServiceDetailDao(mardisContext);
_questionDao = new QuestionDao(mardisContext);
_questionDetailDao = new QuestionDetailDao(mardisContext);
_typePollDao = new TypePollDao(mardisContext);
_sequenceBusiness = new SequenceBusiness(mardisContext);
_typeServiceDao = new TypeServiceDao(mardisContext);
_customerDao = new CustomerDao(mardisContext);
_redisCache = distributedCache;
}
private void btnViewReport_Click(object sender, EventArgs e)
{
dgvOperatorReport.AutoGenerateColumns = false;
int cUser = (cmbUsername.SelectedItem as Employee).Id;
var data = new ServiceDao().GetOperatorReport(dtpDate.Value, cUser);
var totals = new Service();
totals.Name = "Total";
totals.SoldQuantity = data.Sum(x => x.SoldQuantity);
totals.TotalCollection = data.Sum(x => x.TotalCollection);
data.Add(totals);
dgvOperatorReport.DataSource = data;
}
public IActionResult GetServiceByCategoryId(int id)
{
try
{
var data = new ServiceDao(_unitOfWork, _mapper).GetServiceByCategoryId(id);
return(Ok(data));
}
catch (Exception e)
{
Console.WriteLine(e);
return(NotFound());
}
}
public ActionResult <List <ServiceMv> > GetCountService(int idCategoryService)
{
try
{
var data = new ServiceDao(_unitOfWork, _mapper).GetListServiceByIdCate(idCategoryService);
if (data == null)
{
return(NotFound());
}
return(data);
}
catch (Exception e)
{
Console.WriteLine(e);
return(NotFound());
}
}
public ActionResult <ServiceMv> Get(int id)
{
try
{
var data = new ServiceDao(_unitOfWork, _mapper).GetById(id);
if (data == null)
{
return(NotFound());
}
return(data);
}
catch (Exception e)
{
Console.WriteLine(e);
return(NotFound());
}
}
private void PoojaReport_Load(object sender, EventArgs e)
{
var serviceDao = new ServiceDao();
cmbServiceID.DataSource = serviceDao.GetAllPoojasExceptVIPPrasadam();
dgvServiceReport.AutoGenerateColumns = false;
if (App.LoggedInEmployee.Designation == 3)
{
dgvServiceReport.Columns[Constants.GridColumnIndex_Tokens_EditAction].Visible = true;
dgvServiceReport.Columns[Constants.GridColumnIndex_Tokens_Action].Visible = true;
}
else
{
dgvServiceReport.Columns[Constants.GridColumnIndex_Tokens_EditAction].Visible = false;
dgvServiceReport.Columns[Constants.GridColumnIndex_Tokens_Action].Visible = false;
}
}
public ActionResult <IEnumerable <ServiceMv> > Get()
{
try
{
var data = new ServiceDao(_unitOfWork, _mapper).GetAll();
if (data == null)
{
return(NotFound());
}
return(Ok(data));
}
catch (Exception e)
{
Console.WriteLine(e);
return(NotFound());
}
}
// GET: Services
public ActionResult Index(int page = 1, int pageSize = 5)
{
int totalRecord = 0;
var model = new ServiceDao().ListServicesPaging(ref totalRecord, page, pageSize);
ViewBag.Total = totalRecord;
ViewBag.Page = page;
int maxPage = 5;
int totalPage = 0;
totalPage = (int)Math.Ceiling((double)(totalRecord / pageSize));
ViewBag.TotalPage = totalPage;
ViewBag.MaxPage = maxPage;
ViewBag.First = 1;
ViewBag.Last = totalPage;
ViewBag.Next = page + 1;
ViewBag.Prev = page - 1;
return(View(model));
}
/// <summary>
/// 查询结构信息
/// </summary>
/// <returns></returns>
public List <Model.SysCode> QueryStructureInfoMap()
{
ServiceDao service = new ServiceDao();
return(service.QuerySysCodeList(" and ID = 2005 "));
}
/// <summary>
/// 查询房屋类型
/// </summary>
/// <returns></returns>
public List <Model.SysCode> QueryHouseTypeInfoMap()
{
ServiceDao service = new ServiceDao();
return(service.QuerySysCodeList(" and ID = 4001 "));
}
/// <summary>
/// 查询建筑类型
/// </summary>
/// <returns></returns>
public List <Model.SysCode> QueryBuildingTypeInfoMap()
{
ServiceDao service = new ServiceDao();
return(service.QuerySysCodeList(" and ID = 2003 "));
}
/// <summary>
/// 查询朝向信息
/// </summary>
/// <returns></returns>
public List <Model.SysCode> QueryFrontInfoMap()
{
ServiceDao service = new ServiceDao();
return(service.QuerySysCodeList(" and ID = 2004 "));
}
/// <summary>
/// 查询用途信息
/// </summary>
/// <returns></returns>
public List <Model.SysCode> QueryPurposeInfoMap()
{
ServiceDao service = new ServiceDao();
return(service.QuerySysCodeList(" and ID = 1002 "));
}
