コード例 #1
0
ファイル: TestReportDeduc.cs プロジェクト: Berkcolakk/WiodySM
        public TestReportDeduc(int payoffMasterId)
        {
            InitializeComponent();

            using (var dbContext = new WiodySMContext())
            {
                var defPayoffMaster = dbContext.PayoffMaster.Find(payoffMasterId);
                SelfDeduc(defPayoffMaster.Project.Contract.MasterContract.CONTRACT_PRICECUTRATE, payoffMasterId, defPayoffMaster.Project.Company.COMPANY_COMPANY_NAME, defPayoffMaster.PAYOFFMASTER_PROJECT_ID);
                var payoffList = dbContext.PayoffMaster.Where(x => x.PAYOFFMASTER_PROJECT_ID == defPayoffMaster.PAYOFFMASTER_PROJECT_ID && x.ID != payoffMasterId).OrderBy(x => x.ID).ToList();
                foreach (var item in payoffList)
                {
                    PayoffDeductionVM vm = new PayoffDeductionVM();
                    int index            = payoffList.FindIndex(a => a.ID == item.ID);
                    index = index + 1;
                    var    payoffMaster       = dbContext.PayoffMaster.Find(item.ID);
                    double toplam             = Math.Round(dbContext.PayoffControl.Where(x => x.PAYOFFCONTROL_TYPE_ID == 1 && x.PAYOFFCONTROL_PAYOFFMASTER_ID == payoffMasterId).Sum(x => x.PAYOFFCONTROL_TOTALTENSIZUP), 2);
                    double tenzilat           = Math.Round(toplam * payoffMaster.Project.Contract.MasterContract.CONTRACT_PRICECUTRATE / 100, 2);
                    double tenzilatToplam     = Math.Round(toplam - tenzilat, 2);
                    var    oldToplamData      = dbContext.PayoffControl.Where(x => x.PAYOFFCONTROL_TYPE_ID == 1 && x.PayoffMaster.PAYOFFMASTER_PROJECT_ID == payoffMaster.PAYOFFMASTER_PROJECT_ID && x.PAYOFFCONTROL_PAYOFFMASTER_ID != payoffMasterId && x.PAYOFFCONTROL_PAYOFFMASTER_ID < payoffMasterId).ToList();
                    double oldToplam          = oldToplamData == null ? 0 : Math.Round(oldToplamData.Sum(x => x.PAYOFFCONTROL_TOTALTENSIZUP), 2);
                    double odenecekTutar      = Math.Round(tenzilatToplam - oldToplam, 2);
                    double geciciKabulKesinti = Math.Round(tenzilatToplam * 0.025, 2);
                    double kesinKabulKesinti  = Math.Round(tenzilatToplam * 0.025, 2);
                    totalTemp     += geciciKabulKesinti;
                    totalNet      += kesinKabulKesinti;
                    vm.Description = index + " Nolu Hakediş";
                    vm.TempDeduc   = geciciKabulKesinti.ToString() + " TL";
                    vm.NetDeduc    = kesinKabulKesinti.ToString() + " TL";
                    temp.Add(vm);
                }
                TotalDeduc();
                objectDataSource1.DataSource = temp;
            }
        }
コード例 #2
0
        public PayoffExtractReport(int payoffMasterId)
        {
            InitializeComponent();
            using (var dbContext = new WiodySMContext())
            {
                PayoffIcmalVM vm = new PayoffIcmalVM();

                vm.Tarih = DateTime.Now.ToShortDateString();
                var payoffMaster = dbContext.PayoffMaster.Find(payoffMasterId);
                vm.Yıl    = DateTime.Now.Year.ToString();
                vm.GrupNo = payoffMaster.Project.PROJECT_GROUP;
                vm.PypNo  = payoffMaster.Project.PROJECT_PYP_NO;
                vm.IsAdi  = payoffMaster.Project.PROJECT_NAME;

                var mlz = dbContext.PayoffControl.Where(x => x.PAYOFFCONTROL_TYPE_ID == 1 && x.PAYOFFCONTROL_PAYOFFMASTER_ID == payoffMasterId && x.PAYOFFCONTROL_LB == "MLZ").ToList();
                vm.Malzeme = mlz == null ? "0 TL"  : mlz.Sum(x => x.PAYOFFCONTROL_TOTALTENSIZUP).ToString() + " TL";

                var mon = dbContext.PayoffControl.Where(x => x.PAYOFFCONTROL_TYPE_ID == 1 && x.PAYOFFCONTROL_PAYOFFMASTER_ID == payoffMasterId && x.PAYOFFCONTROL_LB == "MON").ToList();
                vm.Montaj = mon == null ? "0 TL" : mon.Sum(x => x.PAYOFFCONTROL_TOTALTENSIZUP).ToString() + " TL";
                var deMon = dbContext.PayoffControl.Where(x => x.PAYOFFCONTROL_TYPE_ID == 1 && x.PAYOFFCONTROL_PAYOFFMASTER_ID == payoffMasterId && x.PAYOFFCONTROL_LB == "DM").ToList();
                vm.DeMontaj = deMon == null ? "0 TL" : deMon.Sum(x => x.PAYOFFCONTROL_TOTALTENSIZUP).ToString() + " TL";
                var dmm = dbContext.PayoffControl.Where(x => x.PAYOFFCONTROL_TYPE_ID == 1 && x.PAYOFFCONTROL_PAYOFFMASTER_ID == payoffMasterId && x.PAYOFFCONTROL_LB == "DMM").ToList();
                vm.DMM = dmm == null ? "0 TL" : dmm.Sum(x => x.PAYOFFCONTROL_TOTALTENSIZUP).ToString() + " TL";
                var ins = dbContext.PayoffControl.Where(x => x.PAYOFFCONTROL_TYPE_ID == 1 && x.PAYOFFCONTROL_PAYOFFMASTER_ID == payoffMasterId && x.PAYOFFCONTROL_LB == "İNS").ToList();
                vm.Insaat = ins == null ? "0 TL" : ins.Sum(x => x.PAYOFFCONTROL_TOTALTENSIZUP).ToString() + " TL";
                vm.Total  = dbContext.PayoffControl.Where(x => x.PAYOFFCONTROL_TYPE_ID == 1 && x.PAYOFFCONTROL_PAYOFFMASTER_ID == payoffMasterId).Sum(x => x.PAYOFFCONTROL_TOTALTENSIZUP).ToString() + " TL";
                objectDataSource1.DataSource = vm;
            }
        }
コード例 #3
0
ファイル: StockHelper.cs プロジェクト: Berkcolakk/WiodySM
 public static List <StockDetailVM> GetItemStocksDetailAll()
 {
     using (var dbContext = new WiodySMContext())
     {
         try
         {
             var result = dbContext.StockDetail.GroupBy(x => new StockDetailVMT {
                 STOCKDETAIL_BARCODE_ID = x.STOCKDETAIL_BARCODE_ID, STOCKDETAIL_ITEM_NAME = x.Item.ITEM_NAME, STOCKDETAIL_ITEM_UNIT = x.Item.ParameterDetail_Item_Unit.PARAMETERDETAIL_NAME, STOCKDETAIL_STORE_NAME = x.ParameterDetail_StockDetail_Store.PARAMETERDETAIL_NAME, STOCKDETAIL_ITEM_CODE = x.Item.ITEM_CODE
             }).Select(g => new StockDetailVM
             {
                 STOCKDETAIL_BARCODE_ID = g.Key.STOCKDETAIL_BARCODE_ID,
                 STOCKDETAIL_ITEM_NAME  = g.Key.STOCKDETAIL_ITEM_NAME,
                 STOCKDETAIL_ITEM_UNIT  = g.Key.STOCKDETAIL_ITEM_UNIT,
                 STOCKDETAIL_ITEM_CODE  = g.Key.STOCKDETAIL_ITEM_CODE,
                 STOCKDETAIL_STORE_NAME = g.Key.STOCKDETAIL_STORE_NAME,
                 STOCKDETAIL_QUANTITY   = g.Sum(x => x.STOCKDETAIL_QUANTITY),
             }).ToList();
             return(result);
         }
         catch (Exception ex)
         {
             throw;
         }
     }
 }
コード例 #4
0
ファイル: TestReportDeduc.cs プロジェクト: Berkcolakk/WiodySM
 void TotalDeduc()
 {
     using (var dbContext = new WiodySMContext())
     {
         PayoffDeductionVM vm = new PayoffDeductionVM();
         vm.Description = "BU HAKEDİŞTE KESİLMESİ GEREKEN";
         vm.TempDeduc   = (currentTemp - totalTemp).ToString() + " TL";
         vm.NetDeduc    = (currentNet - totalNet).ToString() + " TL";
         temp.Add(vm);
     }
 }
コード例 #5
0
 public static StockActionVM GetBarcodeDetail(string barcode, int storeId)
 {
     using (var dbContext = new WiodySMContext())
     {
         return(dbContext.StockDetail.Where(x => x.STOCKDETAIL_BARCODE_ID == barcode && x.STOCKDETAIL_STORE_ID == storeId)
                .GroupBy(x => new { x.STOCKDETAIL_BARCODE_ID, x.STOCKDETAIL_ITEM_ID, x.Item.ITEM_NAME, x.STOCKDETAIL_STORE_ID, x.ParameterDetail_StockDetail_Store.PARAMETERDETAIL_NAME, x.STOCKDETAIL_RACK_ID })
                .Select(g => new StockActionVM
         {
             Quantity = g.Sum(x => x.STOCKDETAIL_QUANTITY),
             Barcode = g.Key.STOCKDETAIL_BARCODE_ID,
             ItemName = g.Key.ITEM_NAME,
             ItemId = g.Key.STOCKDETAIL_ITEM_ID,
             RackId = g.Key.STOCKDETAIL_RACK_ID
         }).FirstOrDefault());
     }
 }
コード例 #6
0
 public PayoffReportTotalEnd(int payoffMasterId)
 {
     InitializeComponent();
     using (var dbContext = new WiodySMContext())
     {
         PayoffReportVM vm           = new PayoffReportVM();
         var            payoffMaster = dbContext.PayoffMaster.Find(payoffMasterId);
         var            payoffList   = dbContext.PayoffMaster.Where(x => x.PAYOFFMASTER_PROJECT_ID == payoffMaster.PAYOFFMASTER_PROJECT_ID).OrderBy(x => x.ID).ToList();
         int            index        = payoffList.FindIndex(a => a.ID == payoffMasterId);
         index    = index + 1;
         vm.HakNo = index + " Nolu Hakediş";
         vm.Proje = payoffMaster.Project.PROJECT_NAME;
         vm.Firma = payoffMaster.Project.Company.COMPANY_COMPANY_NAME;
         vm.Tarih = payoffMaster.CREATED_DATE + "  TARİHİNE KADAR YAPILAN İŞİN / HİZMETİN";
         double toplam = Math.Round(dbContext.PayoffControl.Where(x => x.PAYOFFCONTROL_TYPE_ID == 1 && x.PAYOFFCONTROL_PAYOFFMASTER_ID == payoffMasterId).Sum(x => x.PAYOFFCONTROL_TOTALTENSIZUP), 2);
         vm.Toplam           = toplam.ToString() + " TL";
         vm.TenzilatOran     = payoffMaster.Project.Contract.MasterContract.CONTRACT_PRICECUTRATE / 100;
         vm.TenzilatOranText = payoffMaster.Project.Contract.MasterContract.CONTRACT_PRICECUTRATE.ToString() + "%";
         double tenzilat = Math.Round(toplam * vm.TenzilatOran, 2);
         vm.Tenzilat = tenzilat.ToString() + " TL";
         double tenzilatToplam = Math.Round(toplam - tenzilat, 2);
         vm.TenzilatToplam = tenzilatToplam.ToString() + " TL";
         var    oldToplamData = dbContext.PayoffControl.Where(x => x.PAYOFFCONTROL_TYPE_ID == 1 && x.PayoffMaster.PAYOFFMASTER_PROJECT_ID == payoffMaster.PAYOFFMASTER_PROJECT_ID && x.PAYOFFCONTROL_PAYOFFMASTER_ID != payoffMasterId && x.PAYOFFCONTROL_PAYOFFMASTER_ID < payoffMasterId).ToList();
         double oldToplam     = oldToplamData == null ? 0 : Math.Round(oldToplamData.Sum(x => x.PAYOFFCONTROL_TOTALTENSIZUP), 2);
         vm.EskiTenzilatToplam = oldToplam.ToString() + " TL";
         double odenecekTutar = Math.Round(tenzilatToplam - oldToplam, 2);
         vm.OdenecekTutar = odenecekTutar.ToString() + " TL";
         double geciciKabulKesinti = Math.Round(tenzilatToplam * 0.025, 2);
         double kesinKabulKesinti  = Math.Round(tenzilatToplam * 0.025, 2);
         vm.GeciciKabulKesintisi = (geciciKabulKesinti * -1).ToString() + " TL";
         vm.KesinKabulKesintisi  = (kesinKabulKesinti * -1).ToString() + " TL";
         double kesintiler = Math.Round(payoffMaster.PAYOFFMASTER_PARAMETERCODE, 2);
         vm.Kesintiler = payoffMaster.PAYOFFMASTER_PARAMETERCODE.ToString() + " TL";
         double hakedisToplam = Math.Round(odenecekTutar - (geciciKabulKesinti + kesinKabulKesinti + kesintiler), 2);
         vm.KesinOdenecekToplam = hakedisToplam.ToString() + " TL";
         double kdv = Math.Round(hakedisToplam * 0.18, 2);
         vm.KDV = kdv.ToString() + " TL";
         double tahakkukToplam = Math.Round(hakedisToplam + kdv, 2);
         vm.TahakkukToplam            = tahakkukToplam.ToString() + " TL";
         objectDataSource1.DataSource = vm;
     }
 }
コード例 #7
0
ファイル: StockHelper.cs プロジェクト: Berkcolakk/WiodySM
 public static List <StockDetailVM> GetStoreStocks(int storeId)
 {
     using (var dbContext = new WiodySMContext())
     {
         try
         {
             var result = dbContext.StockDetail.Where(x => x.STOCKDETAIL_STORE_ID == storeId).GroupBy(x => new { x.STOCKDETAIL_BARCODE_ID, x.Item.ITEM_NAME, x.Item.ITEM_CODE }).Select(g => new StockDetailVM
             {
                 STOCKDETAIL_BARCODE_ID = g.Key.STOCKDETAIL_BARCODE_ID,
                 STOCKDETAIL_ITEM_NAME  = g.Key.ITEM_NAME,
                 STOCKDETAIL_ITEM_CODE  = g.Key.ITEM_CODE,
                 STOCKDETAIL_QUANTITY   = g.Sum(x => x.STOCKDETAIL_QUANTITY),
             }).ToList();
             return(result);
         }
         catch (Exception ex)
         {
             throw;
         }
     }
 }
コード例 #8
0
ファイル: TestReportDeduc.cs プロジェクト: Berkcolakk/WiodySM
 void SelfDeduc(double rate, int payoffMasterId, string companyName, int projectId)
 {
     using (var dbContext = new WiodySMContext())
     {
         PayoffDeductionVM vm             = new PayoffDeductionVM();
         double            toplam         = Math.Round(dbContext.PayoffControl.Where(x => x.PAYOFFCONTROL_TYPE_ID == 1 && x.PAYOFFCONTROL_PAYOFFMASTER_ID == payoffMasterId).Sum(x => x.PAYOFFCONTROL_TOTALTENSIZUP), 2);
         double            tenzilat       = Math.Round(toplam * rate / 100, 2);
         double            tenzilatToplam = Math.Round(toplam - tenzilat, 2);
         var    oldToplamData             = dbContext.PayoffControl.Where(x => x.PAYOFFCONTROL_TYPE_ID == 1 && x.PayoffMaster.PAYOFFMASTER_PROJECT_ID == projectId && x.PAYOFFCONTROL_PAYOFFMASTER_ID != payoffMasterId && x.PAYOFFCONTROL_PAYOFFMASTER_ID < payoffMasterId).ToList();
         double oldToplam          = oldToplamData == null ? 0 : Math.Round(oldToplamData.Sum(x => x.PAYOFFCONTROL_TOTALTENSIZUP), 2);
         double odenecekTutar      = Math.Round(tenzilatToplam - oldToplam, 2);
         double geciciKabulKesinti = Math.Round(tenzilatToplam * 0.025, 2);
         double kesinKabulKesinti  = Math.Round(tenzilatToplam * 0.025, 2);
         currentNet     = kesinKabulKesinti;
         currentTemp    = geciciKabulKesinti;
         vm.FirmaAdi    = companyName;
         vm.Description = "BU HAKEDİŞ KESİLMESİ GEREKEN";
         vm.TempDeduc   = geciciKabulKesinti.ToString() + " TL";
         vm.NetDeduc    = kesinKabulKesinti.ToString() + " TL";
         temp.Add(vm);
     }
 }
コード例 #9
0
ファイル: StockHelper.cs プロジェクト: Berkcolakk/WiodySM
 public static List <StockDetailVM> GetStoreStocksDetail(int storeId)
 {
     using (var dbContext = new WiodySMContext())
     {
         try
         {
             var result = dbContext.StockDetail.Where(x => x.STOCKDETAIL_STORE_ID == storeId).GroupBy(x => new { x.STOCKDETAIL_BARCODE_ID, x.Item.ITEM_NAME, x.Item.ParameterDetail_Item_Unit.PARAMETERDETAIL_NAME, x.STOCKDETAIL_STORE_ID, x.Item.ITEM_CODE }).Select(g => new StockDetailVM
             {
                 STOCKDETAIL_BARCODE_ID = g.Key.STOCKDETAIL_BARCODE_ID,
                 STOCKDETAIL_ITEM_NAME  = g.Key.ITEM_NAME,
                 STOCKDETAIL_ITEM_CODE  = g.Key.ITEM_CODE,
                 STOCKDETAIL_ITEM_UNIT  = g.Key.PARAMETERDETAIL_NAME,
                 STOCKDETAIL_QUANTITY   = g.Sum(x => x.STOCKDETAIL_QUANTITY),
                 CREATED_DATE           = dbContext.StockDetail.FirstOrDefault(x => x.STOCKDETAIL_STORE_ID == storeId && x.STOCKDETAIL_BARCODE_ID == g.Key.STOCKDETAIL_BARCODE_ID) == null ? DateTime.Now : dbContext.StockDetail.FirstOrDefault(x => x.STOCKDETAIL_STORE_ID == storeId && x.STOCKDETAIL_BARCODE_ID == g.Key.STOCKDETAIL_BARCODE_ID).CREATED_DATE,
             }).ToList();
             return(result);
         }
         catch (Exception ex)
         {
             throw;
         }
     }
 }
コード例 #10
0
ファイル: StockHelper.cs プロジェクト: Berkcolakk/WiodySM
 public static StockDetailVM GetBarcodeStocksWithStore(string barcodeId, int storeId)
 {
     using (var dbContext = new WiodySMContext())
     {
         try
         {
             var result = dbContext.StockDetail.Where(x => x.STOCKDETAIL_BARCODE_ID == barcodeId && x.STOCKDETAIL_STORE_ID == storeId).GroupBy(x => new { x.STOCKDETAIL_BARCODE_ID, x.Item.ITEM_NAME, x.STOCKDETAIL_STORE_ID, x.STOCKDETAIL_ITEM_ID, x.STOCKDETAIL_RACK_ID }).Select(g => new StockDetailVM
             {
                 STOCKDETAIL_BARCODE_ID = g.Key.STOCKDETAIL_BARCODE_ID,
                 STOCKDETAIL_ITEM_NAME  = g.Key.ITEM_NAME,
                 STOCKDETAIL_STORE_ID   = g.Key.STOCKDETAIL_STORE_ID,
                 STOCKDETAIL_RACK_ID    = g.Key.STOCKDETAIL_RACK_ID,
                 STOCKDETAIL_ITEM_ID    = g.Key.STOCKDETAIL_ITEM_ID,
                 STOCKDETAIL_QUANTITY   = g.Sum(x => x.STOCKDETAIL_QUANTITY),
             }).Where(x => x.STOCKDETAIL_QUANTITY > 0).FirstOrDefault();
             return(result);
         }
         catch (Exception ex)
         {
             throw;
         }
     }
 }
コード例 #11
0
ファイル: PayoffCover.cs プロジェクト: Berkcolakk/WiodySM
        public PayoffCover(int payoffMasterId)
        {
            InitializeComponent();
            using (var dbContext = new WiodySMContext())
            {
                PayoffIcmalVM vm = new PayoffIcmalVM();

                vm.Tarih = DateTime.Now.ToShortDateString();
                var payoffMaster = dbContext.PayoffMaster.Find(payoffMasterId);
                var payoffList   = dbContext.PayoffMaster.Where(x => x.PAYOFFMASTER_PROJECT_ID == payoffMaster.PAYOFFMASTER_PROJECT_ID).OrderBy(x => x.ID).ToList();
                int index        = payoffList.FindIndex(a => a.ID == payoffMasterId);
                index       = index + 1;
                vm.HakNo    = index + " Nolu Hakediş";
                vm.Yıl      = DateTime.Now.Year.ToString();
                vm.GrupNo   = payoffMaster.Project.PROJECT_GROUP;
                vm.PypNo    = payoffMaster.Project.PROJECT_PYP_NO;
                vm.IsAdi    = payoffMaster.Project.PROJECT_NAME;
                vm.FirmaAdi = payoffMaster.Project.Company.COMPANY_COMPANY_NAME;
                vm.Tenzilat = payoffMaster.Project.Contract.MasterContract.CONTRACT_PRICECUTRATE.ToString() + "%";
                //vm.Toplam = dbContext.PayoffControl.Where(x => x.PAYOFFCONTROL_TYPE_ID == 1 && x.PAYOFFCONTROL_PAYOFFMASTER_ID == payoffMasterId).Sum(x => x.PAYOFFCONTROL_TOTALTENSIZUP);
                objectDataSource1.DataSource = vm;
            }
        }
コード例 #12
0
 public BaseForm()
 {
     dbContext = new WiodySMContext();
 }
コード例 #13
0
ファイル: frmLogin.cs プロジェクト: Berkcolakk/WiodySM
        private async void frmLogin_Shown(object sender, EventArgs e)
        {
            int    versionNew       = 102;
            string connectionString = "Data Source = 185.248.57.239; User ID = wiody; Password = xrwatxN3MM4uEZyV; Initial Catalog = WiodyUpdate; MultipleActiveResultSets = True";
            string query            = "SELECT TOP 1 * FROM[WiodySMVersion] ORDER BY ID DESC";

            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                SqlCommand command = new SqlCommand(query, connection);
                try
                {
                    connection.Open();
                    SqlDataReader reader = command.ExecuteReader();
                    List <string> list   = new List <string>();
                    while (reader.Read())
                    {
                        if (Convert.ToInt32(reader["VERSION"]) != versionNew && Convert.ToBoolean(reader["REQUIRE"]) == false)
                        {
                            var messageBox = XtraMessageBox.Show("ŞU AN KULLANDIĞINIZ SÜRÜM ESKİDİR. YENİSİNE GEÇMEK İÇİN EVET'E TIKLAYINIZ !", "YENİ SÜRÜM GELMİŞTİR.", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
                            if (messageBox == DialogResult.Yes)
                            {
                                ProcessStartInfo proc = new ProcessStartInfo
                                {
                                    WorkingDirectory = Application.StartupPath,
                                    FileName         = "WiodySMUpdater.exe",
                                    Verb             = "runas"
                                };
                                Process.Start(proc);
                                Application.Exit();
                                break;
                            }
                            else if (messageBox == DialogResult.No)
                            {
                                break;
                            }
                        }
                        else if (Convert.ToBoolean(reader["REQUIRE"]) == true && Convert.ToInt32(reader["VERSION"]) != versionNew)
                        {
                            var messageBox = XtraMessageBox.Show("ŞU AN KULLANDIĞINIZ SÜRÜM ESKİDİR. YENİSİNE GEÇMEK İÇİN EVET'E TIKLAYINIZ. AKSİ HALDE PROGRAM KAPANACAKTIR !!", "ZORUNLU SÜRÜM GÜNCELLEMESİ", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
                            if (messageBox == DialogResult.Yes)
                            {
                                ProcessStartInfo proc = new ProcessStartInfo
                                {
                                    WorkingDirectory = Application.StartupPath,
                                    FileName         = "WiodySMUpdater.exe",
                                    Verb             = "runas"
                                };
                                Process.Start(proc);
                                Application.Exit();
                                break;
                            }
                            else if (messageBox == DialogResult.No)
                            {
                                Application.Exit();
                                break;
                            }
                        }
                        else if (Convert.ToInt32(reader["VERSION"]) == versionNew)
                        {
                            break;
                        }
                    }
                    reader.Close();
                    connection.Close();
                }
                catch (Exception)
                {
                    XtraMessageBox.Show("Veri Tabanı Bağlantısı Başarısız. Lütfen sistem yöneticiniz ile iletişime geçin veya daha sonra tekrar deneyin", "Hata");
                    Application.Exit();
                }
            }
            string buffer = "";

            for (int i = 0; i < versionNew.ToString().Length; i++)
            {
                buffer += versionNew.ToString()[i] + ".";
            }
            lblnumberversion.Text = buffer.Remove(5, 1);
            using (var db = new WiodySMContext())
            {
                System.Data.Common.DbConnection conn = db.Database.Connection;
                try
                {
                    await conn.OpenAsync();

                    conn.Close();
                    btnLogin.Enabled = true;
                    this.marqueeProgressBarControl1.Properties.Stopped = true;
                    lblLoading.Text = "Bağlantı Başarılı.";
                }
                catch
                {
                    this.marqueeProgressBarControl1.Properties.Stopped = true;
                    lblLoading.Text = "Bağlantı Hatası.";
                    XtraMessageBox.Show("Veri Tabanı Bağlantısı Başarısız. Lütfen sistem yöneticiniz ile iletişime geçin veya daha sonra tekrar deneyin", "Hata");
                    Application.Exit();
                }
            }
        }