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