public Int32 CheckMailExist(string reportId)
{
ConnectionManager conManager = new ConnectionManager(ConName);
Int32 ID = 0;
try
{
String sql = "GetReportID " + reportId;
Object id = conManager.ExecuteScalarWrapper(sql);
ID = Convert.ToInt32(id);
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (conManager.IsNotNull())
{
conManager.Dispose();
}
}
return ID;
}
public static Decimal GetAllAcc_VoucherDet(Int32 orgKey, string fromDate, string toDate, Int32 head,string spName)
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
Decimal balance = 0.0M;
string search = "";
search = head + "," + orgKey + ",'" + fromDate + "','" + toDate+"'";
try
{
String sql = "EXEC "+spName+" "+ search + "";
Object oppBal = conManager.ExecuteScalarWrapper(sql);
balance = Convert.ToDecimal(oppBal);
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (conManager.IsNotNull())
{
conManager.Dispose();
}
}
return balance;
}
public static String GetHKName(Int32 HKID)
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
String HKName = "";
try
{
String sql = "select HKName from HouseKeepingValue Where HKID=" + HKID;
Object Name = conManager.ExecuteScalarWrapper(sql);
HKName = Convert.ToString(Name);
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (conManager.IsNotNull())
{
conManager.Dispose();
}
}
return HKName;
}