public static int AddImportLog(Guid OrgId, int DepartmentId, int ImportedBy, System.Collections.Generic.List<int> ImportedAssteId) { if(ImportedAssteId==null || ImportedAssteId.Count<1) return 0; DateTime DTUpdated = DateTime.UtcNow; lib.bwa.bigWebDesk.LinqBll.Context.MutiBaseDataContext dc = new lib.bwa.bigWebDesk.LinqBll.Context.MutiBaseDataContext(OrgId, DepartmentId); int? ExistId = (from i in dc.AssetImports where i.DepartmentId==DepartmentId select (int?)i.ImportId).Max(); int ImportId = 1; if(ExistId!=null && (int)ExistId>0) ImportId=((int)ExistId)+1; foreach (int id in ImportedAssteId) { lib.bwa.bigWebDesk.LinqBll.Context.AssetImports imp = new lib.bwa.bigWebDesk.LinqBll.Context.AssetImports() { AssetId = id, DepartmentId = DepartmentId, DtUpdated = DTUpdated, ImportId = ImportId, UpdatedBy = ImportedBy }; dc.AssetImports.InsertOnSubmit(imp); } dc.SubmitChanges(); return ImportId; }
static public int AddImportLog(Guid OrgId, int DepartmentId, int ImportedBy, System.Collections.Generic.List <int> ImportedAssteId) { if (ImportedAssteId == null || ImportedAssteId.Count < 1) { return(0); } DateTime DTUpdated = DateTime.UtcNow; lib.bwa.bigWebDesk.LinqBll.Context.MutiBaseDataContext dc = new lib.bwa.bigWebDesk.LinqBll.Context.MutiBaseDataContext(OrgId, DepartmentId); int?ExistId = (from i in dc.AssetImports where i.DepartmentId == DepartmentId select(int?) i.ImportId).Max(); int ImportId = 1; if (ExistId != null && (int)ExistId > 0) { ImportId = ((int)ExistId) + 1; } foreach (int id in ImportedAssteId) { lib.bwa.bigWebDesk.LinqBll.Context.AssetImports imp = new lib.bwa.bigWebDesk.LinqBll.Context.AssetImports() { AssetId = id, DepartmentId = DepartmentId, DtUpdated = DTUpdated, ImportId = ImportId, UpdatedBy = ImportedBy }; dc.AssetImports.InsertOnSubmit(imp); } dc.SubmitChanges(); return(ImportId); }