public int m_TestMetot2()
        {
            StockTrackingDataContext = new L_StockTrackingERPDataContext();
            var LastCurrentReceiptRecord = StockTrackingDataContext.p_CurrentAccountingNo(5, "M");

            return(LastCurrentReceiptRecord);
        }
        public void m_StoreDelete(int vrStoreID, string vrStoreName)
        {
            DialogResult vrResult;

            StockTrackingDataContext = new L_StockTrackingERPDataContext();
            vrResult = MessageBox.Show(vrStoreName + " deposunu silmek istiyor musunuz ?", "Silme", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
            if (vrResult == DialogResult.Yes)
            {
                var Store_CountControl = from albStoreCount in StockTrackingDataContext.p_StoreStockCountControl(vrStoreID) select albStoreCount.Column1;
                foreach (var storeCount in Store_CountControl)
                {
                    //MessageBox.Show(productCount.ToString());
                    if (storeCount.ToString() == "")
                    {
                        StockTrackingDataContext.p_StoreDelete(vrStoreID);
                        MessageBox.Show("Depo Silindi", "Silme", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    }
                    else
                    {
                        MessageBox.Show("İlgili Deponun Stokları Vardır Silinemez", "Silme", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    }
                }
            }
            else
            {
                MessageBox.Show("Depo Silme İşlemi İptal Edilmiştir", "Silme", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
        }
        public void m_InvoicesList(DataGridView vr_InvoicesList, DateTime vrInvoiceDate1, DateTime vrInvoiceDate2)
        {
            StockTrackingDataContext = new L_StockTrackingERPDataContext();
            var InvoicesList = StockTrackingDataContext.p_InvoicesList(vrInvoiceDate1, vrInvoiceDate2);

            vr_InvoicesList.DataSource = InvoicesList;
        }
示例#4
0
        public void m_ProductDelete(int vrProductCode, string vrProductName)
        {
            DialogResult vrResult;

            StockTrackingDataContext = new L_StockTrackingERPDataContext();
            vrResult = MessageBox.Show(vrProductName + " ürününü silmek istiyor musunuz ?", "Silme", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
            if (vrResult == DialogResult.Yes)
            {
                var Product_CountControl = from albProductCount in StockTrackingDataContext.p_ProductStockCountControl(vrProductCode) select albProductCount.Column1;
                foreach (var productCount in Product_CountControl)
                {
                    //MessageBox.Show(productCount.ToString());
                    if (productCount.ToString() == "")
                    {
                        StockTrackingDataContext.p_ProductDel(vrProductCode);
                        MessageBox.Show("Ürün Silindi", "Silme", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    }
                    else
                    {
                        MessageBox.Show("Ürünün Depolarda Stoğu Vardır Silemezsiniz", "Silme", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    }
                }
            }
            else
            {
                MessageBox.Show("Ürün Silme İşlemi İptal Edilmiştir", "Silme", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
        }
        public void m_StocksAddUpdate(int vrProductCode, int vrStoreID, int vrProductCount, string vrProductChangeStatus)
        {
            StockTrackingDataContext = new L_StockTrackingERPDataContext();
            var StockAddUpdate_Query = StockTrackingDataContext.p_StocksAddUpdate(vrProductCode, vrStoreID, vrProductCount, vrProductChangeStatus);

            StockTrackingDataContext.SubmitChanges();
        }
        public void m_StockActionDetailsList(DataGridView vrdgrStockActionDetailsList, int vrStockActionNo)
        {
            StockTrackingDataContext = new L_StockTrackingERPDataContext();
            var StockActionsDetails_Query = StockTrackingDataContext.StockActionDetailList(vrStockActionNo);

            vrdgrStockActionDetailsList.DataSource = StockActionsDetails_Query;
        }
        public void m_StockActionDetailsDelete(int vrStockActionNo)
        {
            StockTrackingDataContext = new L_StockTrackingERPDataContext();
            var StockActionDetailsDelete_Query = StockTrackingDataContext.p_StockDetailsDelete(vrStockActionNo);

            StockTrackingDataContext.SubmitChanges();
        }
        //public void m_StockTest1(int vrStockNo)
        //{
        //    StockTrackingDataContext = new L_StockTrackingERPDataContext();
        //    var Stores_List = (from albStores in StockTrackingDataContext.StockActionDetails where albStores.StockAction == albStores.StockAction select albStores).Count();
        //    MessageBox.Show(Stores_List.ToString());
        //}
        public int m_StockCount(int vrStockNo /*,int vrStockCount*/)
        {
            StockTrackingDataContext = new L_StockTrackingERPDataContext();
            int Stores_List = (from albStores in StockTrackingDataContext.StockActionDetails where albStores.StockAction == albStores.StockAction select albStores).Count();

            return(Stores_List);
        }
        public void m_CurrentReceiptDel(int vrCurrentReceiptNo)
        {
            StockTrackingDataContext = new L_StockTrackingERPDataContext();
            var DeleteCurrentReceipt = StockTrackingDataContext.CurrentReceipts.Single(d_DeleteCurrentReceipts => d_DeleteCurrentReceipts.ReceiptNo == vrCurrentReceiptNo);

            StockTrackingDataContext.CurrentReceipts.DeleteOnSubmit(DeleteCurrentReceipt);
            StockTrackingDataContext.SubmitChanges();
        }
        public void m_InvoicesDelete(int vrInvoiceNo)
        {
            StockTrackingDataContext = new L_StockTrackingERPDataContext();
            var InvoiceDel = StockTrackingDataContext.Invoices.Single(d_InvoiceDel => d_InvoiceDel.InvoiceNo == vrInvoiceNo);

            StockTrackingDataContext.Invoices.DeleteOnSubmit(InvoiceDel);
            StockTrackingDataContext.SubmitChanges();
        }
        public void m_InvoicesDetailsDelete(int vrInvoiceNo, int vrProductCode)
        {
            StockTrackingDataContext = new L_StockTrackingERPDataContext();
            var InvoiceDetailsDel = StockTrackingDataContext.InvoicesDetails.Single(d_InvoiceDetailsDel => d_InvoiceDetailsDel.InvoiceNo == vrInvoiceNo && d_InvoiceDetailsDel.ProductCode == vrProductCode);

            StockTrackingDataContext.InvoicesDetails.DeleteOnSubmit(InvoiceDetailsDel);
            StockTrackingDataContext.SubmitChanges();
        }
        public void m_InvoicesCounterUpdate(int vrInvoiceCount)
        {
            StockTrackingDataContext = new L_StockTrackingERPDataContext();
            var InvoicesCounterUpdate = StockTrackingDataContext.InvoicesCounters.Single(d_InvoiceCounter => d_InvoiceCounter.CountersID == 1);

            InvoicesCounterUpdate.CountersNo = vrInvoiceCount;
            StockTrackingDataContext.SubmitChanges();
        }
示例#13
0
        public void m_StockActionCounterUpdate(int vrActionCounter)
        {
            StockTrackingDataContext = new L_StockTrackingERPDataContext();
            var StockActionCounterUpdate_Query = StockTrackingDataContext.StockActionCounters.Single(ActCount => ActCount.StockActionCounter1 == 1);

            StockActionCounterUpdate_Query.ActionCounter = vrActionCounter;
            StockTrackingDataContext.SubmitChanges();
        }
示例#14
0
        public void m_StockActionDetailsDelete(int vrStockActionNo, int vrProductCode)
        {
            StockTrackingDataContext = new L_StockTrackingERPDataContext();
            var StockActionDetailsDelete_Query = StockTrackingDataContext.StockActionDetails.Single(stckdetails => stckdetails.StockAction == vrStockActionNo & stckdetails.ProductCode == vrProductCode);

            StockTrackingDataContext.StockActionDetails.DeleteOnSubmit(StockActionDetailsDelete_Query);
            StockTrackingDataContext.SubmitChanges();
        }
        public void m_InvoicesDetailsProductDel(int vrInvoiceDetailsID)
        {
            StockTrackingDataContext = new L_StockTrackingERPDataContext();
            var ProductDel_Query = StockTrackingDataContext.InvoicesDetails.Single(d_query => d_query.InvoiceDetailsID == vrInvoiceDetailsID);

            StockTrackingDataContext.InvoicesDetails.DeleteOnSubmit(ProductDel_Query);
            StockTrackingDataContext.SubmitChanges();
        }
示例#16
0
        public void m_UserDelete(int vrUserID)
        {
            StockTrackingDataContext = new L_StockTrackingERPDataContext();
            var User_Delete = StockTrackingDataContext.Users.Single(usr_delete => usr_delete.UserID == vrUserID);

            StockTrackingDataContext.Users.DeleteOnSubmit(User_Delete);
            StockTrackingDataContext.SubmitChanges();
        }
        public void m_AccountingDelReceiptDel(int vrAccountingReceiptNo)
        {
            StockTrackingDataContext = new L_StockTrackingERPDataContext();
            var DeleteAccountingReceipt = StockTrackingDataContext.AccountingReceipts.Single(d_DeleteAccountingReceipts => d_DeleteAccountingReceipts.ReceiptNo == vrAccountingReceiptNo);

            StockTrackingDataContext.AccountingReceipts.DeleteOnSubmit(DeleteAccountingReceipt);
            StockTrackingDataContext.SubmitChanges();
        }
示例#18
0
        public void m_CustomerDelete(int vrCustomerID)
        {
            StockTrackingDataContext = new L_StockTrackingERPDataContext();
            var myquery = StockTrackingDataContext.Customers.Single(d_myquery => d_myquery.CustomerID == vrCustomerID);

            StockTrackingDataContext.Customers.DeleteOnSubmit(myquery);
            StockTrackingDataContext.SubmitChanges();
        }
示例#19
0
        public void m_StockActionDetailsUpdate(int vrProductCode, int vrProductCount)
        {
            StockTrackingDataContext = new L_StockTrackingERPDataContext();
            var StockActionDetailsUpdate_Query = StockTrackingDataContext.StockActionDetails.Single(stckdetails => stckdetails.ProductCode == vrProductCode);

            StockActionDetailsUpdate_Query.ProductCount = vrProductCount;
            StockTrackingDataContext.SubmitChanges();
        }
示例#20
0
        public void m_ProductTypeDel(int vrProductTypeID)
        {
            StockTrackingDataContext = new L_StockTrackingERPDataContext();
            var ProductType_Delete = StockTrackingDataContext.ProductTypes.Single(protyp_delete => protyp_delete.ProductTypeID == vrProductTypeID);

            StockTrackingDataContext.ProductTypes.DeleteOnSubmit(ProductType_Delete);
            StockTrackingDataContext.SubmitChanges();
        }
示例#21
0
        public void m_DistrictDel(int vrDistrictID)
        {
            StockTrackingDataContext = new L_StockTrackingERPDataContext();
            var District_Delete = StockTrackingDataContext.Districts.Single(dist_update => dist_update.DistrictID == vrDistrictID);

            StockTrackingDataContext.Districts.DeleteOnSubmit(District_Delete);
            StockTrackingDataContext.SubmitChanges();
        }
示例#22
0
        public void m_ProductTypeUpdate(int vrProductTypeID, string vrProductTypeName)
        {
            StockTrackingDataContext = new L_StockTrackingERPDataContext();
            var ProductType_Update = StockTrackingDataContext.ProductTypes.Single(protyp_update => protyp_update.ProductTypeID == vrProductTypeID);

            ProductType_Update.ProductType1 = vrProductTypeName;
            StockTrackingDataContext.SubmitChanges();
        }
示例#23
0
        public void m_CountryDel(int vrCountryID)
        {
            StockTrackingDataContext = new L_StockTrackingERPDataContext();
            var Country_Delete = StockTrackingDataContext.Countries.Single(coun_delete => coun_delete.CountryID == vrCountryID);

            StockTrackingDataContext.Countries.DeleteOnSubmit(Country_Delete);
            StockTrackingDataContext.SubmitChanges();
        }
示例#24
0
        public void m_CountryUpdate(int vrCountryID, string vrCountryName)
        {
            StockTrackingDataContext = new L_StockTrackingERPDataContext();
            var Country_Update = StockTrackingDataContext.Countries.Single(coun_update => coun_update.CountryID == vrCountryID);

            Country_Update.CountryName = vrCountryName;
            StockTrackingDataContext.SubmitChanges();
        }
示例#25
0
        public void m_CountryList(DataGridView vrdgrCountriesList)
        {
            StockTrackingDataContext = new L_StockTrackingERPDataContext();
            var CountryList_Query = StockTrackingDataContext.Countries;

            vrdgrCountriesList.DataSource            = CountryList_Query;
            vrdgrCountriesList.Columns[0].HeaderText = "Ülke ID";
            vrdgrCountriesList.Columns[1].HeaderText = "Ülke Adı";
        }
示例#26
0
        public void m_ProductTypeAdd(string vrProductTypeName)
        {
            StockTrackingDataContext = new L_StockTrackingERPDataContext();
            ProductType productType = new ProductType();

            productType.ProductType1 = vrProductTypeName;
            StockTrackingDataContext.ProductTypes.InsertOnSubmit(productType);
            StockTrackingDataContext.SubmitChanges();
        }
示例#27
0
        public void m_ProductTypesList(DataGridView vrdgrProductTypesList)
        {
            StockTrackingDataContext = new L_StockTrackingERPDataContext();
            var ProductTypesList_Query = StockTrackingDataContext.ProductTypes;

            vrdgrProductTypesList.DataSource            = ProductTypesList_Query;
            vrdgrProductTypesList.Columns[0].HeaderText = "Ürün Tip ID";
            vrdgrProductTypesList.Columns[1].HeaderText = "Ürün Tip Adı";
        }
示例#28
0
        public void m_CountryAdd(string vrCountryName)
        {
            StockTrackingDataContext = new L_StockTrackingERPDataContext();
            Country country = new Country();

            country.CountryName = vrCountryName;
            StockTrackingDataContext.Countries.InsertOnSubmit(country);
            StockTrackingDataContext.SubmitChanges();
        }
示例#29
0
        public void m_ProvincesID(string vrProvinceName, Label vrlblProvinceID)
        {
            StockTrackingDataContext = new L_StockTrackingERPDataContext();
            var ProvincesID_List = from albProvincesID in StockTrackingDataContext.Provinces where albProvincesID.ProvinceName == vrProvinceName select albProvincesID.ProvinceID;

            foreach (int provincesID in ProvincesID_List)
            {
                vrlblProvinceID.Text = provincesID.ToString();
            }
        }
示例#30
0
        public void m_CountriesID(string vrCountryName, Label vrlblID)
        {
            StockTrackingDataContext = new L_StockTrackingERPDataContext();
            var CountriesID_List = from albCountriesID in StockTrackingDataContext.Countries where albCountriesID.CountryName == vrCountryName select albCountriesID.CountryID;

            foreach (int countriesID in CountriesID_List)
            {
                vrlblID.Text = countriesID.ToString();
            }
        }