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_StockActionDetailsDelete(int vrStockActionNo)
{
StockTrackingDataContext = new L_StockTrackingERPDataContext();
var StockActionDetailsDelete_Query = StockTrackingDataContext.p_StockDetailsDelete(vrStockActionNo);
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_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_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_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_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_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_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_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_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_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_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_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_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_ProductTypeAdd(string vrProductTypeName)
{
StockTrackingDataContext = new L_StockTrackingERPDataContext();
ProductType productType = new ProductType();
productType.ProductType1 = vrProductTypeName;
StockTrackingDataContext.ProductTypes.InsertOnSubmit(productType);
StockTrackingDataContext.SubmitChanges();
}
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_ProvinceUpdate(int vrProvinceID, string vrProvinceCode, string vrProvinceName, int vrCountryID)
{
StockTrackingDataContext = new L_StockTrackingERPDataContext();
var Province_Update = StockTrackingDataContext.Provinces.Single(prov_update => prov_update.ProvinceID == vrProvinceID);
Province_Update.ProvinceCode = vrProvinceCode;
Province_Update.ProvinceName = vrProvinceName;
Province_Update.CountryID = vrCountryID;
StockTrackingDataContext.SubmitChanges();
}
public void m_DistrictUpdate(int vrDistrictID, string vrDistrictName, int vrProvinceID, int vrCountryID)
{
StockTrackingDataContext = new L_StockTrackingERPDataContext();
var District_Update = StockTrackingDataContext.Districts.Single(dist_update => dist_update.DistrictID == vrDistrictID);
District_Update.DistrictName = vrDistrictName;
District_Update.ProvinceID = vrProvinceID;
District_Update.CountryID = vrCountryID;
StockTrackingDataContext.SubmitChanges();
}
public void m_DistrictAdd(string vrDistrictName, int vrProvinceID, int vrCountryID)
{
StockTrackingDataContext = new L_StockTrackingERPDataContext();
District district = new District();
district.DistrictName = vrDistrictName;
district.ProvinceID = vrProvinceID;
district.CountryID = vrCountryID;
StockTrackingDataContext.Districts.InsertOnSubmit(district);
StockTrackingDataContext.SubmitChanges();
}
public void m_ProvinceAdd(string vrProvinceCode, string vrProvinceName, int vrCountryID)
{
StockTrackingDataContext = new L_StockTrackingERPDataContext();
Province province = new Province();
province.ProvinceCode = vrProvinceCode;
province.ProvinceName = vrProvinceName;
province.CountryID = vrCountryID;
StockTrackingDataContext.Provinces.InsertOnSubmit(province);
StockTrackingDataContext.SubmitChanges();
}
public void m_StockActionDetailsAdd(int vrStockActionNo, int vrProductCode, int vrProductCount)
{
StockTrackingDataContext = new L_StockTrackingERPDataContext();
StockActionDetail ActionDetail = new StockActionDetail();
ActionDetail.StockAction = vrStockActionNo;
ActionDetail.ProductCode = vrProductCode;
ActionDetail.ProductCount = vrProductCount;
StockTrackingDataContext.StockActionDetails.InsertOnSubmit(ActionDetail);
StockTrackingDataContext.SubmitChanges();
}
public void m_UserAdd(string vrUserCode, string vrUserPassword, string vrNameSurName, string vrEMail, string vrTelephone)
{
StockTrackingDataContext = new L_StockTrackingERPDataContext();
User user = new User();
user.UserCode = vrUserCode;
user.UserPassword = vrUserPassword;
user.NameSurName = vrNameSurName;
user.EMail = vrEMail;
user.Telephone = vrTelephone;
StockTrackingDataContext.Users.InsertOnSubmit(user);
StockTrackingDataContext.SubmitChanges();
}
public void m_UserUpdate(int vrUserID, string vrUserCode, string vrUserPassword, string vrNameSurName, string vrEMail, string vrTelephone)
{
StockTrackingDataContext = new L_StockTrackingERPDataContext();
var User_Update = StockTrackingDataContext.Users.Single(usr_update => usr_update.UserID == vrUserID);
if (vrUserPassword == "")
{
User_Update.UserCode = vrUserCode;
User_Update.NameSurName = vrNameSurName;
User_Update.EMail = vrEMail;
User_Update.Telephone = vrTelephone;
StockTrackingDataContext.SubmitChanges();
}
else
{
User_Update.UserCode = vrUserCode;
User_Update.UserPassword = vrUserPassword;
User_Update.NameSurName = vrNameSurName;
User_Update.EMail = vrEMail;
User_Update.Telephone = vrTelephone;
StockTrackingDataContext.SubmitChanges();
}
}
public void m_AccountingIntegrationBack(int vrAccountingReceiptNo, int vrInvoiceNo)
{
StockTrackingDataContext = new L_StockTrackingERPDataContext();
var AccountingReceiptDelete = StockTrackingDataContext.AccountingReceipts.Single(d_AccountingReceiptDelete => d_AccountingReceiptDelete.ReceiptNo == vrAccountingReceiptNo);
StockTrackingDataContext.AccountingReceipts.DeleteOnSubmit(AccountingReceiptDelete);
StockTrackingDataContext.SubmitChanges();
StockTrackingDataContext = new L_StockTrackingERPDataContext();
var AccountingReceiptUpdate = StockTrackingDataContext.Invoices.Single(d_AccountingReceiptUpdate => d_AccountingReceiptUpdate.InvoiceNo == vrInvoiceNo);
AccountingReceiptUpdate.AccountingReceiptNo = 0;
StockTrackingDataContext.SubmitChanges();
MessageBox.Show("Muhasebe Entegrasyonu Geri Alındı", "Muhasebe Entegrasyon", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
public void m_CustomerUpdate(int vrCustomerID, string vrTitle, string vrTaxAdministration, int vrTaxNumber, string vrCountry, string vrProvince, string vrDistrict, string vrAdress, string vrTelephone, string vrEmail)
{
StockTrackingDataContext = new L_StockTrackingERPDataContext();
var myquery = StockTrackingDataContext.Customers.Single(d_myquery => d_myquery.CustomerID == vrCustomerID);
myquery.Title = vrTitle;
myquery.TaxAdministration = vrTaxAdministration;
myquery.TaxNumber = vrTaxNumber;
myquery.Country = vrCountry;
myquery.Province = vrProvince;
myquery.District = vrDistrict;
myquery.Adress = vrAdress;
myquery.Telephone = vrTelephone;
myquery.Email = vrEmail;
StockTrackingDataContext.SubmitChanges();
}
public void m_CustomerAdd(string vrTitle, string vrTaxAdministration, int vrTaxNumber, string vrCountry, string vrProvince, string vrDistrict, string vrAdress, string vrTelephone, string vrEmail)
{
StockTrackingDataContext = new L_StockTrackingERPDataContext();
Customer Cus = new Customer();
Cus.Title = vrTitle;
Cus.TaxAdministration = vrTaxAdministration;
Cus.TaxNumber = vrTaxNumber;
Cus.Country = vrCountry;
Cus.Province = vrProvince;
Cus.District = vrDistrict;
Cus.Adress = vrAdress;
Cus.Telephone = vrTelephone;
Cus.Email = vrEmail;
StockTrackingDataContext.Customers.InsertOnSubmit(Cus);
StockTrackingDataContext.SubmitChanges();
}