private void FillBillDetailsForEdit(string billID)
{
try
{
_dalBills = new DAL_Bills();
var bills = _dalBills.GetBillDetails(new M_Bills_RQ()
{
BillID = Convert.ToInt32(billID)
});
if (bills != null)
{
btnAdd.Text = "Update";
btnPrint.Enabled = true;
txtCustomerName.Text = bills[0].BillTo;
txtMobileNo.Text = bills[0].MobileNo;
txtAddress.Text = bills[0].BillToAddress;
txtBillNo.Text = bills[0].BillNo;
txtEmailID.Text = bills[0].EmailID;
dtpBillDate.Value = bills[0].BillDate;
IsInv.Checked = Convert.ToBoolean(bills[0].IsIndividual);
//txtCaseDetails.Text = bills[0].BillDescription;
txtGrandTotal.Text = Convert.ToString(bills[0].BillAmout);
lblGrandTotalInWords.Text = "Rupees " + CommonConstants.ConvertNumbertoWords(Convert.ToString(bills[0].BillAmout));
BindParticularDetails();
}
}
catch (Exception)
{
throw;
}
}
private void BillsList(M_Bills_RQ m_Bills_RQ)
{
dAL_Bills = new DAL_Bills();
var result = dAL_Bills.GetBillDetails(m_Bills_RQ);
dgvListOfBills.DataSource = result;
}
private void btnSaveAs_Click(object sender, EventArgs e)
{
StringBuilder sbMsg = new StringBuilder();
if (!string.IsNullOrWhiteSpace(txtBillNo.Text))
{
var confirmResult = MessageBox.Show("Are you sure to make new invoice !", "Confirm !!", MessageBoxButtons.YesNo);
if (confirmResult == DialogResult.Yes)
{
_dalBills = new DAL_Bills();
List <M_Bills_RS> result = _dalBills.BillSaveAs(new M_Bills_RQ()
{
BillNo = txtBillNo.Text
});
if (result != null && result.Count > 0)
{
CommonConstants.ShowMessageBox(result[0].BillNo.ToString() + sbMsg.ToString(), "Success !!", MessageBoxIcon.Information);
BindPageEdit(result[0].BillID.ToString());
//lblBillID.Text = Convert.ToString(result[0].BillID);
//txtBillNo.Text = Convert.ToString(result[0].BillNo);
}
}
}
else
{
CommonConstants.ShowMessageBox("Can not create copy of this invoice !!", "Success !!", MessageBoxIcon.Information);
}
}
private void BindParticularDetails()
{
try
{
dgvParticularDetails.DataSource = null;
_dalBills = new DAL_Bills();
lstbillParticulars.Clear();
lstbillParticulars = _dalBills.GetBillParticularsDetails(new M_BillParticulars_RQ()
{
BillID = Convert.ToInt32(lblBillID.Text)
});
dgvParticularDetails.DataSource = lstbillParticulars;
}
catch (Exception)
{
throw;
}
}
public void BillPrint(int v)
{
this.RvBills.RefreshReport();
RvBills.Visible = true;
RvBills.ProcessingMode = ProcessingMode.Local;
RvBills.LocalReport.ReportPath = "../../Reports/BillsWithFooter.rdlc";
dAL_Bills = new DAL_Bills();
var listPDetails = dAL_Bills.GetBillParticularsDetails(new Models.M_BillParticulars_RQ()
{
BillID = v
});
var listBDetails = dAL_Bills.GetBillDetails(new Models.M_Bills_RQ()
{
BillID = v
});
if (listBDetails != null && listBDetails.Count > 0)
{
listBDetails[0].AmountInWord = "Rupees " + CommonConstants.ConvertNumbertoWords(Convert.ToString(listBDetails[0].BillAmout)) + " Only.";
}
DataTable dtBillParticularDetails = new DataTable();
DataTable dtdsBillReports = new DataTable();
dtdsBillReports = listBDetails.ToDataTable <M_Bills>();
dtBillParticularDetails = listPDetails.ToDataTable <M_BillParticulars>();
ReportDataSource rdsBillParticularDetails = new ReportDataSource("dsBillParticularDetails", dtBillParticularDetails);
ReportDataSource rdsdsBillReports = new ReportDataSource("dsBillReports", dtdsBillReports);
RvBills.LocalReport.DataSources.Clear();
RvBills.LocalReport.DataSources.Add(rdsBillParticularDetails);
RvBills.LocalReport.DataSources.Add(rdsdsBillReports);
RvBills.LocalReport.DisplayName = Convert.ToString(dtdsBillReports.Rows[0]["BillTo"]).Replace('/', '_').Replace(' ', '_') + Convert.ToDateTime(dtdsBillReports.Rows[0]["BillDate"]).ToString("dd_MMM_yyyy");
RvBills.LocalReport.Refresh();
RvBills.RefreshReport();
this.RvBills.RefreshReport();
}
private void CreateUpdateBill()
{
try
{
StringBuilder sbMsg = new StringBuilder();
M_Bills m_Bills = new M_Bills();
int? intBillID = null;
if (!string.IsNullOrWhiteSpace(lblBillID.Text))
{
m_Bills.BillID = Convert.ToInt32(lblBillID.Text);
intBillID = Convert.ToInt32(lblBillID.Text);
sbMsg.Append(" has been updated successfully");
}
else
{
sbMsg.Append(" has been add successfully");
}
m_Bills.BillNo = txtBillNo.Text;
m_Bills.BillAmout = Convert.ToDouble(txtGrandTotal.Text);
m_Bills.BillDate = dtpBillDate.Value;
m_Bills.BillDescription = String.Empty;
m_Bills.BillTo = txtCustomerName.Text;
m_Bills.BillToAddress = txtAddress.Text;
m_Bills.MobileNo = txtMobileNo.Text;
m_Bills.EmailID = txtEmailID.Text;
m_Bills.IsIndividual = IsInv.Checked;
//List<M_BillParticulars> lstM_BillParticulars = dgvParticularDetails.DataSource as List<M_BillParticulars>;
foreach (DataGridViewRow dr in dgvParticularDetails.Rows)
{
//if ((dgvParticularDetails.Rows.Count - 1) == dr.Index)
// continue;
int?intBillParticularsID = null;
if (!string.IsNullOrWhiteSpace(Convert.ToString(dr.Cells["BillParticularsID"].Value)))
{
intBillParticularsID = Convert.ToInt32(dr.Cells["BillParticularsID"].Value);
}
m_Bills._lstBillParticulars.Add(new M_BillParticulars()
{
BillID = intBillID,
BillAmout = Convert.ToDecimal(dr.Cells["txtBillAmouts"].Value),
BillParticularsID = intBillParticularsID,
BPDate = Convert.ToDateTime(dr.Cells["txtBPDate"].Value),
BPDesc = Convert.ToString(dr.Cells["BPDesc"].Value),
BPCreatedOn = DateTime.Now,
BPCreatedBy = "SYS",
IsActive = true,
IsNew = Convert.ToBoolean(dr.Cells["IsNew"].Value)
});
}
_dalBills = new DAL_Bills();
List <M_Bills_RS> result = _dalBills.AddUpdateBillDetails(m_Bills);
if (result != null && result.Count > 0)
{
CommonConstants.ShowMessageBox(result[0].BillNo.ToString() + sbMsg.ToString(), "Success !!", MessageBoxIcon.Information);
btnAdd.Text = "Update";
btnPrint.Enabled = true;
lblBillID.Text = Convert.ToString(result[0].BillID);
txtBillNo.Text = Convert.ToString(result[0].BillNo);
BindParticularDetails();
}
}
catch (Exception)
{
throw;
}
}
public void SavePDF(int v, bool sendMail)
{
this.RvBills.RefreshReport();
RvBills.Visible = true;
RvBills.ProcessingMode = ProcessingMode.Local;
RvBills.LocalReport.ReportPath = "../../Reports/BillsWithFooter.rdlc";
dAL_Bills = new DAL_Bills();
var listPDetails = dAL_Bills.GetBillParticularsDetails(new Models.M_BillParticulars_RQ()
{
BillID = v
});
var listBDetails = dAL_Bills.GetBillDetails(new Models.M_Bills_RQ()
{
BillID = v
});
if (listBDetails != null && listBDetails.Count > 0)
{
listBDetails[0].AmountInWord = "Rupees " + CommonConstants.ConvertNumbertoWords(Convert.ToString(listBDetails[0].BillAmout)) + " Only.";
}
DataTable dtBillParticularDetails = new DataTable();
DataTable dtdsBillReports = new DataTable();
dtdsBillReports = listBDetails.ToDataTable <M_Bills>();
dtBillParticularDetails = listPDetails.ToDataTable <M_BillParticulars>();
ReportDataSource rdsBillParticularDetails = new ReportDataSource("dsBillParticularDetails", dtBillParticularDetails);
ReportDataSource rdsdsBillReports = new ReportDataSource("dsBillReports", dtdsBillReports);
RvBills.LocalReport.DataSources.Clear();
RvBills.LocalReport.DataSources.Add(rdsBillParticularDetails);
RvBills.LocalReport.DataSources.Add(rdsdsBillReports);
string filepath = (Convert.ToString(dtdsBillReports.Rows[0]["BillTo"]).Replace('/', '_').Replace(' ', '_')).TrimEnd('_');
string filename = Convert.ToString(dtdsBillReports.Rows[0]["BillTo"]).Replace('/', '_').Replace(' ', '_') + Convert.ToDateTime(dtdsBillReports.Rows[0]["BillDate"]).ToString("ddMMM_yyyy");
RvBills.LocalReport.DisplayName = filename;
RvBills.LocalReport.Refresh();
RvBills.RefreshReport();
// this.RvBills.RefreshReport();
byte[] Bytes = RvBills.LocalReport.Render(format: "PDF", deviceInfo: "");
//Create Folder
string folderpath = ConfigurationManager.AppSettings["FilePath"].ToString();
string strFullPath = folderpath;
if (!Convert.ToBoolean(dtdsBillReports.Rows[0]["IsIndividual"]))
{
if (!Directory.Exists(folderpath + filepath))
{
Directory.CreateDirectory(folderpath + filepath);
}
strFullPath = strFullPath + filepath + '\\' + filename + ".pdf";
}
else
{
strFullPath = strFullPath + filename + ".pdf";
}
string strFullpathNewName = strFullPath.Substring(0, strFullPath.LastIndexOf('.')) + ".pdf";
if (File.Exists(strFullpathNewName))
{
int index = 1;
strFullpathNewName = strFullPath.Substring(0, strFullPath.LastIndexOf('.')) + "(" + index + ").pdf";
strFullPath = strFullPath.Substring(0, strFullPath.LastIndexOf('.')) + "(" + index + ").pdf";
while (File.Exists(strFullpathNewName))
{
strFullpathNewName = strFullPath.Substring(0, strFullPath.LastIndexOf('.') - 3) + "(" + ++index + ").pdf";
strFullPath = strFullPath.Substring(0, strFullPath.LastIndexOf('.') - 3) + "(" + index + ").pdf";
}
}
using (FileStream stream = new FileStream(strFullPath, FileMode.Create))
{
stream.Write(Bytes, 0, Bytes.Length);
}
if (sendMail)
{
string subject = "Bill for the month of " + Convert.ToDateTime(dtdsBillReports.Rows[0]["BillDate"]).ToString("MMM yyyy");
var IsSent = EmailSender.SendEmail(Convert.ToString(dtdsBillReports.Rows[0]["EmailID"]), strFullPath, subject);
if (IsSent)
{
CommonConstants.ShowMessageBox("Successfully, Bill has been emailed !!", "Success !!", MessageBoxIcon.Information);
}
else
{
CommonConstants.ShowMessageBox("Bill has not been emailed.Is email id valid? ", "Failed !!", MessageBoxIcon.Warning);
}
}
else
{
CommonConstants.ShowMessageBox("Bill has been saved at " + strFullpathNewName, "Success !!", MessageBoxIcon.Information);
}
}
