Exemple #1
0
        public override void ImportToDatabase()
        {
            DataTable dataTable = GetImportDataFromTempDatabase(null);

            if (dataTable.Rows.Count > 0)
            {
                ECommissionAchievementImportBatch batchDetail = new ECommissionAchievementImportBatch();
                batchDetail.CAImportBatchDateTime = AppUtils.ServerDateTime();
                //batchDetail.CAImportBatchOriginalFilename = OriginalBatchFilename;
                batchDetail.CAImportBatchRemark     = Remark;
                batchDetail.CAImportBatchUploadedBy = m_UserID;
                ECommissionAchievementImportBatch.db.insert(dbConn, batchDetail);

                foreach (DataRow row in dataTable.Rows)
                {
                    EUploadCommissionAchievement obj = new EUploadCommissionAchievement();
                    EUploadCommissionAchievement.db.toObject(row, obj);

                    ECommissionAchievement CA = new ECommissionAchievement();
                    CA.CAPercent       = obj.CAPercent;
                    CA.CAEffDate       = obj.CAEffDate;
                    CA.EmpID           = obj.EmpID;
                    CA.CAImportBatchID = batchDetail.CAImportBatchID;

                    ECommissionAchievement.db.insert(dbConn, CA);
                    EUploadCommissionAchievement.db.delete(dbConn, obj);
                }
            }
        }
Exemple #2
0
        public DataTable UploadToTempDatabase(DataTable rawDataTable, int UserID)
        {
            if (rawDataTable == null)
            {
                return(GetImportDataFromTempDatabase(null));
            }

            int rowCount = 1;

            //ArrayList results = new ArrayList();
            try
            {
                foreach (DataRow row in rawDataTable.Rows)
                {
                    rowCount++;
                    string EmpNo = row[FIELD_EMP_NO].ToString();
                    int    EmpID = HROne.Import.Parse.GetEmpID(dbConn, EmpNo, UserID);
                    if (EmpID < 0)
                    {
                        errors.addError(ImportErrorMessage.ERROR_ACCESS_DENIED_EMP_NO, new string[] { EmpNo, rowCount.ToString() });
                    }

                    //string EffDateString = row[FIELD_EFFECTIVE_DATE].ToString();
                    //DateTime EffDate = Import.Parse.toDateTimeObject(row[FIELD_EFFECTIVE_DATE]);

                    string percentString = row[FIELD_PERCENT].ToString();
                    double percent       = 0;

                    string   effDateString = row[FIELD_EFF_DATE].ToString();
                    DateTime effDate       = new DateTime();

                    //if (EmpID > 0 && EffDate.Ticks != 0 && double.TryParse(percentString, out percent))
                    if (EmpID > 0 && double.TryParse(percentString, out percent) && DateTime.TryParse(effDateString, out effDate))
                    {
                        EUploadCommissionAchievement CA = new EUploadCommissionAchievement();
                        CA.EmpID              = EmpID;
                        CA.CAPercent          = HROne.CommonLib.GenericRoundingFunctions.RoundingTo(percent, 2, 2);
                        CA.CAEffDate          = effDate;
                        CA.SessionID          = m_SessionID;
                        CA.TransactionDate    = UploadDateTime;
                        CA.ImportActionStatus = ImportDBObject.ImportActionEnum.UPDATE;

                        db.insert(dbConn, CA);
                    }
                    else
                    {
                        if (EmpID == 0)
                        {
                            errors.addError(ImportErrorMessage.ERROR_INVALID_EMP_NO, new string[] { EmpNo, rowCount.ToString() });
                        }
                        else if (effDate.Ticks == 0)
                        {
                            errors.addError(ImportErrorMessage.ERROR_INVALID_FIELD_VALUE, new string[] { FIELD_EFF_DATE + "=" + effDateString, EmpNo, rowCount.ToString() });
                        }
                        else if (!double.TryParse(percentString, out percent))
                        {
                            errors.addError(ImportErrorMessage.ERROR_INVALID_FIELD_VALUE, new string[] { FIELD_PERCENT + "=" + percentString, EmpNo, rowCount.ToString() });
                        }
                    }
                }
            }
            catch (Exception e)
            {
                errors.addError(e.Message, null);
            }
            if (errors.List.Count > 0)
            {
                ClearTempTable();
                throw (new HRImportException(rawDataTable.TableName + "\r\n" + errors.Message()));
            }
            return(GetImportDataFromTempDatabase(null));
        }