/// <summary>
/// Description : Get the Client information from CSS1
/// Created By : Sudheer
/// Created Date : 14th Oct 2014
/// Modified By :
/// Modified Date:
/// </summary>
public static _ChoosenBillingPartyInfo GetBillingPartyInformation(string ClientName, string WOID)
{
var GetClientInfo = new _ChoosenBillingPartyInfo();
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("@ClientName", ClientName);
var reader = SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "GetAllBillingPartyDetails", sqlParams);
var safe = new SafeDataReader(reader);
while (reader.Read())
{
var ClientInfo = new _ChoosenClient();
ClientInfo.FetchBillingPartyInfo(ClientInfo, safe);
GetClientInfo._ChoosenBillingPartyList.Add(ClientInfo);
}
return GetClientInfo;
}
catch (Exception ex)
{
log.Error("Error: " + ex);
return GetClientInfo;
}
finally
{
log.Debug("End: " + methodBase.Name);
}
}
private _ChoosenClient FetchClientInfo(_ChoosenClient getClientInfo, SafeDataReader dr)
{
getClientInfo.ClientCode = dr.GetString("ID");
getClientInfo.ClientName = dr.GetString("Name");
getClientInfo.SourceID = dr.GetString("SourceCode");
getClientInfo.UniqueID = dr.GetInt32("UniqueID");
return getClientInfo;
}
