protected DataRow GetDataRow(string userName)
{
string funMsg = "Function: GetDataRow(string userName)" + FileUtility.NewLine + _ClassMsg;
string procedureName = "spGetMemberByUserName";
try
{
return(DbUtility.GetDataRowByProc(procedureName, _ConnStr, new SqlParameter[] {
new SqlParameter {
ParameterName = "@userName", SqlDbType = SqlDbType.NVarChar, Value = userName
}
}));
}
catch (Exception ex)
{
throw ex;
}
}
public DataRow GetComparedBuild(string buildId)
{
string funMsg = "function: GetComparedBuild(string buildId)" + FileUtility.NewLine + _ClassMsg;
try
{
string procedure = "spGetComparedBuild";
return(DbUtility.GetDataRowByProc(procedure, this.ConnStr, new SqlParameter[] {
new SqlParameter {
ParameterName = "@buildId", SqlDbType = SqlDbType.VarChar, Value = buildId
}
}));
}
catch (Exception ex)
{
throw ex;
}
}
public DataRow GetUnit(string unitId)
{
string funMsg = "Function: GetUnit(string unitId)" + FileUtility.NewLine + _ClassMsg;
try
{
string procedure = "spGetUnit";
return(DbUtility.GetDataRowByProc(procedure, this.ConnStr, new SqlParameter
{
ParameterName = "@unitId",
SqlDbType = SqlDbType.VarChar,
Value = unitId
}));
}
catch (Exception ex)
{
throw ex;
}
}
public virtual DataRow GetEstate(string estateId)
{
string funMsg = "Function: GetDataRow(string estateId)" + FileUtility.NewLine + _ClassMsg;
string procedureName = string.Empty;
try
{
procedureName = "spGetEstate";
return(DbUtility.GetDataRowByProc(procedureName, this.ConnStr, new SqlParameter[] {
new SqlParameter {
ParameterName = "@estateId", SqlDbType = SqlDbType.NVarChar, Value = estateId
}
}));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
///
/// </summary>
/// <param name="unitId"></param>
/// <returns></returns>
public DataRow GetUnitById(string unitId)
{
string funMsg = "function: GetUnitById(string unitId)" + FileUtility.NewLine + _ClassMsg;
string procedureName = string.Empty;
try
{
procedureName = "sp_getoneunit_DB";//"spGetUnitByKey";
return(DbUtility.GetDataRowByProc(procedureName, _CentaDbConn, new SqlParameter[] {
new SqlParameter {
ParameterName = "@unitId", SqlDbType = SqlDbType.Char, Value = unitId
}
}));
}
catch (Exception ex)
{
string exMsg = "Exception: " + ex.Message + FileUtility.NewLine + "ProcedureName: " + procedureName + FileUtility.NewLine + funMsg;
throw new Exception(exMsg, ex.InnerException);
}
}
