void btnReView_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
var et = gcloginfail.GetFocusedDataSource<t_loginfail>();
if (null == et)
return;
if (MsgBox.ShowYesNoMessage(null,
string.Format("确定要将 {0} MAC:{1} 审核通过吗?", et.UserName, et.LoginMAC)) == System.Windows.Forms.DialogResult.No)
return;
var usr = GetCurUser<t_user>();
using (var db = new Database()) {
try {
db.BeginTransaction();
db.Delete("t_loginfail", "Id", et, et.Id);
db.Execute(sql_addmac, et.LoginMAC, usr.UserName, usr.Guid);
db.CompleteTransaction();
} catch (Exception) {
db.AbortTransaction();
#if DEBUG
throw;
#endif
}
}
using (var db = new Database()) {
var etfail = db.Fetch<t_loginfail>("select * from t_loginfail");
gcloginfail.DataSource = etfail;
gcloginfail.RefreshDataSource();
var etmac = db.Fetch<t_loginfail>("select * from t_mac");
gcMac.DataSource = etmac;
gcMac.RefreshDataSource();
}
}
public void Delete(long id)
{
if (id <= 0)
{
return;
}
ApiAccessPolicy policy = new ApiAccessPolicy(typeof(MixERP.Net.Entities.Core.Account), "DELETE");
policy.Authorize();
if (!policy.IsAuthorized)
{
throw new HttpResponseException(HttpStatusCode.Forbidden);
}
try
{
using (Database db = new Database(Factory.GetConnectionString(), "Npgsql"))
{
db.Delete("core.accounts", "account_id", null, id);
}
}
catch
{
throw new HttpResponseException(HttpStatusCode.InternalServerError);
}
}
protected void patwGridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string id = patwGridView1.DataKeys[e.RowIndex].Value.ToString();
db.Delete(TableName, "sID", null, id);
Query(AspNetPager1.CurrentPageIndex);
}
protected override void DeleteEntities(List<Entity> entities)
{
using (var database = new Database("SQLiteTest"))
{
using (var transaction = database.GetTransaction())
{
entities.ForEach(entity => database.Delete(entity));
transaction.Complete();
}
}
}
public static BoolMessage PpDelete(object o)
{
_checkVal.Data = null;
try
{
if (string.IsNullOrEmpty(_cstring))
{
throw new Exception("No connection string provided");
}
int rows = _pp.Delete(o);
_checkVal.Success = true;
_checkVal.Message = string.Format("Successfully deleted {0} rows", rows);
}
catch (Exception ex)
{
_checkVal.Success = false;
_checkVal.Message = ex.Message;
}
return(_checkVal);
}
protected string DelUniqueId(string UniqueId)
{
try
{
// Create a PetaPoco database object
var db = new PetaPoco.Database("Shell_AutoArchDBConnectionString");
// Get a record
var a = db.SingleOrDefault <planning>("SELECT * FROM shell_Planning WHERE UniqueId=@0", UniqueId);
//delete
db.Delete(a);
return("OK");
}
catch (Exception eg)
{
divMessage.InnerHtml = "<span id='msg' style='color:#FF3300;font-size:Smaller;font-weight:bold;'>" + "Error Message: " + eg.Message + " </span>";
return("Error");
}
}
public void RecreateFilters(string objectName, string filterName, List<MixERP.Net.Entities.Core.Filter> filters)
{
if (!this.SkipValidation)
{
if (!this.Validated)
{
this.Validate(AccessTypeEnum.Create, this._LoginId, this._Catalog, false);
}
if (!this.HasAccess)
{
Log.Information("Access to add entity \"Filter\" was denied to the user with Login ID {LoginId}. {filters}", this._LoginId, filters);
throw new UnauthorizedException("Access is denied.");
}
}
using (Database db = new Database(Factory.GetConnectionString(this._Catalog), Factory.ProviderName))
{
using (Transaction transaction = db.GetTransaction())
{
var toDelete = this.GetWhere(1, new List<EntityParser.Filter>
{
new EntityParser.Filter { ColumnName = "object_name", FilterCondition = (int) FilterCondition.IsEqualTo, FilterValue = objectName },
new EntityParser.Filter { ColumnName = "filter_name", FilterCondition = (int) FilterCondition.IsEqualTo, FilterValue = filterName }
});
foreach (var filter in toDelete)
{
db.Delete(filter);
}
foreach (var filter in filters)
{
filter.AuditUserId = this._UserId;
filter.AuditTs = System.DateTime.UtcNow;
db.Insert(filter);
}
transaction.Complete();
}
}
}
private void btnDel_Click(object sender, EventArgs e)
{
var et = gvItem.GetFocusedDataSource<UltraDbEntity.T_ERP_Item>();
var dt = gvprice.GetFocusedDataSource<UltraDbEntity.T_ERP_ProducePrice>();
if (null == dt) return;
if (null == et) return;
if (MsgBox.ShowYesNoMessage(string.Empty, "确定要删除?") == System.Windows.Forms.DialogResult.No)
return;
dt.IsDel = true;
using (var db = new Database(this.ConnString))
{
db.Delete(dt);
}
gvItem_FocusedRowChanged(null, null);
}
public void Delete(string id)
{
if (string.IsNullOrWhiteSpace(id))
{
return;
}
ApiAccessPolicy policy = new ApiAccessPolicy(typeof(MixERP.Net.Entities.Core.TaxRateType), "DELETE");
policy.Authorize();
if (!policy.IsAuthorized)
{
throw new HttpResponseException(HttpStatusCode.Forbidden);
}
try
{
using (Database db = new Database(Factory.GetConnectionString(), "Npgsql"))
{
db.Delete("core.tax_rate_types", "tax_rate_type_code", null, id);
}
}
catch
{
throw new HttpResponseException(HttpStatusCode.InternalServerError);
}
}
public void Delete(Contato contato)
{
Database db = new PetaPoco.Database("PRWDEV");
db.Delete("contatosbandre", "ID", contato);
}
/// <summary>
/// Deletes the index
/// </summary>
/// <param name="entity"></param>
public void Delete(RetreaveIndex entity)
{
_database.Delete(entity);
}
/// <summary>
/// Deletes a user
/// </summary>
/// <param name="entity"></param>
public void Delete(RegisteredUser entity)
{
_database.Delete(entity);
}
protected override void Process()
{
using (var unit = GetUnitOfWork())
{
try
{
var _assortmentRepo = unit.Scope.Repository <VendorAssortment>();
var connectors = (from c in this.Connectors
where
(((ConnectorType)c.ConnectorType).Has(ConnectorType.WebAssortment) ||
((ConnectorType)c.ConnectorType).Has(ConnectorType.ShopAssortment))
#if !DEBUG
&& c.IsActive
#endif
select c).ToList();
foreach (Connector conn in connectors)
{
bool excludeProducts = conn.ConnectorSettings.GetValueByKey <bool>("ExcludeProducts", false);
using (var pDb = new PetaPoco.Database(Connection, "System.Data.SqlClient"))
{
pDb.CommandTimeout = 15 * 60;
var productMatches = pDb.Query <ProductMatch>("SELECT * FROM ProductMatch WHERE isMatched = 1").ToList();
List <string> vendorItemNumbersToExclude = new List <string>();
Dictionary <int, string> vendorItemNumbers = new Dictionary <int, string>();
Dictionary <int, Content> contentList = new Dictionary <int, Content>();
log.DebugFormat("Start Generating Assortment for {0}", conn.Name);
log.DebugFormat("Connector {0}({1}) has {2} rules for assortment generation", conn.Name, conn.ConnectorID, conn.ContentProducts.Count);
bool assortmentLoaded = false;
var publicationRules = pDb.Fetch <ConnectorPublication>("SELECT * FROM ConnectorPublication WHERE ConnectorID = @0", conn.ConnectorID);
if (excludeProducts)
{
vendorItemNumbersToExclude = pDb.Fetch <string>("Select value from ExcludeProduct where ConnectorID = @0", conn.ConnectorID).ToList();
vendorItemNumbers = pDb.Fetch <Product>("select productID, VendorItemNumber from product").ToDictionary(x => x.ProductID, y => y.VendorItemNumber);
}
foreach (ContentProduct rule in conn.ContentProducts.OrderBy(x => x.ProductContentIndex))
{
var connectorPublicationRules = publicationRules.Where(x => x.VendorID == rule.VendorID && (!x.FromDate.HasValue || (x.FromDate.HasValue && x.FromDate <= DateTime.Now)) && (!x.ToDate.HasValue || (x.ToDate.HasValue && x.ToDate >= DateTime.Now))).ToList();
if (!assortmentLoaded)
{
assortmentLoaded = rule.IsAssortment;
}
#region content logic
log.DebugFormat("Processing Rule {0} for connectorid {1}", rule.ProductContentID, conn.ConnectorID);
if (rule.ProductID.HasValue)
{
#region Single Product
if (assortmentLoaded && !rule.IsAssortment)
{
// exclude product
if (rule.ProductID.HasValue)
{
contentList.Remove(rule.ProductID.Value);
}
}
else
{
var vass = _assortmentRepo.GetSingle(a => a.VendorID == rule.VendorID &&
a.ProductID == rule.ProductID.Value &&
a.IsActive);
if (vass != null)
{
var groups = (from va in _assortmentRepo.GetAllAsQueryable()
from pa in va.ProductGroupVendors
select new
{
va.VendorAssortmentID,
pa.ProductGroupVendorID
}).ToList();
var vendoradd = (from va in _assortmentRepo.GetAllAsQueryable()
where va.VendorAssortmentID == vass.VendorAssortmentID
select new VendorAdds
{
VendorAssortmentID = va.VendorAssortmentID,
ConcentratorStatusID = va.VendorPrices.FirstOrDefault().ConcentratorStatusID,
QuantityOnHand = unit.Scope.Repository <VendorStock>().GetAllAsQueryable(c => c.ProductID == va.ProductID && c.VendorID == va.VendorID).Sum(c => c.QuantityOnHand),
ProductID = va.ProductID,
BrandID = va.Product.BrandID
}).ToList();
Content content = null;
if (!contentList.ContainsKey(vass.ProductID))
{
if (vass.ProductGroupVendors == null)
{
vass.ProductGroupVendors = new List <ProductGroupVendor>();
}
content = new Content
{
ConnectorID = conn.ConnectorID,
ProductID = rule.ProductID.Value,
ShortDescription = vass.ShortDescription,
LongDescription = vass.LongDescription,
ProductContentID = rule.ProductContentID,
ProductGroupVendors = vass.ProductGroupVendors.Select(c => c.ProductGroupID).ToList(),
Product = unit.Scope.Repository <Product>().GetSingle(c => c.ProductID == rule.ProductID.Value)
};
contentList.Add(rule.ProductID.Value, content);
CheckConnectorPublication(content, connectorPublicationRules, vendoradd.FirstOrDefault(x => x.VendorAssortmentID == vass.VendorAssortmentID), unit, contentList);
}
}
else
{
log.DebugFormat(
"Could not add product {0} to content, does not exists in vender assortment (VendorID {1})",
rule.ProductID.Value, rule.VendorID);
}
}
#endregion
}
else
{
#region Non Product
//include scenario
string additionalFilters = String.Empty;
if (rule.BrandID.HasValue)
{
additionalFilters += String.Format(" AND P.BrandID = {0}", rule.BrandID);
}
//if (rule.ProductGroupID.HasValue)
//{
// vendorAssortment = vendorAssortment.Where(c => c.ProductGroupVendors.Any(l => l.ProductGroupID == rule.ProductGroupID.Value && l.VendorID == rule.VendorID));
//}
string query = String.Format(@"SELECT VA.VendorAssortmentID, VP.ConcentratorStatusID, P.BrandID, VA.ProductID, ISNULL(SUM(VS.QuantityOnHand),0) AS QuantityOnHand
FROM VendorAssortment VA
INNER JOIN Product P ON (VA.ProductID = P.ProductID)
INNER JOIN VendorStock VS ON (VA.VendorID = VS.VendorID AND VA.ProductID = VS.ProductID)
INNER JOIN VendorPrice VP ON (VA.VendorAssortmentID = VP.VendorAssortmentID)
WHERE VA.VendorID = {0} {1}
GROUP BY VA.VendorAssortmentID, VP.ConcentratorStatusID, P.BrandID, VA.ProductID
", rule.VendorID, additionalFilters);
var vendoradd = pDb.Query <VendorAdds>(query).ToDictionary(x => x.VendorAssortmentID, y => y);
// base collection
//var vendorAssortment = pDb.Fetch<VendorAssortment>("SELECT * FROM VendorAssortment WHERE VendorID = @0 AND IsActive = 1", rule.VendorID);
var vendorAssortmentQuery = string.Format("SELECT va.*, pavSentToWehkamp.Value as 'SentToWehkamp', pavSentAsDummy.Value as 'SentToWehkampAsDummy' FROM VendorAssortment va LEFT OUTER JOIN ProductAttributeValue pavSentToWehkamp ON va.ProductID = pavSentToWehkamp.ProductID AND pavSentToWehkamp.AttributeID = (SELECT AttributeID FROM ProductAttributeMetaData pamd WHERE pamd.AttributeCode = 'SentToWehkamp') LEFT OUTER JOIN ProductAttributeValue pavSentAsDummy ON va.ProductID = pavSentAsDummy.ProductID AND pavSentAsDummy.AttributeID = (SELECT AttributeID FROM ProductAttributeMetaData pamd WHERE pamd.AttributeCode = 'SentToWehkampAsDummy') WHERE va.VendorID = {0} AND va.IsActive = 1", rule.VendorID);
var vendorAssortment = pDb.Fetch <VendorAssortmentWehkampSent>(vendorAssortmentQuery);
var productGroupVendors = pDb.Fetch <ProductGroupVendor>("SELECT * FROM ProductGroupVendor WHERE VendorID = @0 OR VendorID = @1", rule.VendorID, rule.Vendor.ParentVendorID ?? rule.VendorID);
string groupsQuery = string.Format(@"SELECT DISTINCT VA.VendorAssortmentID, PGV.ProductGroupID
FROM VendorAssortment VA
INNER JOIN VendorProductGroupAssortment VPGA ON (VPGA.VendorAssortmentID = VA.VendorAssortmentID)
INNER JOIN ProductGroupVendor PGV ON (PGV.ProductGroupVendorID = VPGA.ProductGroupVendorID)
WHERE VA.VendorID = {0} AND VA.IsActive=1", rule.VendorID);
var groupSource = pDb.Fetch <VaGroupInfo>(groupsQuery);
var groups = (from g in groupSource
group g by g.VendorAssortmentID into grouped
select grouped).ToDictionary(x => x.Key, y => (from pg in y select pg.ProductGroupID).ToList());
groupSource = null;
var productRepo = pDb.Fetch <Product>("SELECT * FROM Product").ToDictionary(x => x.ProductID, y => y);
List <ProductAttributeValue> values = pDb.Query <ProductAttributeValue>(string.Format(@"select pav.* from productattributevalue pav
inner join connectorpublication cp on pav.attributeid = cp.attributeid
where cp.connectorid = {0}", rule.ConnectorID)).ToList();
foreach (var va in vendorAssortment)
{
if (!groups.ContainsKey(va.VendorAssortmentID))
{
continue;
}
if (assortmentLoaded && !rule.IsAssortment)
{
contentList.Remove(va.ProductID);
}
else
{
if (excludeProducts &&
(string.IsNullOrEmpty(va.SentToWehkamp) || va.SentToWehkamp.ToLowerInvariant() == "false") &&
(string.IsNullOrEmpty(va.SentToWehkampAsDummy) || va.SentToWehkampAsDummy.ToLowerInvariant() == "false"))
{
string vendorItemNumber = vendorItemNumbers[va.ProductID];
if (ExcludeProduct(vendorItemNumber, vendorItemNumbersToExclude))
{
continue;
}
}
Content content = null;
if (!contentList.ContainsKey(va.ProductID))
{
content = new Content
{
ConnectorID = conn.ConnectorID,
ProductID = va.ProductID,
ShortDescription = va.ShortDescription,
LongDescription = va.LongDescription,
LineType = va.LineType,
ProductContentID = rule.ProductContentID,
ProductGroupVendors = groups[va.VendorAssortmentID],
Product = productRepo[va.ProductID]
};
//content.Product.RelatedProductsSource = relatedProducts.Where(c => c.ProductID == content.ProductID).ToList();
content.Product.ProductAttributeValues = values.Where(c => c.ProductID == content.ProductID).ToList();
contentList.Add(va.ProductID, content);
}
VendorAdds vad = null;
vendoradd.TryGetValue(va.VendorAssortmentID, out vad);
CheckConnectorPublication(content, connectorPublicationRules, vad, unit, contentList);
}
}
#endregion
}
log.DebugFormat("Finished Processing Rule {0} for Connector {1}", rule.ProductContentID, conn.Name);
#endregion
}
///put logic here
try
{
var vendorsettings = pDb.Query <ContentProduct>("SELECT * FROM ContentProduct WHERE ConnectorID = @0", conn.ConnectorID)
.Select(v => new
{
v.ProductContentIndex,
v.ProductContentID
}).Distinct().ToDictionary(x => x.ProductContentID, x => x.ProductContentIndex);
var copyContentList = (from c in contentList.Values
join pm in productMatches on c.ProductID equals pm.ProductID
select c).ToList();
foreach (var c in copyContentList)
{
var match = productMatches.Where(x => x.ProductID == c.ProductID).FirstOrDefault();
if (match != null)
{
var matches = productMatches.Where(x => x.ProductMatchID == match.ProductMatchID && x.ProductID != c.ProductID).ToList();
if (matches.Count > 0)
{
foreach (var product in matches)
{
if (!c.ProductContentID.HasValue)
{
continue;
}
int contentVendorIndex = vendorsettings[c.ProductContentID.Value];
Content matchContent = null;
if (contentList.TryGetValue(product.ProductID, out matchContent))
{
if (!matchContent.ProductContentID.HasValue)
{
continue;
}
int matchContentIndex = vendorsettings[matchContent.ProductContentID.Value];
if (contentVendorIndex > matchContentIndex)
{
contentList.Remove(c.ProductID);
}
else
{
contentList.Remove(matchContent.ProductID);
}
}
}
}
}
}
}
catch (Exception ex)
{
log.AuditError("Cleaning Matches failed for {0}", conn.Name);
}
var curContent = pDb.Fetch <Content>("SELECT * FROM Content WHERE ConnectorID = @0", conn.ConnectorID).ToDictionary(x => x.ProductID, y => y);
try
{
log.DebugFormat("Cleaning up assortment for {0}", conn.Name);
var delcontent = (from c in curContent
where !contentList.ContainsKey(c.Key)
select c.Value).ToList();
foreach (var rec in delcontent)
{
pDb.Delete("Content", "ProductID, ConnectorID", rec);
}
log.DebugFormat("Finished cleaning up for {0}", conn.Name);
}
catch (Exception ex)
{
log.FatalFormat("Assorment cleanup failed for {0} error {1}", conn.ConnectorID, ex.StackTrace);
}
#region Existing Content
//OBSOLETE:
//log.Debug("Processing Existing Content");
//foreach (var curCon in contentList.Values)
//{
// Content exCon = null;
// curContent.TryGetValue(curCon.ProductID, out exCon);
// if (exCon != null)
// {
// exCon.ExtendedCatalog = curCon.ExtendedCatalog;
// exCon.LedgerClass = curCon.LedgerClass;
// exCon.LineType = curCon.LineType;
// exCon.LongDescription = curCon.LongDescription;
// exCon.ProductDesk = curCon.ProductDesk;
// exCon.ShortDescription = curCon.ShortDescription;
// exCon.ProductContentID = curCon.ProductContentID;
// pDb.Update("Content", "ProductID, ConnectorID", exCon, new List<String>() { "ShortDescription", "LongDescription", "LineType", "LedgerClass", "ProductDesk", "ExtendedCatalog", "ProductContentID" });
// }
//}
////unit.Save();
//log.Debug("Finished processing existing content");
#endregion
var newContent = (from c in contentList
where !curContent.ContainsKey(c.Key)
select c.Value).ToList();
log.DebugFormat("Inserting {0} rows for connector {1}", newContent.Count(), conn.ConnectorID);
foreach (var c in newContent)
{
pDb.Insert("Content", "ProductID, ConnectorID", false, new { ProductID = c.ProductID, ConnectorID = c.ConnectorID, c.ProductContentID, c.ShortDescription, c.LongDescription, c.ExtendedCatalog, c.LedgerClass, c.LineType, c.ProductDesk, CreatedBy = c.CreatedBy });
}
#region contentproductgroups
try
{
var contentProductGroups = pDb.Fetch <ContentProductGroup>("SELECT * FROM ContentProductGroup WHERE IsCustom = 0 AND ConnectorID = @0", conn.ConnectorID);
//List<ProductGroupMapping> productGroupMappings = pDb.Fetch<ProductGroupMapping>("SELECT * FROM ProductGroupMapping WHERE Depth = 0 AND (ConnectorID = @0 OR ConnectorID = @1)",
// conn.ConnectorID, conn.ParentConnectorID ?? conn.ConnectorID);
List <ProductGroupMapping> productGroupMappings = pDb.Fetch <ProductGroupMapping>("SELECT * FROM ProductGroupMapping WHERE (ConnectorID = @0 OR ConnectorID = @1)",
conn.ConnectorID, conn.ParentConnectorID ?? conn.ConnectorID);
Dictionary <int, List <int> > MappingProductGroup = (
from c in productGroupMappings
group c by c.ProductGroupID into gr
select new { gr.Key, Value = gr.Select(c => c.ProductGroupMappingID) })
.ToDictionary(c => c.Key, c => c.Value.ToList());
//Start assortment tree processes
var tree = BuildTree(productGroupMappings);
var products = GetContentsPerMapping(contentList.Values.ToList(), productGroupMappings, MappingProductGroup);
//add products to tree
AddProductsToTree(tree, products, contentList.Values.ToList(), MappingProductGroup);
//end assortment tree processes
var toSync = tree.FlattenTreeToList(conn.ConnectorID, 1);
SyncNewContentProductGroups(toSync, pDb, conn.ConnectorID);
log.DebugFormat("Finish Remove unused contentproductgroups");
}
catch (Exception ex)
{
log.Fatal("Error processing contentproductgroups for connectorID" + conn.ConnectorID.ToString(), ex);
}
#endregion
log.DebugFormat("Finish insert assortment for connector {0}: {1}", conn.ConnectorID, conn.Name);
if (conn.ConnectorSettings.GetValueByKey <bool>("SyncContentProductGroupsWithParentConnector", false))
{
SyncCustomContentProducts(conn, pDb);
}
}
}
}
catch (Exception ex)
{
log.Fatal("Processs assortment error", ex);
}
}
}
private static void TestDeleteOperation(Database db, Container newContainer)
{
Console.WriteLine("poistetaan: {0} - {1}, {2}", newContainer.ContainerId, newContainer.Modificator, newContainer.ModificationDate);
db.Delete("Container", "ContainerId", newContainer);
Console.WriteLine("poistettu: {0} - {1}, {2}", newContainer.ContainerId, newContainer.Modificator, newContainer.ModificationDate);
}
void IClass.DeleteClass(CheckIn.Model.Class classInfo)
{
var entity = _db.Single <Entity.ClassEntity>(classInfo.Id);
_db.Delete(entity);
}
void btnRemove_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
var et = gcMac.GetFocusedDataSource<t_mac>();
if (null == et)
return;
if (MsgBox.ShowYesNoMessage(null, "确定要删除吗?") == System.Windows.Forms.DialogResult.No)
return;
using (var db = new Database()) {
db.Delete(et);
}
using (var db = new Database()) {
var etmac = db.Fetch<t_mac>("select * from t_mac");
gcMac.DataSource = etmac;
}
}
