//update Category
public int UpdateCategory(EC_tb_Category ec_tb_cat, bool database_type)
{
if (!database_type)
{
return(ConnectionDB.ExecuteNonQuery("update tb_Category set [CategoryName]='" + ec_tb_cat.CategoryName + "' where CategoryID=" + ec_tb_cat.CategoryID + ""));
}
else
{
return(ConnectionDB.ExecuteNonQuery("update tb_Category set [CategoryName]=N'" + ec_tb_cat.CategoryName + "' where CategoryID=" + ec_tb_cat.CategoryID + ""));
}
}
//insert Category precede
public int InsertCategory(EC_tb_Category ec_tb_cat, bool database_type)
{
if (!database_type)
{
return(ConnectionDB.ExecuteNonQuery("INSERT INTO tb_Category([CategoryName]) VALUES('" + ec_tb_cat.CategoryName + "')"));
}
else
{
return(ConnectionDB.ExecuteNonQuery("INSERT INTO tb_Category([CategoryName]) VALUES(N'" + ec_tb_cat.CategoryName + "')"));
}
}
//update Payment
public int UpdatePayment(EC_tb_Payment ec_tb_pay, bool data_type)
{
string sql = "";
if (!data_type)
{
sql = "UPDATE [tb_Payment] SET [Card]= '" + ec_tb_pay.Card + "' WHERE [PaymentID]=" + ec_tb_pay.PaymentID + ";";
}
else
{
sql = "UPDATE [tb_Payment] SET [Card]= N'" + ec_tb_pay.Card + "' WHERE [PaymentID]=" + ec_tb_pay.PaymentID + ";";
}
return(ConnectionDB.ExecuteNonQuery(sql));
}
//update password user
public int UpdatePasswordUser(EC_tb_User ec_tb_use, bool data_type)
{
string sql = "";
if (!data_type)
{
sql = "UPDATE [tb_User] SET [Password] = '" + ec_tb_use.Password + "' WHERE [ID] = " + ec_tb_use.ID;
}
else
{
sql = "UPDATE [tb_User] SET [Password] = N'" + ec_tb_use.Password + "' WHERE [ID] = " + ec_tb_use.ID;
}
return(ConnectionDB.ExecuteNonQuery(sql));
}
//insert Payment
public int InsertPayment(EC_tb_Payment ec_tb_pay, bool data_type)
{
string sql = "";
if (!data_type)
{
sql = "INSERT INTO [tb_Payment] ([Card]) VALUES('" + ec_tb_pay.Card + "');";
}
else
{
sql = "INSERT INTO [tb_Payment] ([Card]) VALUES(N'" + ec_tb_pay.Card + "');";
}
return(ConnectionDB.ExecuteNonQuery(sql));
}
//insert SalesPerson
public int InsertSalesperson(EC_tb_SalesPerson ec_tb_sp, bool data_type)
{
string sql = "";
if (!data_type)
{
sql = "INSERT INTO [tb_Salesperson]([Name], [Birthday], [Address], [Email], [Password], [Active]) VALUES('" + ec_tb_sp.Name + "', '" + ec_tb_sp.Birthday + "', '" + ec_tb_sp.Address + "', '" + ec_tb_sp.Email + "', '" + ec_tb_sp.Password + "', " + ec_tb_sp.Active + ")";
}
else
{
sql = "INSERT INTO [tb_Salesperson]([Name], [Birthday], [Address], [Email], [Password], [Active]) VALUES(N'" + ec_tb_sp.Name + "', N'" + ec_tb_sp.Birthday + "', N'" + ec_tb_sp.Address + "', N'" + ec_tb_sp.Email + "', N'" + ec_tb_sp.Password + "', " + ec_tb_sp.Active + ")";
}
return(ConnectionDB.ExecuteNonQuery(sql));
}
//upadate SalesPerson
public int UpdateSalesperson(EC_tb_SalesPerson ec_tb_sp, bool data_type)
{
string sql = "";
if (!data_type)
{
sql = "UPDATE [tb_Salesperson] SET [Name] ='" + ec_tb_sp.Name + "', [Birthday]='" + ec_tb_sp.Birthday + "', [Address]='" + ec_tb_sp.Address + "', [Email]='" + ec_tb_sp.Email + "', [Password]='" + ec_tb_sp.Password + "', [Active]=" + ec_tb_sp.Active + " WHERE [SalespersonID]=" + ec_tb_sp.SalespersonID;
}
else
{
sql = "UPDATE [tb_Salesperson] SET [Name] = N'" + ec_tb_sp.Name + "', [Birthday] = N'" + ec_tb_sp.Birthday + "', [Address] = N'" + ec_tb_sp.Address + "', [Email]= N'" + ec_tb_sp.Email + "', [Password]= N'" + ec_tb_sp.Password + "', [Active] = " + ec_tb_sp.Active + " WHERE [SalespersonID] = " + ec_tb_sp.SalespersonID;
}
return(ConnectionDB.ExecuteNonQuery(sql));
}
//update User non password
public int UpdateUserNonPassword(EC_tb_User ec_tb_use, bool data_type)
{
string sql = "";
if (!data_type)
{
sql = "UPDATE [tb_User] SET [Name] ='" + ec_tb_use.Name + "', [Email] = '" + ec_tb_use.Email + "', [Address] = '" + ec_tb_use.Address + "', [Question] ='" + ec_tb_use.Question + "',[Answer] ='" + ec_tb_use.Answer + "' WHERE [ID]=" + ec_tb_use.ID;
}
else
{
sql = "UPDATE [tb_User] SET [Name] = N'" + ec_tb_use.Name + "', [Email] = N'" + ec_tb_use.Email + "', [Address] = N'" + ec_tb_use.Address + "', [Question] = N'" + ec_tb_use.Question + "', [Answer] = N'" + ec_tb_use.Answer + "' WHERE [ID] = " + ec_tb_use.ID;
}
return(ConnectionDB.ExecuteNonQuery(sql));
}
//insert User
public int InsertUser(EC_tb_User ec_tb_use, bool data_type)
{
string sql = "";
if (!data_type)
{
sql = "INSERT INTO [tb_User] ([Name],[Email],[Address],[Password],[Question],[Answer]) VALUES('" + ec_tb_use.Name + "','" + ec_tb_use.Email + "','" + ec_tb_use.Address + "','" + ec_tb_use.Password + "','" + ec_tb_use.Question + "','" + ec_tb_use.Answer + "')";
}
else
{
sql = "INSERT INTO [tb_User] ([Name],[Email],[Address],[Password],[Question],[Answer]) VALUES(N'" + ec_tb_use.Name + "', N'" + ec_tb_use.Email + "', N'" + ec_tb_use.Address + "', N'" + ec_tb_use.Password + "', N'" + ec_tb_use.Question + "', N'" + ec_tb_use.Answer + "')";
}
return(ConnectionDB.ExecuteNonQuery(sql));
}
//insert Setting
public int InsertSetting(EC_tb_Setting ec_tb_set, bool data_type)
{
string sql = "";
if (!data_type)
{
sql = "INSERT INTO [tb_Currency] ([Currency],[TaxRate],[Active],[Version]) VALUES('" + ec_tb_set.Currency + "'," + ec_tb_set.TaxRate.ToString(new CultureInfo("en-US")) + "," + ec_tb_set.Active + "," + ec_tb_set.Version + ")";
}
else
{
sql = "INSERT INTO [tb_Currency] ([Currency],[TaxRate],[Active],[Version]) VALUES( N'" + ec_tb_set.Currency + "', " + ec_tb_set.TaxRate.ToString(new CultureInfo("en-US")) + ", " + ec_tb_set.Active + ", " + ec_tb_set.Version + ")";
}
return(ConnectionDB.ExecuteNonQuery(sql));
}
//update OrderDetail
public int UpdateOrderDetail(EC_tb_OrderDetail ec_tb_od, bool data_type)
{
string sql = "";
if (!data_type)
{
sql = "UPDATE [tb_OrderDetail] SET [CategoryID] = " + ec_tb_od.CategoryID + ",[CategoryName]='" + ec_tb_od.CategoryName + "',[ProductID] = " + ec_tb_od.ProductID + ",[ProductName]='" + ec_tb_od.ProductName + "', [Cost] = " + ec_tb_od.Cost.ToString(new CultureInfo("en-US")) + ", [Price] = " + ec_tb_od.Price.ToString(new CultureInfo("en-US")) +
",[Qty] =" + ec_tb_od.Qty + ",[Tax] =" + ec_tb_od.Tax.ToString(new CultureInfo("en-US")) + ",[Discount] =" + ec_tb_od.Discount.ToString(new CultureInfo("en-US")) + ",[TotalDiscount]=" + ec_tb_od.TotalDiscount.ToString(new CultureInfo("en-US")) + ",[Total] =" + ec_tb_od.Total.ToString(new CultureInfo("en-US")) + ",[OrderID] =" + ec_tb_od.OrderID + " WHERE [ID]=" + ec_tb_od.ID;
}
else
{
sql = "UPDATE [tb_OrderDetail] SET [CategoryID] = " + ec_tb_od.CategoryID + ",[CategoryName]= N'" + ec_tb_od.CategoryName + "',[ProductID] = " + ec_tb_od.ProductID + ",[ProductName]= N'" + ec_tb_od.ProductName + "', [Cost] = " + ec_tb_od.Cost.ToString(new CultureInfo("en-US")) + ", [Price] = " + ec_tb_od.Price.ToString(new CultureInfo("en-US")) +
",[Qty] =" + ec_tb_od.Qty + ",[Tax] =" + ec_tb_od.Tax.ToString(new CultureInfo("en-US")) + ",[Discount] =" + ec_tb_od.Discount.ToString(new CultureInfo("en-US")) + ",[TotalDiscount]=" + ec_tb_od.TotalDiscount.ToString(new CultureInfo("en-US")) + ",[Total] =" + ec_tb_od.Total.ToString(new CultureInfo("en-US")) + ",[OrderID] =" + ec_tb_od.OrderID + " WHERE [ID]=" + ec_tb_od.ID;
}
return(ConnectionDB.ExecuteNonQuery(sql));
}
//update Setting
public int UpdateSetting(EC_tb_Setting ec_tb_set, bool data_type)
{
string sql = "";
if (!data_type)
{
sql = "UPDATE [tb_Currency] SET [Currency] ='" + ec_tb_set.Currency + "', [TaxRate] = " + ec_tb_set.TaxRate.ToString(new CultureInfo("en-US")) + ", [Active]= " + ec_tb_set.Active + ", [Version] = " + ec_tb_set.Version +
" WHERE [SettingID] =" + ec_tb_set.SettingID;
}
else
{
sql = "UPDATE [tb_Currency] SET [Currency] = N'" + ec_tb_set.Currency + "', [TaxRate] = " + ec_tb_set.TaxRate.ToString(new CultureInfo("en-US")) + ", [Active] = " + ec_tb_set.Active + ", [Version] = " + ec_tb_set.Version +
" WHERE [SettingID] =" + ec_tb_set.SettingID;
}
return(ConnectionDB.ExecuteNonQuery(sql));
}
//updater Order
public int UpdateOrder(EC_tb_Order ec_tb_ord, bool data_type)
{
string sql = "";
if (!data_type)
{
sql = "UPDATE [tb_Order] SET [CustomerID] = " + ec_tb_ord.CustomerID + ", [CustomerName] = '" + ec_tb_ord.CustomerName + "',[Quantity] =" + ec_tb_ord.Quatity + ",[OrderDate] ='" + ec_tb_ord.OrderDate +
"', [SalespersonID] = " + ec_tb_ord.SalesPersonID + ", [SalespersonName] ='" + ec_tb_ord.SalesPersonName + "', [PaymentID] = " + ec_tb_ord.PaymentID + ", [PaymentName] = '" + ec_tb_ord.PaymentName +
"',[DiscountType]=" + ec_tb_ord.DiscountType + ",[Discount] = " + ec_tb_ord.Discount.ToString(new CultureInfo("en-US")) + ",[TotalDiscount]=" + ec_tb_ord.TotalDiscount.ToString(new CultureInfo("en-US")) + ",[TotalTax] = " + ec_tb_ord.TotalTax.ToString(new CultureInfo("en-US")) + ",[TotalAmount] = " + ec_tb_ord.TotalAmount.ToString(new CultureInfo("en-US")) + " WHERE [OrderID] = " + ec_tb_ord.OrderID;
}
else
{
sql = "UPDATE [tb_Order] SET [CustomerID] = " + ec_tb_ord.CustomerID + ", [CustomerName] = N'" + ec_tb_ord.CustomerName + "', [Quantity] = " + ec_tb_ord.Quatity + ", [OrderDate] = N'" + ec_tb_ord.OrderDate +
"', [SalespersonID] = " + ec_tb_ord.SalesPersonID + ", [SalespersonName] = N'" + ec_tb_ord.SalesPersonName + "', [PaymentID] = " + ec_tb_ord.PaymentID + ", [PaymentName] = N'" + ec_tb_ord.PaymentName +
"', [DiscountType] = " + ec_tb_ord.DiscountType + ", [Discount] = " + ec_tb_ord.Discount.ToString(new CultureInfo("en-US")) + ", [TotalDiscount] = " + ec_tb_ord.TotalDiscount.ToString(new CultureInfo("en-US")) + ", [TotalTax] = " + ec_tb_ord.TotalTax.ToString(new CultureInfo("en-US")) + ",[TotalAmount] = " + ec_tb_ord.TotalAmount.ToString(new CultureInfo("en-US")) + " WHERE [OrderID] = " + ec_tb_ord.OrderID;
}
return(ConnectionDB.ExecuteNonQuery(sql));
}
//insert Order
public int InsertOrder(EC_tb_Order ec_tb_ord, bool data_type)
{
string sql = "";
if (!data_type)
{
sql = "INSERT INTO [tb_Order]([CustomerID],[CustomerName],[Quantity],[OrderDate],[SalespersonID],[SalespersonName],[PaymentID],[PaymentName],[DiscountType],[Discount],[TotalDiscount],[TotalTax],[TotalAmount]) VALUES(" +
ec_tb_ord.CustomerID + ",'" + ec_tb_ord.CustomerName + "'," + ec_tb_ord.Quatity + ",'" + ec_tb_ord.OrderDate + "'," + ec_tb_ord.SalesPersonID + ",'" + ec_tb_ord.SalesPersonName + "'," +
ec_tb_ord.PaymentID + ",'" + ec_tb_ord.PaymentName + "'," + ec_tb_ord.DiscountType + "," + ec_tb_ord.Discount.ToString(new CultureInfo("en-US")) + "," + ec_tb_ord.TotalDiscount.ToString(new CultureInfo("en-US")) + "," + ec_tb_ord.TotalTax.ToString(new CultureInfo("en-US")) + "," + ec_tb_ord.TotalAmount.ToString(new CultureInfo("en-US")) + ")";
}
else
{
sql = "INSERT INTO [tb_Order]([CustomerID],[CustomerName],[Quantity],[OrderDate],[SalespersonID],[SalespersonName],[PaymentID],[PaymentName],[DiscountType],[Discount],[TotalDiscount],[TotalTax],[TotalAmount]) VALUES(" +
ec_tb_ord.CustomerID + ", N'" + ec_tb_ord.CustomerName + "', " + ec_tb_ord.Quatity + ", N'" + ec_tb_ord.OrderDate + "', " + ec_tb_ord.SalesPersonID + ", N'" + ec_tb_ord.SalesPersonName + "', " +
ec_tb_ord.PaymentID + ", N'" + ec_tb_ord.PaymentName + "', " + ec_tb_ord.DiscountType + ", " + ec_tb_ord.Discount.ToString(new CultureInfo("en-US")) + ", " + ec_tb_ord.TotalDiscount.ToString(new CultureInfo("en-US")) + ", " + ec_tb_ord.TotalTax.ToString(new CultureInfo("en-US")) + "," + ec_tb_ord.TotalAmount.ToString(new CultureInfo("en-US")) + ")";
}
return(ConnectionDB.ExecuteNonQuery(sql));
}
//insert Customer
public int InsertCustomer(EC_tb_Customer ec_tb_cus, bool data_type)
{
string sql = "";
if (!data_type)
{
sql = "INSERT INTO [tb_Customer] ([FirstName],[LastName],[Address1],[Address2],[City],[State],[Zipcode],[Phone],[Email]) VALUES('" +
ec_tb_cus.FirstName + "','" + ec_tb_cus.LastName + "','" + ec_tb_cus.Address1 + "','" + ec_tb_cus.Address2 + "','" + ec_tb_cus.City +
"','" + ec_tb_cus.State + "','" + ec_tb_cus.Zipcode + "','" + ec_tb_cus.Phone + "','" + ec_tb_cus.Email + "')";
}
else
{
sql = "INSERT INTO [tb_Customer] ([FirstName],[LastName],[Address1],[Address2],[City],[State],[Zipcode],[Phone],[Email]) VALUES(N'" +
ec_tb_cus.FirstName + "', N'" + ec_tb_cus.LastName + "', N'" + ec_tb_cus.Address1 + "', N'" + ec_tb_cus.Address2 + "', N'" + ec_tb_cus.City +
"', N'" + ec_tb_cus.State + "', N'" + ec_tb_cus.Zipcode + "', N'" + ec_tb_cus.Phone + "', N'" + ec_tb_cus.Email + "')";
}
return(ConnectionDB.ExecuteNonQuery(sql));
}
//InsertInputHistory
public int InsertInputHistory(EC_tb_InputHistory ec_tb_inputhistory, bool data_type)
{
string sql = "";
if (!data_type)
{
sql = "INSERT INTO [tb_InputHistory]([ProductID], [ProductName], [InputDate], [UserID], [UserName], [Cost], [Price], [InventoryCount], [CategoryID], [CategoryName], [Tax], [Active], [Country], [Size_Weight]) VALUES(" +
ec_tb_inputhistory.ProductID + ", '" + ec_tb_inputhistory.ProductName + "', '" + ec_tb_inputhistory.InputDate + "', " + ec_tb_inputhistory.UserID + ", '" + ec_tb_inputhistory.UserName + "', " + ec_tb_inputhistory.Cost.ToString(new CultureInfo("en-US")) +
", " + ec_tb_inputhistory.Price.ToString(new CultureInfo("en-US")) + ", " + ec_tb_inputhistory.InventoryCount + "," + ec_tb_inputhistory.CategoryID + ", '" + ec_tb_inputhistory.CategoryName + "', " + ec_tb_inputhistory.Tax + ", " + ec_tb_inputhistory.Active + ", '" + ec_tb_inputhistory.Country + "', '" + ec_tb_inputhistory.SizeWeight + "')";
}
else
{
sql = "INSERT INTO [tb_InputHistory]([ProductID], [ProductName], [InputDate], [UserID], [UserName], [Cost], [Price], [InventoryCount], [CategoryID], [CategoryName], [Tax], [Active], [Country], [Size_Weight]) VALUES(" +
ec_tb_inputhistory.ProductID + ", N'" + ec_tb_inputhistory.ProductName + "', N'" + ec_tb_inputhistory.InputDate + "', " + ec_tb_inputhistory.UserID + ", N'" + ec_tb_inputhistory.UserName + "', " + ec_tb_inputhistory.Cost.ToString(new CultureInfo("en-US")) +
", " + ec_tb_inputhistory.Price.ToString(new CultureInfo("en-US")) + ", " + ec_tb_inputhistory.InventoryCount + "," + ec_tb_inputhistory.CategoryID + ", N'" + ec_tb_inputhistory.CategoryName + "', " + ec_tb_inputhistory.Tax + ", " + ec_tb_inputhistory.Active + ", N'" + ec_tb_inputhistory.Country + "', N'" + ec_tb_inputhistory.SizeWeight + "')";
}
return(ConnectionDB.ExecuteNonQuery(sql));
}
//insert OrderDetail
public int InsertOrderDetail(EC_tb_OrderDetail ec_tb_od, bool data_type)
{
string sql = "";
if (!data_type)
{
sql = "INSERT INTO [tb_OrderDetail]([CategoryID],[CategoryName],[ProductID],[ProductName],[Cost],[Price],[Qty],[Tax],[DiscountType],[Discount],[TotalDiscount],[Total],[OrderID]) VALUES(" +
ec_tb_od.CategoryID + ",'" + ec_tb_od.CategoryName + "'," + ec_tb_od.ProductID + ",'" + ec_tb_od.ProductName + "'," + ec_tb_od.Cost.ToString(new CultureInfo("en-US")) + ", " + ec_tb_od.Price.ToString(new CultureInfo("en-US")) + "," + ec_tb_od.Qty + "," + ec_tb_od.Tax.ToString(new CultureInfo("en-US")) +
"," + ec_tb_od.DiscountType + "," + ec_tb_od.Discount.ToString(new CultureInfo("en-US")) + "," + ec_tb_od.TotalDiscount.ToString(new CultureInfo("en-US")) + "," + ec_tb_od.Total.ToString(new CultureInfo("en-US")) + "," + ec_tb_od.OrderID + ")";
}
else
{
sql = "INSERT INTO [tb_OrderDetail]([CategoryID],[CategoryName],[ProductID],[ProductName],[Cost],[Price],[Qty],[Tax],[DiscountType],[Discount],[TotalDiscount],[Total],[OrderID]) VALUES(" +
ec_tb_od.CategoryID + ", N'" + ec_tb_od.CategoryName + "', " + ec_tb_od.ProductID + ", N'" + ec_tb_od.ProductName + "', " + ec_tb_od.Cost.ToString(new CultureInfo("en-US")) + ", " + ec_tb_od.Price.ToString(new CultureInfo("en-US")) + "," + ec_tb_od.Qty + "," + ec_tb_od.Tax.ToString(new CultureInfo("en-US")) +
"," + ec_tb_od.DiscountType + "," + ec_tb_od.Discount.ToString(new CultureInfo("en-US")) + "," + ec_tb_od.TotalDiscount.ToString(new CultureInfo("en-US")) + "," + ec_tb_od.Total.ToString(new CultureInfo("en-US")) + "," + ec_tb_od.OrderID + ")";
}
return(ConnectionDB.ExecuteNonQuery(sql));
}
//insert Product
public int InsertProduct(EC_tb_Product ec_tb_pro, bool data_type)
{
string sql = "";
if (!data_type)
{
sql = "INSERT INTO [tb_Product]([BarcodeID],[ShortName],[LongName],[Cost],[Price],[InventoryCount],[CategoryID],[Tax],[PathImage],[Capture],[Active],[Country],[Size_Weight]) VALUES('" +
ec_tb_pro.BarcodeID + "','" + ec_tb_pro.ShortName + "','" + ec_tb_pro.LongName + "'," + ec_tb_pro.Cost.ToString(new CultureInfo("en-US")) + "," + ec_tb_pro.Price.ToString(new CultureInfo("en-US")) + "," + ec_tb_pro.InventoryCount + "," + ec_tb_pro.CategoryID + "," +
ec_tb_pro.Tax + ",'" + ec_tb_pro.PathImage + "'," + ec_tb_pro.Capture + "," + ec_tb_pro.Active + ",'" + ec_tb_pro.Country + "','" + ec_tb_pro.SizeWeight + "')";
}
else
{
sql = "INSERT INTO [tb_Product]([BarcodeID],[ShortName],[LongName],[Cost],[Price],[InventoryCount],[CategoryID],[Tax],[PathImage],[Capture],[Active],[Country],[Size_Weight]) VALUES(N'" +
ec_tb_pro.BarcodeID + "', N'" + ec_tb_pro.ShortName + "', N'" + ec_tb_pro.LongName + "', " + ec_tb_pro.Cost.ToString(new CultureInfo("en-US")) + ", " + ec_tb_pro.Price.ToString(new CultureInfo("en-US")) + ", " + ec_tb_pro.InventoryCount + ", " + ec_tb_pro.CategoryID + "," +
ec_tb_pro.Tax + ", N'" + ec_tb_pro.PathImage + "', " + ec_tb_pro.Capture + "," + ec_tb_pro.Active + ", N'" + ec_tb_pro.Country + "', N'" + ec_tb_pro.SizeWeight + "')";
}
return(ConnectionDB.ExecuteNonQuery(sql));
}
//update Product
public int UpdateProduct(EC_tb_Product ec_tb_pro, bool data_type)
{
string sql = "";
if (!data_type)
{
sql = "UPDATE [tb_Product] SET [ShortName] = '" + ec_tb_pro.ShortName + "', [LongName] ='" + ec_tb_pro.LongName + "', [Cost] = " + ec_tb_pro.Cost.ToString(new CultureInfo("en-US")) + ", [Price] = " + ec_tb_pro.Price.ToString(new CultureInfo("en-US")) + ", [InventoryCount] = " + ec_tb_pro.InventoryCount +
",[CategoryID] =" + ec_tb_pro.CategoryID + ",[Tax] =" + ec_tb_pro.Tax + ",[PathImage] ='" + ec_tb_pro.PathImage + "', [Capture]=" + ec_tb_pro.Capture +
",[Active]=" + ec_tb_pro.Active + ",[BarcodeID]='" + ec_tb_pro.BarcodeID + "', [Country] = '" + ec_tb_pro.Country + "', [Size_Weight] = '" + ec_tb_pro.SizeWeight + "' WHERE ProductID = " + ec_tb_pro.ProductID;
}
else
{
sql = "UPDATE [tb_Product] SET [ShortName] = N'" + ec_tb_pro.ShortName + "', [LongName] = N'" + ec_tb_pro.LongName + "', [Cost] = " + ec_tb_pro.Cost.ToString(new CultureInfo("en-US")) + ", [Price] = " + ec_tb_pro.Price.ToString(new CultureInfo("en-US")) + ", [InventoryCount] = " + ec_tb_pro.InventoryCount +
",[CategoryID] =" + ec_tb_pro.CategoryID + ", [Tax] = " + ec_tb_pro.Tax + ",[PathImage] = N'" + ec_tb_pro.PathImage + "', [Capture]= " + ec_tb_pro.Capture +
", [Active]=" + ec_tb_pro.Active + ",[BarcodeID]= N'" + ec_tb_pro.BarcodeID + "', [Country] = N'" + ec_tb_pro.Country + "', [Size_Weight] = N'" + ec_tb_pro.SizeWeight + "' WHERE ProductID = " + ec_tb_pro.ProductID;
}
return(ConnectionDB.ExecuteNonQuery(sql));
}
//update Customer
public int UpdateCustomer(EC_tb_Customer ec_tb_cus, bool data_type)
{
string sql = "";
if (!data_type)
{
sql = "UPDATE [tb_Customer] SET [FirstName] = '" + ec_tb_cus.FirstName + "',[LastName] ='" + ec_tb_cus.LastName +
"',[Address1] ='" + ec_tb_cus.Address1 + "',[Address2] ='" + ec_tb_cus.Address2 + "',[City] ='" + ec_tb_cus.City +
"',[State] ='" + ec_tb_cus.State + "',[Zipcode] ='" + ec_tb_cus.Zipcode + "',[Phone] ='" + ec_tb_cus.Phone +
"',[Email] ='" + ec_tb_cus.Email + "' WHERE CustomerID=" + ec_tb_cus.CustomerID;
}
else
{
sql = "UPDATE [tb_Customer] SET [FirstName] = N'" + ec_tb_cus.FirstName + "', [LastName] = N'" + ec_tb_cus.LastName +
"',[Address1] = N'" + ec_tb_cus.Address1 + "', [Address2] = N'" + ec_tb_cus.Address2 + "', [City] = N'" + ec_tb_cus.City +
"', [State] = N'" + ec_tb_cus.State + "',[Zipcode] = N'" + ec_tb_cus.Zipcode + "', [Phone] = N'" + ec_tb_cus.Phone +
"', [Email] = N'" + ec_tb_cus.Email + "' WHERE CustomerID=" + ec_tb_cus.CustomerID;
}
return(ConnectionDB.ExecuteNonQuery(sql));
}
//delete all Payment
public int DeleteAllPayment()
{
string sql = "DELETE FROM [tb_Payment]";
return(ConnectionDB.ExecuteNonQuery(sql));
}
//delete all Setting
public int DeleteAllSetting()
{
string sql = "DELETE FROM [tb_Currency]";
return(ConnectionDB.ExecuteNonQuery(sql));
}
//delete all SalesPerson
public int DeleteAllSalesperson()
{
string sql = "DELETE from [tb_Salesperson]";
return(ConnectionDB.ExecuteNonQuery(sql));
}
//delete SalesPerson
public int DeleteSalesperson(EC_tb_SalesPerson ec_tb_sp)
{
string sql = "DELETE from [tb_SalesPerson] where [SalespersonID]=" + ec_tb_sp.SalespersonID;
return(ConnectionDB.ExecuteNonQuery(sql));
}
//update salesperson active
public void UpdateSalespersonActive(int active)
{
ConnectionDB.ExecuteNonQuery("Update [tb_Salesperson] SET [Active]=0");
}
//delete User
public int DeleteUser(EC_tb_User ec_tb_use)
{
string sql = "DELETE FROM [tb_User] WHERE [ID]=" + ec_tb_use.ID;
return(ConnectionDB.ExecuteNonQuery(sql));
}
//DeleteAllInputHistory
public int DeleteAllInputHistory()
{
string sql = "DELETE FROM [tb_InputHistory]";
return(ConnectionDB.ExecuteNonQuery(sql));
}
//DeleteInputHistory
public int DeleteInputHistory(EC_tb_InputHistory ec_tb_inputhistory)
{
string sql = "DELETE FROM [tb_InputHistory] WHERE [InputID] = " + ec_tb_inputhistory.InputID;
return(ConnectionDB.ExecuteNonQuery(sql));
}
//delete all User
public int DeleteAllUser()
{
string sql = "DELETE FROM [tb_User]";
return(ConnectionDB.ExecuteNonQuery(sql));
}
//delete Payment
public int DeletePayment(EC_tb_Payment ec_tb_pay)
{
string sql = "DELETE FROM [tb_Payment] WHERE [PaymentID]=" + ec_tb_pay.PaymentID;
return(ConnectionDB.ExecuteNonQuery(sql));
}
