private void addRecord() { if (CurrentStage == Stage.locked) { if (formValidate()) { setObjects(); HANDLER.ShowMessage(txtMessage, HandlerToDB.InsertOrUpdate(ConfigFormNames.STOCK_NEW, ConfigQueryModes.INSERT) + " " + ConfigApp.INSERT_MESSAGE); // callOnLoad(); clearForm(); txtStockCode.AdvanceText = HandlerToDB.GetNewID(ConfigFormNames.STOCK_NEW).ToString(); DataGrid.DataSource = HandlerToDB.GetDataTableWhere(ConfigSelectQueryModes.CURRENT_INVOICE_MODE); txtProCode.AdvanceText = "0"; txtBatchNo.Enabled = true; txtBatchNo.Focus(); } else { HANDLER.ShowMessage(txtMessage, ConfigApp.NOT_VALID_FORM_MESSAGE); } } else { HANDLER.ShowMessage(txtMessage, "Enter Invoice No To Proced"); } }
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 addReccord() { if (IsValidate()) { setObject(); HANDLER.ShowMessage(txtMessage, HandlerToDB.InsertOrUpdate(ConfigFormNames.COMPANY, ConfigQueryModes.INSERT) + " " + ConfigApp.INSERT_MESSAGE); txtCCode.AdvanceText = HandlerToDB.GetNewID(ConfigFormNames.COMPANY).ToString(); FormReset(); } }
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 updateRecord() { if (isFormValidated()) { setObject(); HANDLER.ShowMessage(txtMessage, HandlerToDB.InsertOrUpdate(ConfigFormNames.PRODUCT_NEW, ConfigQueryModes.UPDATE) + " " + ConfigApp.UPDATE_MESSAGE); calOnLoad(); } else { HANDLER.ShowMessage(txtMessage, ConfigApp.NOT_VALID_FORM_MESSAGE); } }
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 addRecord() { if (isValid()) { OBJ_Zone.ZONE_NAME = txtZName.AdvanceText; HANDLER.ShowMessage(txtMessage, HandlerToDB.InsertOrUpdate(ConfigFormNames.ZONE_NEW, ConfigQueryModes.INSERT) + " " + ConfigApp.INSERT_MESSAGE); txtZCode.AdvanceText = HandlerToDB.GetNewID(ConfigFormNames.ZONE_NEW).ToString(); FormReset(); } else { HANDLER.ShowMessage(txtMessage, ConfigApp.NOT_VALID_FORM_MESSAGE); } }
private void addRecord() { if (isFormValied()) { setObjects(); HANDLER.ShowMessage(txtMessage, HandlerToDB.InsertOrUpdate(ConfigFormNames.SALES_MAN_NEW, ConfigQueryModes.INSERT) + " " + ConfigApp.INSERT_MESSAGE); txtSalesManCode.AdvanceText = HandlerToDB.GetNewID(ConfigFormNames.SALES_MAN_NEW).ToString(); resetForm(); } 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 btnAdd_Click(object sender, EventArgs e) { if (formValidate()) { setObjects(); HANDLER.ShowMessage(txtMessage, HandlerToDB.InsertOrUpdate(ConfigFormNames.SALES, ConfigQueryModes.INSERT) + " " + ConfigApp.INSERT_MESSAGE); currentSgate = Stage.Locked; clearForm(); btnNewInvoice.Enabled = true; txtSalesNo.AdvanceText = HandlerToDB.GetNewID(ConfigFormNames.SALES).ToString(); salesDataGrid.DataSource = HandlerToDB.GetDataTableWhere(ConfigSelectQueryModes.CURRENT_SALE_INVOICE_MODE); } else { HANDLER.ShowMessage(txtMessage, ConfigApp.NOT_VALID_FORM_MESSAGE); } }
private void setInvoice() { //Check if invoice already exist or not OBJ_Stock.INVOICE_NO = txtInvoice.AdvanceText; OBJ_Stock.COMPANY_CODE =Convert.ToInt32( txtComCode.AdvanceText); if (HandlerToDB.GetCount(ConfigSelectQueryModes.NO_OF_INVOICES) == 0) { txtInvoice.Enabled = false; txtBatchNo.Enabled = true; txtBatchNo.Focus(); CurrentStage = Stage.locked; } else { txtInvoice.AdvanceText = ""; HANDLER.ShowMessage(txtMessage, "Invoice Already Exist in "+ ComDataGrid.Rows[ComDataGrid.SelectedRows[0].Index].Cells["C_Name"].Value.ToString()); } }
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 setBatch() { //Check if invoice already exist or not OBJ_Stock.BATCH_NO = txtBatchNo.AdvanceText; OBJ_Stock.COMPANY_CODE = Convert.ToInt32(txtComCode.AdvanceText); if (HandlerToDB.GetCount(ConfigSelectQueryModes.NO_OF_BATCHS) == 0) { txtQuantity.Enabled = true; dateInvoice.Enabled = true; DateExpiry.Enabled = true; gbActions.Enabled = true; gPricing.Enabled = true; txtBatchNo.Enabled = false; } else { txtBatchNo.AdvanceText = ""; HANDLER.ShowMessage(txtMessage, "Batch Already Exist in "+ComDataGrid.Rows[ComDataGrid.SelectedRows[0].Index].Cells["C_Name"].Value.ToString()); } }
private void callOnLoad() { DataGrid.DataSource = HandlerToDB.GetDataTable(ConfigSelectQueries.ALL_CITY); HandlerToDB.SetComboBox(combZoneName, ConfigFormNames.CITY_NEW); FormReset(); }
private void ZoneNew_Load(object sender, EventArgs e) { txtZCode.AdvanceText = HandlerToDB.GetNewID(ConfigFormNames.ZONE_NEW).ToString(); }
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 Company_Load(object sender, EventArgs e) { txtCCode.AdvanceText = HandlerToDB.GetNewID(ConfigFormNames.COMPANY).ToString(); // txtCName.AdvanceText = DateTime.Now.ToString(); }
private void callOnLoad() { HandlerToDB.SetComboBox(combZone, ConfigFormNames.CITY_NEW); txtSalesManCode.AdvanceText = HandlerToDB.GetNewID(ConfigFormNames.SALES_MAN_NEW).ToString(); }
private void btnAddNewZone_Click(object sender, EventArgs e) { GUI.loadFormInDialoge(ConfigFormNames.ZONE_NEW); HandlerToDB.SetComboBox(combZoneName, ConfigFormNames.CITY_NEW); }
private void DialogeZoneList_Load(object sender, EventArgs e) { DataGrid.DataSource = HandlerToDB.GetDataTable(ConfigSelectQueries.ALL_ZONE); }
private void CityNew_Load(object sender, EventArgs e) { HandlerToDB.SetComboBox(combZoneName, ConfigFormNames.CITY_NEW); txtCCode2.AdvanceText = HandlerToDB.GetNewID(ConfigFormNames.CITY_NEW).ToString(); }