private void btnKaydet_ItemClick(object sender, ItemClickEventArgs e)
{
DevExpress.DashboardCommon.Dashboard rep = new DevExpress.DashboardCommon.Dashboard();
int iEkleyenID = 0;
iEkleyenID = Genel.AktifKullaniciID;
DashboardParameter prmUser = new DashboardParameter();
prmUser.Name = "EkleyenID";
prmUser.Type = typeof(System.Int32);
prmUser.Value = iEkleyenID;
prmUser.Description = "EkleyenID";
prmUser.Visible = false;
rep.Parameters.Add(prmUser);
MemoryStream stream = new MemoryStream();
rep.SaveToXml(stream);
stream.Position = 0;
byte[] RaporData = Genel.StreamToByteArray(stream);
var IslemEkle = data.IUD_Evraklar(1, -1, RaporData, txtAdi.Text, txtAdi.Text, -1,
-1, true, false, -1, -1,
true, Genel.AktifKullaniciID).ToList();
if (IslemEkle != null && IslemEkle.FirstOrDefault().ID > 0)
{
//Ayar.InfoMesajGoster(Genel.DilGetirMesaj(1017), Ayar.MesajTipi.Bilgi, this);
}
}
void dasboard_DataLoading(object sender, DashboardDataLoadingEventArgs e)
{
if (datasourcedisardan != null)
{
foreach (DataTable item in datasourcedisardan.Tables)
{
if (e.DataSource.Name == item.TableName)
{
e.Data = item;
}
}
}
else
{
DataSet datasourcelist = Genel.DsGetir(DashboardID, true);
foreach (DataTable item in datasourcelist.Tables)
{
if (e.DataSource.Name == item.TableName)
{
e.Data = item;
}
}
}
// var list = Application.OpenForms;
// list[1].BeginInvoke(new Action(() => list[1].Hide()));
// var asdf = "";
}
/// <summary>
/// Dashboard formundaki layout ayarlarını kaydeder.
/// </summary>
public static byte[] DashboardLayoutToByte(int iDashboardID, DockManager dm)
{
System.IO.Stream str;
str = new System.IO.MemoryStream();
dm.SaveLayoutToStream(str);
str.Seek(0, System.IO.SeekOrigin.Begin);
byte[] Layout = Genel.StreamToByteArray(str);
return(Layout);
//MListler.MList_S_Dashboard = Genel.PrmDb.S_Dashboard(0, Genel.DilID).ToList();
}
private void dasboard_DataLoading(object sender, DashboardDataLoadingEventArgs e)
{
DataSet datasourcelist = Genel.DsGetir(DashboardID, true);
foreach (DataTable item in datasourcelist.Tables)
{
if (e.DataSource.Name == item.TableName)
{
e.Data = item;
}
}
}
private void btnGiris_Click(object sender, EventArgs e)
{
int kullaniciid = 0;
string KullaniciAyarlari = "";
if (Convert.ToBoolean(toggHatirla.EditValue))
{
KullaniciAyarlari += txtKullaniciAdi.Text.Trim() + ";";
}
else
{
KullaniciAyarlari += ";";
}
KullaniciAyarlari += toggHatirla.EditValue.ToString() + ";";
Genel.TextDosyaYaz(Genel.ProgramYolu + "PrmParams.txt", KullaniciAyarlari);
var list = data.S_KullaniciGirisKontrol(txtKullaniciAdi.Text, txtParola.Text).ToList();
if (Convert.ToInt32(list.FirstOrDefault().ID) > 0)
{
kullaniciid = Convert.ToInt32(list.FirstOrDefault().ID);
Genel.AktifKullaniciID = kullaniciid;
Genel.AktifKullaniciAdi = txtKullaniciAdi.Text;
var ayarlar = data.S_KullaniciAyarlari(kullaniciid).ToList();
if (ayarlar.Count > 0)
{
Genel.AktifKullanici_DashboardID = ayarlar.FirstOrDefault().DashboardID;
Genel.AktifKullanici_DashboardOtomatikYenilensinMi = ayarlar.FirstOrDefault().DashboardYenileme;
Genel.AktifKullanici_DashboardYenilemeSuresi = ayarlar.FirstOrDefault().DashboardYenilemeSure;
}
else
{
Genel.AktifKullanici_DashboardID = 0;
Genel.AktifKullanici_DashboardOtomatikYenilensinMi = false;
Genel.AktifKullanici_DashboardYenilemeSuresi = 0;
}
this.Hide();
Master frm = new Master();
frm.ShowDialog();
}
else
{
XtraMessageBox.Show("Kullanici Adı veya Parola hatalı!", "Hata", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public S_Evraklar_Result Evrak = new S_Evraklar_Result(); //Model.S_Evraklar_Result Evrak = new Model.S_Evraklar_Result();
public void Datagetir()
{
//açınca ekran kitleniyor. incelemek lazım.
//SplashScreenManager.ShowForm(this, typeof(BarduckCRM.Bekleyiniz), true, true);
//SplashScreenManager.CloseForm();
Evrak = data.S_Evraklar(DashboardID, true, 1).FirstOrDefault(); //Genel.PrmDb.S_Evraklar(DashboardID, true, Genel.DilID).FirstOrDefault();
var DosyaYolu = data.S_AyarKarakter(2, 1).FirstOrDefault().Deger; //Genel.PrmDb.S_AyarKarakter(2, Genel.DilID).FirstOrDefault().Deger;
DosyaYolu += Evrak.DosyaAdi + ".xml";
byte[] bytearry = data.S_DosyaGet(DosyaYolu).FirstOrDefault();
if (bytearry == null)
{
//Ayar.InfoMesajGoster(Genel.DilGetirMesaj(0), Ayar.MesajTipi.Hata, this);
return;
}
Stream RepData = Genel.ByteArrayToStream(bytearry);
DevExpress.DashboardCommon.Dashboard dasboard = new DevExpress.DashboardCommon.Dashboard();
dasboard.BeginUpdateLayout();
dasboard.LoadFromXml(RepData);
dasboard.DataLoading += dasboard_DataLoading;
dasboard.EndUpdateLayout();
// DataSet datasourcelist = Ayar.DsGetir(DashboardID, MusteriID, ProjeID, AktiviteID, Parametre4, Parametre5, Parametre6, Parametre7, Parametre8, Parametre9, Parametre10);
//// dasboard.DataSources.Clear();
// foreach (DataTable item in datasourcelist.Tables)
// {
// dasboard.AddDataSource(item.TableName, item);
// //if (dasboard.DataSources.Where(z => z.Name == item.TableName).FirstOrDefault() == null)
// //{
// // dasboard.AddDataSource(item.TableName, item);
// //}
// }
if (dasboard != null)
{
dashboardViewer1.Dashboard = dasboard;
// dashboardViewer1.PopulateUnusedDataSources = true;
// dashboardViewer1.ReloadData();
}
}
private void GorunumKaydet()
{
try
{
if (Genel.AktifKullaniciID < 1)
{
return;
}
RibbonPageGroup grp = ribbonControl1.Pages[1].Groups[0]; //BenimMenum
string strBenimMenum = "";
foreach (BarItemLink lnk in grp.ItemLinks)
{
BarItem item = lnk.Item;
strBenimMenum += item.Name + ";";
}
if (!bFormYuklendiMi)
{
return;
}
#region Quick Access Toolbar ayarları stream değişkene atılıyor...
System.IO.Stream str;
str = new System.IO.MemoryStream();
ribbonControl1.Toolbar.SaveLayoutToStream(str);
str.Seek(0, System.IO.SeekOrigin.Begin);
byte[] QAT = Genel.StreamToByteArray(str);
#endregion
//bool bSolNavigasyonAcikMi = false;
//if (nbcNavigasyon.OptionsNavPane.NavPaneState == DevExpress.XtraNavBar.NavPaneState.Expanded)
// bSolNavigasyonAcikMi = true;
data.IUD_KullaniciAyarlari(Genel.AktifKullaniciID,
DevExpress.LookAndFeel.UserLookAndFeel.Default.SkinName.ToString(), strBenimMenum, QAT, ribbonControl1.ToolbarLocation.ToString(),
false, -1, -1, false, -1, 2);//bSolNavigasyonAcikMi, iSolNavigasyonGenislik
}
catch (Exception Hata)
{
//Genel.LogErrorYaz(iFormID, Hata);
//XtraMessageBox.Show(Genel.DilGetirMesaj(1034) + "\n\n" + Hata.Message, Genel.DilGetirMesaj(2), MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void MasterGiris_Load(object sender, EventArgs e)
{
barStaticVersiyon.Caption = "Versiyon " + System.Reflection.Assembly.GetExecutingAssembly().GetName().Version.ToString();
txtKullaniciAdi.Focus();
if (File.Exists(Genel.ProgramYolu + "PrmParams.txt"))
{
string[] Ayarlar = Genel.TextDosyaOku(Genel.ProgramYolu + "PrmParams.txt").Split(';');
string KullaniciAdi = Ayarlar[0];
bool BeniHatirla = Convert.ToBoolean(Ayarlar[1]);
if (BeniHatirla)
{
txtKullaniciAdi.Text = KullaniciAdi;
}
toggHatirla.EditValue = BeniHatirla;
}
//SirketCombosuOlustur();
}
/// <summary>
/// Dashboard formundaki layout ayarlarını getirir.
/// </summary>
public static Stream DashboardLayoutGetir(int iDashboardID)
{
BarduckCRMEntities data = new BarduckCRMEntities();
try
{
var List = data.S_Dashboard(iDashboardID, -1).ToList(); //MListler.MList_S_Dashboard.Where(u => u.ID == iDashboardID);
if (List == null)
{
return(null);
}
byte[] bLayout = null;
bLayout = (byte[])List.FirstOrDefault().Layout;
return(Genel.ByteArrayToStream(bLayout));
}
catch (Exception exc)
{
return(null);
}
}
private void btnTasarim_ItemClick(object sender, ItemClickEventArgs e)
{
//DevExpress.DashboardCommon.Dashboard dasboard = new DevExpress.DashboardCommon.Dashboard();
//var DosyaYolu = data.S_AyarKarakter(2, 1).ToList().FirstOrDefault().Deger + "dash.xml";//gv.GetRowCellValue(iRowID, "DosyaAdi").ToString() + ".xml";
//if (DosyaYolu == null)
// return;
//byte[] bytearry = data.S_DosyaGet(DosyaYolu).FirstOrDefault();
//if (bytearry != null)
//{
// Stream RepData = Genel.ByteArrayToStream(bytearry);
// dasboard.LoadFromXml(RepData);
//}
////DataSet datasourcelist = Ayar.DsGetir(iSelectedReportID, 1, 1, 1, 1, 1, 1, 1, 1, 1, 99, true);
//////dasboard.DataSources.Clear();
////foreach (DataTable item in datasourcelist.Tables)
////{
//// if (dasboard.DataSources.Where(z => z.Name == item.TableName).FirstOrDefault() == null)
//// {
//// dasboard.AddDataSource(item.TableName, item);
//// }
////}
////dasboard.DataLoading += dasboard_DataLoading;
//DashboardTasarim frm = new DashboardTasarim(dasboard);
//frm.Show();
#region Dashboard
var DosyaYolu = data.S_AyarKarakter(2, 1).FirstOrDefault().Deger + DosyaAdi + ".xml";
byte[] bytearry = data.S_DosyaGet(DosyaYolu).FirstOrDefault();
if (bytearry != null)
{
Stream RepData = Genel.ByteArrayToStream(bytearry);
DevExpress.DashboardCommon.Dashboard dasboard = new DevExpress.DashboardCommon.Dashboard();
dasboard.LoadFromXml(RepData);
DataSet datasourcelist = Genel.DsGetir(DashboardID, true);
//dasboard.DataSources.Clear();
foreach (DataTable item in datasourcelist.Tables)
{
if (dasboard.DataSources.Where(z => z.Name == item.TableName).FirstOrDefault() == null)
{
dasboard.AddDataSource(item.TableName, item);
}
}
dasboard.DataLoading += dasboard_DataLoading;
DashboardTasarim rep = new DashboardTasarim(dasboard);
rep.ShowDialog();
if (rep.SaveDashboard)
{
MemoryStream stream = new MemoryStream();
rep.Dashboard.SaveToXml(stream);
stream.Position = 0;
byte[] RaporData = Genel.StreamToByteArray(stream);
data.IUD_Evraklar(4, DashboardID, RaporData, null, null, null, null, null, null, null, null, true, Genel.AktifKullaniciID);
}
}
#endregion
}
private void XtraForm3_Load(object sender, EventArgs e)
{
try
{
Cursor.Current = Cursors.WaitCursor;
tabPane1.SelectedPageIndex = 0; //tab ların hangisi seçili geleceğini belirler.
barLblKayitAktifPasif.Caption = "Pasif Kayıt";
barLblKayitAktifPasif.Glyph = BarduckCRM.Properties.Resources.Apply_16x16;
barLblKayitID.Caption = "0";
barLblKayitTarihi.Caption = "0";
var list = data.S_Tip(-1).ToList();
if (list.Count > 0)
{
cmbMedeniHali.Properties.DataSource = list.Where(c => c.UstID == 44).ToList();
cmbMeslek.Properties.DataSource = list.Where(c => c.UstID == 2).ToList();
}
tipresimli = data.S_TipResimli(52).ToList();
if (tipresimli.Count > 0)
{
cmbOnek.Properties.DataSource = tipresimli;
}
var ulkelist = data.S_Ulke(-1).ToList();
if (ulkelist.Count > 0)
{
cmbUlke.Properties.DataSource = ulkelist;
cmbUyrugu.Properties.DataSource = ulkelist;
}
//var firmalist = data.S_Firma(-1).ToList();
//if(firmalist.Count>0)
// cmbFirma.Properties.DataSource = firmalist;
if (kayitid > 0)
{
DataGetir(kayitid);
}
//if (kayitid > 0)
// KayitIzlemeModu(true);
//FormYetkileri(1);
var esnekozeltercihler = Data.EsnekKayitlar(1, kayitid).ToList();
if (esnekozeltercihler.Count > 0)
{
grdOTT.DataSource = esnekozeltercihler;
}
var geneltercihler = Data.EsnekKayitlar(2, kayitid).ToList();
if (geneltercihler.Count > 0)
{
DataTable dt = Genel.ListToDt(geneltercihler);
checkedListBoxControl1.ValueMember = "ID";
checkedListBoxControl1.DisplayMember = "Aciklama";
checkedListBoxControl1.CheckMember = "Checkbox";
checkedListBoxControl1.DataSource = dt;
}
Cursor.Current = Cursors.Default;
}
catch (Exception hata)
{
Cursor.Current = Cursors.Default;
}
}
