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 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 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; }
private void PattiInForm_Load(object sender, EventArgs e) { var serviceDao = new ServiceDao(); cmbServiceID.DataSource = serviceDao.GetAllPoojas(); ShowPattiIn(); }
private void PoojaAddressReport_Load(object sender, EventArgs e) { var serviceDao = new ServiceDao(); cmbServiceID.DataSource = serviceDao.GetAllPoojasExceptVIPPrasadam(); }
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(); }
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(); }
private void LoadPOCServiceGrid() { var serviceDao = new ServiceDao(); dataGridView1.AutoGenerateColumns = false; dataGridView1.DataSource = serviceDao.GetAllServices(); }
private void ShowServices() { var serviceDao = new ServiceDao(); dgvServices.AutoGenerateColumns = false; dgvServices.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 load_menu() { panel3.Hide(); panel4.Hide(); panel5.Hide(); panel6.Hide(); panel7.Hide(); panel8.Hide(); panel11.Hide(); cmbTimeId.Hide(); //var timingObj = new TimingDao(); //cmbTimeId.DataSource = timingObj.GetAllTimings(); var all_poojas = new ServiceDao(); var poojas_list = all_poojas.GetAllPoojasExceptMiscIncomeHundials(); int button_position = 0; if (cmbQty.Text == "") { cmbQty.Text = "1"; } else { cmbQty.Text = cmbQty.Text; } devoteeAdd(Convert.ToInt32(cmbQty.Text)); //dgvPrasadamStatus.Show(); foreach (var pooja_details in poojas_list) { //System.Windows.Forms.ToolTip pooja_tooptip = new System.Windows.Forms.ToolTip(); var pooja_tooptip = new ToolTip(); var pooja_button = new Button(); pooja_button.Text = pooja_details.Id.ToString(); pooja_button.Name = "btnPooja" + pooja_details.Id; pooja_tooptip.SetToolTip(pooja_button, pooja_details.Name); pooja_button.Width = 46; pooja_button.Height = 46; pooja_button.Font = new Font("Segoe UI", 15.5F, FontStyle.Bold); if (pooja_details.Type == 2 || pooja_details.Type == 11 || pooja_details.Type == 15) { pooja_button.Click += (sender, e) => { PrasadamReceipt(sender, e, pooja_details.Id, pooja_details.Name, pooja_details.Type, pooja_details.Cost); }; } else if (pooja_details.Type == 9) { pooja_button.Click += (sender, e) => { FreeAnnadanamReceipt(sender, e, pooja_details.Id, pooja_details.Name, pooja_details.Type, pooja_details.Cost); }; } else if (pooja_details.Type == 1 || pooja_details.Type == 3 || pooja_details.Type == 4 || pooja_details.Type == 10) { pooja_button.Click += (sender, e) => { DailyPoojaReceipt(sender, e, pooja_details.Id, pooja_details.Name, pooja_details.Type, pooja_details.Cost); }; } else if (pooja_details.Type == 5 || pooja_details.Type == 6 || pooja_details.Type == 7 || pooja_details.Type == 8 || pooja_details.Type == 12) { pooja_button.Click += (sender, e) => { SpecialPoojaReceipt(sender, e, pooja_details.Id, pooja_details.Name, pooja_details.Type, pooja_details.Cost); }; } pooja_button.Left = (button_position + 0) * (pooja_button.Width + 2); this.panel1.Controls.Add(pooja_button); button_position++; } }
private void ShowMiscIncomes() { var serviceDaoObj = new ServiceDao(); serviceId = serviceDaoObj.GetMiscIncomes(); var tokenDaoObj = new TokenDao(); dgvMiscIncomes.AutoGenerateColumns = false; dgvMiscIncomes.DataSource = tokenDaoObj.GetMiscIncomeDetails(); }