public bool Update()
{
using (SqlConnection connection = new SqlConnection(CONSTANT.connectBD))
{
string sqlExpression = @"
UPDATE [SPAVREMONT].[USLUGS_SHOP] SET
[ID_SHOP] ='" + ID_SHOP + @"'
,[ID_USLUG] ='" + Uslug.ID_USLUG + @"'
,[PRICE] =" + PRICE.ToString() + @"
,[NOTE_USLUGS_SHOP] ='" + NOTE_USLUGS_SHOP + @"'
WHERE [ID_USLUGS_SHOP]='" + ID_USLUGS_SHOP + @"'
";
connection.Open();
SqlCommand command = new SqlCommand();
command.CommandText = sqlExpression;
command.Connection = connection;
int numb = command.ExecuteNonQuery();
// если успешно вставились данные
if (numb > 0)
{
return(true);
}
}
return(false);
}
static void Main(string[] args)
{
const double PRICE = 14.99;
const double TAX = 0.08;
var name = "";
var address = "";
var city = "";
var state = "";
var zip = "";
double shirts = 0;
double total = 0.0;
double personalTax = 0.0;
double grandTotal = 0.0;
Write(" Enter your name: ");
name = Convert.ToString(ReadLine());
Write(" Street address: ");
address = Convert.ToString(ReadLine());
Write(" City: ");
city = Convert.ToString(ReadLine());
Write(" State: ");
state = Convert.ToString(ReadLine());
Write(" Zip: ");
zip = Convert.ToString(ReadLine());
Write(" How many T-Shirts did you want to order? ");
shirts = Convert.ToDouble(ReadLine());
total = (shirts * PRICE);
personalTax = (total * TAX);
grandTotal = (total + (total * TAX));
WriteLine("\n\n Reciept for: \n " + name);
WriteLine(" " + address);
WriteLine(" " + city + ", " + state + " " + zip);
WriteLine(" " + shirts + " shirts ordered @ " + PRICE.ToString("C2") + " each");
WriteLine("\n Total:\t " + total.ToString("C2"));
WriteLine(" Tax:\t " + personalTax.ToString("C2"));
WriteLine("----------------");
WriteLine(" Due:\t " + grandTotal.ToString("C2"));
WriteLine(" Press any key to continue . . .");
ReadLine();
}
public bool CreateItemsBuy()
{
using (SqlConnection connection = new SqlConnection(CONSTANT.connectBD))
{
string sqlExpression = @"
INSERT INTO [SPAVREMONT].[ITEMS_BUY]
(
[ID_ITEMS_BUY]
,[ID_ITEMS_SHOP]
,[NAME_IB]
,[NOTE_IB]
,[IMG_URL]
,[PRICE]
)
VALUES (
'" + Guid.NewGuid().ToString() + @"' --[ID_ITEMS_BUY]
,'" + ID_ITEMS_SHOP + @"' --[ID_ITEMS_SHOP]
,'" + NAME_IB + @"' --[NAME_IB]
,'" + NOTE_IB + @"' --[NOTE_IB]
,'" + IMG_URL + @"' --[IMG_URL]
," + PRICE.ToString() + @" --[PRICE]
)
";
connection.Open();
SqlCommand command = new SqlCommand();
command.CommandText = sqlExpression;
command.Connection = connection;
int numbInsUser = command.ExecuteNonQuery();
// если успешно вставились данные
if (numbInsUser > 0)
{
return(true);
}
}
return(false);
}
public bool CreateUslugShop()
{
using (SqlConnection connection = new SqlConnection(CONSTANT.connectBD))
{
string sqlExpression = @"
INSERT INTO [SPAVREMONT].[USLUGS_SHOP]
(
[ID_USLUGS_SHOP]
,[ID_SHOP]
,[ID_USLUG]
,[PRICE]
,[NOTE_USLUGS_SHOP]
)
VALUES(
'" + Guid.NewGuid().ToString() + @"'--[ID_USLUGS_SHOP]
,'" + ID_SHOP + @"' --[ID_SHOP]
,'" + Uslug.ID_USLUG + @"' --[ID_USLUG]
," + PRICE.ToString() + @"--[PRICE]
,'" + NOTE_USLUGS_SHOP + @"' --[NOTE_USLUGS_SHOP]
)
";
connection.Open();
SqlCommand command = new SqlCommand();
command.CommandText = sqlExpression;
command.Connection = connection;
int numbInsUser = command.ExecuteNonQuery();
// если успешно вставились данные
if (numbInsUser > 0)
{
return(true);
}
}
return(false);
}