/// <summary>
/// GetListForSalesOrderLine
/// Calls [usp_selectAll_Allocation_for_SalesOrderLine]
/// </summary>
public override List <AllocationDetails> GetListForSalesOrderLine(System.Int32?salesOrderLineId)
{
SqlConnection cn = null;
SqlCommand cmd = null;
try {
cn = new SqlConnection(this.ConnectionString);
cmd = new SqlCommand("usp_selectAll_Allocation_for_SalesOrderLine", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 30;
cmd.Parameters.Add("@SalesOrderLineId", SqlDbType.Int).Value = salesOrderLineId;
cn.Open();
DbDataReader reader = ExecuteReader(cmd);
List <AllocationDetails> lst = new List <AllocationDetails>();
while (reader.Read())
{
AllocationDetails obj = new AllocationDetails();
obj.AllocationId = GetReaderValue_Int32(reader, "AllocationId", 0);
obj.StockNo = GetReaderValue_NullableInt32(reader, "StockNo", null);
obj.QuantityAllocated = GetReaderValue_Int32(reader, "QuantityAllocated", 0);
obj.Part = GetReaderValue_String(reader, "Part", "");
obj.ROHS = GetReaderValue_Byte(reader, "ROHS", (byte)0);
obj.LandedCost = GetReaderValue_NullableDouble(reader, "LandedCost", null);
obj.QuantityInStock = GetReaderValue_Int32(reader, "QuantityInStock", 0);
obj.PurchaseOrderNo = GetReaderValue_NullableInt32(reader, "PurchaseOrderNo", null);
obj.PurchaseOrderNumber = GetReaderValue_NullableInt32(reader, "PurchaseOrderNumber", null);
obj.SupplierPart = GetReaderValue_String(reader, "SupplierPart", "");
obj.PurchaseOrderLineNo = GetReaderValue_NullableInt32(reader, "PurchaseOrderLineNo", null);
obj.ReturnDate = GetReaderValue_NullableDateTime(reader, "ReturnDate", null);
obj.CompanyNo = GetReaderValue_Int32(reader, "CompanyNo", 0);
obj.CompanyName = GetReaderValue_String(reader, "CompanyName", "");
obj.Price = GetReaderValue_NullableDouble(reader, "Price", null);
obj.ExpediteDate = GetReaderValue_NullableDateTime(reader, "ExpediteDate", null);
obj.CustomerRMANo = GetReaderValue_NullableInt32(reader, "CustomerRMANo", null);
obj.CustomerRMANumber = GetReaderValue_NullableInt32(reader, "CustomerRMANumber", null);
obj.QuantityOnOrder = GetReaderValue_NullableInt32(reader, "QuantityOnOrder", null);
obj.POSerialNo = GetReaderValue_Int16(reader, "POSerialNo", 0);
obj.InternalPurchaseOrderId = GetReaderValue_NullableInt32(reader, "InternalPurchaseOrderId", null);
obj.InternalPurchaseOrderNo = GetReaderValue_NullableInt32(reader, "InternalPurchaseOrderNumber", null);
obj.IPOSupplier = GetReaderValue_NullableInt32(reader, "IPOSupplier", null);
obj.IPOSupplierName = GetReaderValue_String(reader, "IPOSupplierName", "");
obj.ClientLandedCost = GetReaderValue_NullableDouble(reader, "ClientLandedCost", null);
lst.Add(obj);
obj = null;
}
return(lst);
} catch (SqlException sqlex) {
//LogException(sqlex);
throw new Exception("Failed to get Allocations", sqlex);
} finally {
cmd.Dispose();
cn.Close();
cn.Dispose();
}
}
/// <summary>
/// Get
/// Calls [usp_select_Allocation]
/// </summary>
public override AllocationDetails Get(System.Int32?allocationId)
{
SqlConnection cn = null;
SqlCommand cmd = null;
try {
cn = new SqlConnection(this.ConnectionString);
cmd = new SqlCommand("usp_select_Allocation", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 30;
cmd.Parameters.Add("@AllocationId", SqlDbType.Int).Value = allocationId;
cn.Open();
DbDataReader reader = ExecuteReader(cmd, CommandBehavior.SingleRow);
if (reader.Read())
{
//return GetAllocationFromReader(reader);
AllocationDetails obj = new AllocationDetails();
obj.AllocationId = GetReaderValue_Int32(reader, "AllocationId", 0);
obj.StockNo = GetReaderValue_NullableInt32(reader, "StockNo", null);
obj.SalesOrderLineNo = GetReaderValue_NullableInt32(reader, "SalesOrderLineNo", null);
obj.QuantityAllocated = GetReaderValue_Int32(reader, "QuantityAllocated", 0);
obj.SupplierRMALineNo = GetReaderValue_NullableInt32(reader, "SupplierRMALineNo", null);
obj.UpdatedBy = GetReaderValue_NullableInt32(reader, "UpdatedBy", null);
obj.DLUP = GetReaderValue_DateTime(reader, "DLUP", DateTime.MinValue);
return(obj);
}
else
{
return(null);
}
} catch (SqlException sqlex) {
//LogException(sqlex);
throw new Exception("Failed to get Allocation", sqlex);
} finally {
cmd.Dispose();
cn.Close();
cn.Dispose();
}
}
public JsonResult SaveAllocationList(TeamAllocationPresenter presenter)
{
var result = 0;
if (presenter != null)
{
int previousDaysCount = ApplicationSettings.Instance.PastAllocationAllowedDays;
var allowedDays = DateTimeHelper.RetrieveCurrentDate().AddDays(-previousDaysCount);
var teamEngagementDetail = new AllocationDetails();
foreach (var allocation in presenter.TeamAllocationList)
{
if ((allocation.Date <= allocation.EndDate && allocation.Date >= allowedDays) && (allocation.ProjectID != null && allocation.ProjectID > 0))
{
if (!string.IsNullOrEmpty(allocation.SelectedDeveloperIds))
{
allocation.SelectedDeveloperIds += "," + presenter.DeveloperId;
}
else
{
allocation.SelectedDeveloperIds = presenter.DeveloperId.ToString();
}
teamEngagementDetail.Add(new Allocation()
{
AllocationID = allocation.AllocationID,
ProjectID = allocation.ProjectID,
DeveloperIDs = allocation.SelectedDeveloperIds,
FromDate = allocation.Date,
ToDate = allocation.EndDate,
Hours = allocation.ProjectAllocatedHours
});
}
}
if (teamEngagementDetail.Count > 0)
{
presenter.ValidationErrors.Append(this.teamEngagementService.SaveTeamEngagementList(teamEngagementDetail, SessionData.Instance.UserInfo.Developer.DeveloperID, presenter.IsHoliday, true, false));
}
result = presenter.ValidationErrors.Count;
if (result > 0)
{
return this.Json(presenter);
}
}
return this.Json("success");
}
private static Allocation PopulateFromDBDetailsObject(AllocationDetails obj)
{
Allocation objNew = new Allocation();
objNew.AllocationId = obj.AllocationId;
objNew.StockNo = obj.StockNo;
objNew.SalesOrderLineNo = obj.SalesOrderLineNo;
objNew.QuantityAllocated = obj.QuantityAllocated;
objNew.SupplierRMALineNo = obj.SupplierRMALineNo;
objNew.UpdatedBy = obj.UpdatedBy;
objNew.DLUP = obj.DLUP;
objNew.SalesmanName = obj.SalesmanName;
objNew.SupplierRMANo = obj.SupplierRMANo;
objNew.SupplierRMANumber = obj.SupplierRMANumber;
objNew.Part = obj.Part;
objNew.ProductNo = obj.ProductNo;
objNew.ProductName = obj.ProductName;
objNew.ProductDescription = obj.ProductDescription;
objNew.ManufacturerNo = obj.ManufacturerNo;
objNew.ManufacturerCode = obj.ManufacturerCode;
objNew.ManufacturerName = obj.ManufacturerName;
objNew.PackageNo = obj.PackageNo;
objNew.PackageName = obj.PackageName;
objNew.PackageDescription = obj.PackageDescription;
objNew.DateCode = obj.DateCode;
objNew.ROHS = obj.ROHS;
objNew.LandedCost = obj.LandedCost;
objNew.QuantityInStock = obj.QuantityInStock;
objNew.WarehouseNo = obj.WarehouseNo;
objNew.WarehouseName = obj.WarehouseName;
objNew.PurchaseOrderNo = obj.PurchaseOrderNo;
objNew.PurchaseOrderNumber = obj.PurchaseOrderNumber;
objNew.PurchaseOrderLineId = obj.PurchaseOrderLineId;
objNew.BuyPrice = obj.BuyPrice;
objNew.DeliveryDate = obj.DeliveryDate;
objNew.BuyCurrencyNo = obj.BuyCurrencyNo;
objNew.BuyCurrencyCode = obj.BuyCurrencyCode;
objNew.SupplierCompanyNo = obj.SupplierCompanyNo;
objNew.SupplierCompanyName = obj.SupplierCompanyName;
objNew.CustomerCompanyNo = obj.CustomerCompanyNo;
objNew.CustomerCompanyName = obj.CustomerCompanyName;
objNew.Salesman = obj.Salesman;
objNew.SalesOrderNo = obj.SalesOrderNo;
objNew.SalesOrderNumber = obj.SalesOrderNumber;
objNew.CustomerPO = obj.CustomerPO;
objNew.SellPrice = obj.SellPrice;
objNew.SellCurrencyNo = obj.SellCurrencyNo;
objNew.SellCurrencyCode = obj.SellCurrencyCode;
objNew.DatePromised = obj.DatePromised;
objNew.CustomerPart = obj.CustomerPart;
objNew.GoodsInLineNo = obj.GoodsInLineNo;
objNew.Shipped = obj.Shipped;
objNew.Location = obj.Location;
objNew.SupplierPart = obj.SupplierPart;
objNew.CustomerRMALineNo = obj.CustomerRMALineNo;
objNew.PurchaseOrderLineNo = obj.PurchaseOrderLineNo;
objNew.ReturnDate = obj.ReturnDate;
objNew.SupplierRMADate = obj.SupplierRMADate;
objNew.CompanyNo = obj.CompanyNo;
objNew.CompanyName = obj.CompanyName;
objNew.CurrencyNo = obj.CurrencyNo;
objNew.CurrencyCode = obj.CurrencyCode;
objNew.Price = obj.Price;
objNew.ExpediteDate = obj.ExpediteDate;
objNew.CustomerRMANo = obj.CustomerRMANo;
objNew.CustomerRMANumber = obj.CustomerRMANumber;
objNew.QuantityOnOrder = obj.QuantityOnOrder;
return(objNew);
}
/// <summary>
/// Function to save team engagement list.
/// </summary>
/// <param name="teamEngagementDetail">The team engagement detail.</param>
/// <param name="modifiedByDeveloperId">The modified by developer id.</param>
/// <param name="includeOffDays">Value indicating whether to include off days or not</param>
/// <param name="isOverride">Value indicating whether to override or not</param>
/// <param name="isUnderHierarchy">if set to <c>true</c> [is under hierarchy].</param>
/// <returns>
/// List of team engagement list error.
/// </returns>
public IList<ErrorListItem> SaveTeamEngagementList(AllocationDetails teamEngagementDetail, int modifiedByDeveloperId, bool includeOffDays, bool isOverride, bool isUnderHierarchy)
{
return this.teamEngagementRepository.SaveTeamEngagementList(SerializeExtensions.XmlSerializerMethod(teamEngagementDetail), modifiedByDeveloperId, includeOffDays, isOverride, isUnderHierarchy);
}
/// <summary>
/// GetListForStock
/// Calls [usp_selectAll_Allocation_for_Stock]
/// </summary>
public override List <AllocationDetails> GetListForStock(System.Int32?stockId)
{
SqlConnection cn = null;
SqlCommand cmd = null;
try {
cn = new SqlConnection(this.ConnectionString);
cmd = new SqlCommand("usp_selectAll_Allocation_for_Stock", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 30;
cmd.Parameters.Add("@StockId", SqlDbType.Int).Value = stockId;
cn.Open();
DbDataReader reader = ExecuteReader(cmd);
List <AllocationDetails> lst = new List <AllocationDetails>();
while (reader.Read())
{
AllocationDetails obj = new AllocationDetails();
obj.AllocationId = GetReaderValue_Int32(reader, "AllocationId", 0);
obj.StockNo = GetReaderValue_NullableInt32(reader, "StockNo", null);
obj.QuantityAllocated = GetReaderValue_Int32(reader, "QuantityAllocated", 0);
obj.SalesmanName = GetReaderValue_String(reader, "SalesmanName", "");
obj.SupplierRMANo = GetReaderValue_NullableInt32(reader, "SupplierRMANo", null);
obj.SupplierRMANumber = GetReaderValue_NullableInt32(reader, "SupplierRMANumber", null);
obj.Part = GetReaderValue_String(reader, "Part", "");
obj.ProductNo = GetReaderValue_NullableInt32(reader, "ProductNo", null);
obj.ProductName = GetReaderValue_String(reader, "ProductName", "");
obj.ManufacturerNo = GetReaderValue_NullableInt32(reader, "ManufacturerNo", null);
obj.ManufacturerCode = GetReaderValue_String(reader, "ManufacturerCode", "");
obj.ManufacturerName = GetReaderValue_String(reader, "ManufacturerName", "");
obj.PackageNo = GetReaderValue_NullableInt32(reader, "PackageNo", null);
obj.PackageName = GetReaderValue_String(reader, "PackageName", "");
obj.ROHS = GetReaderValue_Byte(reader, "ROHS", (byte)0);
obj.Salesman = GetReaderValue_NullableInt32(reader, "Salesman", null);
obj.SalesOrderNo = GetReaderValue_NullableInt32(reader, "SalesOrderNo", null);
obj.SalesOrderNumber = GetReaderValue_NullableInt32(reader, "SalesOrderNumber", null);
obj.CustomerPO = GetReaderValue_String(reader, "CustomerPO", "");
obj.DatePromised = GetReaderValue_NullableDateTime(reader, "DatePromised", null);
obj.CustomerPart = GetReaderValue_String(reader, "CustomerPart", "");
obj.GoodsInLineNo = GetReaderValue_NullableInt32(reader, "GoodsInLineNo", null);
obj.CustomerRMALineNo = GetReaderValue_NullableInt32(reader, "CustomerRMALineNo", null);
obj.PurchaseOrderLineNo = GetReaderValue_NullableInt32(reader, "PurchaseOrderLineNo", null);
obj.ReturnDate = GetReaderValue_NullableDateTime(reader, "ReturnDate", null);
obj.SupplierRMADate = GetReaderValue_NullableDateTime(reader, "SupplierRMADate", null);
obj.CompanyNo = GetReaderValue_Int32(reader, "CompanyNo", 0);
obj.CompanyName = GetReaderValue_String(reader, "CompanyName", "");
obj.CurrencyNo = GetReaderValue_NullableInt32(reader, "CurrencyNo", null);
obj.CurrencyCode = GetReaderValue_String(reader, "CurrencyCode", "");
obj.Price = GetReaderValue_NullableDouble(reader, "Price", null);
lst.Add(obj);
obj = null;
}
return(lst);
} catch (SqlException sqlex) {
//LogException(sqlex);
throw new Exception("Failed to get Allocations", sqlex);
} finally {
cmd.Dispose();
cn.Close();
cn.Dispose();
}
}
/// <summary>
/// GetList
/// Calls [usp_selectAll_Allocation]
/// </summary>
public override List <AllocationDetails> GetList()
{
SqlConnection cn = null;
SqlCommand cmd = null;
try {
cn = new SqlConnection(this.ConnectionString);
cmd = new SqlCommand("usp_selectAll_Allocation", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 30;
cn.Open();
DbDataReader reader = ExecuteReader(cmd);
List <AllocationDetails> lst = new List <AllocationDetails>();
while (reader.Read())
{
AllocationDetails obj = new AllocationDetails();
obj.AllocationId = GetReaderValue_Int32(reader, "AllocationId", 0);
obj.StockNo = GetReaderValue_NullableInt32(reader, "StockNo", null);
obj.SalesOrderLineNo = GetReaderValue_NullableInt32(reader, "SalesOrderLineNo", null);
obj.QuantityAllocated = GetReaderValue_Int32(reader, "QuantityAllocated", 0);
obj.SupplierRMALineNo = GetReaderValue_NullableInt32(reader, "SupplierRMALineNo", null);
obj.UpdatedBy = GetReaderValue_NullableInt32(reader, "UpdatedBy", null);
obj.DLUP = GetReaderValue_DateTime(reader, "DLUP", DateTime.MinValue);
obj.SalesmanName = GetReaderValue_String(reader, "SalesmanName", "");
obj.SupplierRMANo = GetReaderValue_NullableInt32(reader, "SupplierRMANo", null);
obj.SupplierRMANumber = GetReaderValue_NullableInt32(reader, "SupplierRMANumber", null);
obj.Part = GetReaderValue_String(reader, "Part", "");
obj.ProductNo = GetReaderValue_NullableInt32(reader, "ProductNo", null);
obj.ProductName = GetReaderValue_String(reader, "ProductName", "");
obj.ProductDescription = GetReaderValue_String(reader, "ProductDescription", "");
obj.ManufacturerNo = GetReaderValue_NullableInt32(reader, "ManufacturerNo", null);
obj.ManufacturerCode = GetReaderValue_String(reader, "ManufacturerCode", "");
obj.ManufacturerName = GetReaderValue_String(reader, "ManufacturerName", "");
obj.PackageNo = GetReaderValue_NullableInt32(reader, "PackageNo", null);
obj.PackageName = GetReaderValue_String(reader, "PackageName", "");
obj.PackageDescription = GetReaderValue_String(reader, "PackageDescription", "");
obj.DateCode = GetReaderValue_String(reader, "DateCode", "");
obj.ROHS = GetReaderValue_Byte(reader, "ROHS", (byte)0);
obj.LandedCost = GetReaderValue_NullableDouble(reader, "LandedCost", null);
obj.QuantityInStock = GetReaderValue_Int32(reader, "QuantityInStock", 0);
obj.WarehouseNo = GetReaderValue_NullableInt32(reader, "WarehouseNo", null);
obj.WarehouseName = GetReaderValue_String(reader, "WarehouseName", "");
obj.PurchaseOrderNo = GetReaderValue_NullableInt32(reader, "PurchaseOrderNo", null);
obj.PurchaseOrderNumber = GetReaderValue_NullableInt32(reader, "PurchaseOrderNumber", null);
obj.PurchaseOrderLineId = GetReaderValue_NullableInt32(reader, "PurchaseOrderLineId", null);
obj.BuyPrice = GetReaderValue_NullableDouble(reader, "BuyPrice", null);
obj.DeliveryDate = GetReaderValue_NullableDateTime(reader, "DeliveryDate", null);
obj.BuyCurrencyNo = GetReaderValue_NullableInt32(reader, "BuyCurrencyNo", null);
obj.BuyCurrencyCode = GetReaderValue_String(reader, "BuyCurrencyCode", "");
obj.SupplierCompanyNo = GetReaderValue_NullableInt32(reader, "SupplierCompanyNo", null);
obj.SupplierCompanyName = GetReaderValue_String(reader, "SupplierCompanyName", "");
obj.CustomerCompanyNo = GetReaderValue_NullableInt32(reader, "CustomerCompanyNo", null);
obj.CustomerCompanyName = GetReaderValue_String(reader, "CustomerCompanyName", "");
obj.Salesman = GetReaderValue_NullableInt32(reader, "Salesman", null);
obj.SalesOrderNo = GetReaderValue_NullableInt32(reader, "SalesOrderNo", null);
obj.SalesOrderNumber = GetReaderValue_NullableInt32(reader, "SalesOrderNumber", null);
obj.CustomerPO = GetReaderValue_String(reader, "CustomerPO", "");
obj.SellPrice = GetReaderValue_NullableDouble(reader, "SellPrice", null);
obj.SellCurrencyNo = GetReaderValue_NullableInt32(reader, "SellCurrencyNo", null);
obj.SellCurrencyCode = GetReaderValue_String(reader, "SellCurrencyCode", "");
obj.DatePromised = GetReaderValue_NullableDateTime(reader, "DatePromised", null);
obj.CustomerPart = GetReaderValue_String(reader, "CustomerPart", "");
obj.GoodsInLineNo = GetReaderValue_NullableInt32(reader, "GoodsInLineNo", null);
obj.Shipped = GetReaderValue_NullableBoolean(reader, "Shipped", null);
obj.Location = GetReaderValue_String(reader, "Location", "");
obj.SupplierPart = GetReaderValue_String(reader, "SupplierPart", "");
lst.Add(obj);
obj = null;
}
return(lst);
} catch (SqlException sqlex) {
//LogException(sqlex);
throw new Exception("Failed to get Allocations", sqlex);
} finally {
cmd.Dispose();
cn.Close();
cn.Dispose();
}
}
