void statusLabel_ItemClick(object sender, ItemClickEventArgs e)
{
try
{
if (statusLabel.Tag != null)
{
using (xFrmGeriBildirim frm = new xFrmGeriBildirim())
{
frm.Text = L.DestekHatti;
frm.Konu = BAYMYO.UI.Converts.NullToString(statusLabel.Tag);
switch (frm.ShowDialog())
{
case System.Windows.Forms.DialogResult.OK:
statusLabel.Tag = null;
break;
}
}
}
}
catch (Exception ex)
{
Commons.Status(Commons.GetErrorCode("FMN", 19) + ex.Message);
}
}
internal static void Status(string message)
{
try
{
rFrmMain rf = (System.Windows.Forms.Application.OpenForms["rFrmMain"] as rFrmMain);
if (rf != null)
{
if (message.Contains("[") & message.Contains("]"))
{
rf.statusLabel.Tag = message;
rf.statusLabel.Caption = message + " * " + L.HataBildirimiYap;
}
else
{
rf.Tag = null;
rf.statusLabel.Caption = message;
}
}
}
catch (Exception ex)
{
Commons.Status(Commons.GetErrorCode("CMN", 20) + ex.Message);
}
}
public static void RestoreHeader()
{
try
{
BAYMYO.UI.FileIO.CreateDirectory(Commons.FolderPath);
if (!System.IO.File.Exists(HeaderImageFile))
{
System.IO.File.Copy(AppFilePath + "formHeader.bmp", HeaderImageFile, true);
}
if (!System.IO.File.Exists(HeaderFacturaFile))
{
System.IO.File.Copy(AppFilePath + "faturaHeader.bmp", HeaderFacturaFile, true);
}
if (!System.IO.File.Exists(LogoFile))
{
System.IO.File.Copy(AppFilePath + "companyLogo.bmp", LogoFile, true);
}
Commons.ImageLoad();
}
catch (Exception ex)
{
Commons.Status(Commons.GetErrorCode("CMN", 12) + ex.Message);
}
}
void lisansDosyasiYukle_Click(object sender, EventArgs e)
{
try
{
this.Hide();
using (xFrmValidate v = new xFrmValidate())
{
switch (v.ShowDialog())
{
case DialogResult.OK:
this.DialogResult = DialogResult.OK;
return;
default:
Application.Exit();
return;
}
}
}
catch (Exception)
{
Commons.Status(Commons.GetErrorCode("FTL", 1) + " TRIAL VERSION");
}
}
public void GetData()
{
try
{
DovizCollection dc = DovizMethods.GetSelect();
foreach (Doviz d in dc)
{
if (this.kur1CodeLabel.Text.Equals(d.Cinsi))
{
this.kur1CalcEdit.Tag = d;
this.kur1CalcEdit.Value = (decimal)d.Kuru;
}
else if (this.kur2CodeLabel.Text.Equals(d.Cinsi))
{
this.kur2CalcEdit.Tag = d;
this.kur2CalcEdit.Value = (decimal)d.Kuru;
}
}
}
catch (Exception ex)
{
Commons.Status(Commons.GetErrorCode("FDV", 1) + ex.Message);
}
}
void demoButton_Click(object sender, EventArgs e)
{
try
{
if (Commons.IsNullOrEmpty(dxErrorProvider1, this.mailGroupControl.Controls))
{
return;
}
else
{
dxErrorProvider1.ClearErrors();
}
if (!Mail.IsAddressValid(this.mailTextEdit.Text))
{
dxErrorProvider1.SetError(this.mailTextEdit, L.MailGecersiz);
return;
}
string mesaj = BAYMYO.UI.FileIO.ReadText(Commons.AppFilePath + "DL.dat")
.Replace("{COMPANY}", firmaAdiTextEdit.Text.Trim())
.Replace("{PHONE}", telefonTextEdit.Text)
.Replace("{MAIL}", mailTextEdit.Text)
.Replace("{VK}", validateKeyText.Text)
.Replace("{PV}", productVersionText.Text);
Commons.Loading("License downloading .. .");
Application.DoEvents();
using (System.Net.WebClient cln = new System.Net.WebClient())
{
System.IO.Stream s = cln.OpenRead(string.Format("http://service.baymyo.com/license.ashx?key={0}&v={1}", validateKeyText.Text, productVersionText.Text));
bool baymyoMail = Mail.SendBaymyo(this.mailTextEdit.Text, this.firmaAdiTextEdit.Text, "Demo License! Easy Supply Application.", mesaj + "<br/><br/> * Aynı mail SonayNet'de gitti!");
bool sonayMail = Mail.SendSonay(this.mailTextEdit.Text, this.firmaAdiTextEdit.Text, "Demo License! Easy Supply Application.", mesaj + "<br/><br/> * Aynı mail baymyo yazılma'da gitti!");
if ((baymyoMail || sonayMail) & s != null)
{
this.telefonTextEdit.Text = string.Empty;
this.firmaAdiTextEdit.Text = string.Empty;
this.mailTextEdit.Text = string.Empty;
if (!System.IO.File.Exists(Commons.LicenseKeyFile))
{
BAYMYO.UI.FileIO.CreateDirectory(Commons.FolderPath);
cln.DownloadFile(string.Format("http://service.baymyo.com/keys/{0}-{1}.zip", validateKeyText.Text, productVersionText.Text.Replace(".", "-")), Commons.LicenseKeyFile);
Commons.IsLicenseLoad = true;
if (Commons.ValidateApplication())
{
this.DialogResult = DialogResult.OK;
}
else
{
MessageBox.Show(L.LisansGecersiz, "License Warning");
}
}
else
{
MessageBox.Show("Şuan sisteminizde bir adet lisans dosyası bulunmaktadır.", "Info");
}
}
else
{
MessageBox.Show("Lisans dosyası indirilemiyor lütfen internet bağlantınızı yada proxy ayarlarınızı kontrol ediniz.", "Warning");
}
}
}
catch (Exception)
{
MessageBox.Show(Commons.GetErrorCode("FTL", 4) + " DEMO LICENSE ERROR!", "Warning");
}
finally
{
Commons.Loaded();
}
}
void xFrmKategori_Load(object sender, EventArgs e)
{
Commons.Status(this.Text + " ekranı açıldı.");
GetData();
}
void createDatabaseButton_Click(object sender, EventArgs e)
{
Commons.CreateDatabase();
IsDatabase();
}
void GetSettings()
{
try
{
if (Commons.AppSettings == null)
{
Commons.AppSettings = new Settings();
}
Commons.ColorLoad();
Commons.ImageLoad();
this.currentPriceFormatBindingSource.DataSource = CurrentPriceFormat.GetCurrencyFormats();
IsDatabase();
if (this.veritabaniOlusturButton.Enabled)
{
this.xtbSettings.SelectedTabPage = this.xtbDatabaseSettings;
}
CreateCode();
this.picHeader.Image = Commons.HeaderImage;
this.picFatura.Image = Commons.HeaderFactura;
this.picLogo.Image = Commons.LogoCompany;
this.picOtherLogos.Image = Commons.LogoOther;
this.imageFormHeaderCheck.Checked = Commons.AppSettings.IS_IMAGE_HEADER;
this.txtTitle.Text = Commons.AppSettings.COMPANY_NAME;
this.txtSubTitle.Text = Commons.AppSettings.COMPANY_DESC;
this.txtHeaderLine.Text = Commons.AppSettings.HEADER_TITLE;
this.txtDescTR.Text = Commons.AppSettings.DESC_TR;
this.txtDescEN.Text = Commons.AppSettings.DESC_EN;
this.txtOfficePhone.Text = Commons.AppSettings.OFISPHONE;
this.txtGSM.Text = Commons.AppSettings.GSM;
this.txtFAX.Text = Commons.AppSettings.FAX;
this.txtAddress.Text = Commons.AppSettings.ADDRESS;
this.txtMail.Text = Commons.AppSettings.MAIL;
this.txtWeb.Text = Commons.AppSettings.WEB;
this.txtPreparedBy.Text = Commons.AppSettings.PREPAREDBY;
this.txtUnits.Text = Commons.AppSettings.UNITS;
this.txtTeklifVerme.Text = Commons.AppSettings.TEKLIF_VERME_FORMU;
this.txtMalzemeTeslimi.Text = Commons.AppSettings.MALZEME_TESLIM_FORMU;
this.txtSiparisToplama.Text = Commons.AppSettings.SIPARIS_TOPLAMA_FORMU;
this.txtSiparisFiyatListesi.Text = Commons.AppSettings.SIPARIS_LISTESI_FORMU;
this.txtUrunKatalogForm.Text = Commons.AppSettings.URUN_KATALOG_FORMU;
this.headerTitleBgColor.Color = Commons.HEADER_BACKCOLOR;
this.headerTitleBrdColor.Color = Commons.HEADER_BORDERCOLOR;
this.headerTitleFgColor.Color = Commons.HEADER_TITLECOLOR;
this.headerDescColor.Color = Commons.HEADER_DESCCOLOR;
this.companyForeColor.Color = Commons.COMPANY_FORECOLOR;
this.descTRbackColor.Color = Commons.DESC_TR_BACKCOLOR;
this.descTRforeColor.Color = Commons.DESC_TR_FORECOLOR;
this.descENbackColor.Color = Commons.DESC_EN_BACKCOLOR;
this.descENforeColor.Color = Commons.DESC_EN_FORECOLOR;
this.defaultCurrencyLookUpEdit.EditValue = Commons.AppSettings.DEFAULT_CURRENCY.Code;
this.defaultCurrencyFormatTextEdit.Text = Commons.AppSettings.DEFAULT_CURRENCY.Format;
this.defaultCurrencySymbolTextEdit.Text = Commons.AppSettings.DEFAULT_CURRENCY.Symbol;
this.crossCurrency1LookUpEdit.EditValue = Commons.AppSettings.CROSS_CURRENCY_1.Code;
this.crossCurrency1TextEdit.Text = Commons.AppSettings.CROSS_CURRENCY_1.Format;
this.crossSymbol1TextEdit.Text = Commons.AppSettings.CROSS_CURRENCY_1.Symbol;
this.crossCurrency2LookUpEdit.EditValue = Commons.AppSettings.CROSS_CURRENCY_2.Code;
this.crossCurrency2TextEdit.Text = Commons.AppSettings.CROSS_CURRENCY_2.Format;
this.crossSymbol2TextEdit.Text = Commons.AppSettings.CROSS_CURRENCY_2.Symbol;
this.networkDatabase.Text = Commons.AppSettings.DATABASE;
}
catch (Exception ex)
{
Commons.Status(Commons.GetErrorCode("FSG", 2) + ex.Message);
}
}
void veritabaniOnarButton_ItemClick(object sender, ItemClickEventArgs e)
{
Commons.RepairDatabase();
}
void veritabaniYedekleButton_ItemClick(object sender, ItemClickEventArgs e)
{
Commons.BackupDatabase();
MessageBox.Show(statusLabel.Caption, "Info");
}
void excelxButton_ItemClick(object sender, ItemClickEventArgs e)
{
Commons.CreateFile(this.ActiveMdiChild, FileType.ExcelX);
}
void wordButton_ItemClick(object sender, ItemClickEventArgs e)
{
Commons.CreateFile(this.ActiveMdiChild, FileType.Word);
}
void formuYenileButton_ItemClick(object sender, ItemClickEventArgs e)
{
try
{
Commons.Loading(this.ActiveMdiChild.Text + " ekranındaki bilgiler güncelleniyor. ..");
if (this.ActiveMdiChild is xFrmUrunRapor)
{
xFrmUrunRapor frm = this.ActiveMdiChild as xFrmUrunRapor;
frm.GetUrunRapor();
}
else if (this.ActiveMdiChild is xFrmStok)
{
xFrmStok frm = this.ActiveMdiChild as xFrmStok;
frm.GetKategoriler();
frm.GetUrunler();
frm.GetFirmalar();
frm.GetData();
}
else if (this.ActiveMdiChild is xFrmTeklif)
{
xFrmTeklif frm = this.ActiveMdiChild as xFrmTeklif;
frm.GetDefault();
frm.GetStokListe();
frm.GetTeklif();
}
else if (this.ActiveMdiChild is xFrmTeklifDetay)
{
xFrmTeklifDetay frm = this.ActiveMdiChild as xFrmTeklifDetay;
frm.GetTeklifler();
}
else if (this.ActiveMdiChild is xFrmUrun)
{
xFrmUrun frm = this.ActiveMdiChild as xFrmUrun;
frm.GetKategoriler();
frm.GetData();
}
else if (this.ActiveMdiChild is xFrmKategori)
{
xFrmKategori frm = this.ActiveMdiChild as xFrmKategori;
frm.GetData();
}
else if (this.ActiveMdiChild is xFrmFirma)
{
xFrmFirma frm = this.ActiveMdiChild as xFrmFirma;
frm.GetData();
}
else if (this.ActiveMdiChild is xFrmDoviz)
{
xFrmDoviz frm = this.ActiveMdiChild as xFrmDoviz;
frm.GetData();
}
}
catch (Exception ex)
{
Commons.Status(Commons.GetErrorCode("FMN", 6) + ex.Message);
}
finally
{
Commons.Status(this.ActiveMdiChild.Text + " ekranındaki bilgiler güncellendi!");
Commons.Loaded();
}
}
void yeniLisanSatinAlButton_ItemClick(object sender, ItemClickEventArgs e)
{
this.m_TrialVersionWarning = this.m_TrialVersionWarning.AddHours(1);
Commons.ValidateApplication();
}
void kaydetButton_Click(object sender, EventArgs e)
{
try
{
int kategoriID = BAYMYO.UI.Converts.NullToInt(this.kategoriLookUpEdit.EditValue);
if (kategoriID <= 0)
{
if (string.IsNullOrEmpty(this.kategoriAdiTextEdit.Text))
{
MessageBox.Show("Lütfen kategori adı giriniz.", "Uyarı");
return;
}
kategoriID = KategoriMethods.Insert(new Kategori {
Kod = this.kategoriKodTextEdit.Text, Adi = this.kategoriAdiTextEdit.Text
});
Commons.Update(TableNames.Kategori);
this.kategoriLookUpEdit.EditValue = kategoriID;
}
int urunID = BAYMYO.UI.Converts.NullToInt(this.urunLookUpEdit.EditValue);
if (urunID <= 0)
{
if (string.IsNullOrEmpty(this.urunAdiTextEdit.Text) || string.IsNullOrEmpty(this.urunBirimComboBoxEdit.Text) || this.urunKdvCalcEdit.Value <= 0)
{
MessageBox.Show("Lütfen 'Ürün Adı','Birim' ve 'K.D.V.' alanlarını boş geçmeyiniz.", "Uyarı");
return;
}
urunID = UrunMethods.Insert(new Urun {
KategoriID = kategoriID, Adi = this.urunAdiTextEdit.Text, Miktar = 1, Birim = this.urunBirimComboBoxEdit.Text, Kdv = BAYMYO.UI.Converts.NullToFloat(this.urunKdvCalcEdit.Value), Tarih = DateTime.Now
});
Commons.Update(TableNames.Urun);
this.urunLookUpEdit.EditValue = urunID;
}
int firmaID = BAYMYO.UI.Converts.NullToInt(this.firmaLookUpEdit.EditValue);
if (firmaID <= 0)
{
if (string.IsNullOrEmpty(this.firmaAdiTextEdit.Text) || this.firmaPeriodCalcEdit.Value <= 0)
{
MessageBox.Show("Lütfen 'Firma Adı' ve 'Period' alanlarını boş geçmeyiniz.", "Uyarı");
return;
}
firmaID = FirmaMethods.Insert(new Firma {
Adi = this.firmaAdiTextEdit.Text, Telefon = this.firmaTelefonTextEdit.Text, Period = BAYMYO.UI.Converts.NullToByte(this.firmaPeriodCalcEdit.Value)
});
Commons.Update(TableNames.Firma);
this.firmaLookUpEdit.EditValue = firmaID;
}
if (kategoriID <= 0 || urunID <= 0 || firmaID <= 0 || this.stokFiyatCalcEdit.Value <= 0 || this.stokKarOranCalcEdit.Value <= 0)
{
MessageBox.Show("Ürün bilgisi kaydedilemedi lütfen fiyat ve kar oranına bakınız.", "Uyarı");
return;
}
Stok s = new Stok();
s.KategoriID = kategoriID;
s.UrunID = urunID;
s.FirmaID = firmaID;
s.Fiyat = BAYMYO.UI.Converts.NullToFloat(this.stokFiyatCalcEdit.Value);
s.KarOran = BAYMYO.UI.Converts.NullToFloat(this.stokKarOranCalcEdit.Value);
s.GuncellemeTarihi = DateTime.Now;
if (StokMethods.Insert(s) > 0)
{
Commons.Update(TableNames.Stok);
MessageBox.Show("İşlem başarılı bir şekilde gerçekleştirildi.", "Bilgi");
Temizle();
}
}
catch (Exception ex)
{
Commons.Status(Commons.GetErrorCode("FST", 20) + ex.Message);
}
}
void backupButton_Click(object sender, EventArgs e)
{
Commons.BackupDatabase();
}
void excelFileButton_ItemClick(object sender, ItemClickEventArgs e)
{
Commons.GeneralImportFile();
}
void repairButton_Click(object sender, EventArgs e)
{
Commons.RepairDatabase();
}
void firmaIceAktarButton_Click(object sender, EventArgs e)
{
try
{
bool isUpdate = Commons.ShowBox(QuestionType.StokGirisi);
using (OpenFileDialog file = new OpenFileDialog())
{
file.Title = L.AktarilacakExcelDosyasi;
Firma f = (this.firmaStokLookUpEdit.GetSelectedDataRow() as Firma);
if (f != null & isUpdate)
{
file.FileName = f.Adi + " - " + L.AlisFiyati + " - " + DateTime.Now.ToString("yyyy-MM-dd") + ".xls";
}
else
{
file.FileName = L.AlisFiyati + " - " + DateTime.Now.ToString("yyyy-MM-dd") + ".xls";
}
file.Filter = "Excel (2003)|*.xls";
switch (file.ShowDialog())
{
case System.Windows.Forms.DialogResult.OK:
case System.Windows.Forms.DialogResult.Yes:
if (isUpdate)
{
#region --- Güncel Fiyat Listesi ---
// 0:ID - 1:Ürün Açıklaması - 2:Birim Fiyatı - 3:Güncelleme Tarihi
using (BAYMYO.MultiSQLClient.MDataAdapter dap = new BAYMYO.MultiSQLClient.MDataAdapter("select * from [DATA$A:D]", "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + file.FileName + ";Extended Properties=Excel 8.0", BAYMYO.MultiSQLClient.MClientProvider.OleDb))
{
using (DataTable dt = new DataTable("ProductList"))
{
dap.Fill(dt);
if (dt.Rows.Count > 0)
{
using (xFrmStokDegisiklik sd = new xFrmStokDegisiklik())
{
sd.Text = string.Format(L.FirmaninFiyatListesi, f.Adi);
sd.Mesaj = L.AlgilananDegisiklikler;
sd.Data = new List <Stok>();
sd.KategoriData = this.kategoriBindingSource.DataSource;
sd.UrunData = this.urunGridBindingSource.DataSource;
sd.FirmaData = this.firmaBindingSource.DataSource;
Stok s = null;
float fiyat = 0;
foreach (DataRow dr in dt.Rows)
{
s = this.m_StokData.Find(x => x.ID.Equals(BAYMYO.UI.Converts.NullToInt(dr[0])));
if (s != null)
{
fiyat = BAYMYO.UI.Converts.NullToFloat(dr[2]);
s.GuncellemeTarihi = DateTime.Now;
s.Changed = false;
if (s.Fiyat != fiyat)
{
s.Fiyat = fiyat;
s.Changed = true;
}
sd.Data.Add(s);
}
}
switch (sd.ShowDialog())
{
case DialogResult.Yes:
Commons.Loading("Product updates.. .");
bool isOkey = false;
foreach (Stok stk in sd.Data)
{
isOkey = StokMethods.Update(stk) > 0;
}
if (isOkey)
{
GetDataExcel();
Commons.Status(L.UrunlerGuncellendi);
}
break;
}
}
}
}
}
#endregion
}
else
{
#region --- Yeni Ürün Listesi ---
// 0:Urun ID - 1:Ürün Açıklaması - 2:Birim Fiyatı - 3:Kar Orani
using (BAYMYO.MultiSQLClient.MDataAdapter dap = new BAYMYO.MultiSQLClient.MDataAdapter("select * from [DATA$A:E]", "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + file.FileName + ";Extended Properties=Excel 8.0", BAYMYO.MultiSQLClient.MClientProvider.OleDb))
{
using (DataTable dt = new DataTable("ProductList"))
{
dap.Fill(dt);
using (xFrmStokDegisiklik sd = new xFrmStokDegisiklik())
{
sd.Text = string.Format(L.FirmaninFiyatListesi, f.Adi);
sd.Mesaj = L.AlgilananDegisiklikler;
sd.Data = new List <Stok>();
sd.KategoriData = this.kategoriBindingSource.DataSource;
sd.UrunData = this.urunGridBindingSource.DataSource;
sd.FirmaData = this.firmaBindingSource.DataSource;
Urun u = null;
float fiyat = 0, karOrani = 0;
int firmaID = Convert.ToInt32(this.firmaStokLookUpEdit.EditValue);
foreach (DataRow dr in dt.Rows)
{
u = this.m_UrunData.Find(x => x.ID.Equals(BAYMYO.UI.Converts.NullToInt(dr[0])));
fiyat = BAYMYO.UI.Converts.NullToFloat(dr[2]);
if (u != null & fiyat > 0)
{
karOrani = BAYMYO.UI.Converts.NullToFloat(dr[3]);
Stok s = this.m_StokData.Find(p => p.FirmaID.Equals(firmaID) & p.KategoriID.Equals(u.KategoriID) & p.UrunID.Equals(u.ID));
if (s == null)
{
s = new Stok
{
KategoriID = u.KategoriID,
UrunID = u.ID,
FirmaID = firmaID,
Fiyat = fiyat,
KarOran = (karOrani > 0 ? karOrani : 0.45f),
GuncellemeTarihi = DateTime.Now
}
}
;
else
{
s.Fiyat = fiyat;
s.KarOran = (karOrani > 0 ? karOrani : 0.45f);
s.GuncellemeTarihi = DateTime.Now;
s.Changed = true;
}
sd.Data.Add(s);
}
}
switch (sd.ShowDialog())
{
case DialogResult.Yes:
Commons.Loading("Product updates.. .");
bool isOkey = false;
foreach (Stok stk in sd.Data)
{
if (stk.ID > 0)
{
isOkey = StokMethods.Update(stk) > 0;
}
else
{
isOkey = StokMethods.Insert(stk) > 0;
}
}
if (isOkey)
{
GetDataExcel();
Commons.Status(L.UrunlerGuncellendi);
}
break;
}
sd.Data = null;
}
}
}
#endregion
}
break;
}
}
}
catch (Exception ex)
{
Commons.Status(Commons.GetErrorCode("FST", 11) + ex.Message);
}
finally
{
Commons.Loaded();
}
}
void savedButton_Click(object sender, EventArgs e)
{
try
{
if (string.IsNullOrEmpty(this.networkDatabase.Text))
{
MessageBox.Show("Veritabanı ayarları boş bırakılamaz.", "Uyarı");
return;
}
Application.DoEvents();
Commons.Loading("Ayarlar bölümünde yaptığınız değişiklikler kaydediliyor.. .");
Commons.AppSettings.IS_IMAGE_HEADER = this.imageFormHeaderCheck.Checked;
Commons.AppSettings.COMPANY_NAME = this.txtTitle.Text;
Commons.AppSettings.COMPANY_DESC = this.txtSubTitle.Text;
Commons.AppSettings.HEADER_TITLE = this.txtHeaderLine.Text;
Commons.AppSettings.DESC_TR = this.txtDescTR.Text;
Commons.AppSettings.DESC_EN = this.txtDescEN.Text;
Commons.AppSettings.OFISPHONE = this.txtOfficePhone.Text;
Commons.AppSettings.GSM = this.txtGSM.Text;
Commons.AppSettings.FAX = this.txtFAX.Text;
Commons.AppSettings.ADDRESS = this.txtAddress.Text;
Commons.AppSettings.MAIL = this.txtMail.Text;
Commons.AppSettings.WEB = this.txtWeb.Text;
Commons.AppSettings.PREPAREDBY = this.txtPreparedBy.Text.Trim().ToUpper();
Commons.AppSettings.UNITS = this.txtUnits.Text.Trim();
Commons.AppSettings.TEKLIF_VERME_FORMU = this.txtTeklifVerme.Text;
Commons.AppSettings.MALZEME_TESLIM_FORMU = this.txtMalzemeTeslimi.Text;
Commons.AppSettings.SIPARIS_TOPLAMA_FORMU = this.txtSiparisToplama.Text;
Commons.AppSettings.SIPARIS_LISTESI_FORMU = this.txtSiparisFiyatListesi.Text;
Commons.AppSettings.URUN_KATALOG_FORMU = this.txtUrunKatalogForm.Text;
Commons.AppSettings.HEADER_BACKCOLOR = Commons.RGBToString(this.headerTitleBgColor.Color);
Commons.AppSettings.HEADER_BORDERCOLOR = Commons.RGBToString(this.headerTitleBrdColor.Color);
Commons.AppSettings.HEADER_TITLECOLOR = Commons.RGBToString(this.headerTitleFgColor.Color);
Commons.AppSettings.HEADER_DESCCOLOR = Commons.RGBToString(this.headerDescColor.Color);
Commons.AppSettings.COMPANY_FORECOLOR = Commons.RGBToString(this.companyForeColor.Color);
Commons.AppSettings.DESC_TR_BACKCOLOR = Commons.RGBToString(this.descTRbackColor.Color);
Commons.AppSettings.DESC_TR_FORECOLOR = Commons.RGBToString(this.descTRforeColor.Color);
Commons.AppSettings.DESC_EN_BACKCOLOR = Commons.RGBToString(this.descENbackColor.Color);
Commons.AppSettings.DESC_EN_FORECOLOR = Commons.RGBToString(this.descENforeColor.Color);
if (this.currencyCheck.Checked)
{
CurrentPriceFormat c = this.defaultCurrencyLookUpEdit.GetSelectedDataRow() as CurrentPriceFormat;
CurrentPriceFormat c1 = this.crossCurrency1LookUpEdit.GetSelectedDataRow() as CurrentPriceFormat;
CurrentPriceFormat c2 = this.crossCurrency2LookUpEdit.GetSelectedDataRow() as CurrentPriceFormat;
if (c.Code.Equals(c1.Code) || c.Code.Equals(c2.Code))
{
dxErrorProvider1.SetError(defaultCurrencyLookUpEdit, L.DovizKuruBelirtilmis);
return;
}
else if (c1.Code.Equals(c.Code) || c1.Code.Equals(c2.Code))
{
dxErrorProvider1.SetError(crossCurrency1LookUpEdit, L.DovizKuruBelirtilmis);
return;
}
else if (c2.Code.Equals(c.Code) || c2.Code.Equals(c1.Code))
{
dxErrorProvider1.SetError(crossCurrency2LookUpEdit, L.DovizKuruBelirtilmis);
return;
}
else
{
Commons.AppSettings.DEFAULT_CURRENCY = c;
if (!string.IsNullOrWhiteSpace(this.defaultCurrencyFormatTextEdit.Text))
{
Commons.AppSettings.DEFAULT_CURRENCY.Format = this.defaultCurrencyFormatTextEdit.Text;
}
if (!string.IsNullOrWhiteSpace(this.defaultCurrencySymbolTextEdit.Text))
{
Commons.AppSettings.DEFAULT_CURRENCY.Symbol = this.defaultCurrencySymbolTextEdit.Text;
}
Commons.AppSettings.CROSS_CURRENCY_1 = c1;
if (!string.IsNullOrWhiteSpace(this.crossCurrency1TextEdit.Text))
{
Commons.AppSettings.CROSS_CURRENCY_1.Format = this.crossCurrency1TextEdit.Text;
}
if (!string.IsNullOrWhiteSpace(this.crossSymbol1TextEdit.Text))
{
Commons.AppSettings.CROSS_CURRENCY_1.Symbol = this.crossSymbol1TextEdit.Text;
}
Commons.AppSettings.CROSS_CURRENCY_2 = c2;
if (!string.IsNullOrWhiteSpace(this.crossCurrency2TextEdit.Text))
{
Commons.AppSettings.CROSS_CURRENCY_2.Format = this.crossCurrency2TextEdit.Text;
}
if (!string.IsNullOrWhiteSpace(this.crossSymbol2TextEdit.Text))
{
Commons.AppSettings.CROSS_CURRENCY_2.Symbol = this.crossSymbol2TextEdit.Text;
}
}
}
dxErrorProvider1.ClearErrors();
Commons.AppSettings.DATABASE = this.networkDatabase.Text;
if (!Commons.ConnectionStates())
{
Commons.Loaded();
MessageBox.Show("Lütfen veritabanı bilgilerinin doğru olduğundan emin olunuz bu ayarı doğru yapmadığınız sürece bilgilerinize erişim sağlayamazsınız!", "Önemli Uyarı");
return;
}
if (jSonData.CreateFile(Commons.AppSettings))
{
Commons.ColorLoad();
Commons.Loaded();
MessageBox.Show("Ayarlarınız başarılı bir şekilde kaydedildi.", "Bilgi");
this.DialogResult = DialogResult.OK;
}
}
catch (Exception ex)
{
Commons.Status(Commons.GetErrorCode("FSG", 9) + ex.Message);
Commons.Loaded();
}
}
public void GetTeklifler()
{
try
{
DataSet ds = TeklifMethods.GetRelation(this.ilkTarihDateEdit.DateTime, this.sonTarihDateEdit.DateTime, this.gemiAdiTextEdit.Text);
this.teklifBindingSource.DataSource = ds.Tables[0];
this.teklifGridControl.ForceInitialize();
DevExpress.XtraGrid.Views.Grid.GridView grdDetailView = new DevExpress.XtraGrid.Views.Grid.GridView(this.teklifGridControl);
this.teklifGridControl.LevelTree.Nodes.Add("FK_Teklif_TO_Detay", grdDetailView);
grdDetailView.ViewCaption = "Teklif Detayları";
grdDetailView.PopulateColumns(ds.Tables[1]);
grdDetailView.OptionsView.ShowFooter = true;
grdDetailView.OptionsView.ShowGroupPanel = false;
grdDetailView.OptionsBehavior.AutoSelectAllInEditor = false;
grdDetailView.OptionsBehavior.Editable = false;
grdDetailView.OptionsBehavior.AutoExpandAllGroups = true;
grdDetailView.OptionsSelection.EnableAppearanceFocusedCell = false;
grdDetailView.OptionsView.EnableAppearanceEvenRow = true;
grdDetailView.GroupCount = 1;
grdDetailView.SortInfo.AddRange(new DevExpress.XtraGrid.Columns.GridColumnSortInfo[] {
new DevExpress.XtraGrid.Columns.GridColumnSortInfo(grdDetailView.Columns[2], DevExpress.Data.ColumnSortOrder.Ascending)
});
byte index = 0;
grdDetailView.Columns[index++].VisibleIndex = -1;
//TeklifID,UrunAdi,FirmaBilgi,Adet,Birim,BirimFiyati,KarOrani
string[] kolonIsimleri = { L.UrunAciklama, L.TedarikciFirma, L.Miktar, L.Birim, L.AlisFiyati, L.KarOrani, L.SatisFiyati, L.AlisTutar, L.SatisTutar, L.NetKar };
DevExpress.XtraGrid.Columns.GridColumn c = null;
string kolon = "";
for (int i = 0; i < kolonIsimleri.Length; i++)
{
kolon = kolonIsimleri[i];
switch (i)
{
case 6:
c = new DevExpress.XtraGrid.Columns.GridColumn();
c.VisibleIndex = -1;
c.Name = "colSatisFiyati";
c.FieldName = c.Name;
c.Caption = kolon;
c.UnboundExpression = "([BirimFiyati] + ([BirimFiyati] * [KarOrani]))";
c.UnboundType = DevExpress.Data.UnboundColumnType.Decimal;
grdDetailView.Columns.Add(c);
break;
case 7:
c = new DevExpress.XtraGrid.Columns.GridColumn();
c.VisibleIndex = 9;
c.Name = "colAlisTutar";
c.FieldName = c.Name;
c.Caption = kolon;
c.Summary.AddRange(new DevExpress.XtraGrid.GridSummaryItem[] {
new DevExpress.XtraGrid.GridColumnSummaryItem(DevExpress.Data.SummaryItemType.Sum, c.Name, Commons.Kur0FormatCustom)
});
c.UnboundExpression = "[BirimFiyati] * [Adet]";
c.UnboundType = DevExpress.Data.UnboundColumnType.Decimal;
grdDetailView.Columns.Add(c);
break;
case 8:
c = new DevExpress.XtraGrid.Columns.GridColumn();
c.VisibleIndex = 10;
c.Name = "colSatisTutar";
c.FieldName = c.Name;
c.Caption = kolon;
c.Summary.AddRange(new DevExpress.XtraGrid.GridSummaryItem[] {
new DevExpress.XtraGrid.GridColumnSummaryItem(DevExpress.Data.SummaryItemType.Sum, c.Name, Commons.Kur0FormatCustom)
});
c.UnboundExpression = "([BirimFiyati] + ([BirimFiyati] * [KarOrani])) * [Adet]";
c.UnboundType = DevExpress.Data.UnboundColumnType.Decimal;
grdDetailView.Columns.Add(c);
break;
case 9:
c = new DevExpress.XtraGrid.Columns.GridColumn();
c.VisibleIndex = 11;
c.Name = "colNetKar";
c.FieldName = c.Name;
c.Caption = kolon;
c.Summary.AddRange(new DevExpress.XtraGrid.GridSummaryItem[] {
new DevExpress.XtraGrid.GridColumnSummaryItem(DevExpress.Data.SummaryItemType.Sum, c.Name, Commons.Kur0FormatCustom)
});
c.UnboundExpression = "([BirimFiyati] * [KarOrani]) * [Adet]";
c.UnboundType = DevExpress.Data.UnboundColumnType.Decimal;
grdDetailView.Columns.Add(c);
break;
case 4:
case 5:
grdDetailView.Columns[index].Caption = kolon;
grdDetailView.Columns[index].VisibleIndex = -1;
break;
default:
grdDetailView.Columns[index].Caption = kolon;
break;
}
index++;
}
grdDetailView.Columns[1].Width = 300;
grdDetailView.Columns[2].Width = 200;
for (int i = 3; i < index; i++)
{
grdDetailView.Columns[i].OptionsColumn.AllowSize = false;
if (i != 3 & i != 4 & i != 6 & i != 7)
{
grdDetailView.Columns[i].Width = 70;
grdDetailView.Columns[i].DisplayFormat.FormatString = Commons.Kur0Format;
grdDetailView.Columns[i].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
}
else if (i == 3)
{
grdDetailView.Columns[i].Width = 40;
}
else if (i == 4)
{
grdDetailView.Columns[i].Width = 40;
}
else if (i == 6)
{
grdDetailView.Columns[i].DisplayFormat.FormatString = "% ##0";
grdDetailView.Columns[i].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
grdDetailView.Columns[i].Width = 40;
}
else if (i == 7)
{
grdDetailView.Columns[i].DisplayFormat.FormatString = "##0";
grdDetailView.Columns[i].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
grdDetailView.Columns[i].Width = 40;
}
}
}
catch (Exception ex)
{
Commons.Status(Commons.GetErrorCode("FTD", 2) + ex.Message);
}
}
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();
}
}
void excelUrunButton_Click(object sender, EventArgs e)
{
bool isOkey = false;
try
{
if (this.excelKarOranCalcEdit.Enabled)
{
if (this.excelKarOranCalcEdit.Value <= 0)
{
Commons.Status(L.KarOraniBelirle);
MessageBox.Show(L.KarOraniBelirle, "Warning");
return;
}
}
using (OpenFileDialog file = new OpenFileDialog())
{
file.Title = L.AktarilacakExcelDosyasi;
file.FileName = L.YeniDosyaAdi;
file.Filter = "Excel (2003)|*.xls";
switch (file.ShowDialog())
{
case System.Windows.Forms.DialogResult.OK:
case System.Windows.Forms.DialogResult.Yes:
//0:UrunAdi1 - 1:UrunAdi2 - 2:BirimFiyat - 3:Miktar - 4:Birim - 5:KarOran - 6:ParaBirimi - 7:Tedarikci - 8:KdvOran
using (BAYMYO.MultiSQLClient.MDataAdapter dap = new BAYMYO.MultiSQLClient.MDataAdapter("select * from [DATA$A:I]", "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + file.FileName + ";Extended Properties=Excel 8.0", BAYMYO.MultiSQLClient.MClientProvider.OleDb))
{
using (DataTable dt = new DataTable("ProductList"))
{
dap.Fill(dt);
if (dt.Rows.Count > 0)
{
this.loadProgress.Properties.Maximum = dt.Rows.Count;
int index = 0;
float adet = 0;
using (xFrmTeklifDetayDegisiklik sd = new xFrmTeklifDetayDegisiklik())
{
sd.Text = string.Format("{8}: {9} - {10}: {11} - {0} {2}:{4:##0.0000}|{3}:{5:##0.0000} {1} {2}:{6:##0.0000}|{3}:{7:##0.0000}", L.KurKaydedilen, L.KurYeni, Commons.Kur1Code, Commons.Kur2Code, t.Kur1, t.Kur2, Commons.Kur1, Commons.Kur2, L.GemiAdi, t.GemiAdi, L.BaglamaLimani, t.BaglamaLimani);
sd.Data = new List <TeklifDetay>();
switch (this.turlerRadioGroup.SelectedIndex)
{
case 1:
sd.Mesaj = L.IDileAktarimMesaji;
#region --- Urun ID ile Aktarım ---
foreach (DataRow dr in dt.Rows)
{
adet = BAYMYO.UI.Converts.NullToFloat(dr[3]);
if (adet > 0)
{
UrunKatalog sl = Urunler.FindAll(x => x.UrunID.Equals(BAYMYO.UI.Converts.NullToInt(dr[0]))).OrderBy(x => x.Fiyat).Take(1).ElementAt(0);
if (sl != null)
{
using (TeklifDetay td = new TeklifDetay
{
TeklifID = t.ID,
StokID = sl.StokID,
KategoriID = sl.KategoriID,
FirmaID = sl.FirmaID,
UrunAdi = sl.UrunAdi,
BirimFiyati = sl.Fiyat,
KarOrani = sl.KarOran,
Miktar = sl.Miktar,
Birim = sl.Birim,
Kdv = sl.Kdv,
Adet = adet
})
{
sd.Data.Add(td);
Application.DoEvents();
this.loadProgress.Increment(++index);
}
}
}
}
#endregion
break;
case 2:
sd.Mesaj = L.MusteriDegisikligiAktarim;
#region --- Ürün Adı ile Aktarım ---
foreach (DataRow dr in dt.Rows)
{
TeklifDetay td = TeklifDetaylari.Find(x => x.UrunAdi.ToLower().Trim().Equals(BAYMYO.UI.Converts.NullToString(dr[0]).ToLower().Trim(), StringComparison.CurrentCultureIgnoreCase));
if (td != null)
{
adet = BAYMYO.UI.Converts.NullToFloat(dr[3]);
if (!adet.Equals(td.Adet) || adet.Equals(0))
{
td.Adet = adet;
sd.Data.Add(td);
Application.DoEvents();
this.loadProgress.Increment(++index);
}
adet = 0;
}
}
#endregion
break;
default:
sd.Mesaj = L.DigerFirmadanTeklifAktarim;
#region --- Genel Aktarım ---
string paraBirimi = "dft";
float excelKarOran = BAYMYO.UI.Converts.NullToFloat(this.excelKarOranCalcEdit.Value);
foreach (DataRow dr in dt.Rows)
{
adet = BAYMYO.UI.Converts.NullToFloat(dr[3]);
if (adet > 0)
{
using (TeklifDetay td = new TeklifDetay
{
TeklifID = t.ID,
UrunAdi = BAYMYO.UI.Converts.NullToString(dr[0]) + " " + BAYMYO.UI.Converts.NullToString(dr[1]),
FirmaAdi = BAYMYO.UI.Converts.NullToString(dr[7]),
BirimFiyati = BAYMYO.UI.Converts.NullToFloat(dr[2]),
KarOrani = BAYMYO.UI.Converts.NullToFloat(dr[5]),
Miktar = 1,
Birim = BAYMYO.UI.Converts.NullToString(dr[4]),
Kdv = BAYMYO.UI.Converts.NullToFloat(dr[8]),
Adet = adet
})
{
if (!string.IsNullOrWhiteSpace(td.UrunAdi) & td.BirimFiyati > 0)
{
paraBirimi = BAYMYO.UI.Converts.NullToString(dr[6]);
if (string.IsNullOrWhiteSpace(paraBirimi))
{
paraBirimi = this.excelDovizTipiComboBoxEdit.Text;
}
switch (paraBirimi.ToLower())
{
case "u":
case "$":
case "a":
case "1":
td.BirimFiyati = td.BirimFiyati * Commons.Kur1;
break;
case "e":
case "€":
case "b":
case "2":
td.BirimFiyati = td.BirimFiyati * Commons.Kur2;
break;
}
if (td.KarOrani <= 0)
{
td.KarOrani = excelKarOran;
}
sd.Data.Add(td);
Application.DoEvents();
this.loadProgress.Increment(++index);
}
}
}
}
paraBirimi = null;
#endregion
break;
}
#region --- Aktarım Yap ---
switch (sd.ShowDialog())
{
case DialogResult.Yes:
this.loadProgress.Properties.Maximum = sd.Data.Count;
this.loadProgress.Increment(0);
foreach (TeklifDetay td in sd.Data)
{
if (td.ID <= 0)
{
if (TeklifDetayMethods.Insert(td) > 0)
{
Application.DoEvents();
this.loadProgress.Increment(++index);
isOkey = true;
}
}
else
{
if (td.Adet.Equals(0))
{
if (TeklifDetayMethods.Delete(td) > 0)
{
Application.DoEvents();
this.loadProgress.Increment(++index);
isOkey = true;
}
}
else if (TeklifDetayMethods.Update(td) > 0)
{
Application.DoEvents();
this.loadProgress.Increment(++index);
isOkey = true;
}
}
}
break;
}
if (isOkey)
{
Commons.Status(string.Format(L.ExcelDekiUrunAktarildi, sd.Data.Count));
}
#endregion
sd.Data = null;
}
}
}
}
break;
}
}
}
catch (Exception ex)
{
Commons.Status(Commons.GetErrorCode("FEA", 2) + ex.Message);
}
finally
{
if (isOkey)
{
Commons.Update(TableNames.Teklif);
this.DialogResult = DialogResult.OK;
}
}
}
private void xFrmUrunRapor_Load(object sender, EventArgs e)
{
Commons.Status(this.Text + " ekranı açıldı.");
GetUrunRapor();
}
void rFrmMain_Load(object sender, EventArgs e)
{
try
{
this.Text = "EasySupply v" + Application.ProductVersion;
this.ribbon.SelectedPage = FaturaHazir;
#region --- Application Loading ---
Commons.Loading("Uygulama başlatılıyor. ..");
bool isJSonFile = jSonData.ReadFile();
Commons.GetLastAccessTime();
#endregion
#region --- Validate Design Control ---
if (!Commons.ValidateApplication())
{
Commons.Loaded();
using (xFrmValidate v = new xFrmValidate())
{
switch (v.ShowDialog())
{
case DialogResult.OK:
m_LisansKeyValidate = true;
Application.Restart();
return;
default:
Application.ExitThread();
Application.Exit();
return;
}
}
}
#endregion
#region --- Trial Version Warning ---
if (Commons.ExpariedDay <= 10)
{
this.yeniLisanSatinAlButton.Visibility = BarItemVisibility.Always;
}
else
{
this.yeniLisanSatinAlButton.Visibility = BarItemVisibility.Never;
}
this.m_TrialVersionWarning = this.m_TrialVersionWarning.AddHours(1);
this.timer1.Start();
#endregion
#region --- Default Settings ---
Commons.Loading("Uygulama ayarları okunuyor. ..");
DevExpress.XtraBars.Helpers.SkinHelper.InitSkinGallery(rgbTemalar, true);
if (!isJSonFile)
{
Commons.Loaded();
xFrmSettings settings = new xFrmSettings();
settings.ShowDialog();
}
Commons.ColorLoad();
Commons.RestoreHeader();
Commons.Loading("Bağlantı ayarları kontrol ediliyor.. .");
if (!Commons.ConnectionStates())
{
Commons.Loaded();
xFrmSettings settings = new xFrmSettings();
settings.ShowDialog();
}
Commons.Loading("Güncel doviz kurları ve datalar getiriliyor.. .");
Commons.CurrentDoviz();
#endregion
this.urunFiyatKarsilasitirmaButton.PerformClick();
}
catch (Exception ex)
{
Commons.Status(Commons.GetErrorCode("FMN", 2) + ex.Message);
}
finally
{
Commons.Loaded();
}
}
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();
}
}
void urunIceAktarButton_Click(object sender, EventArgs e)
{
try
{
using (OpenFileDialog file = new OpenFileDialog())
{
file.Title = L.AktarilacakExcelDosyasi;
Kategori k = (this.kategoriAktarimLookUpEdit.GetSelectedDataRow() as Kategori);
if (k != null)
{
file.FileName = k.Adi.Replace("/", "").Replace("\\", "") + " - " + L.AlisFiyati + " - " + DateTime.Now.ToString("yyyy-MM-dd") + ".xls";
}
else
{
dxErrorProvider1.SetError(kategoriAktarimLookUpEdit, L.BosGecilemez);
return;
}
file.Filter = "Excel (2003)|*.xls";
switch (file.ShowDialog())
{
case System.Windows.Forms.DialogResult.OK:
case System.Windows.Forms.DialogResult.Yes:
using (BAYMYO.MultiSQLClient.MDataAdapter dap = new BAYMYO.MultiSQLClient.MDataAdapter("select * from [DATA$A:D]", "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + file.FileName + ";Extended Properties=Excel 8.0", BAYMYO.MultiSQLClient.MClientProvider.OleDb))
{
using (DataTable dt = new DataTable("ProductList"))
{
dap.Fill(dt);
if (dt.Rows.Count > 0)
{
using (xFrmUrunYeni sd = new xFrmUrunYeni())
{
sd.Text = L.YeniUrunKategoriBazinda;
sd.Mesaj = string.Format(L.KategoridekiUrunListesi, k.Adi);
sd.Data = new List <Urun>();
foreach (DataRow dr in dt.Rows)
{
Urun u = new Urun
{
KategoriID = k.ID,
Kod = Commons.CreateImpaCode(dr[0]),//BAYMYO.UI.Converts.NullToInt(BAYMYO.UI.Converts.NullToString(dr[0]).Replace(" ", "").Trim()).ToString("00 00 00"),
Adi = BAYMYO.UI.Converts.NullToString(dr[1]),
Miktar = 1,
Birim = BAYMYO.UI.Converts.NullToString(dr[2]),
Kdv = BAYMYO.UI.Converts.NullToFloat(dr[3]),
Tarih = DateTime.Now
};
if (!string.IsNullOrWhiteSpace(u.Adi))
{
sd.Data.Add(u);
}
}
switch (sd.ShowDialog())
{
case DialogResult.Yes:
Commons.Loading("Product updates.. .");
foreach (Urun stk in sd.Data)
{
UrunMethods.Insert(stk);
}
Commons.Update(TableNames.Urun);
Commons.Status(string.Format(L.KategoriUrunlerEklendi, k.Adi));
dxErrorProvider1.ClearErrors();
GetData(k.ID);
break;
}
sd.Data = null;
}
}
}
}
break;
}
}
}
catch (Exception ex)
{
Commons.Status(Commons.GetErrorCode("FUN", 8) + ex.Message);
}
finally
{
Commons.Loaded();
}
}
public xrpUrunKatalog(bool isID)
{
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. ..");
this.DisplayName = "PRODUCT CATALOG - " + DateTime.Now.ToString("yyyy-MM-dd");
#region --- Header ---
if (Commons.AppSettings.IS_IMAGE_HEADER)
{
this.reportHeaderBand1.HeightF = 225f;
foreach (XRControl item in this.reportHeaderBand1.Controls)
{
switch (BAYMYO.UI.Converts.NullToString(item.Tag))
{
case "T":
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.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.xrFormRevNo.Text = Commons.AppSettings.URUN_KATALOG_FORMU;
}
this.xrhSalesPrice.Text = string.Format("Sales Price ({0}) ({1}) ({2})",
Commons.AppSettings.DEFAULT_CURRENCY.Code,
Commons.AppSettings.CROSS_CURRENCY_1.Code,
Commons.AppSettings.CROSS_CURRENCY_2.Code);
switch (!isID)
{
case true:
this.xrhID.Text = "ID";
this.xrID.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "UrunID") });
break;
}
#endregion
this.xrKur0.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
new DevExpress.XtraReports.UI.XRBinding("Text", null, "Tutar", Commons.Kur0FormatCustom)
});
this.xrKur1.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
new DevExpress.XtraReports.UI.XRBinding("Text", null, "TutarKur1", Commons.Kur1FormatCustom)
});
this.xrKur2.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
new DevExpress.XtraReports.UI.XRBinding("Text", null, "TutarKur2", Commons.Kur2FormatCustom)
});
}
catch (Exception ex)
{
Commons.Status(Commons.GetErrorCode("RFR", 5) + ex.Message);
}
finally
{
Commons.Loaded();
}
}
void excelAktarimButton_Click(object sender, EventArgs e)
{
Commons.ProductImportFile();
}