public int GetId(string ItemName, string ItemValue)
{
DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery("prcGetId");
dquery.AddVarcharParam("@ItemName", 15, ItemName);
dquery.AddVarcharParam("@ItemValue", 50, ItemValue);
return(Convert.ToInt32(dquery.GetScalar()));
}
public bool IsUnique(string tableName, string colName, string val)
{
DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery("Select count(*) from " + tableName + " where " + colName + " = '" + val + "'", true);
bool returnval = false;
try
{
returnval = Convert.ToInt32(dquery.GetScalar()) > 0 ? false : true;
}
catch (Exception)
{
}
return(returnval);
}
public int InvoiceDateCheck(DateTime dt)
{
DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery("prcInvoiceDateCheck");
dquery.AddDateTimeParam("@StaxDate", dt);
return(Convert.ToInt32(dquery.GetScalar()));
}
public decimal GetExchnageRate(DateTime dt)
{
DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery("prcGetExchnageRate");
dquery.AddDateTimeParam("@Exdate", dt);
return(Convert.ToDecimal(dquery.GetScalar()));
}