private string GetCashNumber() { //SequenceInvoice : this is a sequance object created in SQL ( this is not a table) long LastID = (long)ObjDAL.ExecuteScalar("SELECT NEXT VALUE FOR " + clsUtility.DBName + ".[dbo].Seq_CashNumber"); return(LastID.ToString()); }
private bool CheckProductQTY(string _BarCoeNumber, decimal CurQTY) { string strSQL = "SELECT QTY FROM " + clsUtility.DBName + ".[dbo].[ProductStockColorSizeMaster] WITH(NOLOCK) WHERE BarcodeNo=" + _BarCoeNumber + " AND StoreID=" + cmbShop.SelectedValue.ToString(); decimal TotalQTY = Convert.ToDecimal(ObjDAL.ExecuteScalar(strSQL)); if (CurQTY > TotalQTY) { return(false); } else { return(true); } }
private void btnAutoBackup_Click(object sender, EventArgs e) { inc++; if (inc % 2 == 0) { this.Size = new Size(364, 446); btnAutoBackup.Text = "Configure Auto Backup >>"; } else { this.Size = new Size(801, 446); btnAutoBackup.Text = "Configure Auto Backup <<"; dateTimePicker2.Value = DateTime.Now; try { object p = ObjDAL.ExecuteScalar("SELECT Path FROM " + clsUtility.DBName + ".dbo.BackupConfig WITH(NOLOCK) WHERE LEN(Path)>0 AND ISNULL(IsAutoBackup,0)=1 AND BackupID=1"); if (Directory.Exists(p.ToString())) { txtBacupPath.Text = p.ToString(); dateTimePicker2.Enabled = true; btnSave.Enabled = true; } } catch (Exception ex) { ObjUtil.WriteToFile("Exception Occured while getting auto path in button4_Click() " + ex.Message, "backup.log", true); } } }
private bool IsAdmin() { object a = ObjDAL.ExecuteScalar("SELECT IsAdmin FROM " + DBName + ".[dbo].[UserManagement] WITH(NOLOCK) WHERE UserName='******'"); bool admin = Convert.ToBoolean(a); return(admin); }
private void cmbCountry_SelectionChangeCommitted(object sender, EventArgs e) { if (cmbCountry.SelectedIndex >= 0) { object ob = ObjDAL.ExecuteScalar("SELECT CurrencyRate FROM " + clsUtility.DBName + ".dbo.CurrencyRateSetting WITH(NOLOCK) WHERE CountryID = " + cmbCountry.SelectedValue); txtCurrencyRate.Text = Convert.ToDecimal(ob).ToString(); } }
private void DisplayRegistrationInfo() { object ob = ObjDAL.ExecuteScalar("SELECT CONVERT(DATE,RegDate) RegDate FROM " + clsUtility.DBName + ".[dbo].[RegistrationDetails] WITH(NOLOCK) where PcName='" + Environment.MachineName + "'"); if (ob != null) { lblRegistrationDate.Text = Convert.ToDateTime(ob).ToShortDateString(); } else { lblRegistrationDate.Text = "NA"; } object company = ObjDAL.ExecuteScalar("SELECT CompanyName FROM " + clsUtility.DBName + ".[dbo].[CompanyMaster] WITH(NOLOCK)"); if (company != null) { lblLicensedTo.Text = company.ToString(); } else { lblLicensedTo.Text = "NA"; } }
private void LoadData() { DataTable dt = ObjDAL.ExecuteSelectStatement("EXEC " + clsUtility.DBName + ".dbo.Get_DiffPurchase_Received_Details " + PurchaseInvoiceID); int TotalBillQTY = 0, TotalReceivedQTY = 0, TotalDiffQTY = 0; double TotalDiffValue = 0; if (ObjUtil.ValidateTable(dt)) { for (int i = 0; i < dt.Rows.Count; i++) { TotalReceivedQTY += dt.Rows[i]["Receive QTY"] != DBNull.Value ? Convert.ToInt32(dt.Rows[i]["Receive QTY"]) : 0; TotalDiffQTY += dt.Rows[i]["Diff QTY"] != DBNull.Value ? Convert.ToInt32(dt.Rows[i]["Diff QTY"]) : 0; TotalDiffValue += dt.Rows[i]["Diff QTY"] != DBNull.Value ? Convert.ToDouble(dt.Rows[i]["Diff Value"]) : 0; if (i == 0) { TotalBillQTY = dt.Rows[i]["TotalQTY"] != DBNull.Value ? Convert.ToInt32(dt.Rows[i]["TotalQTY"]) : 0; continue; } } cmbSupplier.SelectedValue = Convert.ToInt32(dt.Rows[0]["SupplierID"]); txtTotalBillQTY.Text = TotalBillQTY.ToString(); txtTotalQTYReceived.Text = TotalReceivedQTY.ToString(); //txtTotalDiffQTY.Text = TotalDiffQTY.ToString(); txtTotalDiffQTY.Text = (TotalReceivedQTY - TotalBillQTY).ToString(); txtTotalDiffValue.Text = TotalDiffValue.ToString(); txtSupplierBillNo.Text = dt.Rows[0]["SupplierBillNo"].ToString(); txtNewRate.Text = dt.Rows[0]["New Rate"].ToString(); dtpBillDate.Value = Convert.ToDateTime(dt.Rows[0]["BillDate"]); object ob = ObjDAL.ExecuteScalar("SELECT CurrencyName FROM " + clsUtility.DBName + ".[dbo].[CurrencyRateSetting] WITH(NOLOCK) WHERE CountryID=" + dt.Rows[0]["CountryID"]); txtCurrencyName.Text = ob.ToString(); dataGridView1.DataSource = dt; } else { txtTotalBillQTY.Text = TotalBillQTY.ToString(); txtTotalQTYReceived.Text = TotalReceivedQTY.ToString(); txtTotalDiffQTY.Text = TotalDiffQTY.ToString(); txtTotalDiffValue.Text = TotalDiffValue.ToString(); dataGridView1.DataSource = null; } }
private string GetLoginEmployee() { string emp = "NA"; string str = " select e1.Name from EmployeeDetails e1 join " + " UserManagement u1 on e1.EmpID = u1.EmployeeID" + " where u1.UserID = " + clsUtility.LoginID; object strEmployeName = ObjDAL.ExecuteScalar(str); if (strEmployeName != null) { emp = strEmployeName.ToString(); } return(emp); }
private void cmbCountry_SelectionChangeCommitted(object sender, EventArgs e) { if (cmbCountry.SelectedIndex >= 0) { object ob = ObjDAL.ExecuteScalar("SELECT CurrencyRate FROM " + clsUtility.DBName + ".dbo.CurrencyRateSetting WITH(NOLOCK) WHERE CountryID = " + cmbCountry.SelectedValue); txtCurrencyRate.Text = Convert.ToDecimal(ob).ToString(); if (ob == null) { clsUtility.ShowInfoMessage("Currency Rate is not defined for Country " + cmbCountry.Text, clsUtility.strProjectTitle); btnCurrencyRatePopup.Enabled = true; } else { btnCurrencyRatePopup.Enabled = false; } } }
private void frmHome_Load(object sender, EventArgs e) { try { clsUtility.DBName = "IMS"; clsUtility.LoginID = 1; //clsUtility.IsAdmin = false; clsUtility.IsAdmin = true; if (clsUtility.LoginID > 0) { object ob = ObjDAL.ExecuteScalar("SELECT UserName from " + clsUtility.DBName + ".[dbo].[UserManagement] WHERE UserID =" + clsUtility.LoginID); lblLoginName.Text = "Login By : " + ob.ToString(); } else { lblLoginName.Text = "Login By : Test Admin"; } lblVersion.Text = "Version : " + Application.ProductVersion; } catch { } }
private string GetStoreName() { return(Convert.ToString(ObjCon.ExecuteScalar("SELECT CompanyName FROM " + clsUtility.DBName + ".dbo.CompanyMaster WITH(NOLOCK)"))); }