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;
}
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();
}
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();
}
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();
}
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();
}
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();
}
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();
}
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();
}
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();
}
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();
}
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();
}
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();
}
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ı";
}
public void m_ProductTypeAdd(string vrProductTypeName)
{
StockTrackingDataContext = new L_StockTrackingERPDataContext();
ProductType productType = new ProductType();
productType.ProductType1 = vrProductTypeName;
StockTrackingDataContext.ProductTypes.InsertOnSubmit(productType);
StockTrackingDataContext.SubmitChanges();
}
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ı";
}
public void m_CountryAdd(string vrCountryName)
{
StockTrackingDataContext = new L_StockTrackingERPDataContext();
Country country = new Country();
country.CountryName = vrCountryName;
StockTrackingDataContext.Countries.InsertOnSubmit(country);
StockTrackingDataContext.SubmitChanges();
}
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();
}
}
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();
}
}