private ShareHoldingStructure FetchShareHolersList(ShareHoldingStructure objShareHoldingStructure, SafeDataReader dr)
{
objShareHoldingStructure.ID = dr.GetInt32("ID");
objShareHoldingStructure.CmpyID = dr.GetInt32("CmpyID");
objShareHoldingStructure.ShareHolderID = dr.GetInt32("ShareHolderID");
objShareHoldingStructure.ShareHolderName = dr.GetString("ShareHolderName");
objShareHoldingStructure.PersonSource = dr.GetString("PersonSource");
objShareHoldingStructure.WOID = dr.GetInt32("WOID");
objShareHoldingStructure.SharesHeld = dr.GetDecimal("SharesHeld");
objShareHoldingStructure.NetCashDividend = dr.GetString("NetCashDividend");
objShareHoldingStructure.NoOfBonusShareToIssue = dr.GetString("NoOfBonusShareToIssue");
objShareHoldingStructure.ShareClassID = dr.GetInt32("ShareClassID");
objShareHoldingStructure.ClassName = dr.GetString("ClassName");
return objShareHoldingStructure;
}
/// <summary>
/// Description : Get ShareHoldingStructure Details from database.
/// Created By : Pavan
/// Created Date : 11 August 2014
/// Modified By :
/// Modified Date:
/// </summary>
/// <returns></returns>
public static List<ShareHoldingStructure> GetShareHoldingStructureDetails()
{
var data = new List<ShareHoldingStructure>();
System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame();
System.Reflection.MethodBase methodBase = stackFrame.GetMethod();
log.Debug("Start: " + methodBase.Name);
try
{
var reader = SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "[SpGetAllMShareHoldingStructure]");
var safe = new SafeDataReader(reader);
while (reader.Read())
{
var ShareHoldingStructure = new ShareHoldingStructure();
ShareHoldingStructure.FetchShareHoldingStructure(ShareHoldingStructure, safe);
data.Add(ShareHoldingStructure);
}
return data;
}
catch (Exception ex)
{
log.Error("Error: " + ex);
return data;
}
finally
{
log.Debug("End: " + methodBase.Name);
}
}
private ShareHoldingStructure FetchShareHoldingStructure(ShareHoldingStructure objShareHoldingStructure, SafeDataReader dr)
{
objShareHoldingStructure.ID = dr.GetInt32("ID");
objShareHoldingStructure.Name = dr.GetString("Name");
return objShareHoldingStructure;
}
public static ShareHoldingStructureinfo GetShareholdersByWOID(int WOID, int ShareClassID)
{
var data = new ShareHoldingStructureinfo();
System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame();
System.Reflection.MethodBase methodBase = stackFrame.GetMethod();
log.Debug("Start: " + methodBase.Name);
try
{
SqlParameter[] sqlParams = new SqlParameter[2];
sqlParams[0] = new SqlParameter("@WOID", WOID);
sqlParams[1] = new SqlParameter("@ShareClassID", ShareClassID);
var reader = SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "SpGetShareHoldersListByWOID", sqlParams);
var safe = new SafeDataReader(reader);
while (reader.Read())
{
var ShareHoldingStructure = new ShareHoldingStructure();
ShareHoldingStructure.FetchShareHolersList(ShareHoldingStructure, safe);
data.shereHoldersList.Add(ShareHoldingStructure);
}
}
catch (Exception ex)
{
log.Error("Error: " + ex);
return data;
}
finally
{
log.Debug("End: " + methodBase.Name);
}
return data;
}
