private void callOnLoad()
{
HandlerToDB.SetComboBox(combMedType, ConfigFormNames.PRODUCT_NEW);
HandlerToDB.SetComboBox(combSTMode, ConfigSelectQueries.SALES_TAX_MODE);
HandlerToDB.SetComboBox(combDisMode, ConfigSelectQueries.DISCOUNT_MODE);
stockDataGrid.DataSource = stockREC = HandlerToDB.GetDataTable(ConfigSelectQueries.ALL_STOCK);
proDataGrid.DataSource = ProREC = HandlerToDB.GetDataTable(ConfigSelectQueries.ALL_PRODUCTS);
ComDataGrid.DataSource = companyList = HandlerToDB.GetDataTable(ConfigSelectQueries.ALL_COMPANY);
SalesManDataGrid.DataSource = smREC = HandlerToDB.GetDataTable(ConfigSelectQueries.ALL_SALES_MAN);
cusDataGrid.DataSource = cusREC = HandlerToDB.GetDataTable(ConfigSelectQueries.ALL_CUSTOMER);
ModeID = false;
cityRec = new DataTable();
CityDataGrid.DataSource = cityRec = HandlerToDB.GetDataTable(ConfigSelectQueries.ALL_CITY);
// cusDataGrid.Focus();
CurrentStage = Stage.One;
Stage1.Visible = true;
lblSearchPro.Text = ConfigApp.SEARCH_MODE_ID_MESSAGE;
ModeIDPro = true;
lblMode.Text = ConfigApp.SEARCH_MODE_ID_MESSAGE;
lblSearchCom.Text = ConfigApp.SEARCH_MODE_ID_MESSAGE;
ModeID = true;
//CityDataGrid.Focus();
dateInvoice.CustomFormat = ConfigApp.DATETIME_FORMATE;
txtSalesNo.AdvanceText = HandlerToDB.GetNewID(ConfigFormNames.SALES).ToString();
txtInvoice.AdvanceText = HandlerToDB.GetNewID(ConfigSelectQueryModes.MAX_INVOICE).ToString();
txtSearch.Focus();
}
private void callOnLoad()
{
DataGrid.DataSource = HandlerToDB.GetDataTable(ConfigSelectQueries.ALL_CUSTOMER);
ModeID = false;
cityRec = new DataTable();
CityDataGrid.DataSource = cityRec = HandlerToDB.GetDataTable(ConfigSelectQueries.ALL_CITY);
DataGrid.Focus();
}
private void callOnLoad()
{
DateTime now = DateTime.Now;
txtCusExpDate.MinDate = new DateTime(now.Year + ConfigApp.CUSTOMER_EXPIRY_MIN_Y, now.Month + ConfigApp.CUSTOMER_EXPIRY_MIN_M, now.Day + ConfigApp.CUSTOMER_EXPIRY_MIN_D);
DatePicker.MinDate = ConfigApp.MIN_DATETIME;
ModeID = false;
cityRec = new DataTable();
txtCusCusCode.AdvanceText = HandlerToDB.GetNewID(ConfigFormNames.CUSTOMER_NEW).ToString();
DataGrid.DataSource = cityRec = HandlerToDB.GetDataTable(ConfigSelectQueries.ALL_CITY);
}
private void callOnLoad()
{
ModeID = false;
txtPSalesTax.Text = ConfigApp.SALES_TEX_PERCENTAGE.ToString();
companyList = new DataTable();
DatePicker.CustomFormat = ConfigApp.DATETIME_FORMATE;
txtProductCode.AdvanceText = HandlerToDB.GetNewID(ConfigFormNames.PRODUCT_NEW).ToString();
HandlerToDB.SetComboBox(combMedType, ConfigFormNames.PRODUCT_NEW);
HandlerToDB.SetComboBox(combSTMode, ConfigSelectQueries.SALES_TAX_MODE);
HandlerToDB.SetComboBox(combDisMode, ConfigSelectQueries.DISCOUNT_MODE);
HandlerToDB.SetComboBox(combGroup, ConfigSelectQueries.GROUPS_LOAD);
DataGrid.DataSource = companyList = HandlerToDB.GetDataTable(ConfigSelectQueries.ALL_COMPANY);
}
private void btnDel_Click(object sender, EventArgs e)
{
if (isValid())
{
OBJ_Zone.ZONE_CODE = Convert.ToInt32(txtZCode.AdvanceText);
HANDLER.ShowMessage(txtMessage, HandlerToDB.InsertOrUpdate(ConfigFormNames.ZONE_NEW, ConfigQueryModes.DELETE) + " " + ConfigApp.DELETE_MESSAGE);
FormReset();
DataGrid.DataSource = HandlerToDB.GetDataTable(ConfigSelectQueries.ALL_ZONE);
}
else
{
HANDLER.ShowMessage(txtMessage, ConfigApp.NOT_VALID_FORM_MESSAGE);
}
}
private void saveRecord()
{
if (isValid())
{
OBJ_Zone.ZONE_NAME = txtName.AdvanceText;
OBJ_Zone.ZONE_CODE = Convert.ToInt32(txtCode.AdvanceText);
HANDLER.ShowMessage(txtMessage, HandlerToDB.InsertOrUpdate(ConfigFormNames.ZONE_NEW, ConfigQueryModes.UPDATE) + " " + ConfigApp.UPDATE_MESSAGE);
DataGrid.DataSource = HandlerToDB.GetDataTable(ConfigSelectQueries.ALL_ZONE);
FormReset();
}
else
{
HANDLER.ShowMessage(txtMessage, ConfigApp.NOT_VALID_FORM_MESSAGE);
}
}
private void callOnLoad()
{
lblModePro.Text = ConfigApp.SEARCH_MODE_ID_MESSAGE;
ModeIDPRO = true;
lblMode.Text = ConfigApp.SEARCH_MODE_ID_MESSAGE;
ModeID = true;
companyList = new DataTable();
productList = new DataTable();
ProDataGrid.DataSource = productList = HandlerToDB.GetDataTable(ConfigSelectQueries.ALL_PRODUCTS);
ComDataGrid.DataSource = companyList = HandlerToDB.GetDataTable(ConfigSelectQueries.ALL_COMPANY);
DateExpiry.CustomFormat = ConfigApp.DATETIME_EXPIRY_FORMATE;
DateTime now = DateTime.Now;
DateExpiry.MinDate = new DateTime(now.Year + ConfigApp.STOCK_EXPIRY_MIN_Y, now.Month + ConfigApp.STOCK_EXPIRY_MIN_M, now.Day + ConfigApp.STOCK_EXPIRY_MIN_D);
dateInvoice.CustomFormat = ConfigApp.DATETIME_FORMATE;
dateInvoice.MinDate = DateTime.Now;
HandlerToDB.SetComboBox(combSTMode, ConfigSelectQueries.SALES_TAX_MODE);
HandlerToDB.SetComboBox(combDisMode, ConfigSelectQueries.DISCOUNT_MODE);
txtStockCode.AdvanceText = HandlerToDB.GetNewID(ConfigFormNames.STOCK_NEW).ToString();
}
private void DialogeZoneList_Load(object sender, EventArgs e)
{
DataGrid.DataSource = HandlerToDB.GetDataTable(ConfigSelectQueries.ALL_ZONE);
}
private void callOnLoad()
{
HandlerToDB.SetComboBox(combZone, ConfigFormNames.CITY_NEW);
DataGrid.DataSource = HandlerToDB.GetDataTable(ConfigSelectQueries.ALL_SALES_MAN);
DataGrid.Focus();
}
private void callOnLoad()
{
DataGrid.DataSource = HandlerToDB.GetDataTable(ConfigSelectQueries.ALL_COMPANY);
DataGrid.Focus();
}
private void callOnLoad()
{
DataGrid.DataSource = HandlerToDB.GetDataTable(ConfigSelectQueries.ALL_CITY);
HandlerToDB.SetComboBox(combZoneName, ConfigFormNames.CITY_NEW);
FormReset();
}