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; }
public int UpdatePrintSeries(Service ps) { using (var db = new eTempleDbDB()) { return db.Update(ps); } }
public int SavePrintSeries(Service ps) { using (var db = new eTempleDbDB()) { db.Save(ps); return ps.Id; } }
private void ShowService(Service serviceObj) { txtServiceId.Text = serviceObj.Id.ToString(); cmbType.SelectedValue = serviceObj.Type; txtName.Text = serviceObj.Name; txtCost.Text = serviceObj.Cost.ToString(); }