//[001] code start
/// <summary>
/// AutoSearch
/// Calls [usp_autosearch_BOM]
/// </summary>
public override List <Rebound.GlobalTrader.DAL.BOMDetails> AutoSearch(System.Int32?clientId, System.String nameSearch)
{
SqlConnection cn = null;
SqlCommand cmd = null;
try
{
cn = new SqlConnection(this.ConnectionString);
cmd = new SqlCommand("usp_autosearch_BOM", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 60;
cmd.Parameters.Add("@ClientId", SqlDbType.Int).Value = clientId;
cmd.Parameters.Add("@NameSearch", SqlDbType.NVarChar).Value = nameSearch;
cn.Open();
DbDataReader reader = ExecuteReader(cmd);
List <Rebound.GlobalTrader.DAL.BOMDetails> lst = new List <Rebound.GlobalTrader.DAL.BOMDetails>();
while (reader.Read())
{
Rebound.GlobalTrader.DAL.BOMDetails obj = new Rebound.GlobalTrader.DAL.BOMDetails();
obj.BOMId = GetReaderValue_Int32(reader, "BOMId", 0);
obj.BOMName = GetReaderValue_String(reader, "BOMName", "");
obj.BOMCode = GetReaderValue_String(reader, "BOMCode", "");
lst.Add(obj);
obj = null;
}
return(lst);
}
catch (SqlException sqlex)
{
//LogException(sqlex);
throw new Exception("Failed to get BOM", sqlex);
}
finally
{
cmd.Dispose();
cn.Close();
cn.Dispose();
}
}
/// <summary>
/// Get
/// Calls [usp_select_BOM]
/// </summary>
public override BOMDetails Get(System.Int32?BOMId)
{
SqlConnection cn = null;
SqlCommand cmd = null;
try {
cn = new SqlConnection(this.ConnectionString);
cmd = new SqlCommand("usp_select_BOM", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 30;
cmd.Parameters.Add("@BOMId", SqlDbType.Int).Value = BOMId;
cn.Open();
DbDataReader reader = ExecuteReader(cmd, CommandBehavior.SingleRow);
if (reader.Read())
{
//return GetBOMFromReader(reader);
Rebound.GlobalTrader.DAL.BOMDetails obj = new Rebound.GlobalTrader.DAL.BOMDetails();
obj.BOMId = GetReaderValue_Int32(reader, "BOMId", 0);
obj.ClientNo = GetReaderValue_Int32(reader, "ClientNo", 0);
obj.BOMName = GetReaderValue_String(reader, "BOMName", "");
obj.Notes = GetReaderValue_String(reader, "Notes", "");
obj.BOMCode = GetReaderValue_String(reader, "BOMCode", "");
obj.Inactive = GetReaderValue_Boolean(reader, "Inactive", false);
obj.UpdatedBy = GetReaderValue_NullableInt32(reader, "UpdatedBy", null);
obj.CompanyNo = GetReaderValue_Int32(reader, "companyId", 0);
obj.CompanyName = GetReaderValue_String(reader, "CompanyName", "");
obj.ContactNo = GetReaderValue_Int32(reader, "contactId", 0);
obj.ContactName = GetReaderValue_String(reader, "contactName", "");
obj.RequestToPOHubBy = GetReaderValue_NullableInt32(reader, "RequestToPOHubBy", null);
obj.DateRequestToPOHub = GetReaderValue_NullableDateTime(reader, "DateRequestToPOHub", null);
obj.ReleaseBy = GetReaderValue_NullableInt32(reader, "ReleaseBy", null);
obj.DateRelease = GetReaderValue_NullableDateTime(reader, "DateRelease", null);
obj.BomCount = GetReaderValue_Int32(reader, "BomCount", 0);
obj.UpdatedBy = GetReaderValue_NullableInt32(reader, "UpdatedBy", null);
obj.DLUP = GetReaderValue_DateTime(reader, "DLUP", DateTime.MinValue);
obj.BOMStatus = GetReaderValue_String(reader, "Status", "");
obj.StatusValue = GetReaderValue_NullableInt32(reader, "StatusValue", null);
obj.CurrencyCode = GetReaderValue_String(reader, "CurrencyCode", "");
obj.CurrencyNo = GetReaderValue_NullableInt32(reader, "CurrencyId", null);
obj.Currency_Code = GetReaderValue_String(reader, "Currency_Code", "");
obj.CurrentSupplier = GetReaderValue_String(reader, "CurrentSupplier", "");
obj.QuoteRequired = GetReaderValue_DateTime(reader, "QuoteRequired", DateTime.MinValue);
obj.AllItemHasSourcing = GetReaderValue_NullableInt32(reader, "AllHasSourcing", 0);
obj.AS9120 = GetReaderValue_Boolean(reader, "AS9120", false);
obj.Requestedby = GetReaderValue_String(reader, "Requestedby", "");
obj.Releasedby = GetReaderValue_String(reader, "Releasedby", "");
obj.NoBidCount = GetReaderValue_Int32(reader, "NoBidCount", 0);
obj.UpdateByPH = GetReaderValue_Int32(reader, "UpdateByPH", 0);
obj.AssignedUser = GetReaderValue_String(reader, "AssignTo", "");
obj.Contact2Id = GetReaderValue_Int32(reader, "Contact2Id", 0);
obj.Contact2Name = GetReaderValue_String(reader, "Contact2Name", "");
obj.ValidationMessage = GetReaderValue_String(reader, "ValidateMessage", "");
obj.IsReqInValid = GetReaderValue_Int32(reader, "IsReqInValid", 0) > 0 ? true : false;
return(obj);
}
else
{
return(null);
}
} catch (SqlException sqlex) {
//LogException(sqlex);
throw new Exception("Failed to get BOM", sqlex);
} finally {
cmd.Dispose();
cn.Close();
cn.Dispose();
}
}
