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); } }