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); } }