public Int32 Save(ProductGroupVariationsMatrixDetails Details) { try { string SQL = "CALL procSaveProductGroupVariationsMatrix(@ProductGroupVariationsMatrixID, @MatrixID, @VariationID, @Description, @CreatedOn, @LastModified);"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; cmd.Parameters.AddWithValue("ProductGroupVariationsMatrixID", Details.ProductGroupVariationsMatrixID); cmd.Parameters.AddWithValue("MatrixID", Details.MatrixID); cmd.Parameters.AddWithValue("VariationID", Details.VariationID); cmd.Parameters.AddWithValue("Description", Details.Description); 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); return(base.ExecuteNonQuery(cmd)); } catch (Exception ex) { throw base.ThrowException(ex); } }
public void UpdateVariation(ProductGroupVariationsMatrixDetails Details) { try { string SQL = "UPDATE tblProductGroupVariationsMatrix SET " + "Description = @Description " + "WHERE MatrixID = @MatrixID " + "AND VariationID = @VariationID;"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; cmd.Parameters.AddWithValue("@Description", Details.Description); cmd.Parameters.AddWithValue("@MatrixID", Details.MatrixID); cmd.Parameters.AddWithValue("@VariationID", Details.VariationID); base.ExecuteNonQuery(cmd); } catch (Exception ex) { throw base.ThrowException(ex); } }
public ProductGroupVariationsMatrixDetails Details(Int64 MatrixID, Int32 VariationID) { try { string SQL = "SELECT * FROM tblProductGroupVariationsMatrix " + "WHERE MatrixID = @MatrixID AND VariationID = @VariationID;"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmMatrixID = new MySqlParameter("@MatrixID", MySqlDbType.Int64); prmMatrixID.Value = MatrixID; cmd.Parameters.Add(prmMatrixID); MySqlParameter prmVariationID = new MySqlParameter("@VariationID", MySqlDbType.Int32); prmVariationID.Value = VariationID; cmd.Parameters.Add(prmVariationID); MySqlDataReader myReader = base.ExecuteReader(cmd, System.Data.CommandBehavior.SingleResult); ProductGroupVariationsMatrixDetails Details = new ProductGroupVariationsMatrixDetails(); while (myReader.Read()) { Details.MatrixID = MatrixID; Details.VariationID = VariationID; Details.Description = myReader.GetString(2); } myReader.Close(); return(Details); } catch (Exception ex) { { } throw base.ThrowException(ex); } }
public bool InsertVariation(ProductGroupVariationsMatrixDetails Details) { try { string SQL = "INSERT INTO tblProductGroupVariationsMatrix (MatrixID, VariationID, Description) VALUES (@MatrixID, @VariationID, @Description);"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; cmd.Parameters.AddWithValue("@MatrixID", Details.MatrixID); cmd.Parameters.AddWithValue("@VariationID", Details.VariationID); cmd.Parameters.AddWithValue("@Description", Details.Description); base.ExecuteNonQuery(cmd); return(true); } catch (Exception ex) { throw base.ThrowException(ex); } }
public bool InsertVariation(ProductGroupVariationsMatrixDetails Details) { try { string SQL = "INSERT INTO tblProductGroupVariationsMatrix (MatrixID, VariationID, Description) VALUES (@MatrixID, @VariationID, @Description);"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; cmd.Parameters.AddWithValue("@MatrixID", Details.MatrixID); cmd.Parameters.AddWithValue("@VariationID", Details.VariationID); cmd.Parameters.AddWithValue("@Description", Details.Description); base.ExecuteNonQuery(cmd); return true; } catch (Exception ex) { throw base.ThrowException(ex); } }
private bool SaveRecord() { ProductGroupVariationsMatrixDetails clsDetails; ProductGroupVariationsMatrix clsProductGroupVariationsMatrix = new ProductGroupVariationsMatrix(); string stringVariationDesc = null; foreach (DataListItem item in lstItem.Items) { HtmlInputCheckBox chkList = (HtmlInputCheckBox) item.FindControl("chkList"); TextBox txtDescription = (TextBox) item.FindControl("txtDescription"); clsDetails = new ProductGroupVariationsMatrixDetails(); clsDetails.MatrixID = Convert.ToInt32(lblMatrixID.Text); clsDetails.GroupID = Convert.ToInt32(lblGroupID.Text); clsDetails.VariationID = Convert.ToInt32(chkList.Value); clsDetails.Description = txtDescription.Text; if (clsProductGroupVariationsMatrix.IsVariationExists(clsDetails.MatrixID, clsDetails.VariationID) == false) { clsProductGroupVariationsMatrix.InsertVariation(clsDetails); } else { clsProductGroupVariationsMatrix.UpdateVariation(clsDetails); } //Label lblVariationType = (Label) item.FindControl("lblVariationType"); //stringVariationDesc += lblVariationType.Text + ":" + txtDescription.Text + "; "; stringVariationDesc += txtDescription.Text + "; "; } //update the base variation matrix ProductGroupBaseVariationsMatrixDetails clsBaseDetails = new ProductGroupBaseVariationsMatrixDetails(); clsBaseDetails.MatrixID = Convert.ToInt32(lblMatrixID.Text); clsBaseDetails.GroupID = Convert.ToInt32(lblGroupID.Text); clsBaseDetails.Description = stringVariationDesc; clsBaseDetails.UnitID = Convert.ToInt32(cboUnit.SelectedItem.Value); clsBaseDetails.Price = Convert.ToDecimal(txtProductPrice.Text); clsBaseDetails.PurchasePrice = Convert.ToDecimal(txtPurchasePrice.Text); clsBaseDetails.IncludeInSubtotalDiscount = Convert.ToBoolean(chkIncludeInSubtotalDiscount.Checked); clsBaseDetails.VAT = Convert.ToDecimal(txtVAT.Text); clsBaseDetails.EVAT = Convert.ToDecimal(txtEVAT.Text); clsBaseDetails.LocalTax = Convert.ToDecimal(txtLocalTax.Text); clsProductGroupVariationsMatrix.UpdateBaseVariation(clsBaseDetails); clsProductGroupVariationsMatrix.CommitAndDispose(); return true; }
public ProductGroupVariationsMatrixDetails Details(Int64 MatrixID, Int32 VariationID) { try { string SQL= "SELECT * FROM tblProductGroupVariationsMatrix " + "WHERE MatrixID = @MatrixID AND VariationID = @VariationID;"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmMatrixID = new MySqlParameter("@MatrixID",MySqlDbType.Int64); prmMatrixID.Value = MatrixID; cmd.Parameters.Add(prmMatrixID); MySqlParameter prmVariationID = new MySqlParameter("@VariationID",MySqlDbType.Int32); prmVariationID.Value = VariationID; cmd.Parameters.Add(prmVariationID); MySqlDataReader myReader = base.ExecuteReader(cmd, System.Data.CommandBehavior.SingleResult); ProductGroupVariationsMatrixDetails Details = new ProductGroupVariationsMatrixDetails(); while (myReader.Read()) { Details.MatrixID = MatrixID; Details.VariationID = VariationID; Details.Description = myReader.GetString(2); } myReader.Close(); return Details; } catch (Exception ex) { { } throw base.ThrowException(ex); } }
public Int32 Save(ProductGroupVariationsMatrixDetails Details) { try { string SQL = "CALL procSaveProductGroupVariationsMatrix(@ProductGroupVariationsMatrixID, @MatrixID, @VariationID, @Description, @CreatedOn, @LastModified);"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; cmd.Parameters.AddWithValue("ProductGroupVariationsMatrixID", Details.ProductGroupVariationsMatrixID); cmd.Parameters.AddWithValue("MatrixID", Details.MatrixID); cmd.Parameters.AddWithValue("VariationID", Details.VariationID); cmd.Parameters.AddWithValue("Description", Details.Description); 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); return base.ExecuteNonQuery(cmd); } catch (Exception ex) { throw base.ThrowException(ex); } }
public void UpdateVariation(ProductGroupVariationsMatrixDetails Details) { try { string SQL= "UPDATE tblProductGroupVariationsMatrix SET " + "Description = @Description " + "WHERE MatrixID = @MatrixID " + "AND VariationID = @VariationID;"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; cmd.Parameters.AddWithValue("@Description", Details.Description); cmd.Parameters.AddWithValue("@MatrixID", Details.MatrixID); cmd.Parameters.AddWithValue("@VariationID", Details.VariationID); base.ExecuteNonQuery(cmd); } catch (Exception ex) { throw base.ThrowException(ex); } }