private static CustomerRmaLineAllocation PopulateFromDBDetailsObject(CustomerRmaLineAllocationDetails obj) { CustomerRmaLineAllocation objNew = new CustomerRmaLineAllocation(); objNew.CustomerRMALineAllocationId = obj.CustomerRMALineAllocationId; objNew.CustomerRMALineNo = obj.CustomerRMALineNo; objNew.InvoiceLineAllocationNo = obj.InvoiceLineAllocationNo; objNew.Quantity = obj.Quantity; objNew.GoodsInLineNo = obj.GoodsInLineNo; objNew.UpdatedBy = obj.UpdatedBy; objNew.DLUP = obj.DLUP; objNew.CustomerRMAId = obj.CustomerRMAId; objNew.CustomerRMANumber = obj.CustomerRMANumber; objNew.CustomerRMADate = obj.CustomerRMADate; objNew.ReturnDate = obj.ReturnDate; objNew.ClientNo = obj.ClientNo; objNew.Reason = obj.Reason; objNew.InvoiceNumber = obj.InvoiceNumber; objNew.InvoiceNo = obj.InvoiceNo; objNew.InvoiceLineNo = obj.InvoiceLineNo; objNew.CompanyNo = obj.CompanyNo; objNew.CompanyName = obj.CompanyName; objNew.PurchaseOrderLineNo = obj.PurchaseOrderLineNo; objNew.AuthorisedBy = obj.AuthorisedBy; objNew.AuthoriserName = obj.AuthoriserName; objNew.StockNo = obj.StockNo; objNew.RowNum = obj.RowNum; return(objNew); }
/// <summary> /// GetListForPurchaseOrderLine /// Calls [usp_selectAll_CustomerRMALineAllocation_for_PurchaseOrderLine] /// </summary> public override List <CustomerRmaLineAllocationDetails> GetListForPurchaseOrderLine(System.Int32?purchaseOrderLineId, System.Int32?pageIndex, System.Int32?pageSize) { SqlConnection cn = null; SqlCommand cmd = null; try { cn = new SqlConnection(this.ConnectionString); cmd = new SqlCommand("usp_selectAll_CustomerRMALineAllocation_for_PurchaseOrderLine", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandTimeout = 30; cmd.Parameters.Add("@PurchaseOrderLineId", SqlDbType.Int).Value = purchaseOrderLineId; cmd.Parameters.Add("@PageIndex", SqlDbType.Int).Value = pageIndex; cmd.Parameters.Add("@PageSize", SqlDbType.Int).Value = pageSize; cn.Open(); DbDataReader reader = ExecuteReader(cmd); List <CustomerRmaLineAllocationDetails> lst = new List <CustomerRmaLineAllocationDetails>(); while (reader.Read()) { CustomerRmaLineAllocationDetails obj = new CustomerRmaLineAllocationDetails(); obj.CustomerRMALineAllocationId = GetReaderValue_Int32(reader, "CustomerRMALineAllocationId", 0); obj.CustomerRMALineNo = GetReaderValue_Int32(reader, "CustomerRMALineNo", 0); obj.InvoiceLineAllocationNo = GetReaderValue_Int32(reader, "InvoiceLineAllocationNo", 0); obj.Quantity = GetReaderValue_Int32(reader, "Quantity", 0); obj.GoodsInLineNo = GetReaderValue_NullableInt32(reader, "GoodsInLineNo", null); obj.CustomerRMAId = GetReaderValue_Int32(reader, "CustomerRMAId", 0); obj.CustomerRMANumber = GetReaderValue_Int32(reader, "CustomerRMANumber", 0); obj.CustomerRMADate = GetReaderValue_DateTime(reader, "CustomerRMADate", DateTime.MinValue); obj.ReturnDate = GetReaderValue_NullableDateTime(reader, "ReturnDate", null); obj.ClientNo = GetReaderValue_Int32(reader, "ClientNo", 0); obj.Reason = GetReaderValue_String(reader, "Reason", ""); obj.InvoiceNumber = GetReaderValue_Int32(reader, "InvoiceNumber", 0); obj.InvoiceNo = GetReaderValue_NullableInt32(reader, "InvoiceNo", null); obj.InvoiceLineNo = GetReaderValue_Int32(reader, "InvoiceLineNo", 0); obj.CompanyNo = GetReaderValue_Int32(reader, "CompanyNo", 0); obj.CompanyName = GetReaderValue_String(reader, "CompanyName", ""); obj.PurchaseOrderLineNo = GetReaderValue_NullableInt32(reader, "PurchaseOrderLineNo", null); obj.AuthorisedBy = GetReaderValue_Int32(reader, "AuthorisedBy", 0); obj.AuthoriserName = GetReaderValue_String(reader, "AuthoriserName", ""); obj.StockNo = GetReaderValue_NullableInt32(reader, "StockNo", null); lst.Add(obj); obj = null; } return(lst); } catch (SqlException sqlex) { //LogException(sqlex); throw new Exception("Failed to get CustomerRmaLineAllocations", sqlex); } finally { cmd.Dispose(); cn.Close(); cn.Dispose(); } }
/// <summary> /// Get /// Calls [usp_select_CustomerRMALineAllocation] /// </summary> public override CustomerRmaLineAllocationDetails Get(System.Int32?customerRmaLineAllocationId) { SqlConnection cn = null; SqlCommand cmd = null; try { cn = new SqlConnection(this.ConnectionString); cmd = new SqlCommand("usp_select_CustomerRMALineAllocation", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandTimeout = 30; cmd.Parameters.Add("@CustomerRMALineAllocationId", SqlDbType.Int).Value = customerRmaLineAllocationId; cn.Open(); DbDataReader reader = ExecuteReader(cmd, CommandBehavior.SingleRow); if (reader.Read()) { //return GetCustomerRmaLineAllocationFromReader(reader); CustomerRmaLineAllocationDetails obj = new CustomerRmaLineAllocationDetails(); obj.CustomerRMALineAllocationId = GetReaderValue_Int32(reader, "CustomerRMALineAllocationId", 0); obj.CustomerRMALineNo = GetReaderValue_Int32(reader, "CustomerRMALineNo", 0); obj.InvoiceLineAllocationNo = GetReaderValue_Int32(reader, "InvoiceLineAllocationNo", 0); obj.Quantity = GetReaderValue_Int32(reader, "Quantity", 0); obj.GoodsInLineNo = GetReaderValue_NullableInt32(reader, "GoodsInLineNo", 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 CustomerRmaLineAllocation", sqlex); } finally { cmd.Dispose(); cn.Close(); cn.Dispose(); } }