public static List <Store> MapStoreData(DataTable dTstore, DataTable dtCustStock, DataTable dtStockMovement)
{
List <Store> ListStores = new List <Store>();
foreach (DataRow dr in dTstore.Rows)
{
Store mapData = new Store();
mapData.Id = new Guid(dr["id"].ToString());
mapData.Status = (StoreStatus)Enum.Parse(typeof(StoreStatus), dr["status"].ToString());
mapData.SaleStationId = CommonDataManager.GetSaleStation(dr["SaleStationId"].ToString());
mapData.CreatedOn = dr["CreatedOn"] != DBNull.Value ? DateTime.Parse(dr["CreatedOn"].ToString()) : DateTime.MinValue;
mapData.CreatedBy = dr["CreatedBy"] != null?UserManager.GetUserRef(dr["CreatedBy"].ToString()) : UserManager.GetDefaultRef();
mapData.ModifiedOn = dr["ModifiedOn"] != DBNull.Value ? DateTime.Parse(dr["ModifiedOn"].ToString()) : DateTime.MinValue;
mapData.ModifiedBy = dr["ModifiedBy"] != null?UserManager.GetUserRef(dr["ModifiedBy"].ToString()) : UserManager.GetDefaultRef();
mapData.Name = dr["Name"].ToString();
mapData.Location = dr["Location"].ToString();
mapData.Capacity = decimal.Parse(dr["Capacity"].ToString());
mapData.Stock = new List <CustomerStock>();
foreach (DataRow drCustStock in dtCustStock.Rows)
{
Guid StoreId = drCustStock["StoreId"] != null ? new Guid(drCustStock["StoreId"].ToString()) : Guid.Empty;
if (StoreId != Guid.Empty && StoreId == mapData.Id)
{
CustomerStock CustStock = new CustomerStock();
CustStock.Customer = drCustStock["CustomerId"] != null?CustomerManager.GetCustomerRef(drCustStock["CustomerId"].ToString()) : CustomerManager.GetDefaultRef();
CustStock.Store = new Reference()
{
Id = mapData.Id, Name = mapData.Name
};
CustStock.Vessel = drCustStock["Vessel"] != null?CommonDataManager.GetVessel(drCustStock["Vessel"].ToString()) : CommonDataManager.GetDefaultRef();
CustStock.Origin = drCustStock["Origin"] != null?CommonDataManager.GetOrigin(drCustStock["Origin"].ToString()) : CommonDataManager.GetDefaultRef();
CustStock.Size = drCustStock["Size"] != null?CommonDataManager.GetSize(drCustStock["Size"].ToString()) : CommonDataManager.GetDefaultRef();
CustStock.Quantity = drCustStock["Quantity"] != null?decimal.Parse(drCustStock["Quantity"].ToString()) : 0;
mapData.Stock.Add(CustStock);
}
}
mapData.ListStockMovement = new List <StockMovement>();
foreach (DataRow drStMovement in dtStockMovement.Rows)
{
Guid StoreId = drStMovement["StoreId"] != null ? new Guid(drStMovement["StoreId"].ToString()) : Guid.Empty;
if (StoreId != Guid.Empty && StoreId == mapData.Id)
{
StockMovement StMovement = new StockMovement();
StMovement.Customer = drStMovement["CustomerId"] != null?CustomerManager.GetCustomerRef(drStMovement["CustomerId"].ToString()) : CustomerManager.GetDefaultRef();
StMovement.Store = new Reference()
{
Id = mapData.Id, Name = mapData.Name
};
StMovement.Type = (StMovType)Enum.Parse(typeof(StMovType), drStMovement["Type"].ToString());
StMovement.HistoryRef = drStMovement["Reference"] != null ? drStMovement["Reference"].ToString() : "";
StMovement.Quantity = drStMovement["Quantity"] != null?decimal.Parse(drStMovement["Quantity"].ToString()) : 0;
StMovement.IsIn = drStMovement["InOut"] != null?bool.Parse(drStMovement["InOut"].ToString()) : false;
StMovement.Origin = drStMovement["Origin"] != null?CommonDataManager.GetOrigin(drStMovement["Origin"].ToString()) : CommonDataManager.GetDefaultRef();
StMovement.Vessel = drStMovement["Vessel"] != null?CommonDataManager.GetVessel(drStMovement["Vessel"].ToString()) : CommonDataManager.GetDefaultRef();
StMovement.Size = drStMovement["Size"] != null?CommonDataManager.GetSize(drStMovement["Size"].ToString()) : CommonDataManager.GetDefaultRef();
mapData.ListStockMovement.Add(StMovement);
}
}
ListStores.Add(mapData);
mapData = null;
}
return(ListStores);
}
public static List <Customer> MapCustomerDataTable(DataTable dtCust, DataTable dtCustStock, DataTable dtCustDest)
{
List <Customer> AllCustomers = new List <Customer>();
foreach (DataRow drCust in dtCust.Rows)
{
Customer Cust = new Customer();
Cust.Id = drCust["Id"] != null ? new Guid(drCust["Id"].ToString()) : Guid.Empty;
Cust.Status = drCust["Status"] != null ? CustStatus.Active : CustStatus.InActive;
Cust.CreatedOn = drCust["CreatedOn"] != DBNull.Value ? DateTime.Parse(drCust["CreatedOn"].ToString()) : DateTime.MinValue;
Cust.CreatedBy = drCust["CreatedBy"] != null?UserManager.GetUserRef(drCust["CreatedBy"].ToString()) : UserManager.GetDefaultRef();
Cust.ModifiedOn = drCust["ModifiedOn"] != DBNull.Value ? DateTime.Parse(drCust["ModifiedOn"].ToString()) : DateTime.MinValue;
Cust.ModifiedBy = drCust["ModifiedBy"] != null?UserManager.GetUserRef(drCust["ModifiedBy"].ToString()) : UserManager.GetDefaultRef();
Cust.Lead = drCust["Lead"] != null?UserManager.GetUserRef(drCust["Lead"].ToString()) : UserManager.GetDefaultRef();
Cust.Name = drCust["FullName"] != null ? drCust["FullName"].ToString() : "";
Cust.ShortName = drCust["ShortName"] != null ? drCust["ShortName"].ToString() : "";
Cust.NTN = drCust["NTN"] != null ? drCust["NTN"].ToString() : "";
Cust.STRN = drCust["STRN"] != null ? drCust["STRN"].ToString() : "";
Cust.Address = drCust["Address"] != null ? drCust["Address"].ToString() : "";
Cust.InvoiceAddress = drCust["InvoiceAddress"] != null ? drCust["InvoiceAddress"].ToString() : "";
Cust.Email = drCust["Email"] != null ? drCust["Email"].ToString() : "";
Cust.Phone = drCust["Phone"] != null ? drCust["Phone"].ToString() : "";
Cust.ContactPerson = drCust["ContactPerson"] != null ? drCust["ContactPerson"].ToString() : "";
Cust.HeadOffice = drCust["HeadOffice"] != null ? drCust["HeadOffice"].ToString() : "";
Cust.Remarks = drCust["Remarks"] != null ? drCust["Remarks"].ToString() : "";
Cust.Stock = new List <CustomerStock>();
foreach (DataRow drCustStock in dtCustStock.Rows)
{
Guid custId = drCustStock["CustomerId"] != null ? new Guid(drCustStock["CustomerId"].ToString()) : Guid.Empty;
if (custId != Guid.Empty && custId == Cust.Id)
{
CustomerStock CustStock = new CustomerStock();
CustStock.Customer = new Reference()
{
Id = Cust.Id, Name = Cust.Name
};
CustStock.Store = drCustStock["StoreId"] != null ? new Reference()
{
Id = new Guid(drCustStock["StoreId"].ToString())
} : StoreManager.GetDefaultRef();
CustStock.Vessel = drCustStock["Vessel"] != null?CommonDataManager.GetVessel(drCustStock["Vessel"].ToString()) : CommonDataManager.GetDefaultRef();
CustStock.Origin = drCustStock["Origin"] != null?CommonDataManager.GetOrigin(drCustStock["Origin"].ToString()) : CommonDataManager.GetDefaultRef();
CustStock.Size = drCustStock["Size"] != null?CommonDataManager.GetSize(drCustStock["Size"].ToString()) : CommonDataManager.GetDefaultRef();
CustStock.Quantity = drCustStock["Quantity"] != null?decimal.Parse(drCustStock["Quantity"].ToString()) : 0;
Cust.Stock.Add(CustStock);
}
}
Cust.Destination = new List <Item>();
foreach (DataRow drCustDest in dtCustDest.Rows)
{
Guid custId = drCustDest["CustomerId"] != null ? new Guid(drCustDest["CustomerId"].ToString()) : Guid.Empty;
if (custId != Guid.Empty && custId == Cust.Id)
{
Item CustDest = new Item()
{
Index = int.Parse(drCustDest["id"].ToString()), Value = drCustDest["Name"].ToString()
};
Cust.Destination.Add(CustDest);
}
}
AllCustomers.Add(Cust);
}
return(AllCustomers);
}
