protected void ImageButton3_Click(object sender, ImageClickEventArgs e)
{
using (SqlDB db = new SqlDB(ConfigurationManager.ConnectionStrings["dbconn"].ToString()))
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_HubInv_SyncPolicy";
cmd.CommandType = CommandType.StoredProcedure;
db.execSqlWithCmd(ref cmd);
cmd.Dispose();
}
loadOEM();
}
private void updateOEM(string warehouseId, int billing, int transit)
{
using (SqlDB db = new SqlDB(ConfigurationManager.ConnectionStrings["dbconn"].ToString()))
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "update hubInventoryOEMPolicy set billingpolicy=@billing, transit=@transit where warehouseId=@warehouseId";
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@billing", billing);
cmd.Parameters.AddWithValue("@transit", transit);
cmd.Parameters.AddWithValue("@warehouseId", warehouseId);
db.execSqlWithCmd(ref cmd);
cmd.Dispose();
}
}
private void updateCUS(string customer_code, string location)
{
using (SqlDB db = new SqlDB(ConfigurationManager.ConnectionStrings["dbconn"].ToString()))
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "update hubInventoryCEMLocation set location=@location where customer_code=@customer_code";
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@location", location);
cmd.Parameters.AddWithValue("@customer_code", customer_code);
db.execSqlWithCmd(ref cmd);
cmd.Dispose();
}
}