private List <GRNListBLL> MergeWithClient(List <GRNBLL> list)
{
//Get Client list.
List <GRNListBLL> grnList = new List <GRNListBLL>();
List <ClientBLL> ClientList = new List <ClientBLL>();
ClientList = ClientBLL.GetAllClient();
if (ClientList == null)
{
throw new ClientInformationException("Can not get Clinet Information");
}
else
{
var q = from GRN in list
join client in ClientList on GRN.ClientId equals client.ClientUniqueIdentifier
select new { GRN.Id, GRN.GRN_Number, GRN.CommodityId, GRN.CommodityClassId, GRN.CommodityGradeId, GRN.Status, GRN.OriginalQuantity, GRN.DateDeposited, client.ClientName };
foreach (var i in q)
{
GRNListBLL obj = new GRNListBLL();
obj.Id = i.Id;
obj.GRN = i.GRN_Number;
obj.CommodityId = i.CommodityId;
obj.CommodityClassId = i.CommodityClassId;
obj.CommodityGradeId = i.CommodityGradeId;
obj.Status = (GRNStatus)i.Status;
obj.ClinetName = i.ClientName;
obj.OriginalQuantity = i.OriginalQuantity;
obj.DateDeposited = Convert.ToDateTime(i.DateDeposited.ToShortDateString());
obj.CommodityGrade = CommodityGradeBLL.GetCommodityGradeNameById(i.CommodityGradeId);
grnList.Add(obj);
}
return(grnList);
}
}
public static string GetClinetNameById(Guid Id)
{
try
{
ClientBLL objClient = new ClientBLL();
Membership.Client objWebServiceClient;
Membership.MemberShipLookUp objMembership = new WarehouseApplication.Membership.MemberShipLookUp();
objWebServiceClient = objMembership.GetClient(Id);
if (objWebServiceClient != null)
{
return(objWebServiceClient.Name + " - " + objWebServiceClient.IdNo + "");
}
else
{
Membership.MembershipEntities me = new WarehouseApplication.Membership.MembershipEntities();
me = objMembership.GetEntityByGuid(Id);
if (me != null)
{
return(me.OrganizationName + " - " + me.StringIdNo);
}
else
{
return("");
}
}
}
catch (Exception ex)
{
throw new Exception("Can't get Client from service please trya again.", ex);
}
}
public List <rptArrivalToDepositeBLL> GetReportData(Guid WarehouseId, DateTime from)
{
List <rptArrivalToDepositeBLL> list = null;
list = rptArrivalToDepositeDAL.GetReportData(WarehouseId, from);
if (list != null)
{
// string WarehouseName = WarehouseBLL.GetWarehouseNameById(WarehouseId);
//iterate through list to get clientname .
for (int i = 0; i < list.Count; i++)
{
Guid ClientId = list[i].ClientId;
string Cname = ClientBLL.GetClinetNameById(ClientId);
list[i].ClientName = Cname;
}
}
return(list);
}
public static ClientBLL GetClinet(string IdNo)
{
//Todo Ask sisay
Membership.MembershipEntities objentity;
try
{
Membership.MemberShipLookUp objMembership = new WarehouseApplication.Membership.MemberShipLookUp();
objentity = objMembership.GetEntityByIdNo(IdNo);
if (objentity != null)
{
string status = objentity.Status;
/// Peabean client problem - Nov 2 2010
//if (status == "Active")
//{
//ClientBLL obj = new ClientBLL(objentity.UniqueIdentifier, IdNo, objentity.OrganizationName);
//return obj;
//}
//else
// {
// return null;
// }
if (status == "Terminated")
{
return(null);
}
else
{
ClientBLL objC = new ClientBLL(objentity.UniqueIdentifier, IdNo, objentity.OrganizationName);
return(objC);
}
}
else
{
return(null);
}
}
catch (Exception ex)
{
throw new Exception("Unable to Get membership Service", ex);
}
}
/// <summary>
/// Search Commodity deposite by TransqactionId
/// </summary>
/// <param name="trackingNo">The Transaction Id assiged and used by Traking no.</param>
/// <returns></returns>
public List <CommodityDepositeRequestBLL> SearchCommodityDeposite(string trackingNo, string VoucherNo, Nullable <Guid> Clientid, Nullable <Guid> CommodityId, Nullable <DateTime> from, Nullable <DateTime> to)
{
List <CommodityDepositeRequestBLL> list = new List <CommodityDepositeRequestBLL>();
list = CommodityDepositRequest.SearchCommodityDeposite(trackingNo, VoucherNo, Clientid, CommodityId, from, to);
if (list != null)
{
List <CommodityDepositeRequestBLL> listMerged = new List <CommodityDepositeRequestBLL>();
for (int x = 0; x < list.Count; x++)
{
list[x].ClientName = ClientBLL.GetClinetNameById(list[x].ClientId);
list[x].CommodityName = CommodityGradeBLL.GetCommodityById(list[x].CommodityId).Commodity;
}
return(list);
}
else
{
return(null);
}
}
private static List <CommodityDepositeRequestBLL> MergeWithClient(List <CommodityDepositeRequestBLL> myList)
{
//Get Client list.
List <CommodityDepositeRequestBLL> CDList = new List <CommodityDepositeRequestBLL>();
List <ClientBLL> ClientList = new List <ClientBLL>();
ClientList = ClientBLL.GetAllClient();
List <CommodityGradeBLL> CommGradeList = new List <CommodityGradeBLL>();
CommGradeList = getAllCommodities();
if (ClientList == null)
{
//throw new ClientInformationException("Can not get Clinet Information");
}
else
{
var q = from CD in myList
join client in ClientList on CD.ClientId equals client.ClientUniqueIdentifier
select new { CD.Id, CD.TrackingNo, CD.VoucherNo, client.ClientName, CD.CommodityId, CD.DateTimeRecived };
foreach (var i in q)
{
CommodityDepositeRequestBLL obj = new CommodityDepositeRequestBLL();
obj.Id = i.Id;
obj.TrackingNo = i.TrackingNo;
obj.VoucherNo = i.VoucherNo;
obj.ClientName = i.ClientName;
obj.CommodityId = i.CommodityId;
obj.DateTimeRecived = i.DateTimeRecived;
CDList.Add(obj);
}
return(CDList);
}
return(null);
}
public List <GRNListBLL> Search(string GRN, string TrackingNo, Nullable <Guid> ClientId, Nullable <Guid> CommodityId, Nullable <Guid> CommoidtyClassId, Nullable <Guid> CommodityGradeId, Nullable <GRNStatus> Status, Nullable <DateTime> From, Nullable <DateTime> To)
{
List <GRNListBLL> lstGRNlist = null;
List <GRNBLL> GRNlist = new List <GRNBLL>();
// check search parameters are there.
if ((string.IsNullOrEmpty(GRN) == true) && (string.IsNullOrEmpty(TrackingNo) == true) && (ClientId == null) && (CommodityId == null) && (CommoidtyClassId == null) && (CommodityGradeId == null) && (Status == null) && (From == null) && (To == null))
{
throw (new NULLSearchParameterException("No Search parameter"));
}
GRNlist = GRNDAL.Search(GRN, TrackingNo, ClientId, CommodityId, CommodityClassId, CommodityGradeId, Status, From, To);
if (GRNlist != null)
{
if (GRNlist.Count > 0)
{
lstGRNlist = new List <GRNListBLL>();
GRNListBLL oblGRNList = new GRNListBLL();
foreach (GRNBLL o in GRNlist)
{
GRNListBLL obj = new GRNListBLL();
obj.Id = o.Id;
obj.GRN = o.GRN_Number;
obj.CommodityId = o.CommodityId;
obj.CommodityClassId = o.CommodityClassId;
obj.CommodityGradeId = o.CommodityGradeId;
obj.Status = (GRNStatus)o.Status;
obj.ClinetName = ClientBLL.GetClinetNameById(o.ClientId);
obj.OriginalQuantity = o.OriginalQuantity;
obj.DateDeposited = Convert.ToDateTime(o.DateDeposited.ToShortDateString());
lstGRNlist.Add(obj);
}
}
else
{
return(null);
}
}
return(lstGRNlist);
}
public static List <ClientBLL> GetAllClient()
{
try
{
List <ClientBLL> lstClient = new List <ClientBLL>();
Membership.MemberShipLookUp objMembership = new WarehouseApplication.Membership.MemberShipLookUp();
Membership.Client[] listClient;
listClient = objMembership.GetClients();
foreach (Membership.Client c in listClient)
{
ClientBLL objMyClient = new ClientBLL();
objMyClient.ClientId = c.IdNo;
objMyClient.ClientUniqueIdentifier = c.ClientId;
objMyClient.ClientName = c.Name;
lstClient.Add(objMyClient);
}
return(lstClient);
}
catch (Exception ex)
{
throw new Exception("Can not get Client information", ex);
}
}
public static ClientBLL GetClinet(Guid Id)
{
try
{
ClientBLL objClient = new ClientBLL();
Membership.Client objWebServiceClient;
Membership.MemberShipLookUp objMembership = new WarehouseApplication.Membership.MemberShipLookUp();
objWebServiceClient = objMembership.GetClient(Id);
if (objWebServiceClient != null)
{
objClient.ClientUniqueIdentifier = objWebServiceClient.ClientId;
objClient.ClientName = objWebServiceClient.Name;
objClient.ClientId = objWebServiceClient.IdNo;
return(objClient);
}
else
{
Membership.MembershipEntities me = new WarehouseApplication.Membership.MembershipEntities();
me = objMembership.GetEntityByGuid(Id);
if (me != null)
{
objClient.ClientUniqueIdentifier = Id;
objClient.ClientName = me.OrganizationName.ToString();
objClient.ClientId = me.StringIdNo;
return(objClient);
}
else
{
return(null);
}
}
}
catch (Exception ex)
{
throw new Exception("Can't get Client from service please trya again.", ex);
}
}
