public void updateVariants(ProductVariantsDTO pvDTO)
{
try
{
con = new SqlConnection();
con.ConnectionString = conString;
con.Open();
string sqlQuery = "UPDATE [ShopBase].[dbo].[PRODUCTVARIANTS] SET Price=@Price,Flavor=@Flavor,Size=@Size"
+ ",Product_Id=@Product_Id WHERE Product_Variants_Id=@Product_Variants_Id";
SqlCommand cm = new SqlCommand(sqlQuery, con);
cm.Parameters.AddWithValue("@Product_Variants_Id", pvDTO.PRODVARID);
cm.Parameters.AddWithValue("@Price", pvDTO.PRICE);
cm.Parameters.AddWithValue("@Flavor", pvDTO.FLAVOR);
cm.Parameters.AddWithValue("@Size", pvDTO.SIZE);
cm.Parameters.AddWithValue("@Product_Id", pvDTO.PRODUCTID);
try
{
cm.ExecuteNonQuery();
con.Close();
}
catch (Exception)
{
MessageBox.Show("Data Not Updated!", "Error");
}
}
catch (Exception)
{
MessageBox.Show("Connection Not Successful to Database!", "Error");
}
}
public ProductVariantsDTO GetVariants(string productId)
{
Response response = new Response();
ProductVariantsDTO productVariantsDTO = new ProductVariantsDTO();
var token = AuthorizationService.Authorize(_authParameters.ClientId, _authParameters.ClientSecret, _authParameters.StoreName);
var url = HelperFunctions.CreateUrlFromParts(_authParameters.StoreName, Constants.apiProduct, productId + "/variants/", token.access_token);
var result = HelperFunctions.HttpGet(url).GetAwaiter().GetResult();
if (result.IsSuccessStatusCode)
{
response.HttpStatusCode = result.StatusCode;
response.Result = result.Content.ReadAsAsync <ProductVariantsDTO>().Result;
if (response.Result != null)
{
productVariantsDTO = (ProductVariantsDTO)response.Result;
}
else
{
return(null);
}
}
else
{
response.HttpStatusCode = result.StatusCode;
return(productVariantsDTO);
}
return(productVariantsDTO);
}
public void addVariants(ProductVariantsDTO pvDTO)
{
try
{
con = new SqlConnection();
con.ConnectionString = conString;
con.Open();
string sqlQuery = "INSERT INTO [ShopBase].[dbo].[PRODUCTVARIANTS] (Price,Flavor,Size,Product_Id)"
+ " VALUES (@Price,@Flavor,@Size,@Product_Id)";
SqlCommand cm = new SqlCommand(sqlQuery, con);
cm.Parameters.AddWithValue("@Price", pvDTO.PRICE);
cm.Parameters.AddWithValue("@Flavor", pvDTO.FLAVOR);
cm.Parameters.AddWithValue("@Size", pvDTO.SIZE);
cm.Parameters.AddWithValue("@Product_Id", pvDTO.PRODUCTID);
try
{
cm.ExecuteNonQuery();
con.Close();
}
catch (Exception)
{
MessageBox.Show("Data Not Inserted!", "Variants Error");
}
}
catch (Exception)
{
MessageBox.Show("Connection Not Successful to Database!", "Error");
}
}
void searchAll()
{
dataGridView.Rows.Clear();
dataGridView.Refresh();
ProductVariantsBLL pvBLL = new ProductVariantsBLL();
ArrayList arr = pvBLL.searchAllVariant(productID);
foreach (object o in arr)
{
ProductVariantsDTO dto = (ProductVariantsDTO)o;
int a = dataGridView.Rows.Add();
dataGridView.Rows[a].Cells[0].Value = dto.PRODVARID;
dataGridView.Rows[a].Cells[1].Value = dto.FLAVOR;
dataGridView.Rows[a].Cells[2].Value = dto.PRICE;
dataGridView.Rows[a].Cells[3].Value = dto.SIZE;
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
string flavor = txtFlavor.Text;
string price = txtPrice.Text;
string size = txtSize.Text;
if (flavor != "" & price != "" & size != "")
{
ProductVariantsDTO pvDTO = new ProductVariantsDTO(price, flavor, size, productID);
ProductVariantsBLL pvBLL = new ProductVariantsBLL();
pvBLL.addVariant(pvDTO);
searchAll();
clearAllFields();
}
else
{
MessageBox.Show("Please Fill All The Fields!", "Error");
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
string flavor = txtFlavor.Text;
string price = txtPrice.Text;
string size = txtSize.Text;
DialogResult dialogResult = MessageBox.Show("Are you sure want to Update record?", "Update", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
ProductVariantsDTO pvDTO = new ProductVariantsDTO(pvID, price, flavor, size, productID);
ProductVariantsBLL pvBLL = new ProductVariantsBLL();
pvBLL.updateVariant(pvDTO);
clearAllFields();
Close();
}
else if (dialogResult == DialogResult.No)
{
}
}
static void Main(string[] args)
{
try
{
ServiceFactory serviceFactory = new ServiceFactory("client_id", "client_secret", "store_name");
var product = (ProductService)serviceFactory.GetService(AcendaSDK.Enums.ServiceType.Product);
var order = (OrderService)serviceFactory.GetService(AcendaSDK.Enums.ServiceType.Order);
var inventory = (InventoryService)serviceFactory.GetService(AcendaSDK.Enums.ServiceType.Inventory);
var customer = (CustomerService)serviceFactory.GetService(AcendaSDK.Enums.ServiceType.Customer);
ProductListDTO productDTOs = product.GetAll <ProductListDTO>();
ProductDTO productDTO = product.GetById <ProductDTO>("2");
ProductVariantsDTO productVariants = product.GetVariants("2");
OrderListDTO orderListDTO = order.GetAll <OrderListDTO>();
OrderDTO orderDTO = order.GetById <OrderDTO>("2562611");
try
{
//403 Yasak donuyor izinlerle ilgili
BaseDTO customerCreateResult = customer.Create(new CreateCustomerDTO()
{
first_name = "Bob",
last_name = "Smith",
email = "*****@*****.**",
phone_number = "123-123-1234"
});
}
catch (Exception ex)
{
}
try
{
//401
BaseDTO customerDeleteResult = customer.Delete("1");
}
catch (Exception ex)
{
}
BaseDTO inventoryUpdateResult = inventory.Update("5", new VariantDTO()
{
inventory_quantity = "200"
});
BillingAddress billingAddress = new BillingAddress()
{
first_name = "bob",
last_name = "smith",
phone_number = "123-123-1234",
street_line1 = "123 Test ln. ",
city = "San Diego",
state = "CA",
zip = "92101",
country = "US"
};
ShippingAddress shippingAddress = new ShippingAddress()
{
first_name = "bob",
last_name = "smith",
phone_number = "123-123-1234",
street_line1 = "123 Test ln. ",
city = "San Diego",
state = "CA",
zip = "92101",
country = "US"
};
List <CreateOrderItem> creatOrderItem = new List <CreateOrderItem>();
creatOrderItem.Add(new CreateOrderItem()
{
quantity = 1,
product_id = 2
});
CreateOrderDTO createOrderDTO = new CreateOrderDTO()
{
email = "*****@*****.**",
billing_address = billingAddress,
shipping_address = shippingAddress,
items = creatOrderItem,
};
BaseDTO orderCreateResult = order.Create(createOrderDTO);
try
{
var result = order.CreateFulfillments("2562599", new FulfillmentsDTO()
{
tracking_numbers = new List <string>()
{
"1Z999AA10123456784"
},
tracking_urls = new List <string>()
{
"https://www.ups.com/track?loc=en_US&tracknum=1Z999AA10123456784/trackdetails"
},
tracking_company = "UPS",
shipping_method = "Ground",
status = "success",
items = new List <FulfillmentItems>()
{
new FulfillmentItems()
{
id = 74,
quantity = 1,
}
}
});
}
catch (Exception ex)
{
}
try
{
var orderGetFUlfillmentsResult = order.GetFulfillments("2562611", "86");
}
catch (Exception ex)
{
}
Console.ReadKey();
}
catch (Exception ex)
{
var e = ex;
}
Console.ReadKey();
}
public void updateVariant(ProductVariantsDTO pvDTO)
{
ProductVariantsDAL pvDAL = new ProductVariantsDAL();
pvDAL.updateVariants(pvDTO);
}
public void addVariant(ProductVariantsDTO pvDTO)
{
ProductVariantsDAL pvDAL = new ProductVariantsDAL();
pvDAL.addVariants(pvDTO);
}
