/// <summary>
///
/// </summary>
/// <param name="virtualDealerID"></param>
/// <returns></returns>
internal string DeleteVirtualDealer(int virtualDealerID)
{
string result = "-1";
System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(DBConnection.DBConnection.Connection);
DSTableAdapters.VirtualDealerTableAdapter virtualDealerAdap = new DSTableAdapters.VirtualDealerTableAdapter();
DSTableAdapters.IVirtualDealerTableAdapter iVirtualDealerAdap = new DSTableAdapters.IVirtualDealerTableAdapter();
DSTableAdapters.VirtualDealerConfigTableAdapter configDealerAdap = new DSTableAdapters.VirtualDealerConfigTableAdapter();
System.Data.SqlClient.SqlTransaction trans = null;
try
{
conn.Open();
trans = conn.BeginTransaction();
configDealerAdap.Connection = conn;
configDealerAdap.Transaction = trans;
configDealerAdap.DeleteVirtualConfigByVirtualDealerID(virtualDealerID);
iVirtualDealerAdap.Connection = conn;
iVirtualDealerAdap.Transaction = trans;
iVirtualDealerAdap.DeleteByVirtualDealerID(virtualDealerID);
virtualDealerAdap.Connection = conn;
virtualDealerAdap.Transaction = trans;
int resultDelete = virtualDealerAdap.DeleteVirtualDealer(virtualDealerID);
if (resultDelete == 0)
{
throw new Exception("Data error");
}
result = resultDelete.ToString();
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
return "Data error";
}
finally
{
virtualDealerAdap.Connection.Close();
iVirtualDealerAdap.Connection.Close();
configDealerAdap.Connection.Close();
conn.Close();
}
return result;
}
