public Int64 Insert(ProductGroupBaseVariationsMatrixDetails Details) { try { Save(Details); string SQL = "SELECT LAST_INSERT_ID();"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; System.Data.DataTable dt = new System.Data.DataTable("LAST_INSERT_ID"); base.MySqlDataAdapterFill(cmd, dt); Int64 iID = 0; foreach (System.Data.DataRow dr in dt.Rows) { iID = Int64.Parse(dr[0].ToString()); } return iID; } catch (Exception ex) { throw base.ThrowException(ex); } }
public Int64 Insert(ProductGroupBaseVariationsMatrixDetails Details) { try { Save(Details); string SQL = "SELECT LAST_INSERT_ID();"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; System.Data.DataTable dt = new System.Data.DataTable("LAST_INSERT_ID"); base.MySqlDataAdapterFill(cmd, dt); Int64 iID = 0; foreach (System.Data.DataRow dr in dt.Rows) { iID = Int64.Parse(dr[0].ToString()); } return(iID); } catch (Exception ex) { throw base.ThrowException(ex); } }
public Int32 Save(ProductGroupBaseVariationsMatrixDetails Details) { try { string SQL = "CALL procSaveProductGroupBaseVariationsMatrix(@MatrixID, @GroupID, @Description, @UnitID," + "@Price, @PurchasePrice, @IncludeInSubtotalDiscount," + "@VAT, @EVAT, @LocalTax, @CreatedOn, @LastModified);"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; cmd.Parameters.AddWithValue("MatrixID", Details.MatrixID); cmd.Parameters.AddWithValue("GroupID", Details.GroupID); cmd.Parameters.AddWithValue("Description", Details.Description); cmd.Parameters.AddWithValue("UnitID", Details.UnitID); cmd.Parameters.AddWithValue("Price", Details.Price); cmd.Parameters.AddWithValue("PurchasePrice", Details.PurchasePrice); cmd.Parameters.AddWithValue("IncludeInSubtotalDiscount", Details.IncludeInSubtotalDiscount); cmd.Parameters.AddWithValue("VAT", Details.VAT); cmd.Parameters.AddWithValue("EVAT", Details.EVAT); cmd.Parameters.AddWithValue("LocalTax", Details.LocalTax); 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 bool UpdateVariationDesc(ProductGroupBaseVariationsMatrixDetails Details) { try { string SQL = "UPDATE tblProductGroupBaseVariationsMatrix SET " + "Description = @Description " + "WHERE GroupID = @GroupID AND MatrixID = @MatrixID;"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; cmd.Parameters.AddWithValue("@GroupID", Details.GroupID); cmd.Parameters.AddWithValue("@MatrixID", Details.MatrixID); cmd.Parameters.AddWithValue("@Description", Details.Description); base.ExecuteNonQuery(cmd); return(true); } catch (Exception ex) { throw base.ThrowException(ex); } }
public Int64 InsertBaseVariation(ProductGroupBaseVariationsMatrixDetails Details) { try { ProductGroupBaseVariationsMatrix clsProductGroupBaseVariationsMatrix = new ProductGroupBaseVariationsMatrix(base.Connection, base.Transaction); return(clsProductGroupBaseVariationsMatrix.Insert(Details)); } catch (Exception ex) { throw base.ThrowException(ex); } }
public Int64 InsertBaseVariation(ProductGroupBaseVariationsMatrixDetails Details) { try { ProductGroupBaseVariationsMatrix clsProductGroupBaseVariationsMatrix = new ProductGroupBaseVariationsMatrix(base.Connection, base.Transaction); return clsProductGroupBaseVariationsMatrix.Insert(Details); } catch (Exception ex) { throw base.ThrowException(ex); } }
public bool Update(ProductGroupBaseVariationsMatrixDetails Details) { try { Save(Details); return(true); } catch (Exception ex) { throw base.ThrowException(ex); } }
public bool UpdateBaseVariation(ProductGroupBaseVariationsMatrixDetails Details) { try { ProductGroupBaseVariationsMatrix clsProductGroupBaseVariationsMatrix = new ProductGroupBaseVariationsMatrix(base.Connection, base.Transaction); clsProductGroupBaseVariationsMatrix.Update(Details); return(true); } catch (Exception ex) { throw base.ThrowException(ex); } }
public bool Update(ProductGroupBaseVariationsMatrixDetails Details) { try { Save(Details); return true; } catch (Exception ex) { throw base.ThrowException(ex); } }
public ProductGroupBaseVariationsMatrixDetails BaseDetails(Int64 MatrixID, Int64 GroupID) { try { string SQL= "SELECT " + "MatrixID, " + "GroupID, " + "description, " + "a.UnitID, " + "b.UnitName, " + "a.Price, " + "a.PurchasePrice, " + "a.IncludeInSubtotalDiscount, " + "a.VAT, " + "a.EVAT, " + "a.LocalTax " + "FROM tblProductGroupBaseVariationsMatrix a INNER JOIN " + "tblUnit b ON a.UnitID = b.UnitID " + "WHERE MatrixID = @MatrixID AND GroupID = @GroupID;"; 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 prmGroupID = new MySqlParameter("@GroupID",MySqlDbType.Int64); prmGroupID.Value = GroupID; cmd.Parameters.Add(prmGroupID); MySqlDataReader myReader = base.ExecuteReader(cmd, System.Data.CommandBehavior.SingleResult); ProductGroupBaseVariationsMatrixDetails Details = new ProductGroupBaseVariationsMatrixDetails(); while (myReader.Read()) { Details.MatrixID =myReader.GetInt64("MatrixID"); Details.GroupID = myReader.GetInt64("GroupID"); Details.Description = "" + myReader["Description"].ToString(); Details.UnitID = myReader.GetInt32("UnitID"); Details.UnitName = "" + myReader["UnitName"].ToString(); Details.Price = myReader.GetDecimal("Price"); Details.PurchasePrice = myReader.GetDecimal("PurchasePrice"); Details.IncludeInSubtotalDiscount = myReader.GetBoolean("IncludeInSubtotalDiscount"); Details.VAT = myReader.GetDecimal("VAT"); Details.EVAT = myReader.GetDecimal("EVAT"); Details.LocalTax = myReader.GetDecimal("LocalTax"); } myReader.Close(); return Details; } catch (Exception ex) { throw base.ThrowException(ex); } }
public Int32 Save(ProductGroupBaseVariationsMatrixDetails Details) { try { string SQL = "CALL procSaveProductGroupBaseVariationsMatrix(@MatrixID, @GroupID, @Description, @UnitID," + "@Price, @PurchasePrice, @IncludeInSubtotalDiscount," + "@VAT, @EVAT, @LocalTax, @CreatedOn, @LastModified);"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; cmd.Parameters.AddWithValue("MatrixID", Details.MatrixID); cmd.Parameters.AddWithValue("GroupID", Details.GroupID); cmd.Parameters.AddWithValue("Description", Details.Description); cmd.Parameters.AddWithValue("UnitID", Details.UnitID); cmd.Parameters.AddWithValue("Price", Details.Price); cmd.Parameters.AddWithValue("PurchasePrice", Details.PurchasePrice); cmd.Parameters.AddWithValue("IncludeInSubtotalDiscount", Details.IncludeInSubtotalDiscount); cmd.Parameters.AddWithValue("VAT", Details.VAT); cmd.Parameters.AddWithValue("EVAT", Details.EVAT); cmd.Parameters.AddWithValue("LocalTax", Details.LocalTax); 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 bool UpdateVariationDesc(ProductGroupBaseVariationsMatrixDetails Details) { try { string SQL = "UPDATE tblProductGroupBaseVariationsMatrix SET " + "Description = @Description " + "WHERE GroupID = @GroupID AND MatrixID = @MatrixID;"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; cmd.Parameters.AddWithValue("@GroupID", Details.GroupID); cmd.Parameters.AddWithValue("@MatrixID", Details.MatrixID); 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 ProductGroupBaseVariationsMatrixDetails BaseDetails(Int64 MatrixID, Int64 GroupID) { try { string SQL = "SELECT " + "MatrixID, " + "GroupID, " + "description, " + "a.UnitID, " + "b.UnitName, " + "a.Price, " + "a.PurchasePrice, " + "a.IncludeInSubtotalDiscount, " + "a.VAT, " + "a.EVAT, " + "a.LocalTax " + "FROM tblProductGroupBaseVariationsMatrix a INNER JOIN " + "tblUnit b ON a.UnitID = b.UnitID " + "WHERE MatrixID = @MatrixID AND GroupID = @GroupID;"; 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 prmGroupID = new MySqlParameter("@GroupID", MySqlDbType.Int64); prmGroupID.Value = GroupID; cmd.Parameters.Add(prmGroupID); MySqlDataReader myReader = base.ExecuteReader(cmd, System.Data.CommandBehavior.SingleResult); ProductGroupBaseVariationsMatrixDetails Details = new ProductGroupBaseVariationsMatrixDetails(); while (myReader.Read()) { Details.MatrixID = myReader.GetInt64("MatrixID"); Details.GroupID = myReader.GetInt64("GroupID"); Details.Description = "" + myReader["Description"].ToString(); Details.UnitID = myReader.GetInt32("UnitID"); Details.UnitName = "" + myReader["UnitName"].ToString(); Details.Price = myReader.GetDecimal("Price"); Details.PurchasePrice = myReader.GetDecimal("PurchasePrice"); Details.IncludeInSubtotalDiscount = myReader.GetBoolean("IncludeInSubtotalDiscount"); Details.VAT = myReader.GetDecimal("VAT"); Details.EVAT = myReader.GetDecimal("EVAT"); Details.LocalTax = myReader.GetDecimal("LocalTax"); } myReader.Close(); return(Details); } catch (Exception ex) { throw base.ThrowException(ex); } }
public bool UpdateBaseVariation(ProductGroupBaseVariationsMatrixDetails Details) { try { ProductGroupBaseVariationsMatrix clsProductGroupBaseVariationsMatrix = new ProductGroupBaseVariationsMatrix(base.Connection, base.Transaction); clsProductGroupBaseVariationsMatrix.Update(Details); return true; } catch (Exception ex) { throw base.ThrowException(ex); } }