/// <summary>
/// Updates a subject
/// </summary>
/// <param name="dto"></param>
/// <param name="userName"></param>
/// <returns></returns>
internal int Update(Subject_DTO dto, string userName)
{
var inputParams = new List <ADO_inputParams>()
{
new ADO_inputParams()
{
name = "@SbjCode", value = dto.SbjCode
},
new ADO_inputParams()
{
name = "@SbjValue", value = dto.SbjValue
},
new ADO_inputParams()
{
name = "@userName", value = userName
},
};
var returnParam = new ADO_returnParam()
{
name = "@ReturnVal", value = 0
};
var outParam = new ADO_outputParam()
{
name = "@SbjId", value = 0
};
ado.ExecuteNonQueryProcedure("System_Navigation_Subject_Update", inputParams, ref returnParam, ref outParam);
return((int)outParam.value);
}
/// <summary>
/// Updates a product
/// </summary>
/// <param name="dto"></param>
/// <param name="IsDefault"></param>
/// <param name="userName"></param>
/// <returns></returns>
internal int Update(Product_DTO dto, bool IsDefault, string userName)
{
var inputParams = new List <ADO_inputParams>()
{
new ADO_inputParams()
{
name = "@PrcCode", value = dto.PrcCode
},
new ADO_inputParams()
{
name = "@PrcCodeNew", value = dto.PrcCodeNew
},
new ADO_inputParams()
{
name = "@SbjCode", value = dto.SbjCode
},
new ADO_inputParams()
{
name = "@PrcValue", value = dto.PrcValue
},
new ADO_inputParams()
{
name = "@userName", value = userName
},
new ADO_inputParams()
{
name = "@IsDefault", value = IsDefault
},
};
var outputParam = new ADO_outputParam()
{
name = "@ProductID", value = 0
};
var returnParam = new ADO_returnParam()
{
name = "@ReturnVal", value = 0
};
ado.ExecuteNonQueryProcedure("System_Navigation_Product_Update", inputParams, ref returnParam, ref outputParam);
return((int)outputParam.value);
}
