public bool UpdateQCAuditDetails(QualityAuditEntity obj)
{
bool res = false;
SqlCommand cmd = new SqlCommand("BOM_spRemoveQCAuditDetails");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@p_QCAuditID", obj.QCAuditID);
cmd.Parameters.AddWithValue("@p_ActionBy", obj.ActionBy);
//cmd.Parameters.AddWithValue("@p_RMCode", obj.RMCode);
//cmd.Parameters.AddWithValue("@p_RMName", obj.RMName);
//cmd.Parameters.AddWithValue("@p_UOMID", obj.UOMID);
//cmd.Parameters.AddWithValue("@p_splitable", obj.splitable);
//cmd.Parameters.AddWithValue("@p_stock", obj.stock);
//cmd.Parameters.AddWithValue("@p_re_Orderlevel", obj.re_Orderlevel);
//cmd.Parameters.AddWithValue("@p_HSNCode", obj.HSNCode);
//cmd.Parameters.AddWithValue("@p_sell_price", obj.sell_price);
//cmd.Parameters.AddWithValue("@p_cost_price", obj.cost_price);
//cmd.Parameters.AddWithValue("@createdOn", obj.createdOn);
//cmd.Parameters.AddWithValue("@modifiedOn", obj.modifiedOn);
//cmd.Parameters.AddWithValue("@IsActive", obj.IsActive);
var locMax = _unitOfWork.DbLayer.ExecuteNonQuery(cmd);
if (locMax != Int32.MaxValue)
{
res = true;
}
return(res);
}
public bool CreateQCAudit(QualityAuditEntity obj)
{
bool res = false;
SqlCommand cmd = new SqlCommand("QC_spSaveQCAudit");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@p_QCAuditID", obj.QCAuditID);
cmd.Parameters.AddWithValue("@p_QCID", obj.QCID);
cmd.Parameters.AddWithValue("@p_WOPRDSerialID", obj.WOPRDSerialID);
cmd.Parameters.AddWithValue("@p_StatusID", obj.StatusID);
cmd.Parameters.AddWithValue("@p_ActionBy", obj.ActionBy);
cmd.Parameters.AddWithValue("@p_IsActive", obj.IsActive);
cmd.Parameters.AddWithValue("@p_WODetlID", obj.WODetlID);
cmd.Parameters.AddWithValue("@p_ApprovedQuantity", obj.ApprovedQuantity);
cmd.Parameters.AddWithValue("@p_RejectedQuantity", obj.RejectedQuantity);
cmd.Parameters.AddWithValue("@p_ReworkQuantity", obj.ReworkQuantity);
cmd.Parameters.AddWithValue("@p_prdID", obj.prdID);
cmd.Parameters.AddWithValue("@p_QCAuditDetails", obj.QCAuditDetails);
//cmd.Parameters.AddWithValue("@p_sell_price", obj.sell_price);
//cmd.Parameters.AddWithValue("@p_cost_price", obj.cost_price);
//cmd.Parameters.AddWithValue("@p_ActionBy", obj.ActionBy);
//cmd.Parameters.AddWithValue("@createdOn", obj.createdOn);
//cmd.Parameters.AddWithValue("@modifiedOn", obj.modifiedOn);
//cmd.Parameters.AddWithValue("@IsActive", obj.IsActive);
var locMax = _unitOfWork.DbLayer.ExecuteNonQuery(cmd);
if (locMax != Int32.MaxValue)
{
res = true;
}
return(res);
}
public bool Post(QualityAuditEntity QualityAuditEntity)
{
try
{
return(_QualityAuditService.CreateQCAudit(QualityAuditEntity));
}
catch (Exception ex)
{
throw new ApiDataException(1000, "Category Not Found", HttpStatusCode.NotFound);
}
}
public bool Put(QualityAuditEntity QualityAuditEntity)
{
try
{
if (QualityAuditEntity.QCAuditID > 0)
{
return(_QualityAuditService.UpdateQCAuditDetails(QualityAuditEntity));
}
}
catch (Exception ex)
{
throw new ApiDataException(1000, "Category not found", HttpStatusCode.NotFound);
}
return(false);
}
