public void Update(RemoteBranchInventoryDetails Details) { try { string SQL = "UPDATE tblRemoteBranchInventory SET " + "ProductID = @ProductID, " + "ProductCode = @ProductCode, " + "VariationMatrixID = @VariationMatrixID, " + "MatrixDescription = @MatrixDescription, " + "Quantity = @Quantity, " + "BranchID = @BranchID " + "WHERE BranchInventoryID = @BranchInventoryID;"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmBranchInventoryID = new MySqlParameter("@BranchInventoryID", MySqlDbType.Int64); prmBranchInventoryID.Value = Details.BranchInventoryID; cmd.Parameters.Add(prmBranchInventoryID); MySqlParameter prmProductID = new MySqlParameter("@ProductID", MySqlDbType.String); prmProductID.Value = Details.ProductID; cmd.Parameters.Add(prmProductID); MySqlParameter prmProductCode = new MySqlParameter("@ProductCode", MySqlDbType.String); prmProductCode.Value = Details.ProductCode; cmd.Parameters.Add(prmProductCode); MySqlParameter prmVariationMatrixID = new MySqlParameter("@VariationMatrixID", MySqlDbType.String); prmVariationMatrixID.Value = Details.VariationMatrixID; cmd.Parameters.Add(prmVariationMatrixID); MySqlParameter prmMatrixDescription = new MySqlParameter("@MatrixDescription", MySqlDbType.String); prmMatrixDescription.Value = Details.MatrixDescription; cmd.Parameters.Add(prmMatrixDescription); MySqlParameter prmQuantity = new MySqlParameter("@Quantity", MySqlDbType.String); prmQuantity.Value = Details.Quantity; cmd.Parameters.Add(prmQuantity); MySqlParameter prmBranchID = new MySqlParameter("@BranchID", MySqlDbType.String); prmBranchID.Value = Details.BranchID; cmd.Parameters.Add(prmBranchID); base.ExecuteNonQuery(cmd); } catch (Exception ex) { { } throw base.ThrowException(ex); } }
public RemoteBranchInventoryDetails Details(long BranchInventoryID) { try { string SQL = "SELECT " + "BranchInventoryID, " + "ProductID, " + "ProductCode, " + "VariationMatrixID, " + "MatrixDescription, " + "Quantity, " + "BranchID " + "FROM tblRemoteBranchInventory " + "WHERE BranchInventoryID = @BranchInventoryID;"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmBranchID = new MySqlParameter("@BranchInventoryID", MySqlDbType.Int16); prmBranchID.Value = BranchInventoryID; cmd.Parameters.Add(prmBranchID); MySqlDataReader myReader = base.ExecuteReader(cmd, System.Data.CommandBehavior.SingleResult); RemoteBranchInventoryDetails Details = new RemoteBranchInventoryDetails(); while (myReader.Read()) { Details.BranchInventoryID = BranchInventoryID; Details.ProductID = myReader.GetInt64("ProductID"); Details.ProductCode = "" + myReader["ProductCode"].ToString(); Details.VariationMatrixID = myReader.GetInt64("VariationMatrixID"); Details.MatrixDescription = "" + myReader["MatrixDescription"].ToString(); Details.Quantity = myReader.GetDecimal("Quantity"); Details.BranchID = myReader.GetInt16("BranchID"); } myReader.Close(); return(Details); } catch (Exception ex) { { } throw base.ThrowException(ex); } }
public long Insert(RemoteBranchInventoryDetails Details) { try { string SQL = "INSERT INTO tblRemoteBranchInventory (ProductID, ProductCode, VariationMatrixID, MatrixDescription, Quantity, BranchID) " + "VALUES (@ProductID, @ProductCode, @VariationMatrixID, @MatrixDescription, @Quantity, @BranchID);"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmProductID = new MySqlParameter("@ProductID", MySqlDbType.Int64); prmProductID.Value = Details.ProductID; cmd.Parameters.Add(prmProductID); MySqlParameter prmProductCode = new MySqlParameter("@ProductCode", MySqlDbType.String); prmProductCode.Value = Details.ProductCode; cmd.Parameters.Add(prmProductCode); MySqlParameter prmVariationMatrixID = new MySqlParameter("@VariationMatrixID", MySqlDbType.Int64); prmVariationMatrixID.Value = Details.VariationMatrixID; cmd.Parameters.Add(prmVariationMatrixID); MySqlParameter prmMatrixDescription = new MySqlParameter("@MatrixDescription", MySqlDbType.String); prmMatrixDescription.Value = Details.MatrixDescription; cmd.Parameters.Add(prmMatrixDescription); MySqlParameter prmQuantity = new MySqlParameter("@Quantity", MySqlDbType.Decimal); prmQuantity.Value = Details.Quantity; cmd.Parameters.Add(prmQuantity); MySqlParameter prmBranchID = new MySqlParameter("@BranchID", MySqlDbType.Int16); prmBranchID.Value = Details.BranchID; cmd.Parameters.Add(prmBranchID); base.ExecuteNonQuery(cmd); SQL = "SELECT LAST_INSERT_ID();"; cmd.Parameters.Clear(); 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 long Insert(RemoteBranchInventoryDetails Details) { try { string SQL = "INSERT INTO tblRemoteBranchInventory (ProductID, ProductCode, VariationMatrixID, MatrixDescription, Quantity, BranchID) " + "VALUES (@ProductID, @ProductCode, @VariationMatrixID, @MatrixDescription, @Quantity, @BranchID);"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmProductID = new MySqlParameter("@ProductID",MySqlDbType.Int64); prmProductID.Value = Details.ProductID; cmd.Parameters.Add(prmProductID); MySqlParameter prmProductCode = new MySqlParameter("@ProductCode",MySqlDbType.String); prmProductCode.Value = Details.ProductCode; cmd.Parameters.Add(prmProductCode); MySqlParameter prmVariationMatrixID = new MySqlParameter("@VariationMatrixID",MySqlDbType.Int64); prmVariationMatrixID.Value = Details.VariationMatrixID; cmd.Parameters.Add(prmVariationMatrixID); MySqlParameter prmMatrixDescription = new MySqlParameter("@MatrixDescription",MySqlDbType.String); prmMatrixDescription.Value = Details.MatrixDescription; cmd.Parameters.Add(prmMatrixDescription); MySqlParameter prmQuantity = new MySqlParameter("@Quantity",MySqlDbType.Decimal); prmQuantity.Value = Details.Quantity; cmd.Parameters.Add(prmQuantity); MySqlParameter prmBranchID = new MySqlParameter("@BranchID",MySqlDbType.Int16); prmBranchID.Value = Details.BranchID; cmd.Parameters.Add(prmBranchID); base.ExecuteNonQuery(cmd); SQL = "SELECT LAST_INSERT_ID();"; cmd.Parameters.Clear(); 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 RemoteBranchInventoryDetails Details(long BranchInventoryID) { try { string SQL = "SELECT " + "BranchInventoryID, " + "ProductID, " + "ProductCode, " + "VariationMatrixID, " + "MatrixDescription, " + "Quantity, " + "BranchID " + "FROM tblRemoteBranchInventory " + "WHERE BranchInventoryID = @BranchInventoryID;"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmBranchID = new MySqlParameter("@BranchInventoryID",MySqlDbType.Int16); prmBranchID.Value = BranchInventoryID; cmd.Parameters.Add(prmBranchID); MySqlDataReader myReader = base.ExecuteReader(cmd, System.Data.CommandBehavior.SingleResult); RemoteBranchInventoryDetails Details = new RemoteBranchInventoryDetails(); while (myReader.Read()) { Details.BranchInventoryID = BranchInventoryID; Details.ProductID = myReader.GetInt64("ProductID"); Details.ProductCode = "" + myReader["ProductCode"].ToString(); Details.VariationMatrixID = myReader.GetInt64("VariationMatrixID"); Details.MatrixDescription = "" + myReader["MatrixDescription"].ToString(); Details.Quantity = myReader.GetDecimal("Quantity"); Details.BranchID = myReader.GetInt16("BranchID"); } myReader.Close(); return Details; } catch (Exception ex) { { } throw base.ThrowException(ex); } }
public void Update(RemoteBranchInventoryDetails Details) { try { string SQL= "UPDATE tblRemoteBranchInventory SET " + "ProductID = @ProductID, " + "ProductCode = @ProductCode, " + "VariationMatrixID = @VariationMatrixID, " + "MatrixDescription = @MatrixDescription, " + "Quantity = @Quantity, " + "BranchID = @BranchID " + "WHERE BranchInventoryID = @BranchInventoryID;"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmBranchInventoryID = new MySqlParameter("@BranchInventoryID",MySqlDbType.Int64); prmBranchInventoryID.Value = Details.BranchInventoryID; cmd.Parameters.Add(prmBranchInventoryID); MySqlParameter prmProductID = new MySqlParameter("@ProductID",MySqlDbType.String); prmProductID.Value = Details.ProductID; cmd.Parameters.Add(prmProductID); MySqlParameter prmProductCode = new MySqlParameter("@ProductCode",MySqlDbType.String); prmProductCode.Value = Details.ProductCode; cmd.Parameters.Add(prmProductCode); MySqlParameter prmVariationMatrixID = new MySqlParameter("@VariationMatrixID",MySqlDbType.String); prmVariationMatrixID.Value = Details.VariationMatrixID; cmd.Parameters.Add(prmVariationMatrixID); MySqlParameter prmMatrixDescription = new MySqlParameter("@MatrixDescription",MySqlDbType.String); prmMatrixDescription.Value = Details.MatrixDescription; cmd.Parameters.Add(prmMatrixDescription); MySqlParameter prmQuantity = new MySqlParameter("@Quantity",MySqlDbType.String); prmQuantity.Value = Details.Quantity; cmd.Parameters.Add(prmQuantity); MySqlParameter prmBranchID = new MySqlParameter("@BranchID",MySqlDbType.String); prmBranchID.Value = Details.BranchID; cmd.Parameters.Add(prmBranchID); base.ExecuteNonQuery(cmd); } catch (Exception ex) { { } throw base.ThrowException(ex); } }