public static bool Insert(OrderDetail ord)
{
SqlCommand cmd = new SqlCommand("INSERT INTO orderdetails (orderid, albumid, quantity, unitprice )" +
" VALUES( @od, @al, @qu, @ui)");
cmd.Parameters.AddWithValue("@od", ord.Orderid);
cmd.Parameters.AddWithValue("@al", ord.Albumid);
cmd.Parameters.AddWithValue("@qu", ord.Quantity);
cmd.Parameters.AddWithValue("@ui", ord.UniPrice);
return(DAO.UpdateTable(cmd));
}
public static bool UpdateAccount(Account a)
{
SqlCommand cmd = new SqlCommand(" UPDATE [User] SET FirstName = @fn, LastName = @ln , [Address] = @ad," +
" City = @ci, [State] = @s , Country = @co , Phone = @p, Email = @e WHERE id = @id ");
cmd.Parameters.AddWithValue("@fn", a.firstname);
cmd.Parameters.AddWithValue("@ln", a.lastname);
cmd.Parameters.AddWithValue("@ad", a.address);
cmd.Parameters.AddWithValue("@ci", a.city);
cmd.Parameters.AddWithValue("@s", a.state);
cmd.Parameters.AddWithValue("@co", a.country);
cmd.Parameters.AddWithValue("@p", a.phone);
cmd.Parameters.AddWithValue("@e", a.email);
cmd.Parameters.AddWithValue("@id", a.id);
return(DAO.UpdateTable(cmd));
}
public static bool Insert(Order o)
{
SqlCommand cmd = new SqlCommand("INSERT INTO orders (OrderDate, FirstName, LastName, Address, City, " +
"State, Country, Phone, Email, Total) VALUES( @od, @fn, @ln, @ad, @ci, @st, @co, @p, @e, @t)");
cmd.Parameters.AddWithValue("@od", o.orderDate);
cmd.Parameters.AddWithValue("@fn", o.firstname);
cmd.Parameters.AddWithValue("@ln", o.lastname);
cmd.Parameters.AddWithValue("@ad", o.address);
cmd.Parameters.AddWithValue("@ci", o.city);
cmd.Parameters.AddWithValue("@st", o.state);
cmd.Parameters.AddWithValue("@co", o.country);
cmd.Parameters.AddWithValue("@p", o.phone);
cmd.Parameters.AddWithValue("@e", o.email);
cmd.Parameters.AddWithValue("@t", o.total);
return(DAO.UpdateTable(cmd));
}
public static bool insertRegister(TextBox[] t1, TextBox[] t2)
{
// only auto for guest user
String sql = "INSERT INTO [dbo].[User]" + Environment.NewLine +
" ([UserName]" + Environment.NewLine +
" ,[Password]" + Environment.NewLine +
" ,[FirstName]" + Environment.NewLine +
" ,[LastName]" + Environment.NewLine +
" ,[Address]" + Environment.NewLine +
" ,[City]" + Environment.NewLine +
" ,[State]" + Environment.NewLine +
" ,[Country]" + Environment.NewLine +
" ,[Phone]" + Environment.NewLine +
" ,[Email]" + Environment.NewLine +
" ,[type])" + Environment.NewLine +
" VALUES" + Environment.NewLine +
" (@UserN ,@Psw,@fN,@lN,@addr,@city,@state ,@country,@phone,@email, 1)";
SqlCommand com = new SqlCommand(sql);
com.Parameters.AddWithValue("@UserN", t1[0].Text);
com.Parameters.AddWithValue("@Psw", t1[1].Text);
com.Parameters.AddWithValue("@fN", t1[2].Text);
com.Parameters.AddWithValue("@lN", t1[3].Text);
com.Parameters.AddWithValue("@email", t1[4].Text);
if (t2[0].Text == string.Empty)
{
com.Parameters.AddWithValue("@addr", DBNull.Value);
}
else
{
com.Parameters.AddWithValue("@addr", t2[0].Text);
}
if (t2[1].Text == string.Empty)
{
com.Parameters.AddWithValue("@city", DBNull.Value);
}
else
{
com.Parameters.AddWithValue("@city", t2[1].Text);
}
if (t2[2].Text == string.Empty)
{
com.Parameters.AddWithValue("@state", DBNull.Value);
}
else
{
com.Parameters.AddWithValue("@state", t2[2].Text);
}
if (t2[3].Text == string.Empty)
{
com.Parameters.AddWithValue("@country", DBNull.Value);
}
else
{
com.Parameters.AddWithValue("@country", t2[3].Text);
}
if (t2[4].Text == string.Empty)
{
com.Parameters.AddWithValue("@phone", DBNull.Value);
}
else
{
com.Parameters.AddWithValue("@phone", t2[4].Text);
}
return(DAO.UpdateTable(com));
}