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); } }