private void GenerateInvoiceNumber() { //SequenceInvoice : this is a sequance object created in SQL ( this is not a table) int LastID = ObjDAL.ExecuteScalarInt("SELECT NEXT VALUE FOR " + clsUtility.DBName + ".[dbo].SequenceInvoice"); string InvoiceNumber = "INV-" + LastID; txtInvoiceNumber.Text = InvoiceNumber; }
private bool ValidateRights() { if (ObjUtil.IsControlTextEmpty(txtUserID)) { clsUtility.ShowInfoMessage("Enter Valid User Name.", clsUtility.strProjectTitle); txtName.Focus(); return(false); } if (!AnyRightCheck()) { clsUtility.ShowInfoMessage("Please select any rights from rights grid.", clsUtility.strProjectTitle); grpRights.Focus(); return(false); } int count = ObjCon.ExecuteScalarInt("SELECT COUNT(1) FROM " + clsUtility.DBName + ".[dbo].[tblUserRights] WITH(NOLOCK) WHERE UserID=" + txtUserID.Text); if (count > 0) { clsUtility.ShowInfoMessage("Rights for the user : "******" already exists. Please select new user or select existing user and update.", clsUtility.strProjectTitle); txtName.Focus(); return(false); } return(true); }
private string GetBarcodeNumber() { //SequenceInvoice : this is a sequance object created in SQL ( this is not a table) int LastID = ObjCon.ExecuteScalarInt("SELECT NEXT VALUE FOR " + clsUtility.DBName + ".[dbo].Barcode_Sequance"); return(LastID.ToString()); }
private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) { if (txtMobileNumber.Text.Trim().Length == 0) { clsUtility.ShowInfoMessage("Please enter mobile number."); return; } string strQ1 = "select CustomerID from CustomerMaster where PhoneNo='" + txtMobileNumber.Text + "'"; int CustID = ObjCon.ExecuteScalarInt(strQ1); if (CustID == 0) { clsUtility.ShowInfoMessage("Can not find the given mobile number in the system."); return; } else { DataTable dataTable = ObjCon.ExecuteSelectStatement("select InvoiceNumber, InvoiceDate from SalesInvoiceDetails where CustomerID=" + CustID + " order by Id desc"); if (dataTable.Rows.Count > 0) { cmbInvoice.DataSource = dataTable; cmbInvoice.DisplayMember = "InvoiceNumber"; cmbInvoice.ValueMember = "InvoiceDate"; cmbInvoice.SelectedIndex = -1; } pnlSelectInvoice.Visible = true; } }
private string GenerateReceiveBillNumber() { //SequenceInvoice : this is a sequance object created in SQL ( this is not a table) int LastID = ObjDAL.ExecuteScalarInt("SELECT NEXT VALUE FOR " + clsUtility.DBName + ".[dbo].Seq_StoreTransferReceiveBill"); string InvoiceNumber = "RECEBILL-" + LastID; return(InvoiceNumber); }
private void dgvQtycolor_CellEndEdit(object sender, DataGridViewCellEventArgs e) { try { int pTotalEnteredQTY = 0; if (e.ColumnIndex == 0 && dgvQtycolor.Rows[e.RowIndex].Cells["Color"].Value.ToString() != string.Empty) { int a = ObjDAL.CountRecords(clsUtility.DBName + ".dbo.ColorMaster", "ColorName = '" + dgvQtycolor.Rows[e.RowIndex].Cells["Color"].Value + "' AND ISNULL(ActiveStatus,1) = 1"); if (a <= 0) { flag = 1; clsUtility.ShowInfoMessage("Color Name " + dgvQtycolor.Rows[e.RowIndex].Cells["Color"].Value + " is not present in Color Master", clsUtility.strProjectTitle); //dgvQtycolor.Rows[e.RowIndex].Cells["Color"].Value = OldColorName; } else { int ColorID = ObjDAL.ExecuteScalarInt("SELECT ColorID FROM " + clsUtility.DBName + ".dbo.ColorMaster WITH(NOLOCK) WHERE ColorName = '" + dgvQtycolor.Rows[e.RowIndex].Cells["Color"].Value + "' AND ISNULL(ActiveStatus,1) = 1"); dtPurchaseQTYColor.Rows[e.RowIndex]["ColorID"] = ColorID; flag = 0; } } else { for (int i = 3; i < dtPurchaseQTYColor.Columns.Count - 1; i++) { pTotalEnteredQTY += dtPurchaseQTYColor.Rows[e.RowIndex][i] != DBNull.Value ? Convert.ToInt32(dtPurchaseQTYColor.Rows[e.RowIndex][i]) : 0; } dgvQtycolor.Rows[e.RowIndex].Cells["Total"].Value = pTotalEnteredQTY; txtTotalQTYEntered.Text = pTotalEnteredQTY.ToString(); CalcTotalColorQTY(); if (Convert.ToInt32(txtTotalQTYEntered.Text) > Convert.ToInt32(txtTotalQTYBill.Text)) { clsUtility.ShowInfoMessage("Entered QTY can't be greater then QTY Bill", clsUtility.strProjectTitle); //dgvQtycolor.Rows[e.RowIndex].Cells[e.ColumnIndex].Value = OldSize; } if (e.RowIndex + 1 == dgvQtycolor.Rows.Count) { DataRow Row = dtPurchaseQTYColor.NewRow(); dtPurchaseQTYColor.Rows.Add(Row); dtPurchaseQTYColor.AcceptChanges(); dgvQtycolor.DataSource = dtPurchaseQTYColor; } } } catch (InvalidOperationException) { } catch (IndexOutOfRangeException) { } catch (Exception ex) { clsUtility.ShowErrorMessage(ex.ToString(), clsUtility.strProjectTitle); } }
private void cmbStoreName_SelectionChangeCommitted(object sender, EventArgs e) { if (cmbStoreName.SelectedIndex != -1) { int stroreID = cmbStoreName.SelectedValue == DBNull.Value ? 0 : Convert.ToInt32(cmbStoreName.SelectedValue); string str = "SELECT StoreCategory FROM " + clsUtility.DBName + ".dbo.StoreMaster WITH(NOLOCK) WHERE StoreID=" + stroreID; int _stID = ObjDAL.ExecuteScalarInt(str); cmbStoreCategory.SelectedIndex = _stID; } }
private void cmbSupplier_SelectionChangeCommitted(object sender, EventArgs e) { if (cmbSupplier.SelectedIndex >= 0) { object ob = ObjDAL.ExecuteScalarInt("SELECT CountryID FROM " + clsUtility.DBName + ".dbo.SupplierMaster WHERE SupplierID = " + cmbSupplier.SelectedValue); cmbCountry.SelectedValue = ob; cmbCountry_SelectionChangeCommitted(sender, e); grpCurrencyRate.Enabled = true; grpForeignCurrency.Enabled = true; grpLocalCurrency.Enabled = true; } }
private bool IsArabicEnabled() { int count = ObjCon.ExecuteScalarInt("SELECT COUNT(1) FROM " + clsUtility.DBName + ".[dbo].[DefaultStoreSetting] WITH(NOLOCK) where ISNULL(UserArabicNumbers,0)=1 and MachineName='" + Environment.MachineName + "'"); if (count > 0) { return(true); } else { return(false); } }
private void btnAdd_Click(object sender, EventArgs e) { if (txtPCName.Text.Trim().Length == 0) { clsUtility.ShowInfoMessage("Please enter PC name.", clsUtility.strProjectTitle); txtPCName.Focus(); return; } else if (cmbStoreCategory.SelectedIndex == -1) { clsUtility.ShowInfoMessage("Please Select Store Category.", clsUtility.strProjectTitle); cmbStoreCategory.Focus(); return; } else if (cmbStoreName.SelectedIndex == -1) { clsUtility.ShowInfoMessage("Please Select Store Name.", clsUtility.strProjectTitle); cmbStoreName.Focus(); return; } int result = ObjCon.ExecuteScalarInt("SELECT count(1) FROM " + clsUtility.DBName + ".[dbo].[DefaultStoreSetting] WITH(NOLOCK) WHERE MachineName='" + txtPCName.Text + "'"); if (result > 0) // if data found for the PC thenupdate { ObjCon.UpdateColumnData("StoreID", SqlDbType.Int, cmbStoreName.SelectedValue); ObjCon.UpdateColumnData("MachineName", SqlDbType.NVarChar, txtPCName.Text); ObjCon.UpdateColumnData("StoreCategory", SqlDbType.Int, cmbStoreCategory.SelectedIndex); int r = ObjCon.UpdateData(clsUtility.DBName + ".[dbo].[DefaultStoreSetting]", "MachineName='" + txtPCName.Text + "'"); if (r > 0) { clsUtility.ShowInfoMessage("Default store settings has been updated.", clsUtility.strProjectTitle); } } else { // else insert. ObjCon.SetColumnData("StoreID", SqlDbType.Int, cmbStoreName.SelectedValue); ObjCon.SetColumnData("MachineName", SqlDbType.NVarChar, txtPCName.Text); ObjCon.SetColumnData("StoreCategory", SqlDbType.Int, cmbStoreCategory.SelectedIndex); int r = ObjCon.InsertData(clsUtility.DBName + ".[dbo].[DefaultStoreSetting]", false); if (r > 0) { clsUtility.ShowInfoMessage("Default store settings has been saved.", clsUtility.strProjectTitle); } lblmsg.Visible = false; } }
private void cmbSupplier_SelectionChangeCommitted(object sender, EventArgs e) { int a = 0; if (cmbSupplier.SelectedIndex >= 0) { a = ObjDAL.ExecuteScalarInt("SELECT BrandID FROM " + clsUtility.DBName + ".[dbo].[BrandMaster] WITH(NOLOCK) WHERE SupplierID=" + cmbSupplier.SelectedValue); } if (a > 0) { cmbBrand.SelectedValue = a; } else { cmbBrand.SelectedIndex = -1; } }
private void cmbSupplier_SelectionChangeCommitted(object sender, EventArgs e) { try { int a = ObjDAL.ExecuteScalarInt("SELECT CountryID FROM " + clsUtility.DBName + ".[dbo].[SupplierMaster] WITH(NOLOCK) WHERE SupplierID=" + cmbSupplier.SelectedValue); if (a > 0) { cmbCountry.SelectedValue = a; } else { cmbCountry.SelectedIndex = -1; } } catch (Exception ex) { clsUtility.ShowErrorMessage(ex.ToString(), clsUtility.strProjectTitle); } }
private bool ValidateEmployee() { if (ObjUtil.IsControlTextEmpty(txtEmployeeCode)) { clsUtility.ShowInfoMessage("Please Enter Employee Code.", clsUtility.strProjectTitle); txtEmployeeCode.Focus(); return(false); } else if (ObjUtil.IsControlTextEmpty(txtName)) { clsUtility.ShowInfoMessage("Please Enter Employee Name.", clsUtility.strProjectTitle); txtName.Focus(); return(false); } else if (ObjUtil.IsControlTextEmpty(txtMobileNo)) { clsUtility.ShowInfoMessage("Please Enter Employee Mobile No.", clsUtility.strProjectTitle); txtMobileNo.Focus(); return(false); } else if (radFemale.Checked == false && radMale.Checked == false) { clsUtility.ShowInfoMessage("Please Select Gender.", clsUtility.strProjectTitle); radMale.Focus(); radMale.Checked = false; radFemale.Checked = false; return(false); } int result = ObjDAL.ExecuteScalarInt("SELECT COUNT(1) FROM " + clsUtility.DBName + ".dbo.EmployeeDetails WITH(NOLOCK) WHERE EmployeeCode='" + txtEmployeeCode.Text + "' AND EMPID<>" + EmployeeID); if (result > 0) { clsUtility.ShowInfoMessage("The Employee already exist with the given employee code. Please Enter different employee code.", clsUtility.strProjectTitle); txtEmployeeCode.Focus(); return(false); } if (txtUsername.Text.Trim().Length > 0) // if user name is entered { if (ObjUtil.IsControlTextEmpty(txtPass)) { clsUtility.ShowInfoMessage("Please Enter Password.", clsUtility.strProjectTitle); txtPass.Focus(); return(false); } int countuser = ObjDAL.ExecuteScalarInt("SELECT COUNT(1) FROM " + clsUtility.DBName + ".dbo.UserManagement WITH(NOLOCK) WHERE UserName='******' AND EmployeeID<>" + EmployeeID); if (countuser > 0) { clsUtility.ShowInfoMessage("The user name already exist.Please enter different user name.", clsUtility.strProjectTitle); txtUsername.Focus(); return(false); } } return(true); }