public Int32 Save(ProductCompositionDetails Details)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "CALL procSaveProductComposition(@CompositionID, @MainProductID, @ProductID, @VariationMatrixID, @UnitID, @Quantity, @CreatedOn, @LastModified);";
cmd.Parameters.AddWithValue("CompositionID", Details.CompositionID);
cmd.Parameters.AddWithValue("MainProductID", Details.MainProductID);
cmd.Parameters.AddWithValue("ProductID", Details.ProductID);
cmd.Parameters.AddWithValue("VariationMatrixID", Details.VariationMatrixID);
cmd.Parameters.AddWithValue("UnitID", Details.UnitID);
cmd.Parameters.AddWithValue("Quantity", Details.Quantity);
cmd.Parameters.AddWithValue("CreatedOn", Details.CreatedOn == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.CreatedOn);
cmd.Parameters.AddWithValue("LastModified", Details.LastModified == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.LastModified);
cmd.CommandText = SQL;
return(base.ExecuteNonQuery(cmd));
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public void Update(ProductCompositionDetails Details)
{
try
{
Save(Details);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public void Update(ProductCompositionDetails Details)
{
try
{
Save(Details);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int64 Insert(ProductCompositionDetails Details)
{
try
{
Save(Details);
return(Int32.Parse(base.getLAST_INSERT_ID(this)));
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int64 Insert(ProductCompositionDetails Details)
{
try
{
Save(Details);
return Int32.Parse(base.getLAST_INSERT_ID(this));
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public ProductCompositionDetails Details(Int64 CompositionID)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = SQLSelect() + "WHERE a.CompositionID = @CompositionID;";
cmd.Parameters.AddWithValue("@CompositionID", CompositionID);
cmd.CommandText = SQL;
string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
ProductCompositionDetails Details = new ProductCompositionDetails();
foreach (System.Data.DataRow dr in dt.Rows)
{
Details.CompositionID = Int64.Parse(dr["CompositionID"].ToString());
Details.MainProductID = Int64.Parse(dr["MainProductID"].ToString());
Details.ProductID = Int64.Parse(dr["ProductID"].ToString());
Details.ProductCode = dr["ProductCode"].ToString();
Details.ProductDesc = dr["ProductDesc"].ToString();
Details.VariationMatrixID = Int64.Parse(dr["VariationMatrixID"].ToString());
Details.MatrixDescription = dr["MatrixDescription"].ToString();
Details.Quantity = Decimal.Parse(dr["Quantity"].ToString());
Details.UnitID = Int32.Parse(dr["UnitID"].ToString());
Details.UnitCode = dr["UnitCode"].ToString();
Details.UnitName = dr["UnitName"].ToString();
}
return(Details);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
private void SaveRecord()
{
ProductCompositionDetails clsDetails = new ProductCompositionDetails();
clsDetails.MainProductID = Convert.ToInt64(lblProductID.Text);
clsDetails.ProductID = Convert.ToInt64(cboProductCode.SelectedItem.Value);
clsDetails.VariationMatrixID = Convert.ToInt64(cboVariation.SelectedItem.Value);
clsDetails.Quantity = Convert.ToDecimal(txtQuantity.Text);
clsDetails.UnitID = Convert.ToInt32(cboProductUnit.SelectedItem.Value);
ProductComposition clsProductComposition = new ProductComposition();
if (lblCompositionID.Text != "0")
{
clsDetails.CompositionID = Convert.ToInt64(lblCompositionID.Text);
clsProductComposition.Update(clsDetails);
}
else
clsProductComposition.Insert(clsDetails);
clsProductComposition.CommitAndDispose();
}
public Int32 Save(ProductCompositionDetails Details)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "CALL procSaveProductComposition(@CompositionID, @MainProductID, @ProductID, @VariationMatrixID, @UnitID, @Quantity, @CreatedOn, @LastModified);";
cmd.Parameters.AddWithValue("CompositionID", Details.CompositionID);
cmd.Parameters.AddWithValue("MainProductID", Details.MainProductID);
cmd.Parameters.AddWithValue("ProductID", Details.ProductID);
cmd.Parameters.AddWithValue("VariationMatrixID", Details.VariationMatrixID);
cmd.Parameters.AddWithValue("UnitID", Details.UnitID);
cmd.Parameters.AddWithValue("Quantity", Details.Quantity);
cmd.Parameters.AddWithValue("CreatedOn", Details.CreatedOn == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.CreatedOn);
cmd.Parameters.AddWithValue("LastModified", Details.LastModified == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.LastModified);
cmd.CommandText = SQL;
return base.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public ProductCompositionDetails Details(Int64 CompositionID)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = SQLSelect() + "WHERE a.CompositionID = @CompositionID;";
cmd.Parameters.AddWithValue("@CompositionID", CompositionID);
cmd.CommandText = SQL;
string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
ProductCompositionDetails Details = new ProductCompositionDetails();
foreach (System.Data.DataRow dr in dt.Rows)
{
Details.CompositionID = Int64.Parse(dr["CompositionID"].ToString());
Details.MainProductID = Int64.Parse(dr["MainProductID"].ToString());
Details.ProductID = Int64.Parse(dr["ProductID"].ToString());
Details.ProductCode = dr["ProductCode"].ToString();
Details.ProductDesc = dr["ProductDesc"].ToString();
Details.VariationMatrixID = Int64.Parse(dr["VariationMatrixID"].ToString());
Details.MatrixDescription = dr["MatrixDescription"].ToString();
Details.Quantity = Decimal.Parse(dr["Quantity"].ToString());
Details.UnitID = Int32.Parse(dr["UnitID"].ToString());
Details.UnitCode = dr["UnitCode"].ToString();
Details.UnitName = dr["UnitName"].ToString();
}
return Details;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
