private static Excess PopulateFromDBDetailsObject(ExcessDetails obj) { Excess objNew = new Excess(); objNew.ExcessId = obj.ExcessId; objNew.ExcessName = obj.ExcessName; objNew.FullPart = obj.FullPart; objNew.Part = obj.Part; objNew.ManufacturerNo = obj.ManufacturerNo; objNew.DateCode = obj.DateCode; objNew.ProductNo = obj.ProductNo; objNew.PackageNo = obj.PackageNo; objNew.Quantity = obj.Quantity; objNew.Price = obj.Price; objNew.CurrencyNo = obj.CurrencyNo; objNew.OriginalEntryDate = obj.OriginalEntryDate; objNew.Salesman = obj.Salesman; objNew.CompanyNo = obj.CompanyNo; objNew.ROHS = obj.ROHS; objNew.UpdatedBy = obj.UpdatedBy; objNew.DLUP = obj.DLUP; objNew.OfferStatusNo = obj.OfferStatusNo; objNew.OfferStatusChangeDate = obj.OfferStatusChangeDate; objNew.OfferStatusChangeLoginNo = obj.OfferStatusChangeLoginNo; objNew.CompanyName = obj.CompanyName; objNew.Notes = obj.Notes; objNew.ManufacturerName = obj.ManufacturerName; objNew.ProductName = obj.ProductName; objNew.PackageName = obj.PackageName; objNew.ClientNo = obj.ClientNo; objNew.SupplierName = obj.SupplierName; objNew.SupplierEmail = obj.SupplierEmail; objNew.ManufacturerCode = obj.ManufacturerCode; objNew.CurrencyCode = obj.CurrencyCode; objNew.SalesmanName = obj.SalesmanName; objNew.OfferStatusChangeEmployeeName = obj.OfferStatusChangeEmployeeName; objNew.ClientName = obj.ClientName; objNew.ClientDataVisibleToOthers = obj.ClientDataVisibleToOthers; return(objNew); }
/// <summary> /// Source /// Calls [usp_ipobom_source_Excess] /// </summary> public override List <ExcessDetails> IPOBOMSource(System.Int32?clientId, System.String partSearch, System.Int32?index, DateTime?startDate, DateTime?endDate, out DateTime?outDate, bool hasServerLocal, System.Boolean?isPOHub) { SqlConnection cn = null; SqlCommand cmd = null; outDate = null; try { if (!hasServerLocal) { cn = new SqlConnection(this.GTConnectionString); } else { cn = new SqlConnection(this.ConnectionString); } if (isPOHub.Value) { cmd = new SqlCommand("usp_ipobom_source_ExcessPH", cn); } else { cmd = new SqlCommand("usp_ipobom_source_Excess", cn); } cmd.CommandType = CommandType.StoredProcedure; cmd.CommandTimeout = 30; cmd.Parameters.Add("@ClientId", SqlDbType.Int).Value = clientId; cmd.Parameters.Add("@PartSearch", SqlDbType.NVarChar).Value = partSearch; cmd.Parameters.Add("@Index", SqlDbType.Int).Value = index; cmd.Parameters.Add("@StartDate", SqlDbType.DateTime).Value = startDate; cmd.Parameters.Add("@FinishDate", SqlDbType.DateTime).Value = endDate; cmd.Parameters.Add("@IsPoHUB", SqlDbType.Bit).Value = isPOHub; cn.Open(); //DbDataReader reader = ExecuteReader(cmd); SqlDataReader reader = cmd.ExecuteReader(); List <ExcessDetails> lst = new List <ExcessDetails>(); while (reader.Read()) { ExcessDetails obj = new ExcessDetails(); obj.ExcessId = GetReaderValue_Int32(reader, "ExcessId", 0); obj.ExcessName = GetReaderValue_String(reader, "ExcessName", ""); obj.FullPart = GetReaderValue_String(reader, "FullPart", ""); obj.Part = GetReaderValue_String(reader, "Part", ""); obj.ManufacturerNo = GetReaderValue_NullableInt32(reader, "ManufacturerNo", null); obj.DateCode = GetReaderValue_String(reader, "DateCode", ""); obj.ProductNo = GetReaderValue_NullableInt32(reader, "ProductNo", null); obj.PackageNo = GetReaderValue_NullableInt32(reader, "PackageNo", null); obj.Quantity = GetReaderValue_Int32(reader, "Quantity", 0); obj.Price = GetReaderValue_Double(reader, "Price", 0); obj.CurrencyNo = GetReaderValue_NullableInt32(reader, "CurrencyNo", null); obj.OriginalEntryDate = GetReaderValue_NullableDateTime(reader, "OriginalEntryDate", null); obj.Salesman = GetReaderValue_NullableInt32(reader, "Salesman", null); obj.CompanyNo = GetReaderValue_Int32(reader, "CompanyNo", 0); obj.ROHS = GetReaderValue_Byte(reader, "ROHS", (byte)0); obj.UpdatedBy = GetReaderValue_NullableInt32(reader, "UpdatedBy", null); obj.DLUP = GetReaderValue_DateTime(reader, "DLUP", DateTime.MinValue); obj.OfferStatusNo = GetReaderValue_NullableInt32(reader, "OfferStatusNo", null); obj.OfferStatusChangeDate = GetReaderValue_NullableDateTime(reader, "OfferStatusChangeDate", null); obj.OfferStatusChangeLoginNo = GetReaderValue_NullableInt32(reader, "OfferStatusChangeLoginNo", null); obj.CompanyName = GetReaderValue_String(reader, "CompanyName", ""); obj.Notes = GetReaderValue_String(reader, "Notes", ""); obj.ManufacturerName = GetReaderValue_String(reader, "ManufacturerName", ""); obj.ProductName = GetReaderValue_String(reader, "ProductName", ""); obj.PackageName = GetReaderValue_String(reader, "PackageName", ""); obj.ClientNo = GetReaderValue_NullableInt32(reader, "ClientNo", null); obj.SupplierName = GetReaderValue_String(reader, "SupplierName", ""); obj.SupplierEmail = GetReaderValue_String(reader, "SupplierEmail", ""); obj.ManufacturerCode = GetReaderValue_String(reader, "ManufacturerCode", ""); obj.CurrencyCode = GetReaderValue_String(reader, "CurrencyCode", ""); obj.SalesmanName = GetReaderValue_String(reader, "SalesmanName", ""); obj.OfferStatusChangeEmployeeName = GetReaderValue_String(reader, "OfferStatusChangeEmployeeName", ""); obj.ClientName = GetReaderValue_String(reader, "ClientName", ""); obj.ClientDataVisibleToOthers = GetReaderValue_NullableBoolean(reader, "ClientDataVisibleToOthers", null); //[001] code start obj.SupplierType = GetReaderValue_String(reader, "SupplierType", ""); //[001] code end obj.ClientCode = GetReaderValue_String(reader, "ClientCode", ""); obj.MSL = GetReaderValue_String(reader, "MSL", ""); obj.SPQ = GetReaderValue_String(reader, "SPQ", ""); obj.LeadTime = GetReaderValue_String(reader, "LeadTime", ""); obj.RoHSStatus = GetReaderValue_String(reader, "RoHSStatus", ""); obj.FactorySealed = GetReaderValue_String(reader, "FactorySealed", ""); //obj.IPOBOMNo = GetReaderValue_Int32(reader, "IPOBOMNo", 0); obj.SupplierTotalQSA = GetReaderValue_String(reader, "SupplierTotalQSA", ""); obj.SupplierLTB = GetReaderValue_String(reader, "SupplierLTB", ""); obj.SupplierMOQ = GetReaderValue_String(reader, "SupplierMOQ", ""); lst.Add(obj); obj = null; } reader.NextResult(); while (reader.Read()) { outDate = GetReaderValue_NullableDateTime(reader, "OutPutDate", null); } return(lst); } catch (SqlException sqlex) { //LogException(sqlex); throw new Exception("Failed to get Excesss", sqlex); } finally { cmd.Dispose(); cn.Close(); cn.Dispose(); } }
/// <summary> /// Get /// Calls [usp_select_Excess] /// </summary> public override ExcessDetails Get(System.Int32?excessId, bool?isPoHub) { SqlConnection cn = null; SqlCommand cmd = null; string proc = "usp_select_Excess"; try { // proc = isPoHub == true ? "usp_select_ExcessPH" : proc; cn = new SqlConnection(this.ConnectionString); cmd = new SqlCommand(proc, cn); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandTimeout = 30; cmd.Parameters.Add("@ExcessId", SqlDbType.Int).Value = excessId; cn.Open(); DbDataReader reader = ExecuteReader(cmd, CommandBehavior.SingleRow); if (reader.Read()) { //return GetExcessFromReader(reader); ExcessDetails obj = new ExcessDetails(); obj.ExcessId = GetReaderValue_Int32(reader, "ExcessId", 0); obj.ExcessName = GetReaderValue_String(reader, "ExcessName", ""); obj.FullPart = GetReaderValue_String(reader, "FullPart", ""); obj.Part = GetReaderValue_String(reader, "Part", ""); obj.ManufacturerNo = GetReaderValue_NullableInt32(reader, "ManufacturerNo", null); obj.DateCode = GetReaderValue_String(reader, "DateCode", ""); obj.ProductNo = GetReaderValue_NullableInt32(reader, "ProductNo", null); obj.PackageNo = GetReaderValue_NullableInt32(reader, "PackageNo", null); obj.Quantity = GetReaderValue_Int32(reader, "Quantity", 0); obj.Price = GetReaderValue_Double(reader, "Price", 0); obj.CurrencyNo = GetReaderValue_NullableInt32(reader, "CurrencyNo", null); obj.OriginalEntryDate = GetReaderValue_NullableDateTime(reader, "OriginalEntryDate", null); obj.Salesman = GetReaderValue_NullableInt32(reader, "Salesman", null); obj.CompanyNo = GetReaderValue_Int32(reader, "CompanyNo", 0); obj.ROHS = GetReaderValue_NullableByte(reader, "ROHS", null); obj.UpdatedBy = GetReaderValue_NullableInt32(reader, "UpdatedBy", null); obj.DLUP = GetReaderValue_DateTime(reader, "DLUP", DateTime.MinValue); obj.OfferStatusNo = GetReaderValue_NullableInt32(reader, "OfferStatusNo", null); obj.OfferStatusChangeDate = GetReaderValue_NullableDateTime(reader, "OfferStatusChangeDate", null); obj.OfferStatusChangeLoginNo = GetReaderValue_NullableInt32(reader, "OfferStatusChangeLoginNo", null); obj.CompanyName = GetReaderValue_String(reader, "CompanyName", ""); obj.Notes = GetReaderValue_String(reader, "Notes", ""); obj.ManufacturerName = GetReaderValue_String(reader, "ManufacturerName", ""); obj.ProductName = GetReaderValue_String(reader, "ProductName", ""); obj.PackageName = GetReaderValue_String(reader, "PackageName", ""); obj.SPQ = GetReaderValue_String(reader, "SPQ", ""); obj.LeadTime = GetReaderValue_String(reader, "LeadTime", ""); obj.RoHSStatus = GetReaderValue_String(reader, "ROHSStatus", ""); obj.FactorySealed = GetReaderValue_String(reader, "FactorySealed", ""); obj.MSL = GetReaderValue_String(reader, "MSL", ""); obj.SupplierMOQ = GetReaderValue_String(reader, "SupplierMOQ", ""); obj.SupplierTotalQSA = GetReaderValue_String(reader, "SupplierTotalQSA", ""); obj.SupplierLTB = GetReaderValue_String(reader, "SupplierLTB", ""); obj.ProductDescription = GetReaderValue_String(reader, "ProductDescription", ""); obj.ProductInactive = GetReaderValue_NullableBoolean(reader, "ProductInactive", false); obj.MSLLevelNo = GetReaderValue_NullableInt32(reader, "MSLLevelNo", null); return(obj); } else { return(null); } } catch (SqlException sqlex) { //LogException(sqlex); throw new Exception("Failed to get Excess", sqlex); } finally { cmd.Dispose(); cn.Close(); cn.Dispose(); } }