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)")));
}
