public static string GetCollectionRefNos()
{
string CollRefNosObj = string.Empty;
string StatusCode = "200";
string StatusMsg = "Success";
string[] TempCollRefNo;
try
{
using (CollectionRefNos CollRefNos = new CollectionRefNos())
{
List<CollectionRefNos> lstColRef = new List<CollectionRefNos>();
using (workflow.Components.Inventory DAL = new workflow.Components.Inventory())
{
SqlDataReader Dr;
SqlParameter[] Param = new SqlParameter[1];
Param[0] = new SqlParameter("@Flag", "A");
using (Dr = DAL.ReadData(Usp_CollectionRefOpr, Param))
{
if (Dr.HasRows)
{
while (Dr.Read())
{
TempCollRefNo = EsHelper.EsGetValidString(Dr["PrdCollRefNo"]).Split('|');
foreach (var Temp in TempCollRefNo)
{
lstColRef.Add(new CollectionRefNos()
{
CollRefNo =int.Parse(Temp)
});
}
}
}
}
}
lstColRef.Sort(delegate(CollectionRefNos p1, CollectionRefNos p2)
{
return p1.CollRefNo.CompareTo(p2.CollRefNo);
});
if (lstColRef.Count <= 0)
{
StatusCode = "204"; StatusMsg = "No Records Found";
}
CollRefNosObj = EsHelper.ListToJson<CollectionRefNos>(lstColRef, "CollRefNos", StatusCode, StatusMsg);
}
}
catch (Exception ex)
{
EsHelper.EsADLogger("EstoreCollectionRef.aspx GetCollectionRefNos()", EsHelper.EsGetValidString(ex.Message));
}
return CollRefNosObj;
}
public class CollectionRefNos : IDisposable
{
#region Properties
public int CollRefNo { get; set; }
#endregion
public void Dispose()
{
}
}
No comments:
Post a Comment