public FileResult DepoIslemYazdir(string ID = "")
{
FastReport.Utils.Config.WebMode = true;
FastReport.Report report1 = new FastReport.Report();
report1.Prepare(true);
DataTable dtDetay = new DataTable();
try
{
report1.Load(Path.Combine(Server.MapPath("~/REPORTS/" + Session["FirmaID"].ToString()), "depo.frx"));
}
catch {
report1.Load(Path.Combine(Server.MapPath("~/REPORTS/Default"), "depo.frx"));
}
using (SqlConnection bag = new SqlConnection(AyarMetot.strcon))
{
if (bag.State == ConnectionState.Closed)
{
bag.Open();
}
using (SqlCommand servisgetir = new SqlCommand("Select * From STORE_PROCESS where ID='" + ID + "'", bag))
{
using (SqlDataReader dt = servisgetir.ExecuteReader())
{
while (dt.Read())
{
dtDetay = AyarMetot.DepoIslemDetayBil(ID);
report1.RegisterData(AyarMetot.DepoIslemBil(ID), "Depo_İşlem");
report1.RegisterData(dtDetay, "Depo_İşlem_Detay");
report1.RegisterData(AyarMetot.FirmaBil(), "FirmaBilgileri");
report1.GetDataSource("Depo_İşlem").Enabled = true;
report1.GetDataSource("Depo_İşlem_Detay").Enabled = true;
report1.GetDataSource("FirmaBilgileri").Enabled = true;
}
}
}
}
using (FastReport.Export.Pdf.PDFExport pdf = new FastReport.Export.Pdf.PDFExport())
{
try
{
ReportPage page1 = report1.Pages[0] as ReportPage;
page1.PaperHeight = page1.PaperHeight + (dtDetay.Rows.Count * ((float)6.5));
}
catch { }
report1.Prepare(true);
try {
report1.Export(pdf, Path.Combine(Server.MapPath("~/REPORTS/" + Session["FirmaID"].ToString()), "depo.pdf"));
}
catch
{
report1.Export(pdf, Path.Combine(Server.MapPath("~/REPORTS/Default"), "depo.pdf"));
}
dtDetay.Dispose();
//System.IO.MemoryStream ms = new System.IO.MemoryStream();
//report1.Save(Path.Combine(Server.MapPath("~/REPORTS/ATTACHMENT"), "depoyeni.frx"));
byte[] dosya;
report1.Dispose();
try {
dosya = System.IO.File.ReadAllBytes(Path.Combine(Server.MapPath("~/REPORTS/" + Session["FirmaID"].ToString()), "depo.pdf"));
}
catch
{
dosya = System.IO.File.ReadAllBytes(Path.Combine(Server.MapPath("~/REPORTS/Default"), "depo.pdf"));
}
return(File(dosya, "application/pdf"));
}
}
public FileResult CekSenetYazdir(string ID = "")
{
FastReport.Utils.Config.WebMode = true;
FastReport.Report report1 = new FastReport.Report();
report1.Prepare(true);
try
{
report1.Load(Path.Combine(Server.MapPath("~/REPORTS/" + Session["FirmaID"].ToString()), "Cek.frx"));
}
catch
{
report1.Load(Path.Combine(Server.MapPath("~/REPORTS/Default"), "Cek.frx"));
}
using (SqlConnection conp = new SqlConnection(AyarMetot.strcon))
{
if (conp.State == ConnectionState.Closed)
{
conp.Open();
}
using (SqlCommand getir = new SqlCommand("Select CariID From CASH_PAY where ID='" + ID + "'", conp))
{
using (SqlDataReader dr = getir.ExecuteReader())
{
while (dr.Read())
{
using (DataTable Teklifler = GetDataTable("set dateformat dmy;SELECT * ,(Select Adi+' '+Soyadi from Personel where ID=PersonelID) as PersonelAdi From CASH_PAY where ID = '" + ID + "'"))
{
report1.RegisterData(Teklifler.DefaultView.ToTable(), "NakitHavale");
report1.GetDataSource("NakitHavale").Enabled = true;
}
report1.RegisterData(AyarMetot.CariBil(Convert.ToInt32(dr["CariID"]), "Tümü", "", "Tümü", "Tümü"), "CariBilgileri");
report1.RegisterData(AyarMetot.FirmaBil(), "FirmaBilgileri");
report1.GetDataSource("CariBilgileri").Enabled = true;
report1.GetDataSource("FirmaBilgileri").Enabled = true;
}
}
}
}
using (FastReport.Export.Pdf.PDFExport pdf = new FastReport.Export.Pdf.PDFExport())
{
byte[] dosya;
try
{
dosya =
System.IO.File.ReadAllBytes(Path.Combine(Server.MapPath("~/REPORTS/" + Session["FirmaID"].ToString()),
"Cek.pdf"));
}
catch
{
dosya =
System.IO.File.ReadAllBytes(Path.Combine(Server.MapPath("~/REPORTS/Defaut"),
"Cek.pdf"));
}
try
{
report1.Prepare(true);
try
{
report1.Export(pdf, Path.Combine(Server.MapPath("~/REPORTS/" + Session["FirmaID"].ToString()), "Cek.pdf"));
}
catch
{
report1.Export(pdf, Path.Combine(Server.MapPath("~/REPORTS/Default"), "Cek.pdf"));
}
System.IO.MemoryStream ms = new System.IO.MemoryStream();
//report1.Save(Path.Combine(Server.MapPath("~/REPORTS/ATTACHMENT"),"b.frx"));
report1.Dispose();
return(File(dosya, "application/pdf"));
}
catch (Exception e)
{
return(File(dosya, "application/pdf"));
}
}
}
public FileResult IadeYazdir(string ID = "")
{
try
{
FastReport.Utils.Config.WebMode = true;
FastReport.Report report1 = new FastReport.Report();
report1.Prepare(true);
DataTable dtDetay = new DataTable();
try {
report1.Load(Path.Combine(Server.MapPath("~//REPORTS/" + Session["FirmaID"].ToString()), "Iade.frx"));
}
catch
{
report1.Load(Path.Combine(Server.MapPath("~//REPORTS/Default"), "Iade.frx"));
}
using (SqlConnection bag = new SqlConnection(AyarMetot.strcon))
{
if (bag.State == ConnectionState.Closed)
{
bag.Open();
}
using (SqlCommand servisgetir = new SqlCommand("Select * From INVOICE where ID='" + ID + "'", bag))
{
using (SqlDataReader dt = servisgetir.ExecuteReader())
{
while (dt.Read())
{
string KDVdh = "Dahil";
dtDetay = AyarMetot.FaturaDetayBil(ID, KDVdh, Convert.ToDecimal(dt["FKuru"]));
if (dt["KdvDH"].ToString() != "D")
{
KDVdh = "Hariç";
}
report1.RegisterData(AyarMetot.FaturaBil(ID), "FaturaBilgileri");
report1.RegisterData(dtDetay, "UrunBilgileri");
report1.RegisterData(AyarMetot.CariBil(Convert.ToInt32(dt["CariID"]), "Tümü", "Tümü", "Tümü", "Tümü"), "CariBilgileri");
report1.RegisterData(AyarMetot.FirmaBil(), "FirmaBilgileri");
report1.GetDataSource("FaturaBilgileri").Enabled = true;
report1.GetDataSource("UrunBilgileri").Enabled = true;
report1.GetDataSource("CariBilgileri").Enabled = true;
report1.GetDataSource("FirmaBilgileri").Enabled = true;
}
}
}
}
using (FastReport.Export.Pdf.PDFExport pdf = new FastReport.Export.Pdf.PDFExport())
{
ReportPage page1 = report1.Pages[0] as ReportPage;
page1.PaperHeight = page1.PaperHeight + (dtDetay.Rows.Count * ((float)5));
report1.Prepare(true);
try {
report1.Export(pdf, Path.Combine(Server.MapPath("~//REPORTS/" + Session["FirmaID"].ToString()), "Iade.pdf"));
}
catch
{
report1.Export(pdf, Path.Combine(Server.MapPath("~//REPORTS/Default"), "Iade.pdf"));
}
dtDetay.Dispose();
System.IO.MemoryStream ms = new System.IO.MemoryStream();
//report1.Save(Path.Combine(Server.MapPath("~/REPORTS/ATTACHMENT"),"Irs.frx"));
// page1.Dispose();
report1.Dispose();
byte[] dosya;
try {
dosya = System.IO.File.ReadAllBytes(Path.Combine(Server.MapPath("~/REPORTS/" + Session["FirmaID"].ToString()), "Iade.pdf"));
}
catch
{
dosya = System.IO.File.ReadAllBytes(Path.Combine(Server.MapPath("~/REPORTS/Default"), "Iade.pdf"));
}
return(File(dosya, "application/pdf"));
}
}
catch (Exception e1)
{
try {
System.IO.File.WriteAllText(Path.Combine(@"C:\Users\ilhan\AppData\Local\Sayazilim", "sonuç.xml"), e1.ToString());
}
catch
{
}
byte[] dosya = null;
return(File(dosya, "application/pdf"));
}
}