private void printBtn_Click(object sender, EventArgs e)
{
miktar = float.Parse(cardTextBox.Text) + float.Parse(transferTextBox.Text) + float.Parse(cashTextBox.Text);
if (miktar <= toplam)
{
saveFileDialog1.FileName = musteri + " " + aciklama + " Makbuz";
saveFileDialog1.DefaultExt = "xlsx";
saveFileDialog1.Filter = "Excel files (*.xlsx)|*.xlsx|All files (*.*)|*.*";
saveFileDialog1.ShowDialog();
if (saveFileDialog1.FileName != null)
{
try
{
var filePath = Assembly.GetExecutingAssembly().CodeBase + "/../../../Resources/TAHSİLAT-MAKBUZU.xlsx";
Excel report = new Excel(filePath, 1);
report.WriteCell(4, 6, "Tarih: " + DateTime.Now.ToString("dd/MM/yyyy"));
report.WriteCell(6, 7, Accounting.accID.ToString());
report.WriteCell(8, 2, musteri);
report.WriteCell(8, 5, aciklama);
report.WriteCell(9, 5, miktar.ToString() + "TL");
report.WriteCell(11, 3, cardTextBox.Text);
report.WriteCell(12, 3, transferTextBox.Text);
report.WriteCell(13, 3, cashTextBox.Text);
report.WriteCell(15, 3, miktar.ToString() + "TL");
report.WriteCell(16, 3, musteri);
report.WriteCell(16, 7, teslimAlan);
report.SaveAs(saveFileDialog1.FileName);
report.Close();
if (MessageBox.Show("Makbuz kaydedildi. Açmak istiyor musunuz?", "İşlem Başarılı", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
try
{
string fileName = saveFileDialog1.FileName;
if (!fileName.Contains(".xlsx"))
{
fileName += ".xlsx";
}
var process = new System.Diagnostics.Process();
process.StartInfo = new System.Diagnostics.ProcessStartInfo()
{
UseShellExecute = true, FileName = fileName
};
process.Start();
}
catch (Exception)
{
throw;
}
}
}
catch (Exception)
{
throw;
}
connection.Open();
SqlCommand updateAcc = new SqlCommand("update Accounting set Tahsil = @tahsil where Id = @id", connection);
updateAcc.Parameters.AddWithValue("@tahsil", 1);
updateAcc.Parameters.AddWithValue("@id", Accounting.accID);
updateAcc.ExecuteNonQuery();
connection.Close();
}
}
else
{
wrongLbl.Visible = true;
}
}