public static int Delete(Teklif p)
{
int rowsAffected = 0;
using (MConnection conneciton = new MConnection(MClientProvider.OleDb, Commons.ConnectionStringName))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(CommandType.Text, "delete from Teklif where ID=@ID", conneciton))
{
cmd.Parameters.Add("ID", p.ID, MSqlDbType.BigInt);
rowsAffected = cmd.ExecuteNonQuery();
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rowsAffected);
}
public static Teklif GetTeklif(Int64 pID)
{
Teklif rvTeklif = new Teklif();
using (MConnection conneciton = new MConnection(MClientProvider.OleDb, Commons.ConnectionStringName))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(CommandType.Text, "select top 1 * from Teklif where ID=@ID", conneciton))
{
cmd.Parameters.Add("ID", pID, MSqlDbType.BigInt);
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvTeklif = new Teklif(MConvert.NullToInt64(IDR["ID"]), MConvert.NullToString(IDR["GemiAdi"]), MConvert.NullToString(IDR["BaglamaLimani"]), MConvert.NullToString(IDR["Acenta"]), MConvert.NullToString(IDR["Manager"]), MConvert.NullToDateTime(IDR["Tarih"]), MConvert.NullToFloat(IDR["Kur1"]), MConvert.NullToFloat(IDR["Kur2"]), MConvert.NullToString(IDR["ParaBirimi"]), MConvert.NullToByte(IDR["Kdv"]), MConvert.NullToFloat(IDR["TasimaUcreti"]), MConvert.NullToFloat(IDR["Iskonto"]), MConvert.NullToString(IDR["Hazirlayan"]), MConvert.NullToString(IDR["OdemeSekli"]), MConvert.NullToString(IDR["TeslimSuresi"]), MConvert.NullToString(IDR["Aciklama"]), MConvert.NullToDateTime(IDR["GuncellemeTarihi"]), MConvert.NullToByte(IDR["Durum"]), MConvert.NullToString(IDR["DurumNotu"]), MConvert.NullToString(IDR["TasimaUcretiNotu"]));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvTeklif);
}
public static List <TeklifDetay> GetSelect(Teklif p)
{
List <TeklifDetay> rvTeklifDetay = new List <TeklifDetay>();
using (MConnection conneciton = new MConnection(MClientProvider.OleDb, Commons.ConnectionStringName))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(CommandType.Text, "select * from TeklifDetay where TeklifID=@TeklifID order by ID asc", conneciton))
{
cmd.Parameters.Add("TeklifID", p.ID, MSqlDbType.BigInt);
using (IDataReader IDR = cmd.ExecuteReader())
{
int siraNo = 0;
while (IDR.Read())
{
rvTeklifDetay.Add(new TeklifDetay(++siraNo, MConvert.NullToInt64(IDR["ID"]), MConvert.NullToInt64(IDR["TeklifID"]), MConvert.NullToInt(IDR["StokID"]), MConvert.NullToInt(IDR["KategoriID"]), MConvert.NullToInt(IDR["FirmaID"]), MConvert.NullToString(IDR["FirmaAdi"]), MConvert.NullToString(IDR["UrunAdi"]), MConvert.NullToFloat(IDR["BirimFiyati"]), MConvert.NullToFloat(IDR["KarOrani"]), MConvert.NullToFloat(IDR["Miktar"]), MConvert.NullToString(IDR["Birim"]), MConvert.NullToFloat(IDR["Adet"]), MConvert.NullToFloat(IDR["Kdv"]), p.Kur1, p.Kur2));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvTeklifDetay);
}
public static Int64 Insert(Teklif p)
{
Int64 rowsAffected = 0;
using (MConnection conneciton = new MConnection(MClientProvider.OleDb, Commons.ConnectionStringName))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(CommandType.Text, "insert into Teklif (GemiAdi,BaglamaLimani,Acenta,Manager,Tarih,Kur1,Kur2,ParaBirimi,Kdv,TasimaUcreti,Iskonto,Hazirlayan,OdemeSekli,TeslimSuresi,Aciklama,GuncellemeTarihi,Durum,DurumNotu,TasimaUcretiNotu) values(@GemiAdi,@BaglamaLimani,@Acenta,@Manager,@Tarih,@Kur1,@Kur2,@ParaBirimi,@Kdv,@TasimaUcreti,@Iskonto,@Hazirlayan,@OdemeSekli,@TeslimSuresi,@Aciklama,@GuncellemeTarihi,@Durum,@DurumNotu,@TasimaUcretiNotu)", conneciton))
{
cmd.Parameters.Add("GemiAdi", p.GemiAdi, MSqlDbType.NVarChar);
cmd.Parameters.Add("BaglamaLimani", p.BaglamaLimani, MSqlDbType.NVarChar);
cmd.Parameters.Add("Acenta", p.Acenta, MSqlDbType.NVarChar);
cmd.Parameters.Add("Manager", p.Manager, MSqlDbType.NVarChar);
cmd.Parameters.Add("Tarih", p.Tarih, MSqlDbType.DateTime);
cmd.Parameters.Add("Kur1", p.Kur1, MSqlDbType.Float);
cmd.Parameters.Add("Kur2", p.Kur2, MSqlDbType.Float);
cmd.Parameters.Add("ParaBirimi", p.ParaBirimi, MSqlDbType.VarChar);
cmd.Parameters.Add("Kdv", p.Kdv, MSqlDbType.TinyInt);
cmd.Parameters.Add("TasimaUcreti", p.TasimaUcreti, MSqlDbType.Float);
cmd.Parameters.Add("Iskonto", p.Iskonto, MSqlDbType.Float);
cmd.Parameters.Add("Hazirlayan", p.Hazirlayan, MSqlDbType.NVarChar);
cmd.Parameters.Add("OdemeSekli", p.OdemeSekli, MSqlDbType.NVarChar);
cmd.Parameters.Add("TeslimSuresi", p.TeslimSuresi, MSqlDbType.NVarChar);
cmd.Parameters.Add("Aciklama", p.Aciklama, MSqlDbType.NVarChar);
cmd.Parameters.Add("GuncellemeTarihi", p.GuncellemeTarihi, MSqlDbType.DateTime);
cmd.Parameters.Add("Durum", p.Durum, MSqlDbType.Number);
cmd.Parameters.Add("DurumNotu", p.DurumNotu, MSqlDbType.NVarChar);
cmd.Parameters.Add("TasimaUcretiNotu", p.DurumNotu, MSqlDbType.NVarChar);
if (cmd.ExecuteNonQuery() > 0)
{
cmd.Parameters.Clear();
//;select top 1 ID from Teklif where GemiAdi=@GemiAdi and BaglamaLimani=@BaglamaLimani and Acenta=@Acenta and Manager=@Manager and Tarih=@Tarih;
cmd.CommandText = "SELECT @@IDENTITY";
rowsAffected = MConvert.NullToInt64(cmd.ExecuteScalar());
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rowsAffected);
}
public xrpTeklifMaliyetRapor(Teklif p)
{
InitializeComponent();
try
{
if (Commons.ExpariedDay <= 10)
{
this.Watermark.Text = "CREATED BY TRIAL VERSION!";
}
else
{
this.Watermark.Text = string.Empty;
}
this.xrLogo.Image = Commons.LogoCompany;
this.xrTitle.Text = Commons.AppSettings.COMPANY_NAME;
this.xrSubTitle.Text = Commons.AppSettings.COMPANY_DESC;
this.xrTitle.ForeColor = this.xrSubTitle.ForeColor = Commons.COMPANY_FORECOLOR;
this.xrFormRevNo.Text = Commons.AppSettings.SIPARIS_LISTESI_FORMU;
this.t = p;
this.DisplayName = t.GemiAdi.Replace("/", "").Replace("\\", "") + " - MALİYET RAPORU - " + t.Tarih.ToString("yyyy-MM-dd");
this.xrReferans.Text = "Reference Number: " + t.ID;
this.xrGemiAdi.Text = t.GemiAdi;
this.xrBaglamaLimani.Text = t.BaglamaLimani;
this.xrAcenta.Text = t.Acenta;
this.xrFirma.Text = t.Manager;
this.xrTarih.Text = t.GuncellemeTarihi.ToShortDateString();
this.xrParaBirimi.Text = Commons.CurrencySelected(t.ParaBirimi);
this.xrKdv.Text = Commons.GetTax(t.Kdv);
this.xrHazirlayan.Text = t.Hazirlayan;
this.xrBirimFiyati.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
new DevExpress.XtraReports.UI.XRBinding("Text", null, "BirimFiyati", Commons.Kur0FormatCustom)
});
this.xrBirimFiyatTutari.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
new DevExpress.XtraReports.UI.XRBinding("Text", null, "BirimFiyatiTutar", Commons.Kur0FormatCustom)
});
this.xrFirmaTutar.Summary.FormatString = Commons.Kur0FormatCustom;
this.xrGenelTutar.Summary.FormatString = Commons.Kur0FormatCustom;
}
catch (Exception ex)
{
Commons.Status(Commons.GetErrorCode("RFR", 3) + ex.Message);
}
}
public static int Update(Teklif p)
{
int rowsAffected = 0;
using (MConnection conneciton = new MConnection(MClientProvider.OleDb, Commons.ConnectionStringName))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(CommandType.Text, "Update Teklif SET GemiAdi=@GemiAdi,BaglamaLimani=@BaglamaLimani,Acenta=@Acenta,Manager=@Manager,Tarih=@Tarih,Kur1=@Kur1,Kur2=@Kur2,ParaBirimi=@ParaBirimi,Kdv=@Kdv,TasimaUcreti=@TasimaUcreti,Iskonto=@Iskonto,Hazirlayan=@Hazirlayan,OdemeSekli=@OdemeSekli,TeslimSuresi=@TeslimSuresi,Aciklama=@Aciklama,GuncellemeTarihi=@GuncellemeTarihi,Durum=@Durum,DurumNotu=@DurumNotu,TasimaUcretiNotu=@TasimaUcretiNotu where ID=@ID", conneciton))
{
cmd.Parameters.Add("GemiAdi", p.GemiAdi, MSqlDbType.NVarChar);
cmd.Parameters.Add("BaglamaLimani", p.BaglamaLimani, MSqlDbType.NVarChar);
cmd.Parameters.Add("Acenta", p.Acenta, MSqlDbType.NVarChar);
cmd.Parameters.Add("Manager", p.Manager, MSqlDbType.NVarChar);
cmd.Parameters.Add("Tarih", p.Tarih, MSqlDbType.DateTime);
cmd.Parameters.Add("Kur1", p.Kur1, MSqlDbType.Float);
cmd.Parameters.Add("Kur2", p.Kur2, MSqlDbType.Float);
cmd.Parameters.Add("ParaBirimi", p.ParaBirimi, MSqlDbType.VarChar);
cmd.Parameters.Add("Kdv", p.Kdv, MSqlDbType.TinyInt);
cmd.Parameters.Add("TasimaUcreti", p.TasimaUcreti, MSqlDbType.Float);
cmd.Parameters.Add("Iskonto", p.Iskonto, MSqlDbType.Float);
cmd.Parameters.Add("Hazirlayan", p.Hazirlayan, MSqlDbType.NVarChar);
cmd.Parameters.Add("OdemeSekli", p.OdemeSekli, MSqlDbType.NVarChar);
cmd.Parameters.Add("TeslimSuresi", p.TeslimSuresi, MSqlDbType.NVarChar);
cmd.Parameters.Add("Aciklama", p.Aciklama, MSqlDbType.NVarChar);
cmd.Parameters.Add("GuncellemeTarihi", p.GuncellemeTarihi, MSqlDbType.DateTime);
cmd.Parameters.Add("Durum", p.Durum, MSqlDbType.Number);
cmd.Parameters.Add("DurumNotu", p.DurumNotu, MSqlDbType.NVarChar);
cmd.Parameters.Add("TasimaUcretiNotu", p.TasimaUcretiNotu, MSqlDbType.NVarChar);
cmd.Parameters.Add("ID", p.ID, MSqlDbType.BigInt);
rowsAffected = cmd.ExecuteNonQuery();
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rowsAffected);
}
public xrpTeklifToplamaFiyatsiz(Teklif p)
{
InitializeComponent();
try
{
if (Commons.ExpariedDay <= 10)
{
this.Watermark.Text = "CREATED BY TRIAL VERSION!";
}
else
{
this.Watermark.Text = string.Empty;
}
this.xrLogo.Image = Commons.LogoCompany;
this.xrTitle.Text = Commons.AppSettings.COMPANY_NAME;
this.xrSubTitle.Text = Commons.AppSettings.COMPANY_DESC;
this.xrTitle.ForeColor = this.xrSubTitle.ForeColor = Commons.COMPANY_FORECOLOR;
this.xrFormRevNo.Text = Commons.AppSettings.SIPARIS_TOPLAMA_FORMU;
this.t = p;
this.DisplayName = t.GemiAdi.Replace("/", "").Replace("\\", "") + " - ÜRÜN TOPLAMA TUTNAĞI - " + t.Tarih.ToString("yyyy-MM-dd");
this.xrReferans.Text = "Reference Number: " + t.ID;
this.xrGemiAdi.Text = t.GemiAdi;
this.xrBaglamaLimani.Text = t.BaglamaLimani;
this.xrAcenta.Text = t.Acenta;
this.xrFirma.Text = t.Manager;
this.xrTarih.Text = t.GuncellemeTarihi.ToShortDateString();
this.xrParaBirimi.Text = Commons.CurrencySelected(t.ParaBirimi);
this.xrKdv.Text = Commons.GetTax(t.Kdv);
this.xrHazirlayan.Text = t.Hazirlayan;
}
catch (Exception ex)
{
Commons.Status(Commons.GetErrorCode("RFR", 4) + ex.Message);
}
}
public xrpTeklifFormu(Teklif p, FormType ft, float grandTotal, float discountTotal)
{
InitializeComponent();
try
{
if (Commons.ExpariedDay <= 10)
{
this.Watermark.Text = "CREATED BY TRIAL VERSION!";
}
else
{
this.Watermark.Text = string.Empty;
}
Commons.Loading("Belge hazırlanıyor. ..");
foreach (XRControl item in this.reportHeaderBand1.Controls)
{
switch (BAYMYO.UI.Converts.NullToString(item.Tag))
{
case "T":
item.BorderColor = Commons.HEADER_BORDERCOLOR;
item.ForeColor = Commons.HEADER_DESCCOLOR;
break;
case "TC":
item.BackColor = Commons.HEADER_BACKCOLOR;
item.BorderColor = Commons.HEADER_BORDERCOLOR;
item.ForeColor = Commons.HEADER_TITLECOLOR;
break;
}
}
if (Commons.AppSettings.IS_IMAGE_HEADER)
{
this.reportHeaderBand1.HeightF = 285f;
foreach (XRControl item in this.reportHeaderBand1.Controls)
{
switch (BAYMYO.UI.Converts.NullToString(item.Tag))
{
case "T":
case "TC":
item.LocationFloat = new DevExpress.Utils.PointFloat(item.LocationF.X, item.LocationF.Y + 53);
break;
case "V":
item.Visible = false;
break;
}
}
this.xrLogo.Image = Commons.HeaderImage;
this.xrLogo.WidthF = 788f;
this.xrLogo.HeightF = 200f;
}
else
{
this.xrLogo.Image = Commons.LogoCompany;
this.xrOtherLogos.Image = Commons.LogoOther;
this.xrTitle.ForeColor = this.xrSubTitle.ForeColor = Commons.COMPANY_FORECOLOR;
this.xrDESC_TR.BackColor = Commons.DESC_TR_BACKCOLOR;
this.xrDESC_TR.ForeColor = Commons.DESC_TR_FORECOLOR;
this.xrDESC_EN.BackColor = Commons.DESC_EN_BACKCOLOR;
this.xrDESC_EN.ForeColor = Commons.DESC_EN_FORECOLOR;
this.xrHeaderTitle.Text = Commons.AppSettings.HEADER_TITLE;
this.xrDESC_TR.Text = Commons.AppSettings.DESC_TR;
this.xrDESC_EN.Text = Commons.AppSettings.DESC_EN;
this.xrOfficePhone.Text = Commons.AppSettings.OFISPHONE;
this.xrFax.Text = Commons.AppSettings.FAX;
this.xrGsm.Text = Commons.AppSettings.GSM;
this.xrAddress.Text = Commons.AppSettings.ADDRESS;
this.xrMail.Text = Commons.AppSettings.MAIL;
this.xrWeb.Text = Commons.AppSettings.WEB;
}
this.t = p;
this.ghDicount.Visible = this.xrDiscount.Visible = (t.Iskonto > 0);
if (!this.xrDiscount.Visible)
{
this.ghDeliveryExpenses.LocationFloat = new DevExpress.Utils.PointFloat(445.33F, 20.00001F);
this.xrDeliveryExpenses.LocationFloat = new DevExpress.Utils.PointFloat(593.81F, 20.00008F);
this.ghGrandTotal.LocationFloat = new DevExpress.Utils.PointFloat(445.33F, 40.00003F);
this.xrGrandTotals.LocationFloat = new DevExpress.Utils.PointFloat(593.81F, 40.00009F);
}
else
{
this.ghDicount.Text = "DISCOUNT (" + t.Iskonto.ToString("%##0") + ")";
}
switch (ft)
{
case FormType.Offer:
this.DisplayName = t.GemiAdi.Replace("/", "").Replace("\\", "") + " - " + L.TeklifVermeTutanagi + " - " + t.Tarih.ToString("yyyy-MM-dd");
this.xrFormTitle.Text = "TEKLİF VERME TUTANAĞI / DOCUMENT OF OFFER";
this.xrFormRevNo.Text = Commons.AppSettings.TEKLIF_VERME_FORMU;
this.xrPayment.Text = "PAYMENT: " + t.OdemeSekli;
this.xrDelivery.Text = "DELIVERY: " + t.TeslimSuresi;
this.xrNote.Text = "NOTE: " + t.Aciklama;
switch (t.ParaBirimi)
{
case "KUR1":
case "KUR2":
this.xrDeliverySignature.Text = "OFFERED BY\nUNSIGNED DUE TO ELECTRONICALLY PREPARED."; // TARAFINDAN SUNULAN
break;
default:
switch (Commons.AppSettings.DEFAULT_CURRENCY.Code)
{
case "TRY":
this.xrDeliverySignature.Text = "OFFERED BY\nELEKTRONİK ORTAMDA HAZIRLANDIĞI İÇİN İMZASIZDIR."; // TARAFINDAN SUNULAN
break;
default:
this.xrDeliverySignature.Text = "OFFERED BY\nUNSIGNED DUE TO ELECTRONICALLY PREPARED."; // TARAFINDAN SUNULAN
break;
}
break;
}
this.xrOfferSignature.Text = "ORDERED BY"; // TARAFINDAN SİPARİŞ
break;
case FormType.Delivery:
this.DisplayName = t.GemiAdi.Replace("/", "").Replace("\\", "") + " - " + L.TeslimVermeTutanagi + " - " + t.Tarih.ToString("yyyy-MM-dd");
this.xrFormTitle.Text = "MAZLEME TESLİM TUTANAĞI / DOCUMENT OF DELIVERY";
this.xrFormRevNo.Text = Commons.AppSettings.MALZEME_TESLIM_FORMU;
this.xrPayment.Dispose();
this.xrDelivery.Dispose();
this.xrNote.Dispose();
this.xrDeliverySignature.Text = "TAKEN DELIVERY BY / TESLİM ALAN"; // TESLİM ALAN
this.xrOfferSignature.Text = "DELIVERED BY / TESLİM EDEN"; // TESLİM EDEN
this.xrDeliverySignature.LocationFloat = new DevExpress.Utils.PointFloat(9.999935F, 85.999974F);
this.xrFormRevNo.LocationFloat = new DevExpress.Utils.PointFloat(9.999935F, 145F);
this.xrOfferSignature.LocationFloat = new DevExpress.Utils.PointFloat(406.1256F, 85.999974F);
this.xrReferans.LocationFloat = new DevExpress.Utils.PointFloat(406.1256F, 145F);
this.ReportFooter.HeightF = 190F;
break;
}
this.xrReferans.Text = "Reference Number: " + t.ID;
this.xrGemiAdi.Text = t.GemiAdi;
this.xrBaglamaLimani.Text = t.BaglamaLimani;
this.xrAcenta.Text = t.Acenta;
this.xrFirma.Text = t.Manager;
this.xrTarih.Text = t.GuncellemeTarihi.ToShortDateString();
this.xrParaBirimi.Text = Commons.CurrencySelected(t.ParaBirimi);
this.xrKdv.Text = Commons.GetTax(t.Kdv);
this.xrHazirlayan.Text = t.Hazirlayan;
string
currencyFormat = Commons.Kur0Format,
currencyFormatCustom = Commons.Kur0FormatCustom;
float deliveryExpenses = t.TasimaUcreti;
switch (t.ParaBirimi)
{
case "KUR1":
currencyFormat = Commons.Kur1Format;
currencyFormatCustom = Commons.Kur1FormatCustom;
this.xrSatisFiyati.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "SatisFiyatiKur1", currencyFormatCustom) });
this.xrSatisTutari.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "SatisTutarKur1", currencyFormatCustom) });
this.xrTotals.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "SatisTutarKur1") });
this.xrTotals.Summary.FormatString = currencyFormatCustom;
deliveryExpenses = (t.TasimaUcreti / t.Kur1);
if (this.xrDiscount.Visible)
{
this.xrDiscount.Text = (discountTotal / t.Kur1).ToString(currencyFormat);
}
this.xrGrandTotals.Text = grandTotal.ToString(currencyFormat);
break;
case "KUR2":
currencyFormat = Commons.Kur2Format;
currencyFormatCustom = Commons.Kur2FormatCustom;
this.xrSatisFiyati.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "SatisFiyatiKur2", currencyFormatCustom) });
this.xrSatisTutari.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "SatisTutarKur2", currencyFormatCustom) });
this.xrTotals.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "SatisTutarKur2") });
deliveryExpenses = (t.TasimaUcreti / t.Kur2);
if (this.xrDiscount.Visible)
{
this.xrDiscount.Text = (discountTotal / t.Kur2).ToString(currencyFormat);
}
this.xrGrandTotals.Text = grandTotal.ToString(currencyFormat);
break;
default:
this.xrSatisFiyati.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "SatisFiyati", currencyFormatCustom) });
this.xrSatisTutari.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "SatisTutar", currencyFormatCustom) });
if (this.xrDiscount.Visible)
{
this.xrDiscount.Text = discountTotal.ToString(currencyFormat);
}
this.xrGrandTotals.Text = grandTotal.ToString(currencyFormat);
break;
}
if (t.TasimaUcreti > 0)
{
this.xrDeliveryExpenses.Text = deliveryExpenses.ToString(currencyFormat);
}
else
{
this.xrDeliveryExpenses.Text = t.TasimaUcretiNotu;
}
this.xrTotals.Summary.FormatString = currencyFormatCustom;
}
catch (Exception ex)
{
Commons.Status(Commons.GetErrorCode("RFR", 1) + ex.Message);
}
finally
{
Commons.Loaded();
}
}
public xrpTeklifFormuFiyatsiz(Teklif p, FormType ft)
{
InitializeComponent();
try
{
if (Commons.ExpariedDay <= 10)
{
this.Watermark.Text = "CREATED BY TRIAL VERSION!";
}
else
{
this.Watermark.Text = string.Empty;
}
Commons.Loading("Belge hazırlanıyor. ..");
foreach (XRControl item in this.reportHeaderBand1.Controls)
{
switch (BAYMYO.UI.Converts.NullToString(item.Tag))
{
case "T":
item.BorderColor = Commons.HEADER_BORDERCOLOR;
item.ForeColor = Commons.HEADER_DESCCOLOR;
break;
case "TC":
item.BackColor = Commons.HEADER_BACKCOLOR;
item.BorderColor = Commons.HEADER_BORDERCOLOR;
item.ForeColor = Commons.HEADER_TITLECOLOR;
break;
}
}
if (Commons.AppSettings.IS_IMAGE_HEADER)
{
this.reportHeaderBand1.HeightF = 290f;
foreach (XRControl item in this.reportHeaderBand1.Controls)
{
switch (BAYMYO.UI.Converts.NullToString(item.Tag))
{
case "T":
case "TC":
item.LocationFloat = new DevExpress.Utils.PointFloat(item.LocationF.X, item.LocationF.Y + 53);
break;
case "V":
item.Visible = false;
break;
}
}
this.xrLogo.Image = Commons.HeaderImage;
this.xrLogo.WidthF = 788f;
this.xrLogo.HeightF = 200f;
}
else
{
this.xrLogo.Image = Commons.LogoCompany;
this.xrOtherLogos.Image = Commons.LogoOther;
this.xrTitle.ForeColor = this.xrSubTitle.ForeColor = Commons.COMPANY_FORECOLOR;
this.xrDesc_TR.BackColor = Commons.DESC_TR_BACKCOLOR;
this.xrDesc_TR.ForeColor = Commons.DESC_TR_FORECOLOR;
this.xrDesc_EN.BackColor = Commons.DESC_EN_BACKCOLOR;
this.xrDesc_EN.ForeColor = Commons.DESC_EN_FORECOLOR;
this.xrHeaderTitle.Text = Commons.AppSettings.HEADER_TITLE;
this.xrDesc_TR.Text = Commons.AppSettings.DESC_TR;
this.xrDesc_EN.Text = Commons.AppSettings.DESC_EN;
this.xrOfficePhone.Text = Commons.AppSettings.OFISPHONE;
this.xrFax.Text = Commons.AppSettings.FAX;
this.xrGsm.Text = Commons.AppSettings.GSM;
this.xrAddress.Text = Commons.AppSettings.ADDRESS;
this.xrMail.Text = Commons.AppSettings.MAIL;
this.xrWeb.Text = Commons.AppSettings.WEB;
}
this.t = p;
switch (ft)
{
case FormType.Offer:
this.DisplayName = t.GemiAdi.Replace("/", "").Replace("\\", "") + " - " + L.TeklifVermeTutanagi + " (2) - " + t.Tarih.ToString("yyyy-MM-dd");
this.xrFormTitle.Text = "TEKLİF VERME TUTANAĞI / DOCUMENT OF OFFER";
this.xrFormRevNo.Text = Commons.AppSettings.TEKLIF_VERME_FORMU;
this.xrPayment.Text = "PAYMENT: " + t.OdemeSekli;
this.xrDelivery.Text = "DELIVERY: " + t.TeslimSuresi;
this.xrNote.Text = "NOTE: " + t.Aciklama;
break;
case FormType.Delivery:
this.DisplayName = t.GemiAdi.Replace("/", "").Replace("\\", "") + " - " + L.TeslimVermeTutanagi + " (2) - " + t.Tarih.ToString("yyyy-MM-dd");
this.xrFormTitle.Text = "MAZLEME TESLİM TUTANAĞI / DOCUMENT OF DELIVERY";
this.xrFormRevNo.Text = Commons.AppSettings.MALZEME_TESLIM_FORMU;
this.xrPayment.Dispose();
this.xrDelivery.Dispose();
this.xrNote.Dispose();
this.xrFormRevNo.LocationFloat = new DevExpress.Utils.PointFloat(9.999935F, 9.999974F);
this.xrReferans.LocationFloat = new DevExpress.Utils.PointFloat(406.1256F, 9.999974F);
this.ReportFooter.HeightF = 35F;
break;
}
this.xrReferans.Text = "Reference Number: " + t.ID;
this.xrGemiAdi.Text = t.GemiAdi;
this.xrBaglamaLimani.Text = t.BaglamaLimani;
this.xrAcenta.Text = t.Acenta;
this.xrFirma.Text = t.Manager;
this.xrTarih.Text = t.GuncellemeTarihi.ToShortDateString();
this.xrParaBirimi.Text = Commons.CurrencySelected(t.ParaBirimi);
this.xrKdv.Text = Commons.GetTax(t.Kdv);
this.xrHazirlayan.Text = t.Hazirlayan;
}
catch (Exception ex)
{
Commons.Status(Commons.GetErrorCode("RFR", 2) + ex.Message);
}
finally
{
Commons.Loaded();
}
}
public void Remove(Teklif obj)
{
this.List.Remove(obj);
}
public int IndexOf(Teklif obj)
{
return(this.List.IndexOf(obj));
}
public bool Contains(Teklif obj)
{
return(this.List.Contains(obj));
}
public void Insert(int index, Teklif obj)
{
this.List.Insert(index, obj);
}
public int Add(Teklif obj)
{
return(this.List.Add(obj));
}
public xrpTeklifFatura(Teklif t, float grandTotal, float taxTotal, float discount, float discountTotal)
{
InitializeComponent();
try
{
if (Commons.ExpariedDay <= 10)
{
this.Watermark.Text = "CREATED BY TRIAL VERSION!";
}
else
{
this.Watermark.Text = string.Empty;
}
this.DisplayName = t.GemiAdi.Replace("/", "").Replace("\\", "") + " - " + L.Fatura + " - " + t.Tarih.ToString("yyyy-MM-dd");
this.xrLogo.Image = Commons.HeaderFactura;
string
currencyFormat = Commons.Kur0Format,
currencyCode = Commons.Kur0Code;
switch (t.ParaBirimi)
{
case "KUR1":
currencyFormat = Commons.Kur1Format;
currencyCode = Commons.Kur1Code;
this.xrBirimFiyat.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
new DevExpress.XtraReports.UI.XRBinding("Text", null, "BirimFiyat", Commons.Kur1FormatCustom)
});
this.xrTutar.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
new DevExpress.XtraReports.UI.XRBinding("Text", null, "Tutar", Commons.Kur1FormatCustom)
});
break;
case "KUR2":
currencyFormat = Commons.Kur2Format;
currencyCode = Commons.Kur2Code;
this.xrBirimFiyat.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
new DevExpress.XtraReports.UI.XRBinding("Text", null, "BirimFiyat", Commons.Kur2FormatCustom)
});
this.xrTutar.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
new DevExpress.XtraReports.UI.XRBinding("Text", null, "Tutar", Commons.Kur2FormatCustom)
});
break;
default:
this.xrBirimFiyat.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
new DevExpress.XtraReports.UI.XRBinding("Text", null, "BirimFiyat", Commons.Kur0FormatCustom)
});
this.xrTutar.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
new DevExpress.XtraReports.UI.XRBinding("Text", null, "Tutar", Commons.Kur0FormatCustom)
});
break;
}
switch (currencyCode)
{
case "TRY":
this.xrYaziylaTutar.Text = "Yalnız: " + Commons.NumberToText(grandTotal + taxTotal);
break;
case "EUR":
this.xrYaziylaTutar.Text = "Single: " + Commons.NumberToDeutchText(grandTotal + taxTotal);
break;
default:
this.xrYaziylaTutar.Text = "Single: " + Commons.NumberToEnglishText(grandTotal + taxTotal);
break;
}
if (discountTotal <= 0)
{
this.ghGrandTotal.Visible = this.xrGenelToplam.Visible = false;
this.ghDicount.Text = this.ghSubTotal.Text;
this.ghSubTotal.Text = this.ghTax.Text;
this.ghTax.Text = this.ghGrandTotal.Text;
this.xrIskonto.Text = grandTotal.ToString(currencyFormat);
this.xrAraToplam.Text = taxTotal.ToString(currencyFormat);
this.xrKdv.Text = (grandTotal + taxTotal).ToString(currencyFormat);
}
else
{
this.ghDicount.Text = "İSKONTO " + discount.ToString("%##0");
this.xrIskonto.Text = discountTotal.ToString(currencyFormat);
this.xrAraToplam.Text = (grandTotal).ToString(currencyFormat);
this.xrKdv.Text = taxTotal.ToString(currencyFormat);
this.xrGenelToplam.Text = (grandTotal + taxTotal).ToString(currencyFormat);
}
}
catch (Exception ex)
{
Commons.Status(Commons.GetErrorCode("RFT", 1) + ex.Message);
}
}
