/// <summary>
/// Saves a record to the M_Product_Has_Parts table.
/// </summary>
public Boolean Savem_Product_Has_PartSP(M_Product_Has_Parts m_Product_Has_Part, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "M_Product_Has_PartsSave";
scom.Parameters.Add("@productId", SqlDbType.VarChar, 10).Value = m_Product_Has_Part.productId;
scom.Parameters.Add("@PartId", SqlDbType.VarChar, 10).Value = m_Product_Has_Part.PartId;
scom.Parameters.Add("@triggerVal", SqlDbType.Int, 4).Value = m_Product_Has_Part.triggerVal;
scom.Parameters.Add("@InsMode", SqlDbType.Int).Value = formMode; // For insert
scom.Parameters.Add("@RtnValue", SqlDbType.Int).Value = 0;
u_DBConnection dbcon = new u_DBConnection();
retvalue = dbcon.RunQuery(scom);
return(retvalue);
}
catch (Exception ex)
{
throw (ex);
}
}
public List <M_Product_Has_Parts> SelectM_Product_Has_PartMulti(M_Product_Has_Parts objm_Product_Has_Part2)
{
List <M_Product_Has_Parts> retval = new List <M_Product_Has_Parts>();
try
{
strquery = @"select * from m_Product_Has_Parts where productId = '" + objm_Product_Has_Part2.productId + "'";
DataTable dtm_Product_Has_Part = u_DBConnection.ReturnDataTable(strquery, CommandType.Text);
foreach (DataRow drType in dtm_Product_Has_Part.Rows)
{
if (drType != null)
{
M_Product_Has_Parts objm_Product_Has_Part = new M_Product_Has_Parts();
objm_Product_Has_Part.productId = drType["productId"].ToString();
objm_Product_Has_Part.PartId = drType["PartId"].ToString();
objm_Product_Has_Part.triggerVal = int.Parse(drType["triggerVal"].ToString());
retval.Add(objm_Product_Has_Part);
}
}
return(retval);
}
catch (Exception ex)
{
throw ex;
}
}
public M_Product_Has_Parts Selectm_Product_Has_Part(M_Product_Has_Parts objm_Product_Has_Part)
{
try
{
strquery = @"select * from M_Product_Has_Parts where CompCode = '" + objm_Product_Has_Part.productId + "'";
DataRow drType = u_DBConnection.ReturnDataRow(strquery);
if (drType != null)
{
objm_Product_Has_Part.productId = drType["productId"].ToString();
objm_Product_Has_Part.PartId = drType["PartId"].ToString();
objm_Product_Has_Part.triggerVal = int.Parse(drType["triggerVal"].ToString());
return(objm_Product_Has_Part);
}
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
