public DataSet fillDropDown(string param0, string param1 = "", string param2 = "")
{
List <SqlParameter> _param = new List <SqlParameter>();
try
{
_param.Add(new SqlParameter("@param0", param0));
_param.Add(new SqlParameter("@param1", param1));
_param.Add(new SqlParameter("@param2", param2));
return(_SqlDbBridge.ExecuteDataSet("proc_FillDropDown", _param));
}
catch (Exception ex)
{
return(null);
throw;
}
}
public ReturnStatus setLoginLogout(string UserID, string Action)
{
ReturnStatus objReturnStatus = new ReturnStatus();
List <SqlParameter> _param = new List <SqlParameter>();
try
{
_param.Add(new SqlParameter("@UserID", UserID));
_param.Add(new SqlParameter("@Action", Action));
return(_SqlDbBridge.ExecuteDataSet("proc_LoginLogout", _param).Tables[0].AsEnumerable().Select(d => new ReturnStatus {
ErrorStatus = Convert.ToInt32(d["ErrorStatus"]), ErrorMessage = Convert.ToString(d["ErrorMessage"])
}).Single());
}
catch (Exception ex)
{
objReturnStatus.ErrorStatus = 1;
objReturnStatus.ErrorMessage = ex.Message;
}
return(objReturnStatus);
}