// GET: api/FPLotNum/5
public HttpResponseMessage Get(string Company, string PartNum, string LotNum)
{
try
{
string sErrMsg = "";
BusinessLayer BL = new BusinessLayer();
LotDetails _lotDetails = BL.CheckFPLotNum(Company, PartNum, LotNum, out sErrMsg);
if (sErrMsg != "")
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, sErrMsg));
}
if (_lotDetails.Company != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, _lotDetails));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound,
$"LotNum {LotNum} was not belong to the selected product!"));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message.ToString()));
}
}
/// <summary>
/// DropDownForClient
/// Calls [usp_dropdown_Lot_for_Client]
/// </summary>
public override List <LotDetails> DropDownForClient(System.Int32?clientId)
{
SqlConnection cn = null;
SqlCommand cmd = null;
try {
cn = new SqlConnection(this.ConnectionString);
cmd = new SqlCommand("usp_dropdown_Lot_for_Client", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 30;
cmd.Parameters.Add("@ClientId", SqlDbType.Int).Value = clientId;
cn.Open();
DbDataReader reader = ExecuteReader(cmd);
List <LotDetails> lst = new List <LotDetails>();
while (reader.Read())
{
LotDetails obj = new LotDetails();
obj.LotId = GetReaderValue_Int32(reader, "LotId", 0);
obj.LotName = GetReaderValue_String(reader, "LotName", "");
lst.Add(obj);
obj = null;
}
return(lst);
} catch (SqlException sqlex) {
//LogException(sqlex);
throw new Exception("Failed to get Lots", sqlex);
} finally {
cmd.Dispose();
cn.Close();
cn.Dispose();
}
}
/// <summary>
/// Get
/// Calls [usp_select_Lot]
/// </summary>
public override LotDetails Get(System.Int32?lotId)
{
SqlConnection cn = null;
SqlCommand cmd = null;
try {
cn = new SqlConnection(this.ConnectionString);
cmd = new SqlCommand("usp_select_Lot", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 30;
cmd.Parameters.Add("@LotId", SqlDbType.Int).Value = lotId;
cn.Open();
DbDataReader reader = ExecuteReader(cmd, CommandBehavior.SingleRow);
if (reader.Read())
{
//return GetLotFromReader(reader);
LotDetails obj = new LotDetails();
obj.LotId = GetReaderValue_Int32(reader, "LotId", 0);
obj.ClientNo = GetReaderValue_Int32(reader, "ClientNo", 0);
obj.LotName = GetReaderValue_String(reader, "LotName", "");
obj.Cost = GetReaderValue_NullableDouble(reader, "Cost", null);
obj.CurrencyNo = GetReaderValue_NullableInt32(reader, "CurrencyNo", null);
obj.OnHold = GetReaderValue_Boolean(reader, "OnHold", false);
obj.Consignment = GetReaderValue_Boolean(reader, "Consignment", false);
obj.Notes = GetReaderValue_String(reader, "Notes", "");
obj.LotCode = GetReaderValue_String(reader, "LotCode", "");
obj.Inactive = GetReaderValue_Boolean(reader, "Inactive", false);
obj.UpdatedBy = GetReaderValue_NullableInt32(reader, "UpdatedBy", null);
obj.DLUP = GetReaderValue_DateTime(reader, "DLUP", DateTime.MinValue);
obj.CurrencyCode = GetReaderValue_String(reader, "CurrencyCode", "");
obj.CurrencyDescription = GetReaderValue_String(reader, "CurrencyDescription", "");
obj.LockForCustomerNo = GetReaderValue_NullableInt32(reader, "LockForCustomerNo", null);
obj.LockForCustomer = GetReaderValue_String(reader, "LockForCustomer", "");
return(obj);
}
else
{
return(null);
}
} catch (SqlException sqlex) {
//LogException(sqlex);
throw new Exception("Failed to get Lot", sqlex);
} finally {
cmd.Dispose();
cn.Close();
cn.Dispose();
}
}
/// <summary>
/// DataListNugget
/// Calls [usp_datalistnugget_Lot]
/// </summary>
public override List <LotDetails> DataListNugget(System.Int32?clientId, System.Int32?orderBy, System.Int32?sortDir, System.Int32?pageIndex, System.Int32?pageSize, System.String lotCode, System.String lotName)
{
SqlConnection cn = null;
SqlCommand cmd = null;
try {
cn = new SqlConnection(this.ConnectionString);
cmd = new SqlCommand("usp_datalistnugget_Lot", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 60;
cmd.Parameters.Add("@ClientId", SqlDbType.Int).Value = clientId;
cmd.Parameters.Add("@OrderBy", SqlDbType.Int).Value = orderBy;
cmd.Parameters.Add("@SortDir", SqlDbType.Int).Value = sortDir;
cmd.Parameters.Add("@PageIndex", SqlDbType.Int).Value = pageIndex;
cmd.Parameters.Add("@PageSize", SqlDbType.Int).Value = pageSize;
cmd.Parameters.Add("@LotCode", SqlDbType.NVarChar).Value = lotCode;
cmd.Parameters.Add("@LotName", SqlDbType.NVarChar).Value = lotName;
cn.Open();
DbDataReader reader = ExecuteReader(cmd);
List <LotDetails> lst = new List <LotDetails>();
while (reader.Read())
{
LotDetails obj = new LotDetails();
obj.LotId = GetReaderValue_Int32(reader, "LotId", 0);
obj.LotName = GetReaderValue_String(reader, "LotName", "");
obj.OnHold = GetReaderValue_Boolean(reader, "OnHold", false);
obj.Consignment = GetReaderValue_Boolean(reader, "Consignment", false);
obj.LotCode = GetReaderValue_String(reader, "LotCode", "");
obj.CurrencyCode = GetReaderValue_String(reader, "CurrencyCode", "");
obj.StockCount = GetReaderValue_NullableInt32(reader, "StockCount", null);
obj.RowCnt = GetReaderValue_NullableInt32(reader, "RowCnt", null);
obj.Inactive = GetReaderValue_Boolean(reader, "Inactive", false);
lst.Add(obj);
obj = null;
}
return(lst);
} catch (SqlException sqlex) {
//LogException(sqlex);
throw new Exception("Failed to get Lots", sqlex);
} finally {
cmd.Dispose();
cn.Close();
cn.Dispose();
}
}
private static Lot PopulateFromDBDetailsObject(LotDetails obj)
{
Lot objNew = new Lot();
objNew.LotId = obj.LotId;
objNew.ClientNo = obj.ClientNo;
objNew.LotName = obj.LotName;
objNew.Cost = obj.Cost;
objNew.CurrencyNo = obj.CurrencyNo;
objNew.OnHold = obj.OnHold;
objNew.Consignment = obj.Consignment;
objNew.Notes = obj.Notes;
objNew.LotCode = obj.LotCode;
objNew.Inactive = obj.Inactive;
objNew.UpdatedBy = obj.UpdatedBy;
objNew.DLUP = obj.DLUP;
objNew.CurrencyCode = obj.CurrencyCode;
objNew.StockCount = obj.StockCount;
objNew.RowNum = obj.RowNum;
objNew.RowCnt = obj.RowCnt;
objNew.CurrencyDescription = obj.CurrencyDescription;
return(objNew);
}
/// <summary>
/// GetForPage
/// Calls [usp_select_Lot_for_Page]
/// </summary>
public override LotDetails GetForPage(System.Int32?lotId)
{
SqlConnection cn = null;
SqlCommand cmd = null;
try {
cn = new SqlConnection(this.ConnectionString);
cmd = new SqlCommand("usp_select_Lot_for_Page", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 30;
cmd.Parameters.Add("@LotId", SqlDbType.Int).Value = lotId;
cn.Open();
DbDataReader reader = ExecuteReader(cmd, CommandBehavior.SingleRow);
if (reader.Read())
{
//return GetLotFromReader(reader);
LotDetails obj = new LotDetails();
obj.LotId = GetReaderValue_Int32(reader, "LotId", 0);
obj.ClientNo = GetReaderValue_Int32(reader, "ClientNo", 0);
obj.LotName = GetReaderValue_String(reader, "LotName", "");
obj.Inactive = GetReaderValue_Boolean(reader, "Inactive", false);
return(obj);
}
else
{
return(null);
}
} catch (SqlException sqlex) {
//LogException(sqlex);
throw new Exception("Failed to get Lot", sqlex);
} finally {
cmd.Dispose();
cn.Close();
cn.Dispose();
}
}
