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();
}
