/// <summary>
///
/// </summary>
/// <param name="buildId"></param>
/// <returns></returns>
public IList <DataTable> GetUnitByBuild(string buildId)
{
string funMsg = "function: GetUnitByBuild(string buildId);" + FileUtility.NewLine + _ClassMsg;
string procedureName = string.Empty;
try
{
procedureName = "sp_getallunit_DB";//"spListUnitByBuild";
return(DbUtility.GetDataTableListByProc(procedureName, _CentaDbConn, new SqlParameter[] {
new SqlParameter {
ParameterName = "@buildId", SqlDbType = SqlDbType.NVarChar, Value = buildId
},
new SqlParameter {
ParameterName = "@floor", SqlDbType = SqlDbType.NVarChar, Value = string.Empty
},
new SqlParameter {
ParameterName = "@room", SqlDbType = SqlDbType.NVarChar, Value = string.Empty
}
}));
}
catch (Exception ex)
{
string exMsg = "Exception: " + ex.Message + FileUtility.NewLine + "ProcedureName: " + procedureName + FileUtility.NewLine + funMsg;
throw new Exception(exMsg, ex.InnerException);
}
}
public IList <DataTable> ListScope()
{
string funMsg = "Function: ListScope();" + FileUtility.NewLine + _ClassMsg;
string procedureName = string.Empty;
try
{
procedureName = "spListScope";
return(DbUtility.GetDataTableListByProc(procedureName, _ConnStr));
}
catch (Exception ex)
{
string exMsg = "Exception: " + ex.Message + FileUtility.NewLine + "ProcedureName: " + procedureName + FileUtility.NewLine + funMsg;
throw new Exception(exMsg, ex.InnerException);
}
}
