private void ShowVIPPrasadam()
{
var VIPDao = new VIPPrasadamDao();
String dt = String.Format("{0:yyyy-MM-dd}", Convert.ToDateTime(currentDateTimePicker.Value));
dgvVIPPrasadam.AutoGenerateColumns = false;
dgvVIPPrasadam.DataSource = VIPDao.GetAllVIPPrasadamDetails(dt);
}
private void btnSubmit_Click(object sender, EventArgs e)
{
var sdDao = new StockDetailsDao();
int serviceId = (cmbServiceID.SelectedItem as Service).Id;
string serviceName = (cmbServiceID.SelectedItem as Service).Name;
int stockVal = Convert.ToInt32(numQty.Text) - ActualStock;
//stockVal = -(stockVal);
sdDao.UpdateStockDetail(stockVal, serviceId);
int poId = 0;
int.TryParse(txtId.Text, out poId);
int cUser = (cmbReferenceBy.SelectedItem as Employee).Id;
var poObj = new VIPPrasadam
{
Id = poId,
ServiceId = (cmbServiceID.SelectedItem as Service).Id,
VIPName = txtVIPName.Text,
Phone = txtPhone.Text,
ReferenceBy = cUser,
Qty = Convert.ToInt32(numQty.Text),
VisitedDate = Convert.ToDateTime(dtVisitedDate.Value),
IssuedBy = App.LoggedInEmployee.Id
};
var poDao = new VIPPrasadamDao();
int tokenId = poDao.SaveVIPPrasadam(poObj);
var savedTokens = new List<VIPPrasadam>();
poObj = poDao.getTokenById(tokenId);
savedTokens.Add(poObj);
ShowVIPPrasadam();
PrintTokens2(savedTokens);
}
private void button1_Click(object sender, EventArgs e)
{
var VIPDaoObj = new VIPPrasadamDao();
var abc = VIPDaoObj.GetDaycount(this.dtpFromDate.Value);
var dt1 = String.Format("{0:dd-MM-yyyy}", this.dtpFromDate.Value);
int i = 0;
String VIPContent = "అతిధి సత్కారం కొరకు " + dt1 + " తేదిన వినియోగించిన సరుకు వివరములు : ";
while (i < abc.Count)
{
var xyz = abc[i] as VIPPrasadam;
VIPContent = VIPContent + xyz.ServiceName + " " + xyz.Qty;
i = i + 1;
if (i < abc.Count)
{
VIPContent = VIPContent + ", ";
}
}
if (abc.Count == 0)
{
VIPContent = "";
}
DateTime cdatetime = DateTime.Now;
var cdt = String.Format("{0:dd-MM-yyyy h:mm tt}", cdatetime);
var DCRGenDT = "Generated on : " + cdt;
var reportViewer = new ReportViewer();
reportViewer.HeaderWidthPercent = 100;
reportViewer.ContentWidthPercent = 100;
reportViewer.RowsPerPage = 30;
var duration = dtpToDate.Value - dtpFromDate.Value;
if (duration.Days > 0)
{
reportViewer.HeaderContent = string.Format("<center><h2>Daily Collection Report from {0:dd/MM/yyyy} to {1:dd/MM/yyyy}</h2></center>", this.dtpFromDate.Value, this.dtpToDate.Value);
}
else
{
reportViewer.HeaderContent = string.Format("<center><h2>Daily Collection Report for the Date of {0:dd/MM/yyyy}</h2></center>", this.dtpFromDate.Value);
}
if (VIPContent != "")
{
reportViewer.FooterContent = string.Format("<span><br />{0}</span>", VIPContent);
}
var tokenDAO = new TokenDao();
Double CashDt = tokenDAO.GEtTotalCostByTransactionType(dtpFromDate.Value, dtpToDate.Value, "Cash");
Double CardDt = tokenDAO.GEtTotalCostByTransactionType(dtpFromDate.Value, dtpToDate.Value, "Credit/Debit Card");
Double DDDt = tokenDAO.GEtTotalCostByTransactionType(dtpFromDate.Value, dtpToDate.Value, "DD");
Double ChequeDt = tokenDAO.GEtTotalCostByTransactionType(dtpFromDate.Value, dtpToDate.Value, "Cheque");
var DCRCashDT = "Amount from Cash Transactions : Rs." + CashDt + "/-";
var DCRCardDT = "Amount from Card Transactions : Rs." + CardDt + "/-";
var DCRDDDT = "Amount from DD Transactions : Rs." + DDDt + "/-";
var DCRChequeDT = "Amount from Cheque Transactions : Rs." + ChequeDt + "/-";
reportViewer.FooterContent = reportViewer.FooterContent + string.Format("<span><br />{0}</span>", DCRGenDT);
reportViewer.FooterContent = reportViewer.FooterContent + string.Format("<span><br />{0} {1}</span>", DCRCashDT, DCRCardDT);
reportViewer.FooterContent = reportViewer.FooterContent + string.Format("<span><br />{0} {1}</span>", DCRDDDT, DCRChequeDT);
reportViewer.GenerateFromGridView(this.dgvReport, false);
reportViewer.Show(this);
}
