public static FieldForceChain DataRowToObject(DataRow dr)
{
FieldForceChain TheFieldForceChain = new FieldForceChain();
TheFieldForceChain.FieldForceChainID = int.Parse(dr["FieldForceChainID"].ToString());
TheFieldForceChain.FieldForceID = int.Parse(dr["FieldForceID"].ToString());
TheFieldForceChain.FieldForceCode = dr["FieldForceCode"].ToString();
TheFieldForceChain.FieldForceName = dr["FieldForceName"].ToString();
TheFieldForceChain.FieldForceRankID = int.Parse(dr["FieldForceRankID"].ToString());
TheFieldForceChain.FieldForceRankName = dr["FieldForceRankName"].ToString();
TheFieldForceChain.FieldForceRankDescription = dr["FieldForceRankDescription"].ToString();
TheFieldForceChain.ReportingToFieldForceID = int.Parse(MicroGlobals.ReturnZeroIfNull(dr["ReportingToFieldForceID"].ToString()));
if (TheFieldForceChain.ReportingToFieldForceID > 0)
{
TheFieldForceChain.ReportingToFieldForceCode = dr["ReportingToFieldForceCode"].ToString();
TheFieldForceChain.ReportingToFieldForceName = dr["ReportingToFieldForceName"].ToString();
TheFieldForceChain.ReportingToRankID = int.Parse(dr["ReportingToRankID"].ToString());
TheFieldForceChain.ReportingToRankName = dr["ReportingToRankName"].ToString();
TheFieldForceChain.ReportingToRankDescription = dr["ReportingToRankDescription"].ToString();
}
TheFieldForceChain.ChainCode = dr["ChainCode"].ToString();
TheFieldForceChain.OfficeID = int.Parse(dr["OfficeID"].ToString());
TheFieldForceChain.OfficeName = dr["OfficeName"].ToString();
TheFieldForceChain.EffectiveDateFrom = DateTime.Parse(dr["EffectiveDateFrom"].ToString()).ToString(MicroConstants.DateFormat);
if (!string.IsNullOrEmpty(dr["EffectiveDateTo"].ToString()))
{
TheFieldForceChain.EffectiveDateTo = DateTime.Parse(dr["EffectiveDateTo"].ToString()).ToString(MicroConstants.DateFormat);
}
return(TheFieldForceChain);
}
public static List <FieldForceChain> GetFieldForceChainsByFieldForceID(int fieldForceId)
{
List <FieldForceChain> FieldForceChainList = new List <FieldForceChain>();
DataTable FieldForceChainTable = new DataTable();
FieldForceChainTable = FieldForceChainDataAccess.GetInstance.GetFieldForceChainsByFieldForceID(fieldForceId);
foreach (DataRow dr in FieldForceChainTable.Rows)
{
FieldForceChain TheFieldForceChain = DataRowToObject(dr);
FieldForceChainList.Add(TheFieldForceChain);
}
return(FieldForceChainList);
}
