public static IOBalanceEntity.BatchSummary DtoToEntity(this BatchSummariesDto dto) { IOBalanceEntity.BatchSummary entity = null; if (!dto.IsNull()) { entity = new IOBalanceEntity.BatchSummary { BatchNo = dto.BatchNo == null ? 0 : (long)dto.BatchNo, FileName = dto.FileName, FilePath = dto.FilePath, TotalRecords = dto.TotalRecords, Successful = dto.Successful, Failed = dto.Failed, UploadStatus = dto.UploadStatus, IsDownload = false, ResultFileName = null, ResultFilePath = null, UploadedBy = dto.UploadedBy, StartUpload = dto.StartUpload, EndUpload = dto.EndUpload }; } return(entity); }
public InventoryService(IIOBalanceRepository <Product> product, IIOBalanceRepository <BatchSummary> batchSummary, IIOBalanceRepository <BatchProductLog> batchProductLog) { this._product = product; this._batchSummary = batchSummary; this._batchProductLog = batchProductLog; this.product = new Product(); this.purchaseOrder = new PurchaseOrder(); this.purchaseOrderDetail = new PurchaseOrderDetail(); this.batchSummary = new BatchSummary(); this.batchProductLog = new BatchProductLog(); }
//return results: //result = 0 -> no error //result = 1 -> system error //result = 2 -> batch no error //result = 3 -> bulk insert batchproductlog error //result = 4 -> BATCH UPLOAD data message return <= 0 //result = 5 -> Successfully inserted ALL records //result = 6 -> Successfully inserted but with errors //result = 7 -> All records error public int SaveBulkProducts(BatchSummariesDto dto, List <BatchProductLogDto> dtoList) { int result = 0; if (!dto.IsNull()) { this.batchSummary = dto.DtoToEntity(); var batchNoIdentity = _batchSummary.Insert(this.batchSummary).BatchNo; if (!batchNoIdentity.IsNull() && batchNoIdentity <= 0) { result = 2; } else { if (!SaveProductBulk(dtoList, batchNoIdentity)) { result = 3; } else { DataTable dtResultSet = new DataTable(); SqlParameter[] sqlParameters = new SqlParameter[] { new SqlParameter() { ParameterName = "BatchNo", SqlValue = batchNoIdentity, SqlDbType = SqlDbType.BigInt } }; dtResultSet = _product.ExecuteSPReturnTable("uspBatchProductCreation", true, sqlParameters); if (dtResultSet.Rows.Count <= 0) { result = 4; } else { if (dtResultSet.Rows[0][Globals.Result].ToString() == "5") { result = 0; } else if (dtResultSet.Rows[0][Globals.Result].ToString() == "6") { result = 6; } else if (dtResultSet.Rows[0][Globals.Result].ToString() == "7") { result = 7; } } } } } else { result = 1; } return(result); }