//D
public ResultMessage Delete(int id)
{
if (_da.IsInuse(id))
{
return(new ResultMessage(false, "\r\n已经在单据中使用，不能删除。\r\n可以设为'停用'"));
}
else if (_da.Delete(id) <= 0)
{
return(new ResultMessage(false, "记录不存在"));
}
return(new ResultMessage(true, string.Empty));
}
public void Delete()
{
var da = new CustomerDA();
//Agregando un registro
var entity = new Customer
{
FirstName = "Maria",
LastName = "Romero",
Company = "Reprodata",
Address = "Av. Simon 123",
City = "Lima",
State = "Lima",
Country = "Perú",
PostalCode = "1245",
Phone = "4563214",
Fax = "46512321",
Email = "*****@*****.**",
SupportRepId = null
};
//entity.Name = "Artist Test";
var id = da.Insert(entity);
//Eliminando registro
var result = da.Delete(id);
Assert.IsTrue(result);
}
public decimal Delete(decimal id)
{
decimal ck = -1;
try
{
CustomerDA _da = new CustomerDA();
ck = _da.Delete(id);
}
catch (Exception ex)
{
NaviCommon.Common.log.Error(ex.ToString());
}
return(ck);
}
public bool DeleteCustomer(int id)
{
return(_mCustomerDA.Delete(id));
}
// on logged in
protected void LoggedIn(object sender, EventArgs e)
{
// seeing if there is an order just in case I missed something
if (Session["AnonymousUserName"] != null)
{
// if the user has an order on going delete it and replace it
// with the items that the anonymous user just made(which is really a customer)
//Instantiate our Category specific DataAccess Class
CustomerDA customerDA = new CustomerDA();
// check to see if user has items in their cart
//Create an Object that specifies what we want to Get
Customer customer = new Customer();
//gets customer info based on customer username
customer.Username = UserLogin.UserName;
//We will be returned a collection so lets Declare that and fill it using Get()
Collection<Customer> getCustomer = customerDA.Get(customer);
// count orders with customerid = @customerid and txtnid = @txnid
// instantiate class
Order orders = new Order();
orders.CustomerId = getCustomer[0].Id;
orders.TxnId = "";
OrderDA orderDA = new OrderDA();
Collection<Order> getOrders = orderDA.Get(orders);
// returns number of orders
object getOrder = getOrders.Count;
//clear
orders = null;
orderDA = null;
getOrders = null;
// if the user who is logged has items in his cart as an anonymous user
// delete the items he had previously on his cart and add the new items and order
// that they just put into his cart
if (int.Parse(getOrder.ToString()) > 0)
{
// get the orderID of the customer that he had on going order
// instantiate class
Order oID = new Order();
oID.CustomerId = getCustomer[0].Id;
oID.TxnId = "";
OrderDA ordersDA = new OrderDA();
Collection<Order> getOID = ordersDA.Get(oID);
// returns one item
object getOrderID = getOID[0].Id;
//clear
oID = null;
ordersDA = null;
getOID = null;
// delete the order and items that involve the order above
// delete items from the orderItem table associated with that order if any
//Create an Object that specifies what we want to Get
// OrderItem deleteOrderItem = new OrderItem();
//OrderItemDA deleteOrderItemDA = new OrderItemDA();
////gets orderItem info based on customerID
//deleteOrderItem.OrderId = int.Parse(getOrderID.ToString());
//// deletes the orderItems with that customerID
//deleteOrderItemDA.Delete(deleteOrderItem);
//// clear
//deleteOrderItemDA = null;
//deleteOrderItem = null;
DAL.DataAccess da5 =
new DAL.DataAccess(
ConfigurationManager.ConnectionStrings["MyPetStoreDB"].ConnectionString,
"System.Data.SqlClient");
string comm5 =
"Delete FROM OrderItem WHERE OrderID = @orderID";
// array with orderID
string[] p5 = { "@orderID" };
string[] v5 = { getOrderID.ToString() };
da5.ExecuteNonQuery(comm5, p5, v5);
// clear
p5 = null;
v5 = null;
// delete order
//Instantiate our Order specific DataAccess Class
OrderDA deleteOrderDA = new OrderDA();
//Create an Object that specifies what we want to Get
Order deleteOrder = new Order();
//gets order info based on customerID
deleteOrder.Id = int.Parse(getOrderID.ToString());
// deletes the order with that customerID
deleteOrderDA.Delete(deleteOrder);
// clear
deleteOrderDA = null;
deleteOrder = null;
// get cusotmerID of anonymous user
//Instantiate our Category specific DataAccess Class
CustomerDA customerDA2 = new CustomerDA();
// check to see if user has items in their cart
//Create an Object that specifies what we want to Get
Customer customer2 = new Customer();
//gets customer info based on customer username
customer2.Username = Session["AnonymousUserName"].ToString();
//We will be returned a collection so lets Declare that and fill it using Get()
Collection<Customer> getCustomer2 = customerDA2.Get(customer2);
//for (int i = 0; i < getCustomer2.Count; i++)
//{
// getCustomer2[i].Id;
//}
// get orderID of anonymous user
//Create an Object that specifies what we want to Get
Order ordersID = new Order();
//gets order info based on customerID
ordersID.CustomerId = getCustomer2[0].Id;
OrderDA ordersIDDA = new OrderDA();
// deletes the order with that customerID
Collection<Order> getOrder2 = ordersIDDA.Get(ordersID);
// update the customerid of the anonymous order to the customer, of the user who just logged on
DAL.DataAccess da4 =
new DAL.DataAccess(ConfigurationManager.ConnectionStrings["MyPetStoreDB"].ConnectionString,
"System.Data.SqlClient");
string comm4 =
"UPDATE Orders SET CustomerID = @customerID WHERE OrderID = @orderID AND TXNID = @txnID";
// empty array
string[] p4 = { "@customerID", "@orderID", "@txnID" };
string[] v4 = { getCustomer[0].Id.ToString(), getOrder2[0].Id.ToString(), "" };
// new cus old get order
da4.ExecuteNonQuery(comm4, p4, v4);
// clear
p4 = null;
v4 = null;
// delete anonymous customer from customer table
Customer customers = new Customer();
customers.Id = getCustomer2[0].Id;
CustomerDA customersDA = new CustomerDA();
customersDA.Delete(customers);
// clear
customers = null;
customersDA = null;
//abandon session
Session.Abandon();
Session.Clear();
}
// if user doesn't have an on going order just
// change the customer ID on the order
else
{
// get cusotmerID of anonymous user
//Instantiate our Category specific DataAccess Class
CustomerDA customerDA2 = new CustomerDA();
// check to see if user has items in their cart
//Create an Object that specifies what we want to Get
Customer customer2 = new Customer();
//gets customer info based on customer username
customer2.Username = Session["AnonymousUserName"].ToString();
//We will be returned a collection so lets Declare that and fill it using Get()
Collection<Customer> getCustomer2 = customerDA2.Get(customer2);
//for (int i = 0; i < getCustomer2.Count; i++)
//{
// getCustomer2[i].Id;
//}
// get orderID of anonymous user based on customerID
OrderDA ordersIDDA = new OrderDA();
//Create an Object that specifies what we want to Get
Order ordersID = new Order();
//gets order info based on customerID
ordersID.CustomerId = getCustomer2[0].Id;
// deletes the order with that customerID
Collection<Order> getOrder2 = ordersIDDA.Get(ordersID);
// update the customerid of the anonymous order to the customer, of the user who just logged on
DAL.DataAccess da4 =
new DAL.DataAccess(ConfigurationManager.ConnectionStrings["MyPetStoreDB"].ConnectionString,
"System.Data.SqlClient");
string comm4 =
"UPDATE Orders SET CustomerID = @customerID WHERE OrderID = @orderID AND TXNID = @txnID";
// empty array
string[] p4 = { "@customerID", "@orderID", "@txnID" };
string[] v4 = { getCustomer[0].Id.ToString(), getOrder2[0].Id.ToString(), "" };
// new cus old get order
da4.ExecuteNonQuery(comm4, p4, v4);
// clear
p4 = null;
v4 = null;
// delete anonymous customer from customer table
Customer customers = new Customer();
customers.Id = getCustomer2[0].Id;
CustomerDA customersDA = new CustomerDA();
customersDA.Delete(customers);
// clear
customers = null;
customersDA = null;
//DAL.DataAccess da8 =
// new DAL.DataAccess(
// ConfigurationManager.ConnectionStrings["MyPetStoreDB"].ConnectionString,
// "System.Data.SqlClient");
//string comm8 =
// "Delete FROM Customer WHERE CustomerID = @customerID";
//// array with customerID
//string[] p8 = { "@customerID" };
//string[] v8 = { getCustomer2[0].Id.ToString() };
//da8.ExecuteNonQuery(comm8, p8, v8);
//// clear
//p8 = null;
//v8 = null;
//abandon session
Session.Abandon();
Session.Clear();
}
}
}