/// <summary>
/// Gets the detail for store transfer.
/// </summary>
/// <param name="PickListID">The pick list ID.</param>
/// <returns></returns>
public static DataView GetDetailForStoreTransfer(int PickListID)
{
Transfer transfer = new Transfer();
string query = HCMIS.Repository.Queries.Transfer.SelectGetDetailForStoreTransfer(PickListID);
transfer.LoadFromRawSql(query);
return transfer.DefaultView;
}
/// <summary>
/// Gets the transfer report.
/// </summary>
/// <returns></returns>
public static DataView GetTransferReport()
{
Transfer transfer = new Transfer();
string query = HCMIS.Repository.Queries.Transfer.SelectGetTransferReport();
transfer.LoadFromRawSql(query);
return transfer.DefaultView;
}
/// <summary>
/// Transfers to store.
/// </summary>
/// <param name="PicklistID">The picklist ID.</param>
public static void TransferToStore(int PicklistID)
{
Transfer transfer = new Transfer();
string query = HCMIS.Repository.Queries.Transfer.SelectTransferToStore(PicklistID);
transfer.LoadFromRawSql(query);
}
/// <summary>
/// Gets the detail for store transfer.
/// </summary>
/// <param name="PickListID">The pick list ID.</param>
/// <returns></returns>
public static DataView GetDetailForStoreTransfer(int PickListID)
{
Transfer transfer = new Transfer();
string query = HCMIS.Repository.Queries.Transfer.SelectGetDetailForStoreTransfer(PickListID);
transfer.LoadFromRawSql(query);
return(transfer.DefaultView);
}
/// <summary>
/// Gets the transfer report for store.
/// </summary>
/// <returns></returns>
public static DataView GetTransferReportForStore()
{
Transfer transfer = new Transfer();
string query = HCMIS.Repository.Queries.Transfer.SelectGetTransferReportForStore();
transfer.LoadFromRawSql(query);
return(transfer.DefaultView);
}
/// <summary>
/// Gets the store transfer.
/// </summary>
/// <param name="PicklistID">The picklist ID.</param>
/// <returns></returns>
public static DataRowView GetStoreTransfer(int PicklistID)
{
Transfer transfer = new Transfer();
string query = HCMIS.Repository.Queries.Transfer.SelectGetStoreTransfer(PicklistID);
transfer.LoadFromRawSql(query);
foreach (DataRowView drv in transfer.DefaultView)
{
return drv;
}
return null;
}
/// <summary>
/// Gets the store transfer.
/// </summary>
/// <param name="PicklistID">The picklist ID.</param>
/// <returns></returns>
public static DataRowView GetStoreTransfer(int PicklistID)
{
Transfer transfer = new Transfer();
string query = HCMIS.Repository.Queries.Transfer.SelectGetStoreTransfer(PicklistID);
transfer.LoadFromRawSql(query);
foreach (DataRowView drv in transfer.DefaultView)
{
return(drv);
}
return(null);
}
/// <summary>
/// Transfers to store.
/// </summary>
/// <param name="PicklistID">The picklist ID.</param>
public static void TransferToStore(int PicklistID)
{
Transfer transfer = new Transfer();
string query = HCMIS.Repository.Queries.Transfer.SelectTransferToStore(PicklistID);
transfer.LoadFromRawSql(query);
}
