Subversion Repositories SmartDukaan

Rev

Rev 27064 | Rev 27115 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 27064 Rev 27065
Line 955... Line 955...
955 
					throw new ProfitMandiBusinessException("Invalid ReferenceType", "row number " + rowNumber,
 955 
					throw new ProfitMandiBusinessException("Invalid ReferenceType", "row number " + rowNumber,
956 
							"row number " + rowNumber);
 956 
							"row number " + rowNumber);
957 
				}
 957 
				}
958 
				if (row.getCell(3) != null && row.getCell(3).getCellTypeEnum() == CellType.NUMERIC) {
 958 
				if (row.getCell(3) != null && row.getCell(3).getCellTypeEnum() == CellType.NUMERIC) {
959 
					Date businessDate = row.getCell(3).getDateCellValue();
 959 
					Date businessDate = row.getCell(3).getDateCellValue();
960 
					LocalDateTime businessDateTime = LocalDateTime.of(
 - 
 
961 
							LocalDate.of(businessDate.getYear(), businessDate.getMonth(), businessDate.getDate()),
 960 
					LocalDateTime businessDateTime = LocalDateTime.ofInstant(businessDate.toInstant(), ZoneId.systemDefault());
962 
							LocalTime.MIDNIGHT);
 - 
 
963 
					walletHistoryModel.setBusinessDate(businessDateTime);
 961 
					walletHistoryModel.setBusinessDate(businessDateTime);
964 
					;
 962 
					;
965 
				} else {
 963 
				} else {
966 
					throw new ProfitMandiBusinessException("Invalid Business Date", "row number " + rowNumber,
 964 
					throw new ProfitMandiBusinessException("Invalid Business Date", "row number " + rowNumber,
967 
							"row number " + rowNumber);
 965 
							"row number " + rowNumber);
968 
				}
 966 
				}
969 
				if (row.getCell(4) != null && row.getCell(4).getCellTypeEnum() == CellType.NUMERIC) {
 967 
				if (row.getCell(4) != null && row.getCell(4).getCellTypeEnum() == CellType.NUMERIC) {
970 
					Date businessDate = row.getCell(4).getDateCellValue();
 - 
 
971 
					LocalDateTime businessDateTime = LocalDateTime.of(
 - 
 
972 
							LocalDate.of(businessDate.getYear(), businessDate.getMonth(), businessDate.getDate()),
 - 
 
973 
							LocalTime.MIDNIGHT);
 - 
 
974 
					walletHistoryModel.setBusinessDate(businessDateTime);
 - 
 
975 
					;
 - 
 
976 
				} else {
 - 
 
977 
					throw new ProfitMandiBusinessException("Invalid Business Date", "row number " + rowNumber,
 - 
 
978 
							"row number " + rowNumber);
 - 
 
979 
				}
 - 
 
980 
				if (row.getCell(5) != null && row.getCell(5).getCellTypeEnum() == CellType.NUMERIC) {
 - 
 
981 
					double amount = row.getCell(5).getNumericCellValue();
 968 
					double amount = row.getCell(4).getNumericCellValue();
982 
					if (amount < 0) {
 969 
					if (amount < 0) {
983 
						throw new ProfitMandiBusinessException("Invalid Amount, only positive values",
 970 
						throw new ProfitMandiBusinessException("Invalid Amount, only positive values",
984 
								"row number " + rowNumber, "row number " + rowNumber);
 971 
								"row number " + rowNumber, "row number " + rowNumber);
985 
					}
 972 
					}
986 
					walletHistoryModel.setAmount(amount);
 973 
					walletHistoryModel.setAmount(amount);
987 
				} else {
 974 
				} else {
988 
					throw new ProfitMandiBusinessException("Invalid Amount", "row number " + rowNumber,
 975 
					throw new ProfitMandiBusinessException("Invalid Amount", "row number " + rowNumber,
989 
							"row number " + rowNumber);
 976 
							"row number " + rowNumber);
990 
				}
 977 
				}
991 
				if (row.getCell(6) != null && row.getCell(6).getCellTypeEnum() == CellType.STRING) {
 978 
				if (row.getCell(5) != null && row.getCell(5).getCellTypeEnum() == CellType.STRING) {
992 
					String transactionType = row.getCell(6).getStringCellValue().toLowerCase();
 979 
					String transactionType = row.getCell(5).getStringCellValue().toLowerCase();
993 
					if (transactionType.equals("dr")) {
 980 
					if (transactionType.equals("dr")) {
994 
						walletHistoryModel.setAmount(-walletHistoryModel.getAmount());
 981 
						walletHistoryModel.setAmount(-walletHistoryModel.getAmount());
995 
					} else if (!transactionType.equals("cr")) {
 982 
					} else if (!transactionType.equals("cr")) {
996 
						throw new ProfitMandiBusinessException("Invalid Transaction Type", "row number " + rowNumber,
 983 
						throw new ProfitMandiBusinessException("Invalid Transaction Type", "row number " + rowNumber,
997 
								"row number " + rowNumber);
 984 
								"row number " + rowNumber);
998 
					}
 985 
					}
999 
				} else {
 986 
				} else {
1000 
					throw new ProfitMandiBusinessException("Invalid Transaction Type", "row number " + rowNumber,
 987 
					throw new ProfitMandiBusinessException("Invalid Transaction Type", "row number " + rowNumber,
1001 
							"row number " + rowNumber);
 988 
							"row number " + rowNumber);
1002 
				}
 989 
				}
1003 
				if (row.getCell(7) != null && row.getCell(7).getCellTypeEnum() == CellType.STRING) {
 990 
				if (row.getCell(6) != null && row.getCell(6).getCellTypeEnum() == CellType.STRING) {
1004 
					String description = row.getCell(7).getStringCellValue().toLowerCase();
 991 
					String description = row.getCell(6).getStringCellValue().toLowerCase();
1005 
					walletHistoryModel.setDescription(description);
 992 
					walletHistoryModel.setDescription(description);
1006 
				} else {
 993 
				} else {
1007 
					throw new ProfitMandiBusinessException("Invalid Transaction Type", "row number " + rowNumber,
 994 
					throw new ProfitMandiBusinessException("Invalid Transaction Type", "row number " + rowNumber,
1008 
							"row number " + rowNumber);
 995 
							"row number " + rowNumber);
1009 
				}
 996 
				}